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.

After you have set up your client Oracle installation:

Prepare the remote Oracle RDBMS.
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‌‌

In a Dimensions CM for UNIX server installation with an Oracle Enterprise database, you are prompted for the Oracle Net Service Name. This is the name that the local Oracle client uses to identify particular Oracle databases on the network.

On your local UNIX node, you must define the Net Service Name of the remote Oracle database. Edit tnsnames.ora or use the Oracle Net Configuration Assistant as explained below.

Add a Net Service Name

Log in as the owner of the Oracle installation (usually oracle).
Navigate to: $ORACLE_HOME/network/admin
Open tnsnames.ora in text editor.
Using existing entries as a template, add a Net Service Name, for example:
```
DIM14R = 
  (DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST=iddvm)(PORT = 1521))
  )
CONNECT_DATA = (SERVICE_NAME = DIM14)
```
In the above example, a Net Service Name of DIM14R has been given to the Oracle located on the remote node iddvm that has an Oracle SID of DIM14.

To access a container database, add the PDB name to tnsnames.ora:

PDB_DIM14 = 
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <host name>)(PORT= 1521)) 
    (CONNECT_DATA =
      (SERVER = DEDICATED) 
      (SERVICE_NAME = PDB_DIM14)
    )  
  )

Run the Oracle Net Configuration Assistant Tool

Log in as the owner of the Oracle installation (usually oracle).
Navigate to: $ORACLE_HOME/bin
Execute the file netca.
Select Local Net Service Name configuration and click Next.
Select Add and click Next.
Each database or service has a service name. Normally this is its SID. Enter the SID of the remote database you want the local Oracle client to communicate with. Click Next.
Select TCP and click Next.
To communicate with the remote database, the local database must know the remote database's host name. Enter the remote database's host name. In most cases you can also accept the standard port number of 1521. Click Next.
Select Yes, perform a test to verify that the remote database can be reached. Click Next.
If the test is successful, the following message appears:
```
Connecting... Test successful.
```
If the test fails click Back and check that the information you provided is correct and update until this test is successful.

Click Next.
Assign an Oracle Net Service Name. This is the name that your local database uses to identify the remote database. The Net Service Name field is pre-populated with the service name you provided. If that name is not unique—for example, both the local and remote databases have an Oracle SID of DIM14—enter a unique net service name (for example, DIM14R). Click Next.
Unless you want to configure another net service name, accept the default No and click Next.
Click Next and click Finish.