# 
#  WARNING: Failure to carefully read and understand these requirements may
#  result in your applying a patch that can cause  your Oracle Server to
#  malfunction, including interruption of service and/or loss of data. 
# 
#  If you do not meet all of the following requirements, please log an
#  iTAR, so that an Oracle Support Analyst may review your situation. The
#  Oracle analyst will help you determine if this patch is suitable for you
#  to apply to your system. We recommend that you avoid applying any
#  temporary patch unless directed by an Oracle Support Analyst who has
#  reviewed your system and determined that it is applicable. 
# 
#-------------------------------------------------------------------------
#  Requirements: 
#-------------------------------------------------------------------------
#    - Your system configuration (Oracle Server version and patch
#      level, OS Version) must exactly match those listed below.
# 
#-------------------------------------------------------------------------
# Patchset Exception: 4067749 for MLR 4002909
#-------------------------------------------------------------------------
#
#
# DATE : January 09th 2005
# ------------------------
# Platform Patch for : 453 Solaris Operating System (SPARC 32-bit)
# Product Version #  : 8.1.7.4.0
# Product Patched    : RDBMS
#
#
# Bugs Fixed by this patch:
# -------------------------
#  
# BUGS 
#  4002909    - MLR
#   4057713   - EFFORT REPRESENTATIVE BUG - DATABASE_CPU_1 FOR 8.1.7.4
#   3889519   - UPLOAD IN SSL DOES NOT WORK WITH IE AFTER SECALERT 68
#               OR DB PATCH 9015
#   2363247   - UNNECESSARY BITMAP PATH GENERATION AND BITMAP MEM ALLOCATION
#   2379325   - WRONG COST CALCULATED AT KPRCDT
#   2410612   - CONVENTIONAL EXPORT HAS WRONG DATA ON IMPORT
#   2528524   - CLEAR TEXT PASSWORDS IN TRACE FILE
#   2598387   - WRONG DATA ON IMPORT AFTER EXPORT VIA CONVENTIONAL PATH
#   2643579   - ORA-7445 [10] CURSOR_SHARING=FORCE KXSPOAC 
#   2337115   - INTERRUPTEDEXCEPTION NO HANDLED PROPERLY BY JAVASSL
#   3926963   - MLR
#    1811914  - RDBMS BAD RECOVERY, LOST DATA IF CRASH DURING ALTER
#                TABLESPACE...READ ONLY
#    2073948  - ORA-6550 IN ANONYMOUS PL/SQL AFTER DROPPING TWO PARTITIONS
#               IN A REMOTE TABLE  
#    2238718  - RMAN BACKUP TO DISK HANGS, WAITING FOR CHANNEL TO FINISH
#               (IOCTL)
#    2268284  - ORA-12842 SCHEMA MODIFIED DURING PARALLEL EXECUTION
#    2271499  - ORA-1115,ORA-27063: CKPT CRASHED INSTANCE WHEN NON SYSTEM
#               DATAFILES UNAVAILABLE.
#    2346568  - DBMS_LOB.COMPARE HAS ORA600 AFTER CSCONV
#    2386334  - ORA-7445[QERUAROWPROCEDURE] SELECT FROM VIEW WITH UNION ALL
#    2401670  - ORA-1002 AFTER ROLLBACK-TO-SAVEPOINT IN PRO*C OR OCI
#               APPLICATION
#    2450264  - SIGSEGV, ORA-7445 [KOKMEOC()+48], THEN ORA-4031 AND MANY
#               ORA-600'S
#    2486714  - PATCH SET 8174 CHANGE THE PLAN FROM NESTED LOOP TO HASH JOIN.
#    2660592  - EXCESSIVE PARSE WHEN EXECUTING QUERIES THE FIRST TIME
#    2663395  - ACCESS ACROSS LOCAL VARIABLE BOUNDARY IN KCFRMC()
#    2664217  - APPST9202 HR FAMILY PACK CAUSES PACKAGE LOCKING
#    2791662  - ENTIRE INSTANCE SOMETIMES EXTREMELY SLOWS DOWN
#    3811838  - MLR
#     3828166 - EFFORT REPRESENTATIVE BUG - ALERT #68
#     0917604 - DB CRASHES WHEN INIT.ORA ORACLE_TRACE_COLLECTION_SIZE IS
#               REACHED
#     2128784 - TNS 12537 FROM DISPATCHER ON HPUX 8.1.7 WITH FAILOVER MODE
#               SETUP IN TNSNAMES
#     2198861 - TRYING TO DROP TRANSPORTABLE TABLESPACE GIVES
#               ORA-600[KTFBFGET-1]
#     2225569 - ORA-600 [KOKBNP2] EXECUTING PACKAGE WITH NESTED CURSOR AS
#               GRANTED USER
#     2228280 - CUSTOMER RECEIVING A NUMBER OF ORA-7445 ORA-600 ERROR
#     2288481 - SELECT DATA FROM A PARTITIONED TABLE CAUSES COREDUMP,
#                ORA-600[15212] OR ORA-7445
#     2293786 - TST1159.9 "SUBSTRB" GIVES INCORRECT WITH UTF8 IN PLSQL
#     2324795 - PERFORMANCE OF DICTIONARY VIEW DBA_SEGMENTS IS UNACCEPTABLE
#     2405244 - SIGSEGV, ORA-7445, CORE DUMP WHILE RMAN REPORTING RE-READ
#               OF CORRUPTED BLOCK
#     2444568 - ORA-600 [2886] [2] [1] IN DBWR, INSTANCE CRASH IF FGND DIES
#               IN ALTER...RDONLY
#     2479110 - SELF DEADLOCK WAITING ON "LIBRARY CACHE PIN" ON AUTO
#               RECOMPILATION OF PLSQL
#     2556845 - ORA-14452 ON EXPORT TABLESPACES IN PARALLEL
#     2580648 - MISSES IN LIBRARY CACHE FOR RECURRENT CALLS TO PL/SQL PROCEDURE
#     2594253 - SSL HANDSHAKE FAILURE IN 8.1.7.4
#     2656881 - SESSION EVENT REQUIRED TO DISABLE THE CLOB VARYING WIDTH FIX
#               IN BUG 2133357
#     2767834 - EXP OF META DATA FOR TRANSPORTABLE TABLESPACES IS SLOW FOR
#               MORE DATAFILES
#     2905667 - INSTANCE IS TERMINATED BY CKPT/LGWR DUE TO ORA-1110 DURING
#               SHUTDOWN.
#     2986643 - CHILD CURSORS ARE NOT CACHED WHEN EXECUTING SQL WITH DB LINK
#               AND SQL_TRACE=TRUE
#     3019460 - DBWR REPEATEDLY OPEN/CLOSES THE DATAFILES
#     3212916 - IP GETINPUTSTREAM ERRORS WITH "READ ERROR IN STREAM READ"
#     3315378 - BLOCKED INDEX ONLINE REBUILD HANGS OTHER SESSIONS
#     3197147 - JVM CRASHES ON AN E-BIZ 11.5.9 ENVIRONMENT CONFIGURED TO
#               USE SSL
#
#
#
# Contents of this patch:
# -----------------------
# README.txt install-patch.sh
#
# oraus.msb oraus.msg
#
# libnjssl8.so libnldapj8.so libnoncj8.so libowm2.so
#
# dbmsplts.sql dr0out.plb driload.pkh prvtpexp.plb prvtplts.plb
# prvtmd2.plb
#
# ctx/lib:libctx8.a:
# druf.o
# 
# network/lib:libn8.a:
# hdskcert.o,hdskkyex.o,nnciqd.o,nnfu.o,nsdo.o,nsev.o,
# ntvl.o,ssl2mesg.o,sslrec.o,sslx509.o
# 
# network/lib:libnl8.a:
# nlstd.o,nlstdgo.o,nlstdstp.o
# 
# network/lib:libnlsnr8.a:
# nsgca.o,nsgcmd.o,nsgcs.o,nsglcst.o,nsgle.o,nsglgr.o,
# nsglh.o,nsgli.o,nsgll.o,nsglm.o,nsglpnp.o,nsglro.o,
# nsgls.o,nsglsn.o,nsglv.o,nsgsubgt.o,nsgua.o,snsglsn.o
# 
# network/lib:libnro8.a:
# ncrfipm.o
# 
# network/lib:libnsslb8.a:
# asn1dec.o,pkcs.o
# 
# network/lib:libntcp8.a:
# ntt.o
# 
# network/lib:libnzjs8.a:
# nzjb.o,nzjcu.o,nzjh.o,nzjs.o,nzjsc.o,nzjscb.o,nzjsi.o,
# nzjsm.o,nzjsu.o,snzjs.o
# 
# oracore/lib:libcore8.a:
# ldidfs.o,ldiifs.o,ldiiftz.o,ldiinp.o,ldiout.o
# 
# plsql/lib:libpls8.a:
# pesblt.o
# 
# rdbms/lib:libclient8.a:
# kpuf.o
# 
# rdbms/lib:libcommon8.a:
# ttcf.o
# 
# rdbms/lib:libgeneric8.a:
# kgff.o,kgl.o,kgl2.o,kol.o,kolf.o,skgfr.o
# 
# rdbms/lib/libserver8.a:
# apa.o,atb.o,ctc.o,kcf.o,kcrr.o,kct.o,kcv.o,kdic.o,
# kfh.o,kfp.o,kkdl.o,kke.o,kkm.o,kko.o,kkqu.o,kks.o,
# kksl.o,kokb.o,kokb2.o,kokl.o,kokm.o,kprc.o,kql.o,
# krb.o,krvd.o,kta.o,ktc.o,ktec.o,kxs.o,nsoqbc.o,
# opiall.o,opiodr.o,prsa.o,prsc.o,prsf.o,prssz.o,
# psdicd.o,qkadrv.o,qol.o,tbsdrv.o,vop.o
#
#
# 
# Patch Installation Instructions:
# --------------------------------
# To apply the patch, set your current directory to the directory
# where the patch is located and then run the appropriate script by
# entering the following Unix command:
#
# % cd <patch download directory>
# % unzip p4002909_8174_SOLARIS.zip
# % cd 4067749
# % unzip DB_8.1.7.4.zip
# % cd DB_8.1.7.4 
# % sh install-patch.sh
#
# To run the script and create a log file use the following command
#
# if your login shell is the csh, or csh style shell;
#
# % sh ./install-patch.sh |& tee patch.log
#
# if your login shell is the sh, or sh style shell;
# 
# $ sh ./install-patch.sh 2>&1 | tee patch.log
#
#
#
# Patch Special Instructions:
# ---------------------------
#
# Make sure that all instances running under the ORACLE_HOME being patched
# are cleanly shutdown before installing this patch. Also ensure that the
# tool used to terminate the instance(s) have also been exited cleanly.
#
#
#
# When the system has been patched and all required executables have been
# relinked and you are applying this against a server install please do
# the following
#
#
# Execute the following commands to reload the following
# scripts in the order listed;
#
# Note: During the execution of the sql script dbmsplts.sql you
#       may see the following error reported a few times, these
#       can be safely ignored.
#
#       ERROR at line 1:
#       ORA-00942: table or view does not exist
#
# Note: While connecting to the mdsys schema you may see the
#       following error, this can be safely ignored.
#
#       Error accessing PRODUCT_USER_PROFILE
#       Warning:  Product user profile information not loaded!
#       You may need to run PUPBLD.SQL as SYSTEM
#
#
#
# Reload the following package as a DBA;
#
# % cd $ORACLE_HOME/rdbms/admin
# % sqlplus "/ as sysdba"
# SQL> @dbmsplts.sql
# SQL> @prvtpexp.plb
# SQL> @prvtplts.plb
# SQL> exit
#
#
#
# Note: To check if you have Context installed use
#       the following sql.
#       "select ctxsys.dri_version from dual;"
#
# If Context is installed, run the following:
#
# % cd $ORACLE_HOME/ctx/admin
# % sqlplus "/ as sysdba"
# SQL> alter session set current_schema=CTXSYS;
# SQL> select ctxsys.dri_version from dual;
# SQL> @dr0out.plb 
# SQL> @driload.pkh
# SQL> exit
#
#
#
# Note: Please use the appropriate password for
#       the mdsys schema.
#
# If Oracle spatial is installed, run the following:
#
# % cd $ORACLE_HOME/md/admin
# % sqlplus "mdsys/mdsys"
# SQL> @prvtmd2.plb
# SQL> exit
#
#
#
# Finally, compile any invalid PL/SQL objects
#
# cd $ORACLE_HOME/rdbms/admin
# sqlplus "/ as sysdba"
# SQL> select count(1) from all_objects where STATUS = 'VALID';
# SQL> select count(1) from all_objects where STATUS <> 'VALID';
# SQL> @utlrp.sql
# SQL> select count(1) from all_objects where STATUS = 'VALID';
# SQL> select count(1) from all_objects where STATUS <> 'VALID';
# SQL> exit
#
#
#
# Patch Deinstallation Procedure Instructions:
# --------------------------------------------
# To deinstall the patch, if there are errors or other problem with
# this patch, please run the undo_pre<bug number>.sh shell script
# which is generated automatically when patch.sh is run. Use the
# following syntax to run the deinstall script:
#
# % sh undo_pre4002909_8.1.7.4.0.sh
#
# After deinstalling the patch, revert back to the previous sql
# scripts.
#
#
#
# Reload the following package as a DBA;
#
# % cd $ORACLE_HOME/rdbms/admin
# % sqlplus "/ as sysdba"
# SQL> @dbmsplts.sql
# SQL> @prvtpexp.plb
# SQL> @prvtplts.plb
# SQL> exit
#
#
#
# If Oracle Text is installed, run the following:
#
# % cd $ORACLE_HOME/ctx/admin
# % sqlplus "/ as sysdba"
# SQL> alter session set current_schema=CTXSYS;
# SQL> @dr0out.plb 
# SQL> @driload.pkh
# SQL> exit
#
#
#
# Note: Please use the appropriate password for
#       the mdsys schema.
#
# If Oracle spatial is installed, run the following:
#
# % cd $ORACLE_HOME/md/admin
# % sqlplus "mdsys/mdsys"
# SQL> @prvtmd2.plb
# SQL> exit
#
#
#
# Finally, compile any invalid PL/SQL objects
#
# cd $ORACLE_HOME/rdbms/admin
# sqlplus "/ as sysdba"
# SQL> select count(1) from all_objects where STATUS <> 'VALID';
# SQL> select count(1) from all_objects where STATUS = 'VALID';
# SQL> @utlrp.sql
# SQL> select count(1) from all_objects where STATUS <> 'VALID';
# SQL> select count(1) from all_objects where STATUS = 'VALID';
# SQL> exit
#
#
#
# Patch Description:
# ------------------
# The patching script is a UNIX shell script that installs Oracle patches.
# In summary, it:
#    + saves a copy of any objects that it is about to update;
#    + relinks any products as necessary;
#    + creates an undo script so that the patch can be removed later.
#
# the script saves objects in $ORACLE_HOME/lib in the following format:
#    .<object-name>.pre<bug-number>_<5 digit version>
#        
#    eg:    .vop.o.pre4002909_8.1.7.4.0
#
# Where patches can be applied to several versions, the 5 digit version
# used in the filename of the saved object may be different from the 5
# digit version that a customer is actually running.
#
# Each Oracle fix has a unique patch script; do not use the patch script
# from one fix to apply a patch for another.
