Adding Oracle UDP IPC private IP addresses to the Oracle initialization parameter file

Add the Oracle UDP IPC private IP addresses to the Oracle initialization parameter file (for example, pfile or spfile) if the database cache fusion traffic is configured to use Oracle UDP IPC private IP addresses and if these addresses are configured as a PrivNIC or MultiPrivNIC resource for high availability. You need to configure the cluster_interconnects parameter in the Oracle initialization parameter file to use the appropriate private IP addresses.

To add Oracle UDP IPC private IP addresses to the initialization parameter file

  1. Log in as the Oracle user on one of the nodes in the cluster.

  2. Set the cluster_interconnects parameter in the Oracle initialization parameter file to use the Oracle UDP IPC private IP addresses that are used for database cache fusion and are managed by PrivNIC or MultiPrivNIC.

    Note:

    Configure multiple IP addresses for each database instance in the cluster_interconnects parameter to distribute the database cache fusion traffic across multiple links.

    $ sqlplus '/ as sysdba'
    SQL> alter system set cluster_interconnects='192.168.2.1:192.168.3.1' \
    scope=spfile sid='vrts1';
    SQL> alter system set cluster_interconnects='192.168.2.2:192.168.3.2' \
    scope=spfile sid='vrts2';
    SQL> exit;
  3. Stop the Oracle database on all nodes:

    If the database is configured under VCS:

    # hares -offline oracle_resource -sys system_name

    If the database is not configured under VCS:

    $ srvctl stop database -d db-name
  4. For Oracle RAC 10g: Unlink the Veritas VCS IPC library.

    Perform this step on each node if the Oracle libraries are on local storage. If the Oracle libraries are installed on shared storage, perform the step on one node only.

    $ cd $ORACLE_HOME/lib
    $ cp libskgxpu.so libskgxp10.so
  5. As the Oracle user on one of the nodes in the cluster, restart the Oracle database:

    $ srvctl start database -d db-name
  6. As the root user on each node in the cluster, verify that the private IP addresses are running.

    # ifconfig bge1