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.


    Note –

    If deploying Oracle E-Business Suite within a zone cluster you must loopback mount /var/cluster/logs within the zone-cluster node, before registering the Oracle E-Business Suite components.

    On all the zone-cluster nodes, perform the following step:


    # mkdir /var/cluster/logs
    

    In the global zone where the zone-cluster node is running, perform the following step:


    # mount -F lofs /var/cluster/logs zonenode zonepath/root/var/cluster/logs
    

    After all the Oracle E-Business Suite components have been registered, /var/cluster/logs is no longer required within the zone-cluster node. To unmount the previously loopback mounted /var/cluster/logs, perform the following step from the global zone where you loopback mounted /var/cluster/logs:


    # umount zonenode zonepath/root/var/cluster/logs
    

    Edit the /opt/SUNWscebs/cmgslr/util/cmglsr_config file and follow the comments with in that file. After editing the cmglsr_config file, you must register the resource.


    # cd /opt/SUNWscebs/cmglsr/util
    # vi cmglsr_config
    # ./cmglsr_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 cmgslr_config file.


      RS=ebs-cmglsr
      RG=ebs-rg
      LH=ebs-lh
      HAS_RS=ebs-has
      COMNTOP=use appropriate COMNTOP
      APPSUSER=oraapp-user
      APP_SID=SID
      VERSION=12.0
  10. Create and register a resource for the Concurrent Manager.


    Note –

    A value for the APPS_PASSWD keyword within the /opt/SUNWscebs/cmgslr/util/cmg_config file is optional. You can either specify the password within the /opt/SUNWsebs//cmgslr/util/cmg_config file or within the /opt/SUNWscebs/.${APP_SID}_passwd file on each cluster node as super user. Specifying the password within the /opt/SUNWscebs/.${APP_SID}_passwd file will prevent the password from being viewed by non super users. Refer the comments within the /opt/SUNWscebs/cmgslr/util/cmg_config file for an example.



    Note –

    If deploying Oracle E-Business Suite within a zone cluster, you must loopback mount /var/cluster/logs with in the zone-cluster node before performing this step. See Step 9, for information to loop back mount /var/cluster/logs.


    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=password or empty 
      if using /opt/SUNWscebs/.${APP_SID}_passwd to store the password.
      ORACLE_HOME=oracle_home
      CON_LIMIT=50
      #
      # 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.



    Note –

    If deploying Oracle E-Business Suite within a zone cluster, you must loopback mount /var/cluster/logs with in the zone-cluster node before performing this step. See Step 9, for information to loop back mount /var/cluster/logs.


    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.



    Note –

    If deploying Oracle E-Business Suite within a zone cluster, you must loopback mount /var/cluster/logs with in the zone-cluster node before performing this step. See Step 9, for information to loop back mount /var/cluster/logs.


    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.


    Note –

    If deploying Oracle E-Business Suite within a zone cluster, you must loopback mount /var/cluster/logs with in the zone-cluster node before performing this step. See Step 9, for information to loop back mount /var/cluster/logs.


    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 +