Configuring the Oracle Database Gateway for a Microsoft SQL Server Database

Previous TopicNext TopicContents

If your P6 EPPM database is a Microsoft SQL Server database, perform the following steps to configure the Oracle Database Gateway:

  1. Go to the Oracle Database Gateway install directory\dg4msql\admin folder.
  2. Edit the initdg4msql.ora file:
    1. Edit the HS_FDS_CONNECT_INFO= parameter to be in the format:

      HS_FDS_CONNECT_INFO=servername/instancename/pmdbdatabase

      Where servername refers to the server name, instancename refers to the instance, and pmdbdatabase refers to the database.

      For example:

      HS_FDS_CONNECT_INFO=win2k2/sqlserver/pmdb

      The following example shows the parameter when an instancename is not specified:

      HS_FDS_CONNECT_INFO=serverSQL//proj_pmdb

    2. Save and close the file.
  3. Edit the tnsnames.ora file and add a new TNSnames entry for each new SQLServer Gateway. For example:

    dg4msql =

    (DESCRIPTION=

    (ADDRESS=(PROTOCOL=tcp)(HOST=server name)(PORT=1521))

    (CONNECT_DATA=(SID=dg4msql))

    (HS=OK)

    )

  4. Edit the Listener.Ora file and add information for each necessary gateway. For example:

    (SID_LIST=

    (SID_DESC=

    (SID_NAME=dg4msql)

    (ORACLE_HOME=C:\product\11.1.0\tg_1)

    (PROGRAM=dg4msql)

    )

    )

  5. Stop any existing Listeners on the Oracle Gateway server.
  6. If you need to connect to other Oracle instances, you must configure the TNS Names in the directory where you installed the Gateway.
  7. Start the Gateway Listener. The following Initialization parameters were set for the Gateway:

    For a dataset with similar statistics:

  8. When configuring the Gateway, set HS_LANGUAGE for the Oracle character set of your instance:
    1. On the gateway machine, go to the gateway install directory (for example, C:\product\11.1.0\tg_2\dg4msql\admin)
    2. Edit the initdg4msql.ora file and add the following parameter specific to your Oracle dataset. Depending on your character set, either add the following or adjust for UTF8:

      HS_LANGUAGE=american_america.WE8ISO8859P15

      Or, add all of the following:

      HS_NLS_LENGTH_SEMANTICS=CHAR

      HS_FDS_CHARACTER_SEMANTICS = TRUE

      HS_KEEP_REMOTE_COLUMN_SIZE=ALL

    3. Save the initdg4msql.ora file.
    4. Restart the Gateway listener.

Related Topics

Configuring the Oracle Database Gateway to Link to a P6 EPPM Database on a Microsoft SQL Server System



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014