Installing the Gateway Schema
After installing the Oracle database, run the Gateway-DBInstallation script to install the Gateway schema.
- To be able to run the Gateway-DBInstallation script, set the JAVA_HOME location:
In your Windows system environment:
- Open the Control Panel.
- Go to Advanced System Settings.
- Select View Advanced System Settings.
- In the System Properties dialog box, on the Advanced tab, select Environment Variables.
- In the Environment Variables dialog box, under System variables, select New.
- In the New System Variable dialog box:
- In the Variable name: field, enter JAVA_HOME.
- In the Variable value: field, enter the location where Java is located (for example, C:\Progra~1\Java\jdk7).
Note: The default path is C:\Program Files\Java\jdk7, but you must remove the space from "Program Files" to ensure other wizards run correctly.
- Select OK to exit out of the open dialog boxes.
For Linux and Solaris, 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/jdk1.7.0_75
- From the command line, execute:
sqlplus <sysdba_username>/<sysdba_password>@<SID> as sysdba
Where:
<sysdba_username> is a sysdba user name (sys by default)
<sysdba_password> is a sysdba password
<SID> is a SID of the Oracle database instance
For example, sqlplus sys/myPassword@ORCL as sysdba
Note: The command will be different if you are connecting from the host other than the host where the database is installed, or connecting to the database using a service name.
- At the SQL prompt, execute:
SQL>@<path>\manual_script_before_install.sql
Where, <path> is an absolute path to the directory where the script is located.
For example,
On Windows: If the installer is located in c:\installer\win64, the command to execute the script will be
@C:\install\win64\script\manual_script_before_install.sql
On Linux: If the installer is located in /home/user/installer/linux64, the command to execute the script will be
@/home/user/installer/linux64/script/manual_script_before_install.sql
On Solaris: If the installer is located in /home/user/installer/solaris64, the command to execute the script will be
@/home/user/installer/solaris64/script/manual_script_before_install.sql
This script grants sys.DBMS_REPUTIL privileges to the system user which will be validated during database installation.
- In the Gateway software download, go to the GatewayUtility folder and run the following script:
- For Windows installations, run Gateway-DBInstallation.bat.
- For Linux and Solaris installations, run ./Gateway-DBInstallation.sh.
- On the Primavera Gateway Database Install Utility screen, enter the database connection details for the Oracle database
- DBA User Name: Enter the user name you created when you installed the Oracle database.
- DBA Password: Enter the password you created when you installed the Oracle database.
- Database Host: Enter the host name or the server IP address of the database server.
- Database Host Port: Enter the port number for the database schema.
- Database Name: Enter the name of your database. For example, orcl.
- Service: Select this option to connect to the database using a service name.
- SID: Select this option to connect to the database using the system identifier.
- Schema Owner: Enter the name of the Primavera Gateway database schema owner.
- Schema Password: Enter a case-sensitive password for the schema owner.
- Provider data folder:Enter or select Add to browse and specify the location of the data folder for each provider.
- Gateway data folder: Enter or select Browse to specify the location of the pdi\data folder of the Gateway application.
- Select the Test Connection button to check for database connectivity. If the test is successful, the following message displays: Connection is successful. If the test is not successful, check the port number specified, schema user ID and case-sensitive password combination, SID or Service value, and the database host address.
- Select Run to begin installing the Gateway schema.
- Select Finish to exit the utility.
Prerequisites
Installing the Oracle Database
Installing JDK
Installing WebLogic
Installing Primavera Gateway Application
Installing the Primavera Application Database
Installing the P6 Adapter