Installing the Gateway Schema

After installing the Oracle database, run the Gateway-DBInstallation script to install the Gateway schema.

  1. To be able to run the Gateway-DBInstallation script, set the JAVA_HOME location:

    In your Windows system environment:

    1. Open the Control Panel.
    2. Go to Advanced System Settings.
    3. Select View Advanced System Settings.
    4. In the System Properties dialog box, on the Advanced tab, select Environment Variables.
    5. In the Environment Variables dialog box, under System variables, select New.
    6. 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:\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.

    7. 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

  2. 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.

  3. 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.

  4. 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.
  5. 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.

Related Topics

Prerequisites

Installing the Oracle Database

Installing JDK

Installing WebLogic

Installing Primavera Gateway Application

Installing the Primavera Application Database

Installing the P6 Adapter



Legal Notices
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, March 25, 2015