Creating an Oracle Database

To create an Oracle Database:

Set the JAVA_HOME location:
In your Windows system environment:
1. Right-click on My Computer and select Properties.
2. In the System Properties dialog box, on the Advanced tab, click Environment Variables.
3. In the Environment Variables dialog box, under System variables, click New.
4. In the New System Variable dialog box:
  1. In the Variable name field, enter JAVA_HOME.
  2. In the Variable value field, enter the location where Java is located (for example, C:\Program Files\Java\jre8).
5. Click OK to exit out of the open dialog boxes.
For Linux, add the JAVA_HOME Environment variable to the dbsetup.sh (in the Database folder of the physical media or download) file before running it. For example: export JAVA_HOME=/usr/java/jre1.8.0_73/
Complete the following steps to grant privileges to the SYSTEM or another DBA user:
1. Go to \database\scripts\install\PPM_<release_level> and open manual_script_before_install.sql in a text editor.
  This script grants sys.DBMS_REPUTIL, sys.DBA_VIEWS, sys.DBMS_LOB, sys.DBMS_SQL, sys.DBMS_JOB, sys.DBMS_RANDOM, sys.DBA_EXTENTS privileges to the SYSTEM user (or another DBA user), which will be validated during database installation.
2. Modify all schema user references to match your actual schema user name.
  If you use another DBA account for database install, update the references to SYSTEM with the actual DBA account you will use for the install.
3. From the command line, run sqlplus sys/@<DBNAME> as sysdba and enter the password when prompted.
  where <DBNAME> is the Net Service Name for your database, which can be found in your $ORACLE_HOME\NETWORK\ADMIN\TNSNAMES.ORA file.
4. Go to \database\scripts\install\PPM_<release level> and run manual_script_before_install.sql.
  For example, at the SQL prompt, enter @C:\P6_Professional_Database\database\scripts\install\PPM_15_01_00\manual_script_before_install.sql.
Double-click dbsetup.bat (or dbsetup.sh for Linux) in the Database folder of the P6 EPPM physical media or download to start the Database wizard.
Note: Click Next on each wizard screen to advance to the next step.
On the Primavera P6 screen:
1. In the Database options field, select the Install a new database option.
2. In the Server type field, select the Oracle option.
On the Connection Information screen, enter the following information to connect to the database:
1. In the DBA User Name field, enter the DBA user name (by default, system).
2. In the DBA Password field, enter the password for the DBA user name.
3. In the Database Host Address field, enter the server machine name of IP address where the Oracle Database is installed.
4. In the Database Host Port field, enter the port number that the Oracle Database is using. The default is 1521.
5. In the Database Service Name field, enter the Oracle Service Name or SID. You can find this value in the TNSNAMES.ORA file, which you created when you or your DBA set up the Oracle client. You can also obtain the Service Name or SID by running the following query against the database as a DBA user (db_name reflects the SID and service_names reflects the service name):
  select name, value from v$parameter where name in ('db_name','service_names');
  
  Note: Do not use special characters in the database name, privileged user, or public user, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
On the Configure Oracle Tablespaces screen, do one of the following:
- If the database server to which you are connecting already has existing tablespaces and you want to use them, select the Use existing tablespaces checkbox. If you do this, skip the rest of this procedure and continue to Loading Application Data for Oracle.
- Otherwise, change the estimated tablespace sizes as needed and continue this procedure.
On the Specify Oracle Tablespace Locations screen:
1. Accept the default locations for the Oracle tablespaces or specify different locations.
2. Click Create.

Creating an Oracle Database

Related Topics