Oracle Switch TP1996-9.2.2.1A Manuale Utente
Chapter 3
Configuring the Agile PLM 9.2.2 Database
This chapter includes the following:
Reorganizing the Database ................................................................................................................................. 25
Running Full Text Search Scripts ........................................................................................................................ 26
Configuring the Agile SDK................................................................................................................................... 26
Configuring PG&C ............................................................................................................................................... 27
Configuring PPM.................................................................................................................................................. 27
Upgrading from Agile PLM 9.2.1.1....................................................................................................................... 28
After the database has been configured and all averify errors have been fixed, you must run
additional database scripts to reorganize the database and to enable Full Text Search in the Agile
PLM 9.2.2.1 database.
additional database scripts to reorganize the database and to enable Full Text Search in the Agile
PLM 9.2.2.1 database.
Reorganizing the Database
Important The Agile PLM 9.2.2.1 database includes two user accounts, CTXSYS and AGILE. The
following upgrade procedure is required for the database sizing and configuration of the
CTXSYS and AGILE accounts.
CTXSYS and AGILE accounts.
After AUT is run, the upgraded schema and data have been validated. However, the data still needs
to be analyzed and statistics generated to enable Cost-Based optimizer (CBO) and Full Text Search
(FTS) support. There are eight Agile-specific tablespaces required for optimization. The Agile
schema has to be reorganized for this optimization to occur.
to be analyzed and statistics generated to enable Cost-Based optimizer (CBO) and Full Text Search
(FTS) support. There are eight Agile-specific tablespaces required for optimization. The Agile
schema has to be reorganized for this optimization to occur.
To reorganize the upgraded schema:
1. On the database server, change to the following directory:
(Windows)
\oracle\admin\agile9\create
(UNIX)
$ORACLE_BASE/admin/$ORACLE_SID/create
2. Run the
Agile9exp script.
The Agile9exp.dmp file is created in the current folder. This dump file is used with the agile9imp
script. Make sure the dump file can be imported successfully before proceeding to the next
step.
script. Make sure the dump file can be imported successfully before proceeding to the next
step.
3. Run the
recreateagile script to drop the existing account and recreate the agile account and
schema.
4. Run the
agile9imp script to import the upgraded Agile 9 schema, including setup of CBO and
FTS.
5. Rename the existing agile9exp.dmp file to agile9exp_upgrade9221.dmp for backup. Also
rename the agile9exp.log file to agile9exp_upgrade9221.log.
Database Upgrade Guide
Page - 25