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

