You must create specific tablespaces to use an Oracle database with your P6 EPPM installation.
To create database tablespaces:
- Complete the following steps:
- From the command line, run: sqlplus <system>/password@<db_tns_names_entry>:
- Go to \database\scripts\install\PM_<release_level> and run the orpm_init_db.sql script.
This script creates the following tablespaces:
- PMDB_DAT1
- PMDB_NDX1
- PMDB_LOB1
- PMDB_PX_DAT1
If you want to change the names of the tablespaces that are listed above, you must modify the orpm_init_db.sql script before you run it.
Notes:
- Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
- Instead of running the orpm_init_db.sql script, you can manually create a database with system, temporary, and undo tablespaces. Oracle recommends that you create a database with a 500 MB temporary tablespace and a 500 MB undo tablespace. Make sure that the Oracle client can connect to the database. Refer to your Oracle database documentation if you are unfamiliar with this process.