Remote Oracle Enterprise‌

Allocate at least 1GB of memory as the Oracle System Global Area (SGA) target size. Oracle recommends allocating 40-50% of available memory for the SGA.

Introduction‌

You can install Dimensions CM on a local node and the schema on a remote Oracle Enterprise. This allows CM users on a local node to use a remote Oracle Enterprise RDBMS on Windows or UNIX. To use a remote Oracle first set up an Oracle client on the local node. The Oracle client can be:

  • An Oracle-supplied UNIX client installation.

  • An Oracle-supplied UNIX instant client installation.

  • A full Oracle-supplied UNIX installation.

Note: For Oracle Instant Client on Windows, Dimensions CM requires the following packages:

  • instantclient-basic-<platform>-<version>.zip
  • instantclient-sqlplus-<platform>-<version>.zip

After you have set up your client Oracle installation:

  1. Prepare the remote Oracle RDBMS.

  2. Set up a local Oracle Net Service Name on the remote Oracle database that you want the CM server to communicate with.

Set up a local Oracle Net Service Name

When you install a CM server with a remote Oracle Enterprise database you are prompted for the Oracle Net Service Name. This is the name that the local client uses to identify a specific remote Oracle databases for network operations.

On your local Windows machine define the Net Service Name of the remote Oracle database that you want the CM server to communicate with.

  1. Start the Oracle Net Configuration Assistant:

    Start | Oracle <oracle_home> | Configuration and Migration Tools | Net Configuration Assistant

  2. Select Local Net Service Name configuration.

  3. Select Add.

  4. Enter the service name of the remote database you want the local database client to communicate with.

  5. Select the TCP protocol.

  6. Enter the remote database's host name.

  7. Accept the standard port number (1521) or enter a different one.

  8. Optionally test the connection to the remote database.

  9. Assign an Oracle net service name. This is the name that your local client database uses to identify the remote database.

    Default: same SID as the Net Service Name. If the name is not unique, enter a different net service name

  10. Click Next and Finish.