From the command line, execute: sqlplus <system>/password@<db_tns_names_entry>:
Go to \database\scripts\install\PM_<release_level> and execute 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 execute 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.