Creating the Oracle Instance

The Oracle Instance creation step consists of executing a dbca utility which uses predefined template files to create the instance and perform some system configuration steps.

The General_Purpose.DBC template, used to create the Oracle instance, is pre-configured to use a character set specific to the locale of the operating system on which you install. The preferred character set for Primavera Portfolio Management databases is WE8MSWIN1252.

Note: The General_Purpose.DBC template can also be pre-configured for a different character set. In that case , see Appendix B instructions to create a custom template.

1. For Oracle 11g or 12c, create new container database and pluggable database as follows:

   <ORACLE_HOME>\bin\dbca -silent -createDatabase

   -gdbname <ORACLE_SID> –sid % ORACLE_SID %

   -templateName <TEMPLATE_NAME> -responseFile NO_VALUE -characterSet WE8MSWIN1252 –

   sysPassword <SYS_PASSWORD> -systemPassword <SYSTEM_PASSWORD>

   -createAsContainerDatabase true -numberOfPDBs <No.of PDBs> -pdbName <PDB_NAME>

   -pdbAdminPassword <PDBAdmin_PASSWORD> -datafileDestination <DESTINATION>

   or

   Create new Pluggable for an existing Container Database as follows:

   <ORACLE_HOME>\bin\dbca -silent -createPluggableDatabase -sourceDB <CDB_NAME>

   -pdbName <PDB_NAME> -pdbAdminUserName <PDB_ADMIN_USER_NAME> -pdbAdminPassword <<PDB_ADMIN_USER_PASSWORD> -createUserTableSpace true

   <ORACLE_HOME>\bin\dbca -silent -createPluggableDatabase -sourceDB <CDB_NAME>

   -pdbName <PDB_NAME> -pdbAdminUserName <PDB_ADMIN_USER_NAME> -pdbAdminPassword <<PDB_ADMIN_USER_PASSWORD> -createUserTableSpace true

   where:

   <ORACLE_HOME>: A path to Oracle Home. For example, "C:\oracle\product\12.1.0.2\db_1".

   <TEMPLATE_NAME>: The General_Purpose.DBC or a custom template created according to Appendix B.

   <ORACLE_SID>: The Primavera Portfolio Management Oracle Instance name which will be created. For example, ORCL.

   <CDB_NAME>: The container database.

   <PDB_NAME>: The pluggable database.

   <PDB_ADMIN_USER_NAME>: The administration user name of the pluggable database.

   <PDB_ADMIN_USER_PASSWORD>: The administration user's password for the pluggable database.

   Note: All paths with spaces must be enclosed within double-quotes.

   or

   Create an Oracle 11g / 12c database using the non-interactive/silent mode Database Configuration Assistant (DBCA):

   1. From the Command window, select Start, Run, enter cmd, <ENTER>):
   2. Enter the following commands:

      <ORACLE_HOME>\bin\dbca -silent -createDatabase

      /-templateName <TEMPLATE_NAME>

      / -gdbname <ORACLE_SID> -sid % <ORACLE_SID>%

      / -continueOnNonFatalErrors true

      / -datafileJarLocation <ORACLE_HOME>\assistants\dbca\templates

   where:

   <ORACLE_HOME>: A path to Oracle Home. For example, "C:\oracle\product\11.2.0.0\db_1".

   <TEMPLATE_NAME>: The General_Purpose.DBC or a custom template created according to Appendix B.

   <ORACLE_SID>: The Primavera Portfolio Management Oracle Instance name which will be created. For example, ORCL.

2. From a SQLPlus window, change the default sys password “change_on_install” to “oracle” as follows:

   “sys/change_on_install as sysdba” <ENTER>

   alter user sys identified by oracle;

   The datafiles are placed in the default location %ORACLE_BASE%\oradata\%<ORACLE_SID>%

Legal Notices | Your Privacy Rights
Copyright © 1998, 2020

Last Published Tuesday, December 8, 2020