DOCS

Initializing an Oracle Database for CAE

To initialize an Oracle database for CAE

1. In the left frame of CAE Manager, expand Database Installation & Configuration Tools:

2. Select Oracle - Initialize database for CAE, then click Next.

Or  

Double-click Oracle - Initialize database for CAE.

The server list displays:

3. In the left frame of the Oracle - Initialize database for CAE page, expand, if necessary, the Server list and select a database server connection.
4. In the Database server area, review this information:
Driver
Database server hostname
Database name
5. If the connection parameters are not correct, go to the Connection Manager to edit them before continuing the database initialization.Optional. In the Database administrator account area, change the account password.
If, when adding the database server connection, you have saved the account password in step 4 , the Account password field is deactivated.
6. Click Next.
7. Optional. On the Initialize database for CAE window, change the values of the Role and Profile security parameters if you want them to comply with your naming conventions.
If you need to change the profile definition, you and your database administrator must generate and run the init_database.sql script (see Generating Oracle DBA Scripts for CAE).
8. On the Initialize database for CAE window, verify or change the tablespaces that contain these elements for the CAE entry point(s):
Object property tables
Object property indexes
Link tables
Link indexes
Source and file data
Model and read-only data tables
Model and read-only data indexes
Temporary tables and indexes
Internal work tables
Internal work indexes
9. Click Run to initialize the Oracle database for CAE.