Patch-ID# 107996-18 Keywords: security oracle8i dbms net8 nls haoracle_fmon_start svrmgrl Synopsis: Sun Cluster 2.2: HA-Oracle Patch Date: Jan/28/2004 Install Requirements: None Solaris Release: 2.6 SunOS Release: 5.6 Unbundled Product: Sun Cluster Unbundled Release: 2.2 Xref: This patch available for Solaris 7 as patch 107997 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 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: 109208-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 107996-17) 4660021 PL/SQL procedure core dumps when instance & listener restarted by fault monitor (from 107996-16) 4721488 Fix for bug 4426464 lost from the latest HA-Oracle patches (from 107996-15) 4642440 Oracle security issue breaks HA Oracle environment (from 107996-14) 4620825 sccs string correction (from 107996-13) 4457815 No error messages logged when listener fails (from 107996-12) 4406129 Sun Cluster Database DataService files write to /tmp insecurely 4426464 haoracle_fmon forks many processes when oracle has problem (from 107996-11) 4418855 Bug fixes lost from latest HA-Oracle patch (from 107996-10) 4411704 Changes made to HA-Oracle for bug/rti 4338298 should be backed out (from 107996-09) 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 107996-08) 4399187 Dependency on Framework patch not specified/enforced on HA-Oracle/HA-Sap patches (from 107996-07) 4374500 No error messages logged when listener fails 4304199 Oracle listener is stuck and a truss can free it (from 107996-06) 4344803 Node hangs during "shutdown immediate" stage of haswitch (HA-Oracle) (from 107996-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 107996-04) 4305300 Parse svrmgrl's version string for oracle 8.1.6, for ha_oracle fault monitor (from 107996-03) 4269425 logical host failover after message ID[SUNWcluster.ha.haoracle_fmon_7.3.2050] (from 107996-02) 4254151 haoracle fault monitor code built from older object 4261256 haoracle_fmon doesn't work like expected with SC2.2 and Oracle8.1.5 (from 107996-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: -------------------------------- Refer to the Install.info file within the patch for instructions on using the generic 'installpatch' and 'backoutpatch' scripts provided with each patch. Any other special or non-generic installation instructions should be described below. 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 full support for Solaris Resource Manager (4341392), one needs to install the following patches (or newer): 109208-07 Sun Cluster 2.2: Framework Patch 109211-03 Sun Cluster 2.2: Comm Patch 110653-01 Sun Cluster 2.2: Oracle Parallel Server Patch NOTE 2: To get the complete fix for files insecurely writing to /tmp, one needs to install the following patches (or newer): 109208-12 Sun Cluster 2.2: Framework Patch 109211-07 Sun Cluster 2.2: Comm Patch 108423-04 Sun Cluster 2.2: Data Service Common Patch 108511-03 Sun Cluster 2.2: HA-Sybase Patch 108351-04 Sun Cluster 2.2: HA-SAP Patch 111131-01 Sun Cluster 2.2: HA-Informix Patch 108505-05 Sun Cluster 2.2: Internet Pro Patch 108034-02 Sun Cluster 2.2: HA-Tivoli Patch 108447-04 Sun Cluster 2.2: HA-Lotus Patch 107388-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 o Remove the patch as usual. README -- Last modified date: Wednesday, January 28, 2004