Patch-ID# 107997-18 Keywords: security oracle8i dbms net8 nls haoracle_fmon_start svrmgrl Synopsis: Sun Cluster 2.2: HA-Oracle Patch Date: Feb/18/2004 Install Requirements: None Solaris Release: 7 SunOS Release: 5.7 Unbundled Product: Sun Cluster Unbundled Release: 2.2 Xref: This patch available for Solaris 2.6 as patch 107996 Topic: Sun Cluster 2.2: HA-Oracle Patch NOTE: Refer to Special Install Instructions section for IMPORTANT specific information on this patch. Relevant Architectures: sparc BugId's fixed with this patch: 4170651 4210646 4244172 4254151 4261256 4269425 4304199 4305300 4308703 4313106 4313136 4317055 4341392 4344803 4373890 4374500 4385370 4399187 4406129 4411704 4418855 4426464 4457815 4620825 4642440 4660021 4721488 4852444 Changes incorporated in this version: 4852444 Patches accumulated and obsoleted by this patch: Patches which conflict with this patch: Patches required with this patch: 109209-02 or greater Obsoleted by: Files included with this patch: /etc/opt/SUNWscor/haoracle_support /opt/SUNWcluster/bin/dbms_utilities /opt/SUNWcluster/bin/haoracle /opt/SUNWcluster/ha/oracle/haoracle_fmon /opt/SUNWcluster/ha/oracle/haoracle_fmon_start /opt/SUNWcluster/ha/oracle/oracle_ccd_toggles /opt/SUNWcluster/ha/oracle/oracle_db_restart /opt/SUNWcluster/ha/oracle/oracle_db_shutdown /opt/SUNWcluster/ha/oracle/oracle_fm_init /opt/SUNWcluster/ha/oracle/oracle_fm_start /opt/SUNWcluster/ha/oracle/oracle_fm_stop /opt/SUNWcluster/ha/oracle/oracle_get_lh /opt/SUNWcluster/ha/oracle/oracle_get_version /opt/SUNWcluster/ha/oracle/oracle_monitor_process /opt/SUNWcluster/ha/oracle/oracle_shutdown /opt/SUNWcluster/ha/oracle/oracle_status /opt/SUNWcluster/ha/oracle/oracle_status_svcs /opt/SUNWcluster/ha/oracle/oracle_svc_abort_net /opt/SUNWcluster/ha/oracle/oracle_svc_start_net /opt/SUNWcluster/ha/oracle/oracle_svc_stop_net Problem Description: 4852444 After installing patch 109426-10 or -11, oracle_get_version fails (from 107997-17) 4660021 PL/SQL procedure core dumps when instance & listener restarted by fault monitor (from 107997-16) 4721488 Fix for bug 4426464 lost from the latest HA-Oracle patches (from 107997-15) 4642440 Oracle security issue breaks HA Oracle environment (from 107997-14) 4457815 No error messages logged when listener fails 4620825 sccs string correction (from 107997-13) 4406129 Sun Cluster Database DataService files write to /tmp insecurely 4426464 haoracle_fmon forks many processes when oracle has problem (from 107997-12) 4418855 Bug fixes lost from latest HA-Oracle patch (from 107997-11) 4411704 Changes made to HA-Oracle for bug/rti 4338298 should be backed out (from 107997-10) 4341392 Sun Cluster 2.2 is not aware of Solaris Resource Manager 4385370 bequeath_detach=yes causes local fault monitor to fail, leaving lots of children (from 107997-09) 4399187 Dependency on Framework patch not specified/enforced on HA-Oracle/HA-Sap patches (from 107997-08) 4304199 Oracle listener is stuck and a truss can free it 4374500 No error messages logged when listener fails (from 107997-07) 4373890 107996-06 did not include the correct oracle_shutdown for Solaris 7 (from 107997-06) 4344803 Node hangs during "shutdown immediate" stage of haswitch (HA-Oracle) (from 107997-05) 4308703 sc2.2onSol8 - the string "ORACLE7" is returned when doing pkginfo -l SUNWscor 4313106 HA-Oracle error messages where oracle version is printed are outdated. 4313136 HA-Oracle remote fault monitor complains due to change in Net8 for Oracle 8.1.6 4317055 "SQL*Net V2" is replaced by "Net8" with oracle 8.1.6 (from 107997-04) 4305300 Parse svrmgrl's version string for oracle 8.1.6, for ha_oracle fault monitor (from 107997-03) 4269425 logical host failover after message ID[SUNWcluster.ha.haoracle_fmon_7.3.2050] 4254151 haoracle fault monitor code built from older object 4244172 support for Oracle8i with Sun Cluster 2.2 4261256 haoracle_fmon doesn't work like expected with SC2.2 and Oracle8.1.5 (from 107997-02) 4244172 support for Oracle8i with Sun Cluster 2.2 4210646 Unable to restart database created with non usascii characterset 4170651 SC2.1 imposes a 1k limitation of tnsnames.ora file, can't support many instances (from 107997-01) 4244172 support for Oracle8i with Sun Cluster 2.2 4210646 Unable to restart database created with non usascii characterset 4170651 SC2.1 imposes a 1k limitation of tnsnames.ora file, can't support many instances Patch Installation Instructions: -------------------------------- For Solaris 2.0-2.6 releases, refer to the Install.info file and/or the README within the patch for instructions on using the generic 'installpatch' and 'backoutpatch' scripts provided with each patch. For Solaris 7-9 releases, refer to the man pages for instructions on using 'patchadd' and 'patchrm' scripts provided with Solaris. Any other special or non-generic installation instructions should be described below as special instructions. The following example installs a patch to a standalone machine: example# patchadd /var/spool/patch/104945-02 The following example removes a patch from a standalone system: example# patchrm 104945-02 For additional examples please see the appropriate man pages. Special Install Instructions: ----------------------------- Stop the Sun Cluster software on this node before applying this patch. Apply this patch to this node and then restart the Sun Cluster software after patch installation o login as root, then run the command: # scadmin stopnode o apply the patch as usual o restart the cluster on this node # scadmin startnode NOTE 1: To get the complete fix for files insecurely writing to /tmp, one needs to install the following patches (or newer): 109209-11 Sun Cluster 2.2: Framework Patch 109212-05 Sun Cluster 2.2: Comm Patch 108424-03 Sun Cluster 2.2: Data Service Common Patch 108512-03 Sun Cluster 2.2: HA-Sybase Patch 111132-01 Sun Cluster 2.2: HA-Informix Patch 111135-01 Sun Cluster 2.2: Internet Pro Patch 107538-05 Sun Cluster 2.2: System Management Patch Patch Backout: ------------- Before backing out the patch, make sure the cluster software is stopped on the node: o login as root, then run the command: # scadmin stopnode README -- Last modified date: Wednesday, February 18, 2004