Patch-ID# 116427-05

NOTE:
***********************************************************************
READ THE TERMS OF THE AGREEMENT ("AGREEMENT") IN THE LEGAL_LICENSE.TXT
FILE CAREFULLY BEFORE USING THIS SOFTWARE. BY USING THE SOFTWARE, YOU
AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU DO NOT AGREE TO ALL OF THE
TERMS, PROMPTLY DESTROY THE UNUSED SOFTWARE.
***********************************************************************

Keywords: sunwscebs
Synopsis: Sun Cluster 3.0/3.1:HA-EBS patch
Date: Feb/10/2006


Install Requirements: See Special Install Instructions                      
                      
Solaris Release: 8 9 10

SunOS Release: 5.8 5.9 5.10

Unbundled Product: Sun Cluster

Unbundled Release: 3.1/3.0

Xref: 

Topic: Sun Cluster 3.0/3.1 HA-EBS patch

Relevant Architectures: sparc

BugId's fixed with this patch: 4952922 4952929 6219044 6230796 6230797 6375568 6375575 6375579 6376871

Changes incorporated in this version: 6375568 6375575 6375579 6376871

Patches accumulated and obsoleted by this patch: 

Patches which conflict with this patch: 

Patches required with this patch: 

Obsoleted by: 

Files included with this patch: 

/opt/SUNWscebs/bin/control_ebs
/opt/SUNWscebs/bin/functions
/opt/SUNWscebs/cmg/bin/functions
/opt/SUNWscebs/cmg/bin/probe_cmg
/opt/SUNWscebs/cmg/bin/start_cmg
/opt/SUNWscebs/cmg/bin/stop_cmg
/opt/SUNWscebs/cmg/lib/32/libloghost.so.1
/opt/SUNWscebs/cmg/lib/64/libloghost.so.1
/opt/SUNWscebs/cmg/util/cmg_config
/opt/SUNWscebs/cmg/util/cmg_register
/opt/SUNWscebs/cmg/util/copy_env
/opt/SUNWscebs/etc/SUNW.ebs
/opt/SUNWscebs/frm/bin/functions
/opt/SUNWscebs/frm/bin/probe_frm
/opt/SUNWscebs/frm/bin/start_frm
/opt/SUNWscebs/frm/bin/stop_frm
/opt/SUNWscebs/frm/util/frm_config
/opt/SUNWscebs/frm/util/frm_register
/opt/SUNWscebs/rep/bin/functions
/opt/SUNWscebs/rep/bin/probe_rep
/opt/SUNWscebs/rep/bin/start_rep
/opt/SUNWscebs/rep/bin/stop_rep
/opt/SUNWscebs/rep/util/rep_config
/opt/SUNWscebs/rep/util/rep_register

Problem Description:

6376871 Sun Cluster Data Service for Oracle E-Business Suite documentation needs updating
6375579 Oracle E-Business Suite Concurrent Mgr copy_env script comment is misleading
6375575 Oracle E-Business Suite concurrent manager shutdown takes too long, if DB or Internal Mgr is lost
6375568 Oracle E-Business Suite support for Solaris 10
 
(from 116427-04)
 
6230797	Cleanup up any FNDFSFNDFS on shutdown
6230796	Support for Oracle E-Business Suite 11.5.*
 
(from 116427-03)
 
6219044 Dummy RTR file requires #% SERVICE_NAME entry for package upgrade
 
(from 116427-02)
 
4952922 Support for Oracle E-Business Suite 11.5.9
 
4952929 cmg_register uses an incorrect value for Network_resources_used=
 
(from 116427-01)
 
Revision skipped.

Patch Installation Instructions:
-------------------------------- 
 
There are three (3) possible procedures for installing patches on 
Sun Cluster 3.0 and 3.1.  The proper method to use and any additional
instructions, for this patch are specified below in the "Special
Install Instructions" section.
 
