Establishing applications environment for Oracle RAC

It is relevant to ensure that EBS is aware of the new database tier and that load balancing is implemented and operational. We address this in the following sections.

The following steps are important, as they ensure that the application tier is aware of the new database tier. You will need to carry out the following steps on all application-tier nodes:

1. Source the Oracle applications environment.

2. Edit SID=<Instance 1> and PORT=<New listener port> in $TNS_ADMIN/ tnsnames.ora file, to set up a connection with one of the instances in the Oracle RAC environment.

3. Confirm that you are able to connect to one of the instances in the Oracle RAC environment.

4. Edit the context variable jdbc_url, adding the instance name to the connect_data parameter.

5. Run AutoConfig using the following command:

   $AD_TOP/bin/adconfig.sh contextfile=$INST_TOP/appl/
   admin/<context_file>

   Note

   For more information on AutoConfig, see My Oracle Support Knowledge...