Known Issues specific to the 9.2.0.6 Patch Set

• See Note 189908.1 for Support Status and Alerts affecting 9.2.0 releases.

This note lists known issues specific to the 9.2.0.6 Patch Set which are not documented in the Patch Set README. This includes known install issues and also bugs which are introduced in 9.2.0.6. See the Support Status note above for additional alerts.

9.2.0.6 README Additions

These are additions to the Patch Set README which are not documented in seperate notes.

• Problems applying Interim Patches on top of 9.2.0.6
  Attempting to apply interim patches on top of 9.2.0.6 with "opatch" can fail with errors of the form:
   OPatch detects your platform as XX while this patch nnnnnn supports platforms: YY (description)
  This issue is currently under investigation and is known to affect 9.2.0.6 on HPUX, Solaris Sparc 64bit and AIX 5L. See Note 292946.1 and Note 294658.1
  
  
• "Upgrade SYS Schema" SQL missing "EXECUTE" (4031110)
  The commands in the "Upgrade and SYS Schema" section of the README should read as follows:
    SQL> EXECUTE DBMS_STATS.DELETE_SCHEMA_STATS('SYS');
  SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('SYS');
  
  
• On some platforms the OUI shows as a seperate install option
  The Oracle Universal Installer (OUI) shows as a seperate install option on some platforms (eg: Linux). Please ensure you install the OUI from the Patch Set first and then install the Patch Set itself.
  
  
• PLS-302 may occur when creating a seed database using the Database Configuration Assistant (DBCA) on Solaris 32bit
  When using the DBCA to create a new database from the starter database, the following error message may occur:
    PLS-00302: component 'VALIDATE_COMPONENTS' must be declared
  This error can be ignored. However, the rdbms/admin/catpatch.sql script must be run on the newly created database to upgrade it to 9.2.0.6 .
  
  
• The Oracle Universal Installer (OUI) may core dump on Sun SPARC Solaris
  with the error
    ERROR: Unable to convert from "UTF-8" to "646" for NLS! Bus Error - core dumped.
  See Note 290034.1
  
  
• Solaris README has unapplicable text about globalization (4070666)
  The Solaris patch set note contains information about installing globalization support locale definition files. Ignore this information. It does not apply to this release.
  
  
• Linux systems minimum OS level not documented
  Linux systems should be at Redhat AS 2.1 Update 6 or kernel errata e.57 (or higher) to avoid problems with CJQ processes spinning.
  See Note 295403.1
  

Historic Issues

• Oracle Universal Installer (OUI) 10g not installed on HPUX
  Upgrading an ORACLE_HOME from 9.2.0.1/2/3/4 directly to 9.2.0.6 does not install the new OUI for patchset downloads prior to 2-Dec-2004. This can lead to subsequent opatch errors.
  See Note 293038.1 .

Related Notes

• Note 214887.1 Upgrading directly to a 9.2.0.X Patch Set

9.2.0.6 Alerts / Issues

This section lists alerts and important issues relevant to 9.2.0.6 .

General Alerts / Issues

Note:297306.1*	ORA-7445 SKGXPDMPCTX Instance Crash with 9.2.0.5 or 9.2.0.6 Patchset
Note:293893.1+	CLUSTER_INTERCONNECTS parameter does not work

Upgrade Issues

Note:294693.1P	AIX: 9.2.0.6 "prvtfile.plb" is zero bytes long (ORA-6508 for UTL_FILE)
Note:294647.1P	HPUX: 9.2.0.6 Patch Set does not update 32bit Cobol / Fortran Precompilers
Note:294190.1P	Solaris 64bit: OUI 10.1.0.3.0 reports "CHECKDIR" errors and does not start
4097516P	Solaris: Installing 9205/9206 Patch Set on Solaris 2.7 errors
4071941P	Sol64: 9.2.0.6 JDBC Patch does not include $OH/lib32/libocijdbc9.so
4063079P	Linux: Installing 9.2.0.6 Patch Set installs old "oracm" version
3530253P	HPUX: 9.2.0.5/6 root.sh errors with "chmod: invalid mode"

Security Alerts

Bug#	Security Alert#	Document	Summary
_	_	Note 301040.1	Critical Patch Update (Apr 2005)

Notable fixes included in 9.2.0.6

This section bugs fixed in 9.2.0.6 which may cause a notable change in behaviour.

3646162	False deadlock (ORA-60) in a RAC environment / TM lock mode change
2714430	Wrong results from ROWID comparison to rowid with slot#>32767

Issues introduced in 9.2.0.6

This section lists bugs introduced in 9.2.0.6 (if any). Such issues may be either serious or trivial but the aim is to list them all to help customers assess the risk of applying the Patch Set on top of 9.2.0.5

4157713+	OERI[KGHPIH:DS] can occur when shared pool under load
4080972+	Wrong results from RBO range predicate on concatenated index with NULLs
4074633P+	AIX5L: Higher CPU usage in RAC background processes in 9.2.0.6
4074603+	RMAN backup of primary with a standby using FAL may omit archivelogs
4066495+	CLUSTER_INTERCONNECTS parameter does not work
3691672+	OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
4254094	OERI[QERRMOBND1][932] possible for queries over DB links
4252656	Dump in ktfpsnps during flashback operatios
4197078	Dump (in qerilcil) with correlated variable in multi-column inlist
4187593	NULL data is not inserted correctly using a PLSQL table via JDBC
4172170	ORA-904 can occur referencing a TYPE definition in a TABLE() clause in PLSQL
4165093	Dump (in kkocpr) for SQL over database link
4154611	ORA-22992 can occur for distributed XML queries
4154591	Wrong results from single table joinback elimination
4142932	DBA_SEGMENTS.EXTENTS wrong for locally managed segment after TRUNCATE operation
4131501	Parse of query may spin when STAR_TRANSFORMATION_ENABLED = TRUE
4116896	ORA-932 using extractValue() in SQL inside PLSQL
4112324	OERI[16608] possible from some queries with pushed join predicates
4101485	FORALL inserts duplicate records / false constraint error for partitioned table
4098853	Dump (qerixGetKey->evaopn2) using COUNT(NOT_NULL_COLUMN) with a view
4082618	EXEC SQL ARRAYLEN does not work for length 0
4058160	OERI[KGHALO2] accessing earlier version Gateway
4047527	ORA-17500 ODM "file exists" error on CREATE CONTROLFILE
4039237	No rows returned from HASH join of CHAR columns containing only blanks
4016802	Incorrect export produced for transport of composite partitioned table
4015165	Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics
3998408	RAC instance may crash with OERI:kcsbcscn13
3963167	Wrong results / dump (KKOGTP) from JOIN between CHAR and VARCHAR2
3949307	SGA memory corruption / OERI:KGHALO4 with high concurrency
3945578P	Linux Redhat AS 2.1: CJQ process may spin consuming lots of CPU
3926058	V$SYSSTAT "opened cursors current" can be incorrect
3901170	False OERI [kghiexchk:ds] with event 10235 or 10501 set
3844015	OERI:713 / OERI:712 with fix for bug 3668224 enabled
3777178	TA / US enqueue deadlock during transaction recovery in RAC
3256015	Dump under qecgoc -> ... -> kkqs... -> kgl functions parsing a query
3228560	OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN

Symbols used in this document

In the lists above

• '*' indicates that an alert exists for that issue.
• '+' indicates a particularly notable issue / bug.
• 'P' indicates a port specific issue / bug.
• 'I' indicates an install issue / bug included for completeness.
• "OERI:nnnnn is used as shorthand for ORA-600 [nnnnn].