Refer to the chapter entitled "Patching Sun Cluster Software and 
Firmware" in the Sun Cluster 3.0/3.1 System Administration Guide
for a description of the different install processes and instructions 
on how to install Sun Cluster 3.x patches.
 
For Solaris 8 release, refer to the man pages for instructions on 
using 'patchadd' and 'patchrm' scripts provided with Solaris.

Special Install Instructions:
----------------------------- 
 
Follow "How to Apply a Non-Rebooting Sun Cluster Patch" in the Sun
Cluster 3.0/3.1 System Administration Guide.
 
If this patch is being applied to a Solaris 10 system, the patch must be
applied to the global zone only by using the -G option for patchadd, e.g.
 
        <global zone># patchadd -G 116427-05
 
To remove the patch from a Solaris 10 system, you must also use the -G
option for patchrm, e.g.
 
        <global zone># patchrm -G 116427-05
 
When applying this patch, the files listed within the earlier section
will get overwritten. If you are applying this patch to an existing
deployment of Oracle E-Business Suite within Sun Cluster, you will have 
previously amended the following files
 
        /opt/SUNWscebs/cmg/util/cmg_config
 
and possibly these other files, if you have deployed these components
 
        /opt/SUNWscebs/frm/util/frm_config
        /opt/SUNWscebs/rep/util/rep_config
        /opt/SUNWscebs/web/util/web_config
 
If you want to keep the configuration information within these files then save
these files somewhere else before applying this patch.
 
