Sun Cluster Data Service for Oracle E-Business Suite Guide for Solaris OS

Upgrading Sun Cluster HA for Oracle E-Business Suite

Support for Oracle E-Business Suite v11.5.9 was introduced in Sun Cluster 3.1 9/04. Oracle E-Business Suite v11.5.9 introduces the hostname within some path names. If you are upgrading to Oracle E-Business Suite v11.5.9, you must upgrade Sun Cluster HA for Oracle E-Business Suite for use with Oracle E-Business Suite v11.5.9.

    Upgrading Sun Cluster HA for Oracle E-Business Suite involves the following tasks:

  1. Removing and reregistering resources for the following server components of Oracle E-Business Suite:

    • Concurrent Manager Server

    • Forms Server

    • Reports Server

  2. Removing and reregistering resources for the following listener components of Oracle E-Business Suite:

    • Oracle Listener

    • Concurrent Manager Listener

  3. Bringing online resources for Sun Cluster Oracle E-Business Suite

ProcedureHow to Remove and Reregister a Resource for an Oracle E-Business Suite Server Component

Perform this task for each server resource that you must remove and reregister, namely:

Steps
  1. Save the definition of the Oracle E-Business Suite sever resource.


    # scrgadm -pvv -j resource > file1
    
  2. Disable the Oracle E-Business Suite sever resource.


    # scswitch -n -j resource
    
  3. Remove the Oracle E-Business Suite sever resource.


    # scrgadm -r -j resource
    
  4. Configure and register the Oracle E-Business Suite server resource.

    1. Go to the directory that contains the configuration file and the registration file for the resource.


      # cd /opt/SUNWscebs/prefixutil
      
    2. Edit the configuration file for the resource.


      vi prefix_config
      
    3. Run the registration file for the resource.


      # ./prefix_register
      

    prefix denotes the server to which the file applies, as follows:

    • cmg denotes the Concurrent Manager Server.

    • frm denotes the Forms Server.

    • rep denotes the Reports Server .

  5. Compare the updated definitions to the definitions that you saved before you updated the resource.

    Comparing these definitions enables you to determine if any existing extension properties have changed, for example, time-out values.


    # scrgadm -pvv -j resource > file2
    # diff file1 file2
    
  6. Amend any resource properties that were reset.


    # scrgadm -c -j <resource>-x | y <resource>
    

ProcedureHow to Remove and Reregister Resources for Oracle E-Business Suite Listener Components

This task removes and reregisters all the listener resources that you must remove and reregister, namely:


Note –

These resources are instances of the SUNW.oracle_listener resource type. For information about this resource type, see Sun Cluster Data Service for Oracle Guide for Solaris OS.


Steps
  1. Disable and remove the Sun Cluster Oracle E-Business Suite listener resources.


    # scswitch -n -j resource
    # scrgadm -r -j resource
    
  2. Create a resource for the Oracle E-Business Suite Oracle Listener.

    In the following example, the copy_env script is used to copy the PROD.env file to PROD_ha.env and to format the PROD_ha.env file. The PROD_ha.env is specified for the User_env extension property of the Oracle Listener resource.


    # grep PROD.DBS_ORA816= /var/tmp/config.txt
    PROD.DBS_ORA816=/global/mnt10/d02/oracle/proddb/8.1.7
    #
    # cd /opt/SUNWscebs/cmg/util
    #
    # ./copy_env /global/mnt10/d02/oracle/proddb/8.1.7 PROD
    #
    # scrgadm -a -j Oracle-E-Business-Suite-ORALSR-resource \
    -t SUNW.oracle_listener  \
    -g  Oracle-E-Business-Suite-failover-resource-group\
    -x Listener_name=PROD\
    -x ORACLE_HOME=/global/mnt10/d02/oracle/proddb/8.1.7 \
    -x User_env=/global/mnt10/d02/oracle/proddb/8.1.7/PROD_ha.env
    #
    # scswitch -e -j Oracle-E-Business-Suite-ORALSR-resource
    
  3. Create a resource for the Oracle E-Business Suite Concurrent Manager Listener.

    In the following example, the copy_env script is used to copy the PROD.env file to PROD_ha.env and to format the PROD_ha.env file. The PROD_ha.env is specified for the User_env extension property of the Concurrent Manager Listener resource.


    # grep PROD.CON_ORA806= /var/tmp/config.txt
    PROD.CON_ORA806=/global/mnt10/d01/oracle/prodora/8.0.6
    #
    # cd /opt/SUNWscebs/cmg/util
    #
    # ./copy_env /global/mnt10/d01/oracle/prodora/8.0.6 PROD
    #
    # scrgadm -a -j Oracle-E-Business-Suite-CMGLSR-resource \
    -t SUNW.oracle_listener  \
    -x Listener_name=APPS_PROD\
    -x ORACLE_HOME=/global/mnt10/d01/oracle/prodora/8.0.6 \
    -x User_env=/global/mnt10/d01/oracle/prodora/8.0.6/PROD_ha.env
    #
    # scswitch -e -j Oracle-E-Business-Suite-CMGLSR-resource
    

ProcedureHow to Bring Online Resources for Sun Cluster Oracle E-Business Suite

Step

    For each resource that you are bringing online, type the following command.


    # scswitch -e -j <resource>