Log into Oracle as a SYSTEM or other DBA privileged user.
Go to \database\scripts\install\PM_<release_level> and execute the orpm_init_db.sql script.
Go to \database\scripts\install\PPM_<release_level> and execute the orppm_init_db.sql script.
This script creates the following tablespaces:
PMDB_DAT1
PMDB_NDX1
PMDB_LOB1
PMDB_PX_DAT1
If you want to change those names, you must modify the orpm_init_db.sql script.
If you want to change those names, you must modify the orppm_init_db.sql script.
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.
Do not use special characters in the database name, privileged user, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
Instead of running the orppm_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.