If you are reading this after applying the patch, then remove this patch and
then save your /opt/SUNWscebs/<xxx>/util/<xxx>_config file as required. After
doing this, you can then re-apply this patch.
 
 
Note for bugid: 6376871 
 
	The Sun Cluster Data Service for Oracle E-Business Suite documentation 
	needs to be updated to reflect newer versions of Oracle E-Business Suite. 
 
	The following text reflects condensed documentation to install Oracle 
	E-Business Suite and to register the Sun Cluster Data Service for 
	Oracle E-Business Suite. 
 
	You will need to substitute your values for entries with <>.
 
	How to Install and Configure Oracle E-Business Suite
	----------------------------------------------------
 
	1. As root, execute the rapidwiz program to build your /var/tmp/config.txt file
 
	2. After building /var/tmp/config, execute rapidwiz -servername <logical_hostname>
	    for each logical hostname as required when /var/tmp/config.txt was built.
 
	2.1 If after installing the Web Server, you encounter the validation error, 
 
		"JSP is not responding, waiting 15 seconds and retesting"
 
	    Leave the rapidwiz gui and follow the steps below to resolve the validation 
	    error, after which you must return to the rapidwiz gui to retry the validation.
 
	2.1.1	su - <appsuser> 	
 
	2.1.2 	cd <Base_Install_Directory>/prodora/iAS/Apache/Apache/conf
 
	2.1.3 	vi httpd_pls.conf 
		Add entries for all physical Sun Cluster hostnames within the 
		<VirtualHost _default_:*> section, e.g. 
 
		Allow from <SC_Node>
		Allow from <SC_Node>.fqdn
 
	2.1.4	vi oprocmgr.conf
		Add entries for all physical Sun Cluster hostnames within the 
		<VirtualHost _default_:8100> section, e.g.
 
		Allow from <SC_Node>
		Allow from <SC_Node>.fqdn
 
	2.1.5	cd <Base_Install_Directory>/prodora/iAS/Apache/Jserv/etc
		Add entries for all physical Sun Cluster hostnames within the
		security.allowedAddresses entry, e.g.
 
		security.allowedAddresses=127.0.0.1,<logical_hostname>.fqdn,<SC_Node>.fqdn
 
	2.1.6	Restart Oracle E-Business Suite, e.g.
 
		su - <appsuser>
		cd <Base_Install_Directory>/prodcomn/admin/scripts/<SID>_<logical_hostname>
		./adstpall.sh apps/apps
 
		Exit back to root
 
		su - <dbuser>
		cd <Base_Install_Directory>/proddb/9.2.0/appsutil/scripts/<SID>_<logical_hostname>
		./addlnctl.sh stop <SID>
		./addbctl.sh stop immediate
 
		./addbctl.sh start
		./addlnctl.sh start <SID>
 
		Exit back to root
 
		su - <appsuser>
		cd <Base_Install_Directory>/prodcomn/admin/scripts/<SID>_<logical_hostname>
		./adstrtal.sh apps/apps
 
	2.2 Return to the rapidwiz gui and click Retry. The JSP check should now work.
 
	3. Post Oracle E-Business Suite Installation
 
	3.1	su - <appsuser>
		vi <Base_Install_Directory>/prodora/8.0.6/network/admin/<SID>_<logical_hostname>/listener.ora
		Add the following entries to the envs= parameter for the SID_NAME=FNDSM entry,
 
			LD_PRELOAD_32=/usr/lib/secure/libloghost.so.1 
			LHOSTNAME=<logical_hostname> 
 
		e.g. 
 
		( envs='LD_PRELOAD_32=/usr/lib/secure/libloghost.so.1,LHOSTNAME=<logical_hostname>,MYAPPSORA=...
 
		Exit back to root
 
		On all nodes within Sun Cluster that will host Oracle E-Business Suite
 
		cd /usr/lib/secure
		ln -s /opt/SUNWscebs/cmg/lib/32/libloghost.so.1 libloghost.so.1
 
	4. Stop Oracle E-Business Suite, so that Sun Cluster can manage it.
 
	4.1	su - <appsuser>
		cd <Base_Install_Directory>/prodcomn/admin/scripts/<SID>_<logical_hostname>
		./adstpall.sh apps/apps
 
		Exit back to root
 
		su - <dbuser>
		cd <Base_Install_Directory>/proddb/9.2.0/appsutil/scripts/<SID>_<logical_hostname>
		./addlnctl.sh stop <SID>
		./addbctl.sh stop immediate
 
 
	How to Register and Configure Sun Cluster HA for Oracle E-Business Suite as a Failover Service
	----------------------------------------------------------------------------------------------
 
	1. Ensure the failover Resource Groups, SUNW.LogicalHostname and SUNW.HAStoragePlus resources
	    are registered and configured. Refer to the Sun Cluster Data Service for Oracle E-Business
	    Guide for Solaris to perform these tasks.
 
	2. Create a resource for the Oracle E-Business Suite Oracle Database
 
	   scrgadm a -g <RG> -j <RES> -t SUNW.oracle_server \
	   -x Connect_string=apps/apps \
	   -x ORACLE_SID=<SID> -x ORACLE_HOME=<Base_Install_Directory>/proddb/9.2.0 \
	   -x Alert_log_file=<Base_Install_Directory>/proddb/9.2.0/admin/<SID>_<logical_hostname>/bdump/alert_PROD.log \
	   -y Resource_dependencies=<SUNW.HAStoragePlus_Resource>
 
	   scswitch -e -j <RES>
 
	3. Create a resource for the Oracle E-Business Suite Oracle Listener
 
	   cd /opt/SUNWscebs/cmg/util
	   ./copy_env	<Base_Install_Directory>/proddb/9.2.0 	<SID>_<logical_hostname>
 
	   scrgadm a -g <RG> -j <RES> -t SUNW.oracle_listener \
	   -x Listener_name=<SID> \
	   -x ORACLE_HOME=<Base_Install_Directory>/proddb/9.2.0 \
	   -x User_env=<Base_Install_Directory>/proddb/9.2.0/<SID>_<logical_hostname>_ha.env
	   -y Resource_dependencies=<SUNW.HAStoragePlus_Resource>
 
	   scswitch -e -j <RES>
 
	4. Create a resource for the Oracle E-Business Suite Concurrent Manager Listener
 
	   cd /opt/SUNWscebs/cmg/util
	   ./copy_env	<Base_Install_Directory>/prodora/8.0.6	<SID>_<logical_hostname>
 
	   cd <Base_Install_Directory>/prodora/8.0.6/bin
	   ls oracle
 
	   If there is no entry for oracle then create a dummy entry, e.g.
 
	   echo "Dummy entry for SC Concurrent Manager Listener resource - Do NOT remove" > oracle
 
	   scrgadm a -g <RG> -j <RES> -t SUNW.oracle_listener \
	   -x Listener_name=APPS_<SID> \
	   -x ORACLE_HOME=<Base_Install_Directory>/prodora/8.0.6 \
	   -x User_env=<Base_Install_Directory>/prodora/8.0.6/<SID>_<logical_hostname>_ha.env
	   -y Resource_dependencies=<SUNW.HAStoragePlus_Resource>
 
	   scswitch -e -j <RES>
 
	5. Create a resource for the Oracle E-Business Suite Concurrent Manager
 
	   cd /opt/SUNWscebs/cmg/util
	   vi cmg_config
	   ./cmg_register
 
	   scswitch -e -j <RES>
 
	6. Create a resource for the Oracle E-Business Suite Forms Server
 
	   cd /opt/SUNWscebs/frm/util
	   vi frm_config
	   ./frm_register
 
	   scswitch -e -j <RES>
 
	7. Create a resource for the Oracle E-Business Suite Reports Server
 
	   cd /opt/SUNWscebs/rep/util
	   vi rep_config
	   ./rep_register
 
	   scswitch -e -j <RES>
 
	8. Create a resource for the Oracle E-Business Suite Web Server (Apache)
 
	   cd <Base_Install_Directory>/prodcomn/admin/scripts/<SID>_<logical_hostname>
	   ln -s adapcctl.sh apachectl
 
	   vi adapcctl.sh
	   Modify the "$control_code" test to add -a "$control_code" != "configtest", e.g.
 
	   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"
	      exit 1;
	   fi
 
	   scrgadm -a -g <RG> -j <RES> -t SUNW.apache \
	   -y Port_list=8000/tcp \
	   -x Bin_dir=<Base_Install_Directory>/prodcomn/admin/scripts/<SID>_<logical_hostname> \
	   -y Resource_dependencies=<SUNW.HAStoragePlus_Resource>
 
	   scswitch -e -j <RES>
 
 
Note for bugid: 4952922
 
	Because, Oracle E-Business Suite v11.5.9 introduces the hostname within
	some pathnames, the Concurrent Manager, Forms Server and Reports Server
	must be removed and re-registered. Furthermore, the Oracle DB and 
	Listener as well as the Concurrent Manager Listener will need to be 
	removed and re-registered. 
 
	You may also need to remove and re-register the Apache Web Server if 
	this is running within Sun Cluster.
 
	The following steps show how to remove and re-register the Concurrent
	Manager, repeat this for the other components as required.
 
 
        1. Save the Concurrent Manager resource definitions.
                scrgadm -pvv -j <cmg_resource> > <file1>
 
        2. Offline the Concurrent Manager resource using
                scswitch -n -j <cmg_resource>
 
        3. Remove the Concurrent Manager resource using
                scrgadm -r -j <resource>
 
        4. Add the patch (On all nodes within the cluster)
 
        5. Edit /opt/SUNWscebs/cmg/util/cmg_config 
                and set the parameters as required.
 
        6. Run /opt/SUNWscebs/cmg/util/cmg_register 
                to register the Concurrent Manager resource.
 
        7. Rerun 1. above to a different file.
                scrgadm -pvv -j <cmg_resource> > <file2>
 
        8. Check that no resource property values have been reset, 
                i.e. timeout values
 
                diff <file1> <file2>
 
        9. Amend any resource property values that have been reset.
                scrgadm -c -j <cmg_resource> -x|y <property>=<value> 
 
        10. Bring Online the Concurrent Manager resource using
                scswitch -e -j <cmg_resource>

README -- Last modified date:  Friday, February 10, 2006