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

ProcedureHow to Register and Configure Sun Cluster HA for Oracle E-Business Suite

Perform this procedure on one node of the cluster only.

This procedure assumes that you installed the data service packages during your initial Sun Cluster installation.

If you did not install the Sun Cluster HA for Oracle E-Business Suite packages as part of your initial Sun Cluster installation, go to How to Install the Sun Cluster HA for Oracle E-Business Suite Packages.

  1. On a cluster member, become superuser or assume a role that provides solaris.cluster.modify RBAC authorization.

  2. Register the following resource types.


    # clresourcetype register SUNW.HAStoragePlus
    # clresourcetype register SUNW.gds
    
  3. Create a failover resource group for Oracle E-Business Suite.


    # clresourcegroup create -n nodelist ebs-rg
    
  4. Create a resource for the Oracle E-Business Suite Logical Hostname.


    # clreslogicalhostname create -g ebs-rg \
    > -h logical-hostname \
    > logical-hostname-resource
    
  5. Create a resource for the Oracle E-Business Suite Disk Storage.

    • If a ZFS highly available local file system is being used, perform the following:


      # clresource create -g ebs-rg \
      > -t SUNW.HAStoragePlus \
      > -p Zpools=oracle-ebusiness-suite-zspool \
      > oracle-ebusiness-suite-hastorage-resource
      
    • If a cluster file system or a non-ZFS highly available local file system is being used, perform the following:


      # clresource create -g ebs-rg \
      > -t SUNW.HAStoragePlus \
      > -p FilesystemMountPoints=oracle-ebusiness-suite-filesystem-mountpoint \
      > oracle-ebusiness-suite-hastorage-resource
      
  6. Enable the Resource Group.


    # clresourcegroup online -M ebs-rg
    
  7. Register and enable a resource for the Oracle Database.

    For complete information about creating and registering a cluster resource for the Oracle Database, refer to Sun Cluster Data Service for Oracle Guide for Solaris OS.


    Note –

    Before creating corresponding resources, you need to register the SUNW.oracle_server resource type.



    # clresource create -g ebs-rg \
    > -t SUNW.oracle_Server \
    > -p Connect_string=apps/apps \
    > -p ORACLE_SID=SID \
    > -p ORACLE_HOME=oracle-home \
    > -p Alert_log_file=oracle-home/admin/SID \
    > _db-logical-hostname/bdump/alert_SID.log \
    > -p Restart_type=RESOURCE_GROUP_RESTART \
    > -p Resource_dependencies=oracle-ebusiness-suite-hastorage-resource \
    > oracle-resource
    # clresource enable oracle-resource
    
  8. Register and enable a resource for the Oracle Listener.

    For complete information about creating and registering a cluster resource for the Oracle Listener, refer to Sun Cluster Data Service for Oracle Guide for Solaris OS.


    Note –

    The copy_env script is used to copy and format the sid.env to sid_ha.env, which is used by the User_env= parameter in the following example.



    Note –

    Before creating corresponding resources, you need to register the SUNW.oracle_listener resource type .



    # cd /opt/SUNWscebs/cmg/util
    # ./copy_env oracle-home SID_db-logical-host 
    # clresource create -g ebs-rg \
    > -t SUNW.oracle_listener \
    > -p Listener_name=SID \
    > -p ORACLE_HOME=oracle-home \
    > -p User_env=oracle-home/SID_db-logical-hostname_ha.env \
    > -p Resource_dependencies=oracle-ebusiness-suite-hastorage-resource \
    > listener-resource
    # clresource enable listener-resource
    
  9. Create and register a resource for the Concurrent Manager Listener.

    On all cluster nodes that will run the Concurrent Manager Listener, type:


    # touch /opt/SUNWscor/.use_su
    

    Note –

    The copy_env script is used to copy and format the SID.env to sid_ha.env, which is used by the User_env= parameter in the following example.


    • If you are using Oracle E-Business Suite version 12 or later, perform the following:


      # cd /opt/SUNWscebs/cmg/util
      # ./copy_env app-base-directory/inst/apps/ \
      # SID_app-logical-hostname/ora/10.1.2/ \
      # SID_app-logical-hostname
      # cd oracle-home/apps/tech_st/10.1.2/bin
      # echo "Required for SC cmg Listener resource" > oracle
      

      # clresource create -g ebs-rg \
      > -t SUNW.oracle_listener \
      > -p Listener_name=APPS_SID \
      > -p ORACLE_HOME=app-base-directory//apps/tech_st/10.1.2 \
      > -p User_env=app-base-directory/SID_app-logical-hostname/ora/10.1.2/ \
      > SID_app-logical-hostname_ha.env \
      > -p Resource_dependencies=ebs-hastorage-rs \
      > concurrent-manager-listener-resource
      

      # clresource enable concurrent-manager-listener-resource
      
    • If you are using Oracle E-Business Suite version 11.5.10 or earlier, perform the following:


      # cd /opt/SUNWscebs/cmg/util
      # ./copy_env app-base-directory/SIDora/8.0.6 SID_app-logical-hostname
      # cd app-base-directory/SIDora/8.0.6/bin
      # echo "Required for SC cmg Listener resource" > oracle
      

      # clresource create -g ebs-rg
      > -t SUNW.oracle_listener \
      > -p Listener_name=APPS_SID
      > -p ORACLE_HOME=app-base-directory/SIDora/8.0.6 \
      > -p User_env=app-base-directory/SIDora/8.0.6/ \
      > SID_app-logical-hostname_ha.env \
      > -p Resource_dependencies=ebs-hastorage-rs \
      > concurrent-manager-listener-resource
      

      # clresource enable concurrent-manager-listener-resource
      
  10. Create and register a resource for the Concurrent Manager.

    Edit the /opt/SUNWscebs/cmg/util/cmg_config file and follow the comments within that file. After you have edited the cmg_config file, you must register the resource.


    # cd /opt/SUNWscebs/cmg/util
    # vi cmg_config
    # ./cmg_register
    
    • If you are using Oracle E-Business Suite version 12 or later, use:


      COMNTOP=app-base-directory/inst/apps/SID_app-logical-hostname
      
    • If you are using Oracle E-Business Suite version 11.5.10 or earlier, use:


      COMNTOP=app-base-directory/SIDcomn

      The following example shows edits of the cmg_config file.


      RS=ebs-cmg
      RG=ebs-rg
      LH=ebs-lh
      HAS_RS=ebs-has
      LSR_RS=ebs-cmglsr
      VERSION=11.5.10
      COMNTOP=use appropriate COMNTOP
      APPSUSER=oraapp-user
      APP_SID=SID
      APPS_PASSWD=apps
      ORACLE_HOME=oracle_home
      CON_LIMIT=70
      #
      # Required for Oracle E-Business Suite version 11.5.10 CU2 or later
      #
      ORASVR_RS=ebs1-orasvr
      ORALSR_RS=ebs1-oralsr
      
  11. Create and register a resource for the Forms Server.


    Note –

    This step is required only if you are using Oracle E-Business Suite version 11.5.10 or earlier. If you are using Oracle E-Business Suite version 12 or later, go to Step 14.


    Edit the /opt/SUNWscebs/frm/util/frm_config file and follow the comments within that file. After you have edited the frm_config file, you must register the resource.


    # cd /opt/SUNWscebs/frm/util
    # vi frm_config
    # ./frm_register
    

    The following example shows edits of the frm_config file.


    RS=ebs-frm
    RG=ebs-rg
    LH=ebs-lh
    HAS_RS=ebs-has
    COMNTOP=base-directory/sidcomn
    APPSUSER=oraapp-user
    APP_SID=SID
    VERSION=11.5.10
    
  12. Create and register a resource for the Reports Server.


    Note –

    This step is required only if you are using Oracle E-Business Suite version 11.5.10 or earlier. If you are using Oracle E-Business Suite version 12 or later, go to Step 14.


    Edit the /opt/SUNWscebs/rep/util/rep_config file and follow the comments within that file. After you have edited the rep_config file, you must register the resource.


    # cd /opt/SUNWscebs/rep/util
    # vi rep_config
    # ./rep_register
    

    The following example shows edits of the rep_config file.


    RS=ebs-rep
    RG=ebs-rg
    LH=ebs-lh
    HAS_RS=ebs-has
    COMNTOP=base-directory/sidcomn
    APPSUSER=oraapp-user
    APP_SID=SID
    VERSION=11.5.10
    
  13. (Optional) Create and register a resource for the Web Server.


    Note –

    This step is required only if you are using Oracle E-Business Suite version 11.5.10 or earlier. If you are using Oracle E-Business Suite version 12 or later, go to Step 14.



    # cd base-directory/sidcomn/admin/scripts/SID_logical-hostname
    # ln -s adapcctl.sh apachectl
    

    Edit adapcctl.sh and modify the "$control_code" test to add -a "$control_code" != "configtest".


    # vi adapcctl.sh
    

    The following output shows an amended adapcctl.sh.


    	Note: The output has been realigned to fit the page
    
     	Find control_code (/control_code)
    
    	Modify
    	------ 
    
    control_code="$1"
    
    if test "$control_code" != "start" -a "$control_code" != "stop" \
       -a "$control_code" != "status" ; then
       printf "\n$program: You must either specify \
    			   'start', 'stop', 'status'\n\n"
       printf "\n$program: You must either specify \
    		      'start', 'stop', 'status'\n\n" >> $LOGFILE
       exit 1;
    fi
    
    	To (Note: We've simply added a test to allow "configtest"
    	---------------------------------------------------------
    
    control_code="$1"
    
    if test "$control_code" != "start" -a "$control_code" != "stop" \
       -a "$control_code" != "status" \
    				-a "$control_code" != "configtest" ; then      
       printf "\n$program: You must either specify \
    				'start', 'stop', 'status'\n\n"
       printf "\n$program: You must either specify \
    				'start', 'stop', 'status'\n\n" >> $LOGFILE
       exit 1;
    fi

    # clresource create -g ebs-rg \
    > -t SUNW.apache \
    > -p Port_list=8000/tmpSID \
    > -p Bin_dir=base-directory/sidcomn/admin/scripts/ \
    > SID_logical-hostname \
    > -p Resource_dependencies=oracle-ebusiness-suite-hastorage-resource \
    > apache-resource
    
  14. Create and register a resource for the OPMN Server.

    If you are installing Oracle E-Business Suite version 12 or later, perform the following:

    Edit the /opt/SUNWscebs/opmn/util/opmn_config file and follow the comments within that file. After you have edited the opmn_config file, you must register the resource.


    # cd /opt/SUNWscebs/opmn/util
    # vi opmn_config
    # ./opmn_register
    

    The following example shows the edits of the opmn_config file.


    RS=ebs-opmn
    RG=ebs-rg
    LH=ebs-lh
    HAS_RS=ebs-has
    VERSION=12.0
    COMNTOP=app-base-directory/inst/apps/SID_app-logical-host
    APPSUSER=oraapp-user
    APP_SID=PROD
    APPS_PASSWD=apps
    OPMN_COMPONENTS=all
  15. Enable the Oracle E-Business Suite resources.


    # clresource enable -g ebs-rg +