test

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 oracle-ebusiness-suite-resource-group

  4. Create a resource for the Oracle E-Business Suite Logical Hostname.


    # clreslogicalhostname create -g oracle-ebusiness-suite-resource-group \
> -h logical-hostname \
> logical-hostname-resource

  5. Create a resource for the Oracle E-Business Suite Disk Storage.

    1. If a ZFS highly available local file system is being used.


      # clresource create -g oracle-ebusiness-suite-resource-group \
> -t SUNW.HAStoragePlus \
> -p Zpools=oracle-ebusiness-suite-zspool \
> oracle-ebusiness-suite-hastorage-resource

    2. If a cluster file system or a non ZFS highly available local file system is being used.


      # clresource create -g oracle-ebusiness-suite-resource-group \
> -t SUNW.HAStoragePlus \
> -p FilesystemMountPoints=oracle-ebusiness-suite-filesystem-mountpoint \
> oracle-ebusiness-suite-hastorage-resource

  6. Enable the Resource Group.


    # clresourcegroup enable -M oracle-ebusiness-suite-resource-group

  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.


    # clresource create -g oracle-ebusiness-suite-resource-group \
> -t SUNW.oracle_Server \
> -p Connect_string=apps/apps \
> -p ORACLE_SID=SID \
> -p ORACLE_HOME=base-directory/siddb/9.2.0 \
> -p Alert_log_file=base-directory/siddb/9.2.0/admin/SID_lhost/bdump/alert_SID.log \
> -p Restart_type=RESOUCRE_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 below.


    # cd /opt/SUNWscebs/cmg/util
# ./copy_env base-directory/siddb/9.2.0 SID_lhost 
# clresource create -g oracle-ebusiness-suite-resource-group \
> -t SUNW.oracle_listener \
> -p Listener_name=SID \
> -p ORACLE_HOME=base-directory/siddb/9.2.0 \
> -p User_env=base-directory/siddb/9.2.0/SID_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 –

    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 below.


    # cd /opt/SUNWscebs/cmg/util
# ./copy_env base-directory/sidora/8.0.6 SID_logical-hostname 
# cd base-directory/sidora/8.0.6/bin
# ls oracle

    If there is no entry for oraclethen create a dummy entry.


    # echo "Required for SC cmg Listener resource" > oracle
# ./copy_env base-directory/sidora/8.0.6 SID_logical-hostname 
# ls base-directory/sidora/8.0.6/bin/oracle
# clresource create -g oracle-ebusiness-suite-resource-group \
> -t SUNW.oracle_listener \
> -p Listener_name=APPS_SID \
> -p ORACLE_HOME=base-directory/sidora/8.0.6 \
> -p User_env=base-directory/sidora/8.0.6/SID_lhost_ha.env \
> -p Resource_dependencies=oracle-ebusiness-suite-hastorage-resource \
> concurrent-manager-listener-resource
# clresource enable concurrent-manager-listener-resource

  10. Create and register a resource for the Concurrent Manager.

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


    # cd /opt/SUNWscebs/cmg/util
# vi cmg_config
# ./cmg_register

    The following example shows cmg_config that has been edited.


    RS=oebs-cmg
RG=oebs-rg
LH=oebs-lh
HAS_RS=oebs-has
LSR_RS=oebs-cmglsr
VERSION=11.5.10
COMNTOP=base-directory/sidcomn
APPSUSER=oraapp-user
APP_SID=SID
APPS_PASSWD=apps
ORACLE_HOME=base-directory/sidora/8.0.6
CON_LIMIT=70
MODE=32/Y
#
# Required for Oracle E-Business Suite version 11.5.10 CU2 or later
#
ORASVR_RS=oebs1-orasvr
ORALSR_RS=oebs1-oralsr

  11. Create and register a resource for the Forms Server.

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


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

    The following example shows frm_config that has been edited.


    RS=oebs-frm
RG=oebs
LH=oebs-lh
HAS_RS=oebs-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.

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


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

    The following example shows rep_config that has been edited.


    RS=oebs-rep
RG=oebs
LH=oebs-lh
HAS_RS=oebs-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.


    # 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 oracle-ebusiness-suite-resource-group \
> -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. Enable the Oracle E-Business Suite resources.


    # clresource enable -g oracle-ebusiness-suite-resource-group +