Skip Headers

Oracle9i Database Server Patch Set Notes
Release 2 Patch Set 3 Version 9.2.0.4.0 for Solaris Operating Environment (SPARC 64-bit)
 

 

Copyright © 2001, 2003  Oracle. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Oracle9i Database Server

Patch Set Notes

Release 2 Patch Set 3 Version 9.2.0.4.0 for Solaris Operating Environment (SPARC 64-bit)

August 2003

These patch set notes accompany the Oracle9i release 9.2.0.4 patch set. This patch set includes the patches for all previous 9.2.0.x patch sets, and patches for the following:

This is not a complete software distribution. You must install it over an existing Oracle9i release 9.2.0.x.x server installation. Users applying this patch set must use Oracle Universal Installer release 2.2.0.18.0 or later to ensure their Oracle home can be patched in the future. The patch set is packaged with a fully installable version of Oracle Universal Installer 2.2.0.18.0 to support this requirement. When beginning the installation, you will be presented with a screen to select Oracle Universal Installer 2.2.0.18.0 or Oracle9i 9.2.0.4.0 patch set. You should select Oracle Universal Installer first. Attempts to install the patch set without Oracle Universal Installer 2.2.0.18.0 will cause an error.

This document contains the following sections:

Patch Set Overview

Patch sets are a mechanism for delivering fully tested and integrated product fixes on a regular basis. Patch sets provide bug fixes only; they do not include new functionality, and do not require certification on the target system.

Patch sets include all the libraries that have been rebuilt to implement the bug fixes in the set. All the fixes in the patch set have been tested and are certified to work with each other. Because the patch set includes only low impact patches, it does not require you to certify applications or tools against the server.

Patch sets are cumulative. For example, patch set release 9.2.0.2 would include all the fixes in release 9.2.0.1 as well as new fixes for release 9.2.0.2. This means that unless the patch set documentation indicates otherwise the patch set can be applied to any earlier 9.2.0 version. There is no requirement to install all intermediate patch sets.

Patch sets contain the same set of generic fixes across all platforms. Patch sets may also include additional patches specific to the platform on which they are released.

Oracle provides both 32-bit and 64-bit versions of the Oracle9i database server on the Solaris operating system. The 32-bit version of the database can be run on the 32-bit or 64-bit version of the operating system per certification. The 64-bit version of the database can only be run on the 64-bit version of the operating system.


Note:

The 32-bit version of the patch set must only be installed on the 32-bit version of the database, regardless of whether the operating system is 32-bit or 64-bit. The 64-bit version of the patch set must only be installed on the 64-bit version of the database which runs on the 64-bit operating system.

Patch sets include the Oracle Universal Installer 2.2.0.18.0. You should use this installer to install this patch set and not the one from the 9.2.0.x maintenance release media or Oracle home.

Post-release Updates

Before installing this patch set in a production environment, review the OracleMetaLink site. Oracle Support provides information about the status of issues discovered after this patch set is released on OracleMetaLink. The information is available in document 189908.1, ALERT: Oracle9i Release 2 (9.2) Support Status and Alerts. To locate the document on OracleMetaLink, enter the document number in the search field, and click Search.

OracleMetaLink is available at the following URL

http://metalink.oracle.com/

If you are unable to access this site, then contact Oracle Support before installing this patch set in a production environment.

System Requirements

The following are the system requirements for this patch set:

Patch Set Components

The following table provides a list of patch set components:

Component Version
Advanced Queuing (AQ) API 9.2.0.4.0
Agent required support files 9.2.0.4.0
Assistant common files 9.2.0.4.0
Data Management Services common files 9.2.0.4.0
Authentication and encryption 9.2.0.4.0
Database SQL scripts 9.2.0.4.0
Database Verify utility 9.2.0.4.0
DCE integration 9.2.0.4.0
Export/import 9.2.0.4.0
External naming: NIS 9.2.0.4.0
Generic connectivity common files 9.2.0.4.0
Generic connectivity using ODBC 9.2.0.4.0
JDBC common files 9.2.0.4.0
JDBC/OCI common files 9.2.0.4.0
LDAP required support files 9.2.0.4.0
Migration utility 9.2.0.4.0
Object type translator 9.2.0.4.0
Oracle C++ Call Interface 9.2.0.4.0
Oracle Call Interface (OCI) 9.2.0.4.0
Oracle Client required support files 9.2.0.4.0
Oracle Connection Manager 9.2.0.4.0
Oracle Core required support files 9.2.0.4.0
Oracle database demos 9.2.0.4.0
Oracle database utilities 9.2.0.4.0
Oracle Data Mining 9.2.0.4.0
Oracle interMedia Client compatibility files 9.2.0.4.0
Oracle interMedia Java Advanced Imaging 9.2.0.4.0
Oracle Internet Directory Client 9.2.0.4.0
Oracle Internet Directory Server 9.2.0.4.0
Oracle Intelligent Agent 9.2.0.4.0
Oracle interMedia Locator 9.2.0.4.0
Oracle JDBC Development Drivers 9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.2 9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.4 9.2.0.4.0
Oracle JVM 9.2.0.4.0
Oracle Java Tools 9.2.0.4.0
Oracle Label Security 9.2.0.4.0
Oracle Names 9.2.0.4.0
Oracle Net Configuration Assistant 9.2.0.4.0
Oracle Net Listener 9.2.0.4.0
Oracle Net Manager 9.2.0.4.0
Oracle Net 9.2.0.4.0
Oracle Net Protocol Support 9.2.0.4.0
Oracle Net required support files 9.2.0.4.0
Oracle OLAP 9.2.0.4.0
Oracle Partitioning 9.2.0.4.0
Oracle9i Real Applications Clusters Guard 9.2.0.4.0
Oracle Text 9.2.0.4.0
Oracle Transparent Gateway for Informix 9.2.0.4.0
Oracle Transparent Gateway for INGRES II 9.2.0.4.0
Oracle Transparent Gateway for Sybase 9.2.0.4.0
Oracle Transparent Gateway for Teradata 9.2.0.4.0
Oracle UltraSearch common files 9.2.0.4.0
Oracle UltraSearch middle-tier 9.2.0.4.0
Oracle UltraSearch server 9.2.0.4.0
Oracle Wallet Manager 9.2.0.4.0
Oracle XML Developer’s Kit 9.2.0.6.0
Oracle XML SQL utility 9.2.0.4.0
Oracle9i Globalization 9.2.0.4.0
Oracle9i Real Applications Clusters 9.2.0.4.0
Oracle9i
9.2.0.4.0
Oracle PL/SQL 9.2.0.4.0
Oracle PL/SQL required support files 9.2.0.4.0
Precompiler common files 9.2.0.4.0
Precompiler required support files 9.2.0.4.0
Pro*C/C++ 9.2.0.4.0
Pro*COBOL 1.8.77.4.0
Pro*COBOL 9.2.0.4.0
Pro*FORTRAN 1.8.77.4.0
Oracle database required support files 9.2.0.4.0
Oracle Recovery Manager 9.2.0.4.0
Secure Socket Layer (SSL) 9.2.0.4.0
SQL*Loader 9.2.0.4.0
SQL*Module Ada 9.2.0.4.0
SQL*Module common files 9.2.0.4.0
SQL*Plus 9.2.0.4.0
SQLJ Runtime 9.2.0.4.0
SSL required support files 9.2.0.4.0
Utilities common files 9.2.0.4.0
XML Parser for C 9.2.0.4.0
XML Parser for C++ 9.2.0.4.0
XML Parser for Java 9.2.0.4.0
XML Parser for PL/SQL 9.2.0.4.0
XML Parser for Oracle JVM 9.2.0.4.0
XSQL Servlet 9.2.0.4.0

Pre-Installation Tasks

This section includes the following topics:

Pre-installation Tasks for Oracle Real Applications Clusters

This patch set allows you to install the included patches onto multiple nodes in a cluster when the base release (9.0.1.0.0) is already installed on those nodes. The Oracle Universal Installer will detect whether the machine where you are installing is part of cluster. If it is, then you will be prompted to select the nodes from the cluster onto which you would like to install the patch set.


Note:

It is important the set of nodes that will have the patch set installation be the same set of nodes which had the base release installation. Choosing a different set of nodes during the patch set installation than were chosen during the base release installation will cause undesired behavior in your Oracle Real Application Clusters environment, as some nodes will be upgraded to the new software versions, while others will not.

Pre-Installation Tasks for Oracle Real Applications Clusters with Sun Clusterware

The UDLM 3.3.4.6 patch must be installed before applying this patch set for Oracle Real Applications Clusters environments. If the UDLM patch was applied while applying the 9.2.0.3.0 patch set, then you do not have to reapply it now. The UDLM patch is included in this patch set. The installation instructions are located in the /Disk1/racpatch/README.udlm file.

Installation Tasks

The instructions for installing this patch set assume a minimal familiarity with Oracle Universal Installer. Prior to installing the patch set, Oracle recommends that you create a backup of your system.


Note:

If an attempt to install this patch set on an Oracle database prior to release 9.2.0, then a warning dialog is displayed with the following error:
There are no patches that need to be applied from the patch set Oracle9i patch set 9.2.0.4.0.

The installer will not allow the installation to proceed. The user should acknowledge the error message, and click Exit to end the installation.


The following procedure describes how to install the patch set:

  1. Log in as the oracle account and make sure the environment is set to the correct ORACLE_HOME and ORACLE_SID variables.

  2. Uncompress the downloaded patch set file into a new directory and extract the cpio archive files using the following command:

    cpio -idmv < 9204_solaris64_release.cpio
    
    
  3. Shut down the existing Oracle server instance with normal or immediate priority. For example, shutdown all instances (cleanly) if running Parallel Server.

  4. Stop all listener, agent and other processes running in or against the ORACLE_HOME that will have the patch set installation.

  5. Start the installer. Use the Oracle Universal Installer 2.2.0.18.0 runInstaller script located in the untarred area of the patch set, such as /Disk1/runInstaller.


    Note:

    If you are installing the Oracle9i patch set 9.2.0.4.0 on an Oracle Real Applications Clusters environment, then you must install the Oracle Universal Installer 2.2.0.18.0 on all nodes on the cluster before installing the patch set.

  6. Install the patch set through either an interactive or a silent installation.

    To perform an interactive installation using the Oracle Universal Installer graphical interface:

    1. Start the installer from one of the directories that is appropriate on your installation using the following command:

       % ./runInstaller
      
      
    2. Click Next on the Welcome screen. This will display the File Locations screen.


      Note:

      If you are installing the patch set in a cluster environment, then the Cluster Node Selection screen will appear after clicking Next. After selecting the node, click Next. The File Locations screen will appear.

    3. Click Browse for the Source... entry field.

    4. Navigate to the stage directory where you unpacked the patch set tar file.

    5. Select the products.jar file.

    6. Click Next. The Available Products window will appear. The products file will be read and the installer will load the product definitions. The products to be loaded will be displayed.


      Note:

      If Oracle Universal Installer 2.2.0.18.0 has not been installed, then install that first. If Oracle Universal Installer 2.2.0.18.0 has been installed, then install the Oracle9i 9.2.0.4.0 patch set.

    7. Verify the products listed in the display.

    8. Click Install.

    9. Run the $ORACLE_HOME/root.sh script from a root session when prompted by the installer. If you are applying the patch set in a cluster database environment, then the root.sh script should be run in the same way on both the local node and participating nodes.

    10. Click OK on the installer prompt window. Once the installation has completed successfully, it will display End of Installation.

    11. Click Exit, and confirm to exit the installer.

    To perform a silent installation requiring no user intervention:

    1. Copy the response file template provided in the response directory where you unpacked the patch set tar file.

    2. Edit the values for all fields labeled as <Value Required> according to the comments and examples in the template.

    3. Start the installer from the directory described in Step 4 which applies to your situation. You should pass the full path of the response file template you have edited locally as the last argument with your own value of ORACLE_HOME and FROM_LOCATION. The following is an example of the command:

      % ./runInstaller -silent -responseFile full_path_to_your_response_file
      
      
    4. Run the $ORACLE_HOME/root.sh script from a root session. If you are applying the patch set in a cluster database environment, the root.sh script should be run in the same way on both the local node and all participating nodes.

Post-Installation Tasks

Perform the post-installation tasks only if you have one or more databases associated to the upgraded $ORACLE_HOME.

The following are requirements for the post-installation tasks:

The following describes the post-installation procedure. These tasks should be run on all updated databases. If you are using the OLAP option, then ensure the database listener is up.

  1. Start the database listener using a command such as lsnrct start.

  2. Log in as sysdba using SQL*Plus.

  3. Run the following commands and scripts in order from ORACLE_HOME in migrate mode on all updated databases. If you are using the OLAP option, then ensure the database listener is up.

    1. Run the startup migrate command.


      Note:

      If running Oracle Real Applications Clusters, then set cluster_datbase in initSID.ora to FALSE prior to starting in migrate mode

    2. Run the spool patch.log command.

    3. Run the @?/rdbms/admin/catpatch.sql script.

    4. Run the spool off command.

    5. Review the patch.log file for errors, and rerun the catpatch.sql script after correcting any problems.

    6. Run the shutdown command.

    7. Run the startup command.

    8. Run the @?/rdbms/admin/utlrp.sql script. This step is optional, and will recompile all invalid PL/SQL packages now instead of when the packages are accessed the first time. The utlrcmp.sql script can be used to parallelize this in multiprocessor machines.

    9. Enter the following commands if using Oracle OLAP option:

      alter user olapsys identified by password account unlock;
      connect olapsys/password
      @cwmlite/admin/postamd.sql
      
      
    10. Run the exit command.

  4. Perform the following shell scripts only if Oracle Internet Directory version 9.2.0.x.x was installed in the ORACLE_HOME. Ensure the database and database listener are running, and all parameters for the oidpatchca.sh script are specified prior to running the script:

    $ORACLE_HOME/bin/oidpatchca.sh 
    -connect Connect String 
    -lsnrport Listener Port 
    -systempwd SYSTEM Password 
    -odspwd ODS Password 
    -sudn Super-User DN 
    -supwd Super-User Password 
    -dippwd Password to register DIP Server 
    
    

    In the preceding commands, Password to register DIP Server must conform to the password policy in the Oracle Internet Directory server.

  5. Perform the following steps only if using the Oracle Recovery Manager catalog:

    rman catalog <user/passwd@alias> 
    upgrade catalog; 
    upgrade catalog; 
    

Re-installation Tasks

The patch set can be re-installed if the Oracle home has been corrupted, and you want to restore the updated Oracle home.

The following describes how to re-install the patch set:

  1. Make sure you do the same set of pre-installation tasks were performed when installing that patch set initially:

    1. Log in as the oracle account and make sure the environment is set to the correct ORACLE_HOME and ORACLE_SID.

    2. Uncompress and untar the downloaded patch set file into a new directory.

    3. Shut down the existing Oracle server instance with normal or immediate priority. For example, shutdown all instances (cleanly) if running Parallel Server.

    4. Stop all listener, agent and other processes running in or against the ORACLE_HOME that will have the patch set installation.

  2. Start the installer in the same manner that you did when installing the patch set initially. You may only re-install a patch set by running the installer in interactive mode.

  3. Perform the following tasks using the installer:

    1. Click Next on the Welcome screen. This will display the File Locations screen.

    2. Click Browse for the Source... entry field and navigate to the stage directory where you unpacked the patch set tar file.

    3. Select the products.jar file.

    4. Click Next. The products file will be read and the installer will load the product definitions. The installer will display the Available Product Component screen. This screen contains a listing of all components that have been patched by the original patch set installation. These components will be grayed out, indicating they cannot be selected for installation.

    5. Expand the node for each component listed in the tree. You will see a patch that corresponds to each component.

    6. Select the patch for installation by selecting the check box to the left of the patch name. As you do this, the Install Status column should say "reinstall."

    7. Repeat the process for each patch bundled in the patch set.

    8. Click Next. The patches to be re-installed will be displayed.

    9. Verify the list of patches to be re-installed.

    10. Click Install. Once the installation is completed successfully, it will display End of Installation.

    11. Click Exit, and confirm to exit the installer.

De-installation Tasks

There is no mechanism provided for de-installing patch sets. If you are concerned about being able to de-install a patch set, Oracle Corporation recommends you back up your software installation before applying the patch set.

If you must de-install a patch set, Oracle recommends one of the following procedures (in order of preference):

Regardless of how you de-install a patch set, please contact Oracle Support Services to verify that the problem you are encountering is addressed.

Known Issues

The following issues apply to this patch set release:

CORE Version Shows 9.2.0.3 in V$VERSION

The CORE version in V$VERSION shows 9.2.0.3 after a successful upgrade of the database. This does not cause any problems, and can be ignored by the user.

Bugs 2033385 and 2181830

Using a database link to connect to a read-only database to select data from a view fails, and returns errors ORA-4052, ORA-604, ORA-372, ORA-1110, and ORA-2063. You cannot use a database link to select data from a view using a cursor loop.


Workaround

Avoid using the database link to query views using a cursor loop. This problem only occurs with a view. It does not occur when using a SELECT statement directly from the view using a cursor loop to select from a table.

Bugs 2301915, 2318295 and 2326341

When using the Oracle Streams Wizard, through Oracle Management Server or in standalone mode, to configure replication, the generated scripts are incorrect and may produce errors such as "ORA-26687 Instantiation SCN not set" or "ORA-1403 no data found". Contact Oracle Support Services for an Oracle Enterprise Manager and Oracle Management Server patch that will produce the correct scripts. Use the bug numbers as a patch reference.

Bug 2602782

Scrollable ResultSet returns 3 times NCHAR character byte size when database Ncharset is UTF8. Problem occurs with JDBC Thin driver only.

Bug 2629196

In 9.2.0.2 patch set while using XML DB, character set conversion does not take place when NLS_LANG is not the same as the database character set. With this patch set, clients must set their NLS_LANG to the database character set, otherwise incorrect data is returned with no error or warning whenever character conversion is required.

Bug 2659230

Oracle Data Guard Concepts and Administration, Oracle part number A96553-02, only describes how to instantiate a logical standby database for a single-instance primary database. To register a log for multiple threads of an Oracle Real Applications Clusters primary database, use the following query in place of the one that is documented in "Section 4.2.2, Step 8 Identify the latest archived redo log:"

SQL r

  1 SELECT NAME FROM V$ARCHIVED_LOG
  2    WHERE FIRST_CHANGE# <= (SELECT MAX(FIRST_CHANGE#) FROM V$ARCHIVED_LOG
  3  WHERE DICTIONARY_BEGIN = 'YES' AND STANDBY_DEST= 'NO')
  4      AND NEXT_CHANGE#    (SELECT MAX(FIRST_CHANGE#) FROM V$ARCHIVED_LOG
  5  WHERE DICTIONARY_BEGIN = 'YES' AND STANDBY_DEST= 'NO') 
 
NAME
--------------------------------------------------------------------------------
/arch/prim/arch_-1306740637_2_0000000004.log
/arch/prim/arch_-1306740637_1_0000000278.log
tpcc 
 
SQL r

  1  SELECT MAX(FIRST_CHANGE#) FROM V$ARCHIVED_LOG
  2* WHERE DICTIONARY_BEGIN = 'YES' AND STANDBY_DEST= 'NO' 
 
MAX(FIRST_CHANGE#)
------------------
           1378506

The query will return the sequence number that should be specified in "Section 4.2.17, Register the Archived Redo Log and Start SQL Apply Operations."

Bug 2744635

This bug was fixed in MAIN and backported on top of 9.2.0.3. However, the fix may not work on some platforms, such as AIX-Based Systems (64-bit) due to optimization by the compiler. Bug 3055995 has been opened for this problem.

The following are the indications of the problem:

  1. A drop tablespace is started.

  2. An ORA-24008 error is received.

  3. A drop queue is attempted by the user.

  4. ORA-00376, ORA-01111, and ORA-01110 are received.

  5. The control file is recreated to exclude the datafile corresponding to the AQ-related tablespace.


Workaround:

The tablespace and AQ user can still be dropped. Follow the steps in OracleMetaLink note 203225.1.

Bug 2831333

If you run the Database Configuration Assistant and select the database installation option General Purpose or Transaction Processing in the configuration assistant to install a 9.2.0.4 database after applying the patch set to an ORACLE_HOME without a database, then Ultra Search will not function after the installation.


Workaround:

Use one of the following two approaches:

If you run the Database Configuration Assistant and select the database installation option General Purpose or Transaction Processing in the configuration assistant to install a 9.2.0.4 database after applying the patch set to an ORACLE_HOME without a database, then Ultra Search will not function after the installation. Oracle Corporation has assigned bug identification number 2831333 to track this problem. To workaround the problem, use either one of the following two approaches:

  • Install a preconfigured database optimized for general purpose usage.

    • Install the 9.2.0.1 database using the General Purpose option.

    • Install the 9.2.0.4 patch set using the instructions in this patch set note.

  • Build a new database. It will take longer to complete the installation.

    • Install the 9.2.0.1 database using the Software Only option.

    • Install the 9.2.0.4 patch set using the instructions in this patch set note.

    • Launch Database Configuration Assistant.

    • Create the 9.2.0.4 database using the New Database option.

Bug 3060932

An error message may appear while installing the Oracle9i Release 2 Patch Set 3 Version 9.2.0.4.0 on top of a patch set version 9.2.0.3. The error message will be similar to the following:

Error:
==========================================================
Error: 
  Exception thrown from action: moveFile
  Exception Name: UnableToWriteDestinationException
  Exception String: Cannot write to destination
   /private/qatest/dbversion/bin/dbsnmp.sav
  Exception Severity: 2
  Exception handling set to prompt user with options to RETRY IGNORE
==========================================================


Workaround

Move the dbsnmp.sav file to dbsnmp.old, and select Retry.

Important Notes

This section includes the following notes:

Database Upgrade for Oracle E-Business Suite

If you are an Oracle E-Business Suite customer wishing to upgrade your Oracle E-Business Suite release 11i database server to this patch set, then please check for the latest certification status and Interoperability Notes on OracleMetaLink. All other customers wanting to upgrade their databases directly to this patch set should read Migrating Directly to an Oracle9i Release 2 Patch Set Notes available on OracleMetaLink, document 214887.1

Upgrade and SYS schema

There is a generic issue applicable to the upgrade mode, for example, alter database open migrate. During an upgrade from release 9.2.0.1 to release 9.2.0.2, release 9.2.0.3, or release 9.2.0.4, the catpatch.sql script can take a long time if there are statistics for the SYS schema. The user should delete the statistics on all the objects in the SYS schema, and then re-collect the statistics after normal database open, if necessary.

To drop and recreate the statistics, run the following commands:

dbms_stats.delete_schema_stats('SYS'); 
dbms_stats.gather_schema_stats('SYS'); 

Patch Set Application with Physical or Logical Standby Databases in Place

For information on applying a patch set to a current release of Oracle9i for a configuration that includes one or more physical standby databases, refer to notes available in OracleMetaLink document 187242.1. This information only applies to Oracle9i release 9.0.1 and later installations.

Standard Edition Upgrade

If you are using an Oracle9i 9.2.0 pre-configured database with Standard Edition, then the database contains several components, such as OLAP Catalog, that are not supported by the Standard Edition. The catpatch.sql script will encounter errors when attempting to upgrade these components using Standard Edition. To avoid these errors, do the following:

  1. Connect as SYSDBA prior to running the catpatch.sql script.

  2. Remove the unsupported components as follows:

    execute dbms_registry.removed(’AMD’);
    execute dbms_registry.removed(’APS’);
    execute dbms_registry.removed(’XOQ’);
    execute dbms_registry.removed(’ODM’);
    
    

The component dictionary objects will still be in the database, but the catpatch.sql script will not apply the patch to them.

Oracle Streams

The following items apply to Oracle Streams:

  • All databases that use any features of Oracle Streams must be upgraded to Oracle9i version 9.2.0.2 or later. Operation between version 9.2.0.1 and version 9.2.0.2 is not supported for databases using Streams features.

  • The optional capture process of Oracle Streams requires the SHARED_POOL_SIZE initialization parameter be set to a minimum value of 100 MB, and the database be running in ARCHIVELOG mode. The database initialization parameter, TRANSACTION_AUDITING, must be set to its default value. The default value is TRUE.

  • The first capture process created on a database builds the Oracle Streams dictionary. If the initial dictionary build is interrupted, then an error indicating that the dictionary is invalid may occur. The typical cause of an interrupted dictionary build is a shutdown abort operation. All other shutdown modes will wait for the dictionary build to complete. If you encounter this error, then drop and recreate the capture process.

  • JMS Types and XMLType access to the Oracle Streams queue table is not enabled by default to minimize the impact of bug 2248652 that causes export of the Streams queue table to fail. Users can enable this access by calling the DBMS_AQADM.ENABLE_JMS_TYPES (queue_table) procedure, where the VARCHAR2 parameter queue_table is the name of the queue table. This procedure should be invoked after the call to DBMS_STREAMS_ADM.SET_UP_QUEUE.


    Note:

    Databases dependent on the Export utility as their backup strategy should avoid enabling this access.

  • A capture process cannot capture changes made to tables that use function-based or descending indexes. If a capture process tries to capture a change to a table that uses a function-based or descending index, then it writes the LCR that caused the error into its trace file, raises an ORA-00902 error, and becomes disabled.

  • Oracle Streams support for CLOB datatypes in multibyte character sets is limited to non-variable size multibyte character sets. If the character set uses a variable-width multibyte encoding scheme, then Streams does not support CLOB datatypes. Refer to the Oracle9i database globalization support guide for additional information about encoding schemes.

  • The TRANSACTION_AUDITING initialization parameter must be set to TRUE for Oracle Streams to function correctly.

  • A capture process cannot process logs that include DML update statements using the BUFFER hint. The BUFFER hint disables supplemental logging for the update operation which causes the capture process to stop.

  • Currently, Oracle Streams supports Oracle to non-Oracle heterogeneous information sharing only with the following Oracle Transparent Gateways:

    • Transparent Gateway for Sybase (TG4SYBS) release 9.2 and later

    • Transparent Gateway for Microsoft SQL Server (TG4MSQL) release 9.2 and later

Oracle Data Guard

The following issues apply to Oracle Data Guard:

DBMS_LOGSTDBY Package is Case Sensitive

Be careful to use the correct case when supplying schema and tables names to the DBMS_LOGSTDBY package. For example, the following statements show incorrect and correct syntax for a SKIP procedure that skips changes to OE.TEST.

The following is the incorrect statement:

execute dbms_logstdby.skip(’DML’, ’oe’, ’test’, null);

Because the names are specified with lowercase characters, the transactions that update these columns will still be applied to the logical standby database.

The following is the correct statement:

execute dbms_logstdby.skip(’DML’, ’OE’, ’TEST’, null);

Subheaps and Logical Standby Databases

When subheaps are in use, logical standby databases should be explicitly configured to specify an SGA usage, which is a portion of one subheap. This is known bug 2435087. A good value is 25 percent of the subheap size. For example, if the subheap size is 160 MB, then the following statement would set SGA usage for the redo cache to 25 percent of that value:

SQL> EXECUTE DBMS_LOGSTDBY.APPLY_SET(’MAX_SGA’, 40)

Skipping GRANT DLL

Currently, skipping GRANT DDL for a particular object fails to skip the command when using the DBMS_LOGSTDBY.SKIP(’GRANT’,’MYSCHEMA’,’MYOBJ’) procedure.

This may result in "ORA-00942: table or view does not exist" failures, or other failures because the object was not created but the grant attempt was still made. The same applies to GRANT even if the request was to skip all SCHEMA_DDL. The safest way to work around this problem is simply to check the events table, and find the failing Transaction ID values. Provide those to DBMS_LOGSTDBY.SKIP_TRANSACTION, and restart SQL apply operations.

LOG_ARCHIVE_DEST_STATE=DEFER Ignored after Failover

Section 7.2.2 "Failover Operations Involving a Physical Standby Database" in Oracle Data Guard Concepts and Administration, Oracle part number A96653-02, should include the following note:


Note:

After issuing "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;" to perform a failover to a physical standby database, log transport services attempt to send the last log file being archived to all destinations in the Data Guard configuration, including deferred destinations defined with LOG_ARCHIVE_DEST_STATE_n=DEFER. This can result in the following error being returned for the deferred destinations:
Error 12514 Creating archive log file to '<service_name>'

To avoid receiving this error, replace the deferred fields with blanks by issuing the following statement before initiating the failover: 'ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_n=" " SCOPE=MEMORY; '"


Wait Events

This section describes the wait events that monitor the performance of the log transport modes specified on the primary database with the ARCH, log writer (LGWR) SYNC, and LGWR ASYNC attributes on the LOG_ARCHIVE_DEST_n initialization parameter. These wait events are related to known bug 2435087. The following wait events and associated timing information are displayed by the V$SYSTEM_EVENT view:

ARCH Wait Events

The following wait events are for standby destinations configured with the ARCH attribute:

  • ARCH wait on ATTACH: This wait event monitors the amount of time spent by all archiver processes to spawn an RFS connection.

  • ARCH wait on SENDREQ: This wait event monitors the amount of time spent by all archiver processes to write the received redo to disk as well as open and close the remote archived redo log files.

  • ARCH wait on DETACH: This wait event monitors the amount of time spent by all archiver processes to delete an RFS connection.

LGWR SYNC Wait Events

The following wait events are for standby destinations configured with the log writer (LGWR) SYNC attributes:

  • LGWR wait on ATTACH: This wait event monitors the amount of time spent by all log writer processes to spawn an RFS connection.

  • LGWR wait on SENDREQ: This wait event monitors the amount of time spent by all log writer processes to write the received redo to disk as well as open and close the remote archived redo log files.

  • LGWR wait on DETACH: This wait event monitors the amount of time spent by all log writer processes to delete an RFS connection.

LGWR ASYNC Wait Events

The following wait events are for standby destinations configured with the log writer (LGWR) ASYNC attributes:

  • LNS wait on ATTACH: This wait event monitors the amount of time spent by all network servers to spawn an RFS connection.

  • LNS wait on SENDREQ: This wait event monitors the amount of time spent by all network servers to write the received redo to disk as well as open and close the remote archived redo log files.

  • LNS wait on DETACH: This wait event monitors the amount of time spent by all network servers to delete an RFS connection.

  • LGWR wait on full LNS buffer: This wait event monitors the amount of time spent by the LGWR process waiting for the network server (LNS) to free up ASYNC buffer space. If buffer space has not been freed in a reasonable amount of time, availability of the primary database is not compromised by allowing the archiver process (ARCn) to transmit the redo log data. This wait event is not relevant for destinations configured with the LGWR SYNC=PARALLEL attributes.


    Note:

    This wait event is not relevant for destinations configured with the LGWR SYNC=NOPARALLEL attributes.

LGWR ASYNC or LGWR SYNC=PARALLEL Wait Events

The following wait events are for standby destinations configured with either the log writer (LGWR) ASYNC or LGWR SYNC=PARALLEL attributes:

  • LGWR wait on LNS: This wait event monitors the amount of time spent by the LGWRprocess waiting to receive messages on IPC channels from the network server.

  • LNS wait on LGWR: This wait event monitors the amount of time spent by the network server waiting to receive messages on IPC channels from the LGWR process.

  • LGWR-LNS wait on channel: This wait event monitors the amount of time spent by the LGWR process or the network server processes waiting to receive messages on IPC channels.

Reverting to ARCH If Log Shipping with ASYNC or SYNC Fails

If errors occur when log transport services on the primary database try to transmit redo data to a standby destination that is configured with the LGWR ASYNC or LGWR SYNC attributes (on the LOG_ARCHIVE_DEST_n initialization parameter), log transport services will eventually use the archiver process (ARCn) to transmit the redo data to the standby destination.

For example, timing out messages in alert log with LGWR ASYNC. When the standby destination is configured with the LGWR ASYNC attributes, it is possible to reach "ASYNC buffer full" conditions when the network to the standby destination cannot keep up with the redo generation rate on the primary database. When this occurs, the following message is written to the Alert log:

Timing out on NetServer %d prod=%d,cons=%d,threshold=%d"

This message indicates that the standby destination configured with the LGWR ASYNC attributes encountered an "ASYNC buffer full" error condition. When this occurs, log transport services will automatically stop using the network server process to transmit the redo data and instead use the archiver process (ARCn). This change occurs automatically; no specific user action is necessary to make this happen. However, you may be able to avoid the "ASYNC buffer full" error condition by increasing the ASYNC buffer size.


Note:

This does not apply to Oracle Data Guard configurations running in maximum protection mode. It is only for configurations running in the maximum availability or maximum performance modes. Refer to Oracle Data Guard Concepts and Administration for complete information about the Oracle Data Guard protection modes.

Java VM and XML DB Requirements

Users who have JVM (Java enabled) or JVM and XDB installed on their 9.2.0.1 databases should make sure that the init.ora parameters SHARED_POOL_SIZE and JAVA_POOL_SIZE are each 150 MB or more before running the catpatch.sql upgrade script. Failure to do so could result in an unrecoverable memory failure while running of the script. Please note that JVM and XML DB was shipped as part of the default 9.2.0.1 seed database, and will be present unless the user explicitly installed a 9.2.0.1 instance without them.

Oracle Text INSO Updates

Oracle Text uses the INSO filter during the indexing of binary documents. This filtering technology is based on Stellent Chicago Corporation's HTML Export technology and is licensed from Stellent Chicago Corporation.

INSO 7.5 is included with this patch set and supports additional platforms and document types. A full list of supported platforms and document types is documented in Note 212584.1 in OracleMetaLink.

Oracle Advanced Queuing

Customers running Oracle Applications release 11.5.7 or 11.5.8 with Advanced Queuing Configured with multi-consumer queues may encounter corruption problem after upgrading their database to 9.2.0.x from any Oracle8i database.


Note:

Refer to note 231074.1 on OracleMetaLink for details and workaround.

Event 10499

Event 10499 was introduced in release 9.2.0.3 to allow customers to revert to the earlier behavior of NUMBER datatypes that have no explicit setting of their scale value. Any non-zero setting of the event level will enable the old behavior.

Prior to the introduction of this event, server code could return zero for the scale if a NUMBER datatype was created without specifying the scale. Other code paths would return -127. With this event, all code paths return -127, as this is the correct behavior.

Client applications may rely on the previous (incorrect) behavior. Typically, client applications will test for a scale of -127 to distinguish between NUMBER and FLOAT datatypes. It is not sufficient to test the scale alone to distinguish between these two datatypes, one needs to test for a scale of -127 and a non-zero precision to identify a FLOAT.

Client applications that rely on the old behavior can still work as before if the event is set but will need to be corrected prior to upgrading to the next major release of the Oracle database.

Oracle XDK

Oracle9i release 9.2.0.4 patch set contains XDK version 9.2.0.6.

Oracle Real Application Clusters and Oracle Data Guard During a Network Outage

This section describes Oracle Data Guard configurations running in maximum protection mode with physical standby databases. If you configured Oracle Data Guard to support a primary database in a Oracle Real Application Clusters environment and the primary database is running in maximum protection mode, the network outage between the primary database and all of its physical standby databases will disable the primary database until the network connection is restored. The maximum protection mode dictates that if the last participating physical standby database becomes unavailable, processing halts on the primary database.

If you expect the network to be down for an extended period of time, consider changing the primary database to run in either the maximum availability or the maximum performance mode until network connectivity is restored. If you change the primary database to maximum availability mode, then it is possible for a lag between the primary and standby databases, but you gain the ability to use the primary database until the network problem is resolved.

If you choose to change the primary database to the maximum availability mode, then it is important to use the following procedures to prevent damage to your data.

The following steps describe what to do if the network goes down and you want to change the protection mode for the Real Application Clusters configuration. The example assumes you are using a server parameter file (SPFILE), not a PFILE.

  1. Issue the STARTUP NOMOUNT command to start one instance.

  2. Prepare the Oracle Real Applications Clusters primary database to be in exclusive mode using the following command:

    ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
    
    
  3. Shut down the instance and mount it exclusive using the following command:

    SHUTDOWN STARTUP MOUNT
    
    
  4. Follow the instructions in Oracle Data Guard Concepts and Administration, or Oracle Data Guard Broker documentation if you want to use broker, to change the mode from the maximum protection mode to either maximum availability or maximum performance mode. For example, using the following to set it the mode to maximum availability protection mode:

    ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE AVAILABILITY;
    
    
  5. Prepare the Oracle Real Applications Clusters primary database to be in cluster mode using the following command:

    ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE;
    
    
  6. Shut down the Oracle Real Applications Clusters primary database.

  7. Open the Oracle Real Application Clusters primary database for general access.

  8. Restart the network.

  9. Prepare the Oracle Real Applications Clusters primary database to be in exclusive mode using the following command:

    ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
    
    
  10. Shut down the Oracle Real Application Clusters primary database, all instances.

  11. Mount a single instance of the Oracle Real Applications Clusters primary database without opening it for general access.

  12. Mount the physical standby database.

  13. Change mode on the Oracle Real Application Clusters primary database from its current maximum availability or maximum performance mode to the maximum protection mode using the following command:

    ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE;
    
    
  14. Shut down the Oracle Real Applications Clusters primary database.

  15. Open the Oracle Real Application Clusters primary database for general access.

DDL Statements that Use Database Links

SQL statements, such as CREATE TABLE tablename AS SELECT * FROM bar@dblink, may fail on logical standby databases. Avoid issuing this type of statement, because there are many errors that can arise from this type of operation.

When the statement is executed on the logical standby database, it will access the database link at that time and it's not possible to know if the information on the logical standby database is the same as it was at the time the statement was executed on the primary database. For example, additional columns may have been added or dropped that would make it impossible to apply the rows that follow. Assuming the network was set up so that the initial creation succeeded, you might see the following error: "ORA-26689: column datatype mismatch in LCR" for a table containing nested table columns. Also, the "ORA-02019: connection description for remote database not found" error may be returned if the database link or the TNS service was undefined on the logical standby database.

When this happens, use the DBMS_LOGSTDBY.INSTANTIATE_TABLE procedure for the table being created, and restart SQL apply operations.

Logical Standby Databases on the Same Node as the Primary Database

If a logical standby database is located on the same computer system as the primary database, it's likely both Oracle instances will have access to the same directory structure. There are Oracle commands that reuse datafiles. If Oracle commands that reuse datafiles are applied on the primary database, then the commands may also be applied on the logical standby database. If that happens while the primary database is shut down, then it is possible for the logical standby database to claim the file as part of its database and possibly cause damage to the primary database.

For this reason only, Oracle Corporation recommends using the following settings when running the primary and logical standby databases on the same computer system.

EXECUTE DBMS_LOGSTDBY.SKIP('ALTER TABLESPACE'); 

Granting Privileges to SYS Returns Error ORA-01749

If SQL apply operations fail on a logical standby database and return the "ORA-01749 you may not GRANT/REVOKE privileges to/from yourself" error message, then it is probably caused by an attempt to execute a GRANT DDL statement to grant a privilege or a role to SYS. To verify this is the problem, query the DBA_LOGSTDBY_EVENTS view to see the failed DDL statement along with its transaction ID shown in the XIDUSN, XIDSLT, XIDSQN columns in the view. The following describes how to fix the problem:

  1. Execute the DBMS_LOGSTDBY.GUARD_BYPASS_ON PL/SQL procedure.

  2. Execute the failed DDL statement.

  3. Enter the XIDUSN, XIDSLT, XIDSQN column values as parameters to the DBMS_LOGSTDBY.SKIP_TRANSACTION PL/SQL procedure.

  4. Restart SQL apply operations on the logical standby database.

Refreshing Materialized Views on a Logical Standby Database

Materialized views must be refreshed separately on a logical standby database using the GUARD_BYPASS_ON and GUARD_BYPASS_OFF procedures of the DBMS_LOGSTDBY package. For example:

EXECUTE DBMS_LOGSTDBY.GUARD_BYPASS_ON; 
EXECUTE DBMS_MVIEW.REFRESH ( 'BMVIEW', 'F', '',TRUE,FALSE,0,0,0,FALSE); 
EXECUTE DBMS_LOGSTDBY.GUARD_BYPASS_OFF;

If you are using the DBMS_LOGSTDBY.APPLY_SET procedure but you are not using the default value FULL for the TRANSACTION_CONSISTENCY parameter, then you should stop SQL apply operations before refreshing materialized views on the logical standby database.


See Also:

Refer to the Oracle9i supplied PL/SQL packages and types reference for more information about the DBMS_LOGSTDBY package.

Initially Starting Logical Standby Fails with Error ORA-1652

LogMiner uses temporary tables to stage its internal dictionary as it is mining it out of the redo stream. If the temporary tablespace is not configured adequately, such as it does not have enough space or is not backed up by a temporary file, then the initialization phase of a logical standby database will fail with the following errors:

ORA-1652: unable to extend segment by 512 in tablespace TEMP 
ORA-01332: internal Logminer Dictionary error

To work around the problem, increase the size of the temporary tablespace and start the logical standby database.

Verify Warning is Incorrect

Occasionally when performing Data Guard broker operations, you may see the following message in the Data Guard configuration log file:

RSM: error in accessing metadata.

You can ignore this message. It is benign and does not indicate any operational problem with the broker or the databases included in the broker configuration.

Using Multiple Domain Names in CONNECT Command

When connecting to a database using the Data Guard command-line interface (DGMGRL), a connect string that includes multiple domains separated by dots may result in the "invalid username/password; logon denied" message being returned. For example, the following CONNECT command can be problematic:

DGMGRL> CONNECT sys/change_on_install@standby.acme.com

Use one of the following solutions to work around this problem:

  • Use double quotation marks, such as the following:

    DGMGRL> CONNECT sys/change_on_install@"standby.acme.com"
    
    
  • Use connect strings that do not have multiple domains. This solution might require that you edit the tnsnames.ora file.

SQL Apply Does Not Support Tables with Function-based or Descending Indexes

Logical standby databases do not support tables with function-based or descending indexes in Oracle9i release 2. This information should have been included in Oracle Data Guard Concepts and Administration, Oracle part number A96653-02. There is currently no workaround for this problem.

DBMS_LOGSTDBY.INSTANTIATE_TABLE

The DBMS_LOGSTDBY PL/SQL procedure does not support the BLOB data type even though BLOB data types are supported by logical standby databases. Also, the order of the parameters for the INSTANTIATE_TABLE procedure is incorrect in the Oracle Data Guard Concepts and Administration and in the Oracle9i Supplied PL/SQL Packages and Types Reference. The correct parameter order is as follows:

DBMS_LOGSTDBY.INSTANTIATE_TABLE 
     schema_name IN VARCHAR2, 
     table_name  IN VARCHAR2, 
     dblink      IN VARCHAR2);

XML DB

XML DB users must use XDB version 9.2.0.3 or later. Earlier versions are no longer supported.

Bugs Addressed in this Patch Set by Category

This section describes the bugs addressed in this patch set by category. It includes the following categories:


Note:

This list of fixed bugs was current at the time of the patch set. Details on these fixed bugs may be revised after release of the patch set. Refer to the Patch Set section of OracleMetaLink document 189908.1 for any post-release updates.

Advanced Queuing Bugs

The following table lists the Advanced Queuing bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2131687 ORA-604 / ORA-1001 querying V$AQ / X$KWQSI
9202 2145198 AQ event notifications may not be delivered / QMN does not free connection descriptors
9202 2200934 PMON may crash in kssxdl cleaning up session which was enqueuing a message
9202 2200961 OERI:[529] in PMON after session dies when adding a subscriber
9202 2221168 Orphan messages possible after remote subscriber removed
9202 2249786 IMP-17 / ORA-24150 possible importing user RULE SET
9202 2265794 Dequeue with next message navigation may get ORA-1555
9202 2272964 QMN may die with OERI:[KWQITNMPTME:WAIT] when dequeue by message ID
9202 2273354 AQ/JMS message notifications may not be received
9202 2277283 Only SYS can register Connection Factories using JDBC (or PLS-201 thrown)
9202 2286290 ALTER TABLE MOVE should not be allowed for Queue tables
9202 2349021 ADT LOB dequeue may dump in multithreaded client
9202 2349883 OERI:[kwqpaspse2c: invalid status] after interrupted DBMS_AQADM.UNSCHEDULE_PROPAGATION
9202 2364533 ClassLoaderException possible using OJMS in OC4J EJB
9202 2372052 OJMS does not support multiple JMS connections in JDBC Thin
9202 2372422 OJMS throws NullPointerException with NULL payload enqueued using JDBC THIN
9202 2373192 OERI[KOPE2_WRITES118] on AQ propagations between different character set databases
9202 2384580 OJMS fails to remove a durable subscriber in compliant mode
9202 2390435 OJMS close() rolls back current global transaction
9202 2395193 OERI:4414 / ORA-1403 on dequeue of pre-9.2 enqueued messages
9202 2398517 OERI:KOPE2PIC661 and similar on AQ propagation between different Oracle versions
9202 2402677 ENH: Add JDBC thin OJMS support for all JMS message types on single destination
9202 2402690 ENH: Add JDBC thin OJMS support for all JMS message types on single destination
9202 2405004 PROPAGATION from TYPED QUEUE to AnyData queue fails
9202 2409601 OERI[!QSCHEMA] from DBMS_AQADM.VERIFY_QUEUE_TYPES if queue name does not include SCHEMA
9202 2424746 Unexpected ORA-24033 enqueuing an AQ message after upgrade to 9.2
9202 2458956 OJMS AQjmsException enqueuing javax.jms.BytesMessage greater than 2000 bytes
9202 2483854 ORA-7445 [kwqppreaqe] with greater than 10 remote subscribers to a queue
9203 2298215 AQ dequeue can intermittently take seconds to dequeue
9203 2370520 EMON hang - message notifications not delivered
9203 2381172 IMPORT fails / corrupts the AQ dictionary with duplicate QUEUE_TABLE names
9203 2486477 "buffer busy waits" on very active Queue table (IOT)
9203 2490090 Propagation stops if queues are recreated and enqueuing session does not reconnect
9203 2497219 OERI:[17065] / OERI:[17064] from XAOROLLBACK with AQ in OPS/RAC
9203 2543395 RETRY_COUNT not incremented when DEQUEUEING session dies
9203 2573516 When DEQUEUE rolled back other sessions do not see the message immediately
9203 2598124 EXP-8 / ORA-1422 if queue and queue table have same name
9204 1522211 Dequeue does not see enqueue from another RAC/OPS node for 5 minutes
9204 2397300 CPU Spin from concurrent AQ dequeue of same message without commit/rollback
9204 2457577 EMON does not report errors for continual network errors
9204 2554413 Propagator only waits 30 seconds when there is no message
9204 2579935 CREATE QUEUE fails (ORA-904) if user owns table called "ALL_RULES"
9204 2604145 AQ objects INVALID after upgrade sequence 9.0 to 9.2 to 9.0 to 9.2
9204 2614221 Dequeue from EXCEPTION queue truncates SCHEMA NAME to 8 characters
9204 2671550 JMS getQueue() and getTopic() are slow with many queues in the DB
9204 2722510 ORA-7445 on DEQUEUE after database upgrade from Oracle8i
9204 2744635 Multi-consumer DROP_QUEUE_TABLE fails if datafile inaccessible / DROP TABLESPACE fails with ORA-24008
9204 2747605 Poor "Enqueue" performance of non-persistent queue
9204 2757441 Duplicate rules upgrading from 8.1 or 9.0 - ORA-24033 during enqueue
9204 2781500 Dictionary corruption possible if DBMS_RULE_ADM.DROP_RULE /DROP_EVALUATION_CONTEXT errors
9204 2798855 AQ rules views may become INVALID after upgrade to 9.2
9204 2805491 JMS-120 / PLS-306 using older JMS client (AQAPI.JAR) to 9.2 server
9204 2808007 AQ/JMS does not get message notifications if DB does not know HOSTNAME of client
9204 2809130 Queue import can corrupt dictionary metadata if queue pre-exists
9204 2841243 DBMS_AQADM.CREATE_QUEUE succeeds even if table is invalid
9204 2857178 ORA-1000 from multi-threaded JMS client doing object enqueue/dequeue
9204 2871030 JMS leaks a cursor for each AQOracleQueueTable
9204 2881018 EXP/IMP of Queues after DB upgrade to 9.2 fails
9204 2882923 ORA-1031 importing Queue table
9204 2902091 NULL body from dequeue of LCRs as XMLType message from AQ Anydata queue
9204 2913866 ORA-7445 [KWQAPAQN] when EVENT 10862 is set
9204 2916802 "java.lang.UnsatisfiedLinkError: aqxmlinit" from AQ XML servlet using OC4J
9204 2949941 Rules engine objects may become invalid after upgrade
9204 2951352 No way to cancel a blocking OJMS dequeue with JDBC Thick

Advanced/Secure Network Bugs

The following table lists the advanced/secure network bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2275708 FIPS-140 fails completely on Windows platforms
9202 2285343 RADIUS adapter client may dump for passwords over 128 characters
9202 2299279 Dump possible if user certificate is also a trusted certificate
9202 2337115 JavaSSL: Interrupted Exception not handled properly
9202 2517364 Certicom SSL bug fixes
9202 2524122 SSL patch for "CERT advisory CA-2002-23"
9203 2171847 KERBEROS adapter cannot handle Windows 2000 tickets
9203 2392264 Kerberos adapter cannot get a ticket from a MS KDC user with greater than or equal to 75 groups
9203 2666840 Certificate with CN greater than 64 bytes rejected
9204 2514960 SSLUnknownErr exception using HTTPS / OracleSSLCredential in JVM
9204 2652013 ORA-12157 possible using TCPS (SSL)
9204 2662826 Unable to connect to GLOBALLY IDENTIFIED user via SSL over OCIConnectionPool
9204 2669172 JSSL does not work with JDK 1.4.1
9204 2794931 JDBC OCI does not resolve connect string using directory naming for SSL
9204 2917859 SSL timing bug

Analytic SQL Bugs

The following table lists the analytic SQL joins bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2176103 OERI:[KKQSRRE-1] on query rewrite with FIRST / LAST & aggregate
9202 2331475 OERI:[qkaSplitOGs.2] possible from COUNT(*) with window functions.
9202 2443764 Simple CASE expressions much slower than DECODE equivalent
9202 2482089 GROUPING SET QUERY gives wrong results on Query REWRITE
9202 2483794 ORA-7445[NSOINP] using GROUPING SETS with SUBQUERY
9203 2507421 OERI:[kkqwrm_noref: COLFDNF set] possible from WINDOW function and WITH clause
9203 2708898 STAR_TRANSFORMATION with a WINDOW function may dump (evaopn2)
9203 2767539 Dump (in qerpxStart) possible from TEMP TABLE TRANSFORMATION with WINDOW function
9204 2688053 Wrong results using GROUPING SETS
9204 2744760 Unexpected ORA-604/ORA-904 possible using GROUPING SETS clause
9204 2773831 Wrong results possible from GROUPING SETS with OUTER JOIN
9204 2791967 ORA-7445 [EVAFSTLST] possible using DENSE_RANK with FIRST/LAST function
9204 2836690 ROLLUP over DBLINK may fail with OERI:qks3tinit
9204 2861866 Wrong results from STAR transformation with WINDOW functions
9204 2910437 Inefficient plans on rewrite of SQL with GROUPING SETS and CASE expressions
9204 2928676 CREATE MVIEW using LAG with PARTITION clause may spin in JA16SJIS
9204 2939697 ORA-7445 [qerwnWriteToDisk] using duplicate analytic window functions
9204 2953931 ORA-4031 parsing query with numerous groupings

ANSI Joins Bugs

The following table lists the ANSI joins bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2245372 ORA-904 possible from TABLE.* in SELECT list from ANSI join query
9202 2338661 Wrong results possible from ANSI outer join
9202 2352928 Wrong results / dump from FULL OUTER JOIN to SUBQUERY with GROUP BY
9202 2357784 OERI[QCTCTE1] parsing ANSI OUTER JOIN with a VIEW with a SET operation, such as UNION ALL
9202 2360043 LEFT OUTER JOIN may produce incorrect results instead of ORA-1799
9202 2370324 False ORA-904 possible on NATURAL RIGHT JOIN of different schema tables
9202 2388008 Wrong results from ANSI outer join with 'const <relop> col'
9203 2315444 Dump from query with LATERAL view
9203 2458655 OERI[QCTECTE1] from FULL OUTER JOIN with BIND variable in subquery
9203 2656627 Wrong results from ANSI OUTER JOIN with CONSTANT predicates in ON clause
9203 2670901 ORA-604, ORA-907 or ORA-904 from WITH clause with ANSI join in it
9204 2717694 FROM-clause subqueries using ANSI OUTER JOIN can fail with ORA-1792
9204 2829723 Wrong results from ANSI OUTER JOIN when join condition does not reference both sides
9204 2843541 FULL JOIN with set operator may dump (such as: UNION)

Application Context Bugs

The following table lists the application context bugs addressed in this patch set:

Fixed in Release Bug Number Description
9203 2435725 APPLICATION CONTEXT attribute visible after dropping the NAMESPACE
9204 2635664 VPD policy groups may not respond to the driving application context
9204 2685869 Wrong results using PQO with OLS/VPD which uses application context
9204 2882484 DROP evaluation context FORCE does not invalidate dependents - dumps / OERI possible

Authentication Privileges Auditing Bugs

The following table lists the authentication privileges auditing bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2127974 Cannot decrypt cipher encrypted using 3DES
9202 2254550 Enterprise user using shared schema passes wrong username over DBLINK
9202 2329949 NOT FINAL methods can be invoked without privilege
9202 2350535 MEDIA_DIR is granted READ to PUBLIC in default database
9202 2391877 PMON may crash the instance with OERI:[4157] if AUDITING is enabled
9202 2430504 Dump selecting from table with VARRAY and VPD policy
9202 2597503 Cursors with SYNONYM specific policies may not be shared properly
9203 2479882 Permission changes may not propagate to all nodes
9203 2484754 Cannot drop policy in a non-existent group or with name starting "DEFAULT"
9203 2523151 ORA-7445[updexe] with AUDIT_TRAIL=DB with stressed shared pool
9203 2615477 FGA audit trail may show invalid statement type in DBA_FGA_AUDIT_TRAIL
9203 2652538 ORA-7445 [kkkiprpriv] during GRANT/REVOKE in trusted callout
9204 2595839 ORA-2070 can occur using SYS_CONTEXT in an RLS policy function
9204 2635664 VPD policy groups may not respond to the driving application context
9204 2650731 VPD policies do not allow FLASHBACK
9204 2662826 Unable to connect to GLOBALLY IDENTIFIED user via SSL over OCIConnectionPool
9204 2685869 Wrong results using PQO with OLS/VPD which uses application context
9204 2723653 XDB ACLs evaluated incorrectly if ROLES are changed dynamically
9204 2813521 DBMS_OBFUSCATION_TOOLKIT.DES3GETKEY can product identical keys

Bitmap Index Bugs

The following table lists the bitmap index bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2134836 OIERI:QKABRIX1 possible with BITMAP and PARTITIONED index on NON-PARTITIONED table
9202 2156961 OERI:20040 possible from bitmap index
9202 2286794 Dump in evaopn2 if STAR transformation FACT table has more than1 bitmap index on a join column
9202 2293722 ORA-7445 [evaopn2] possible using BITMAP JOIN INDEX with may NULLs
9202 2364585 STAR transformation may dump (EVAOPN2) if fact column is leading prefix of bitmap index
9203 2451259 ORA-28604 on recreate of BITMAP index on COMPRESSED table
9203 2536531 MERGE on table with BITMAP index fails with OERI:[kauins:1]
9203 2556294 ORA-7445[kkocfcc] possible using Bitmap Join Index
9203 2569154 Wrong results from PQ with NL of BITMAP INDEX with ROWID predicate
9204 2697589 OERI:[kdiblbout:rowidIllegal] on INSERT into IOT with BITMAP indexes
9204 2705892 ORA-7445[qesaPackCols] using functional bitmap indexes
9204 2747052 Wrong results from queries with bitmap index access with large OR-chains
9204 2767505 OERI[KDISLE:NROWS] possible on DELETE from table with BITMAP index
9204 2803588 OERI[20083] using DBMS_STATS.GATHER_TABLE_STATS on table with bitmapped functional index

Change Data Capture Bugs

The following table lists the change data capture bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2205649 ORA-29531 from DBMS_LOGMNR_CDC_PUBLISH.DROP_SUBSCRIBER_VIEW
9202 2338739 DBMS_LOGMNR_CDC_PUBLISH / DBMS_CDC_PUBLISH may error with ORA-1426
9203 2362606 DBMS_CDC_PUBLISH.PURGE does not purge the change table
9204 2802515 ORA-31496 on DROP USER CASCADE on CDC publisher

Compressed Data Storage Bugs

The following table lists the compressed data storage bugs addressed in this patch set:

Fixed in Release Bug Number Description
9203 2451259 ORA-28604 on recreate of BITMAP index on COMPRESSED table
9203 2474106 COMPRESSION information not shown in dictionary views
9203 2501800 ORA-7445 [kdblailb] from Direct path load into a COMPRESSed table
9203 2553074 ORA-12996 should always occur ALTER TABLE DROP COLUMN after COMPRESS

Compressed Key Index Bugs

The following table lists the compressed key index bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2215837 OERI:6100 / index corruption possible on compressed key index
9202 2262336 Compute statistics on COMPRESSed key index has wrong DISTINCT KEYS value
9202 2299683 PK not enforced if added using existing COMPRESSED NON UNIQUE index
9203 2566356 ONLINE MOVE of KEY-COMPRESSED IOT corrupts the IOT
9203 2629193 OERI:[711]..[KDIFXS - PREFIX CONTEXT] selecting COMPRESSed key IOT
9204 2688197 ORA-1408 adding UNIQUE / PK CONSTRAINT with COMPRESSED KEY index
9204 2718937 OERI:6033 from SELECT on IOT with COMPRESSED PRIMARY KEY

Connection Manager Bugs

The following table lists the Connection Manager bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2023584 CMAN may rejects connections if hostname omits domain
9202 2434834 LSNRCTL/CMAN/NAMES passwords do not match
9204 2487224 CMAN may dump when stopped

Constraint Related Bugs

The following table lists the constraint related bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2236731 BULK ROW COUNT returned from ARRAY insert may be wrong if constraint violated
9202 2258479 ORA-00600 [15264] enabling FOREIGN KEY constraint against a view
9202 2281312 ORA-7445/dump possible on UPDATE of PRIMARY KEY enforced with a DESC index
9202 2299683 PK not enforced if added using existing COMPRESSED NON UNIQUE index
9202 2336714 PARALLEL MERGE does not error if the UPDATE violates a CHECK CONSTRAINT
9202 2435787 PDML may hang for tables with referential integrity constraints
9202 2520470 ORA-28506 querying ALL_CONSTRAINTS in HS
9202 2202561' Wrong results possible from CHECK CONSTRAINT with empty string ''
9203 2136347 ORA-4020 on CREATE OR REPLACE VIEW with SELF-REFERENTIAL CONSTRAINTS
9203 2452631 Wrong results with CHECK CONSTRAINTS on OUTER JOIN columns
9203 2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
9204 1874320 Constraints needlessly revalidated during import of transported tablespace metadata
9204 2594803 EXCHANGE PARTITION with Unique constraints can be slow
9204 2663465 Wrong results from CHECK CONSTRAINTS on OUTER JOINED table
9204 2688197 ORA-1408 adding UNIQUE / PK CONSTRAINT with COMPRESSED KEY index
9204 2688545 ORA-600 [QERNSROWP] from NOSORT with CHECK constraints
9204 2750401 DEFERRABLE UNIQUE CONSTRAINTS can cause LOGICAL STANDBY apply errors
9204 2754410 Multi-row insert SLOW with multiple FK constraints
9204 2873855 "SET CONSTRAINTS ALL IMMEDIATE" may incorrectly signal violations
9204 2878338 INSERT into HASH PARTITION may fail with false ORA-2291
9204 2879257 OERI[16609] selecting from PARTITIONED table with CONSTRAINTS

Corruption Bugs

This section describes the corruption bugs addressed in this patch set. It includes the following categories:

General Corruption

The following table lists the general corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2238718 Spin possible due to corrupt block on mirrored datafile
9202 2259466 PL/SQL: Assigning one VARRY to another produces corrupt VARRAY - ORA-6533/OERI:KOPE2_READSTR232
9202 2373145 DBVERIFY does not identify fractured blocks
9202 2428202 ORA-600 [kdrpFLdoeseg_1] using DBMS_REPAIR.REBUILD_FREELISTS
9202 2432864 DBVERIFY does not work properly on RAW or for different BLOCKSIZE
9203 2348277 DBV/Oracle Recovery Manager may incorrectly report completely zero blocks as corrupt
9203 2354965 False fractured block messages possible during Direct Path IO
9203 2469314 DBVERIFY may dump when reporting a block corruption
9203 2541360 V$BACKUP_SPFILE records can get corrupted /RMAN-10021
9203 2803911 Target sees corrupt data in TRANSPORTED tablespace with UNIUSED columns
9203 2870048 False corrupt block messages in alert log
9204 2551000 False ORA-1410 / ORA-8103 possible from ANALYZE COMPUTE/ESTIMATE STATISTICS

Bad Backup

The following table lists the bad backup bugs addressed in this patch set:

Fixed in Release Bug Number Description
9203 2334532 Not all backup pieces have a magic buffer written
9203 2645378 LOB data corruption after RECOVERY

Dictionary Corruption

The following table lists the dictionary corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2161360 DROP of OPERATOR corrupts dictionary - ORA 29836 on ALTER INDEXTYPE
9202 2286290 ALTER TABLE MOVE should not be allowed for Queue tables
9202 2371453 CREATE or REPLACE SYNONYM can lead to inconsistent dictionary (old IDL data)
9202 2377630 OERI[5106]/dictionary corruption on concurrent ADD DATAFILE and DROP TABLESPACE
9202 2380475 Dictionary corruption from CREATE OR REPLACE SYNONYM on TYPE
9202 2405258 Dictionary corruption/OERI:15265 from MOVE LOB to existing segment name
9202 2498186 DEPENDENCY$ corrupted on ALTER INDEXTYPE
9202 2515703 Dictionary corruption from concurrent partitioned IOT maintenance
9203 1584155 DROP FORCE/RECREATE TYPE with DEPENDENCIES corrupts dictionary information
9203 2381172 IMPORT fails/corrupts the AQ dictionary with duplicate QUEUE_TABLE names
9203 2591284 Upgrade to Oracle9i may fail leaving bad KOTTD$ type information in dictionary
9204 2702410 ORA-8194/ORA-8106 occur on ALTER MOVE/REBUILD ONLINE
9204 2781500 Dictionary corruption possible if DBMS_RULE_ADM.DROP_RUL/DROP_EVALUATION_CONTEXT errors
9204 2809130 Queue import can corrupt dictionary metadata if queue pre-exists
9204 2897947 Dictionary (COL$.PROPERTY) does not contain INSERTTABLE FLAG when CTA uses UPPER function
9204 2909084 RENAME of a VIEW with CHAR column can cause wrong results for subsequent SQL
9204 2976763 Failed DROP MVIEW can leave corrupt dictionary data - subsequent ORA-30382

Index Corruption

The following table lists the index corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2215837 OERI:6100/index corruption possible on compressed key index
9202 2299909 ARRAY UPDATE can cause TABLE/INDEX inconsistency
9203 2729655 Direct load of PARTITION man not update bitmap index
9204 2902160 OERI[6122]/index corruption form DML against AUTO space managed indexes

Logical Corruption

The following table lists the logical corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1733957 Array interface deletes too many rows with correlated subquery
9202 2014766 Java TRIGGERS do not set :NEW variables to the new values
9202 2025426 Bad number data or NumberFormatException with leading zeros in number string in JDBC
9202 2197703 Update of LONG with PL/SQL BULK BIND can update incorrectly
9202 2232548 VARRAY number columns are not rounded or truncated
9202 2245006 OCCI populating NESTED TABLE/VARRAY greater than 245 element inserts corrupt data
9202 2299683 PK not enoraced if added using existing COMPRESSED NON UNIQUE index
9202 2314238 VARCHAR2 bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
9202 2336714 PARALLEL MERGE does not error if the UPDATE violates a CHECK CONSTRAINT
9202 2367256 Fix for bug 2133357 non in Oracle9i (corrupt LOB after altering database characterset)
9202 2386401 LOADER may load incorrect values for PACKED DECIMAL data
9202 2421031 VARRAY of FLOATS are truncated on insert
9202 2423571 Invalid Oracle numbers possible if Pro*COBOL uses COMP variables containing invalid COMP data
9202 2448081 DIRECT load loads PACKED DECIMALS exceeding specified precision/scale
9202 2468782 Direct load with SQL expression in CONTROL file can fail or store incorrect data
9203 2234028 CREATE TABLE OF <TYPE> AS SELECT can produce invalid table data
9203 2470864 UPDATE may not update all rows if CHECK CONSTAINT compares columns
9203 2473741 Before row update trigger may not fire for MERGE statement
9203 2508682 Under heavy load concurrent sessions may use wrong shared cursor (wrong schema)
9203 2541038 Streams/logical standby get corrupt or missing data fro row migrated partitioned LOB columns
9203 2563206 CLOB data is corrupted when inserted from an Oracle 8.0 client to multibyte Oracle9i 9.2 server
9203 2645455 Control characters are trimmed from bind variables
9203 2646101 Data corruption binding a JDBC TEMP CLOB into an NCLOB column
9203 2656881 LOB data corrupt update of LOB data greater than 32 KB gives wrong length on APPLY
9203 2697938 UPDATE of object table sets columns to NULL with index only access
9204 2511699 Silent data truncation inserting char literal into NVARCHAR2 column
9204 2594726 JDBC array insert greater than 65535 elements may produce NULL rows or fail with ORA-6531
9204 2679297 Non-numeric characters can be inserted into a NUMBER column in HS
9204 2708284 Loader misreads secondary datafiles for VARRAYs and nested tables
9204 2767857 SQLLAOD of NULL LOB loads previous LOB value
9204 2797392 Streams/logical standby does not replicate DDL from PL/SQL EXECUTE IMMEDIATELY
9204 2886004 Reverse default behavior for blank trimming of Control characters

Physical Corruption

The following table lists the physical corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2293492 Fatal error during COMMIT/ROLLBACK may cause permanent corruption such as ORA-8102
9202 2366191 Database corruption possible from concurrent ALTER DATABASE OPEN
9202 2384280 Corruption/internal errors after upgrading database to 9.2
9202 2399039 ALTER TABLE DROP COLUMN drops the wrong column
9203 2157903 MOVE of MVIEW corrupts the data or dumps (ORA-7445 [qerltRop] or similar)
9203 2542609 Corruption from CANCEL of managed standby if primary is Oracle Real Applications Clusters
9203 2562274 Block corruption/OERI[KCOAPL_BLKCHK] updating LONG data
9203 2566356 ONLINE MOVE of KEY-COMPRESSED IOT corrupts the IOT
9203 2585648 OERI:[KCCCHB_1] should CRASH the instance but does not
9203 2645378 LOB data corruption after RECOVERY
9204 2431450 SMU Undo corruption possible on instance crash
9204 2537604 Oracle Real Applications Clusters graceful failover may result in corrupt new primary database
9204 2742254 In Oracle Real Application Clusters a transaction can use an offline rollback segment causing corruption
9204 2798239 Block corruption possible on rollback of segment merge
9204 2967417 OERI:KCOAPL_BLKCHECK may occur using Auto managed segment

Memory Corruption

The following table lists the memory corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2021310 HS agent memory corruption / dump fetching data
9202 2228280 Private memory corruption possible with OPTIMIZER_MODE=RULE if tracing sometimes used
9202 2257361 ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
9202 2296247 Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY
9202 2298888 ORA-7445 / ORA-27092 / PGA memory corruption in PRESPAWNED server
9202 2311292 OCCI client memory corruption
9202 2340656 Private memory corruption possible from RAISE_APPLICATION_ERROR for long error messages
9202 2370947 Shadow memory corruption / false ORA-1483 assigning NULL to COMP-3 bind
9202 2376273 Memory corruption using LEADING hint with STAR transformation
9203 1839270 Setting FILE_DATASTORE over 260 characters can corrupt server memory
9203 2487248 Dump / memory corruption if Event 10129 is set for a distributed query
9203 2666244 Library cache lock corruption possible
9204 2208113 Dump / memory corruption possible using USER FILTER for 10K document
9204 2662683 Heap corruption from schema name overwriting memory in PL/SQL
9204 2789595 PGA memory corruption from INDEX SKIP SCAN
9204 2867563 OERI:KSMFRFG2 / memory corruption selecting from an EXTERNAL TABLE

Database Link Bugs

The following table lists the database link bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2043542 DATA_PRECISION incorrectly set to 38 for CTAS of SMALLINT over DBLINK
9202 2073948 ORA-6550 possible referencing remote partitioned table after DDL performed on it
9202 2254550 Enterprise user using shared schema passes wrong username over DBLINK
9202 2255030 ORA-3106 possible from Oracle 8.0 client talking to Oracle8i / Oracle9i over a DBLINK
9202 2267522 "INSERT INTO ... SELECT FUNC@LOOP" reports incorrect number of rows processed
9202 2273417 RECO may not recover IN-DOUBT transactions when LOGON triggers exist
9202 2281071 ORA-4030 / memory leak calling RPC in PL/SQL cursor loop
9202 2309738 PL/SQL SELECT over DB link throws unexpected error instead of ORA-1403 /no_data_found
9202 2314238 VARCHAR2 Bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
9202 2314669 OERI:18090 using local functions with remote tables.
9203 1829296 False ORA-980 from PL/SQL referencing SYNONYM which uses a DBLINK
9203 2374041 OERI[QERSQCLOSE-1] selecting REMOTE sequence from empty local table
9203 2425312 ENH: Include PL/SQL RPC information in 10046 trace
9203 2438953 OERI[KCBGCUR_2] / OERI[6856] from RECO in RAC/OPS
9203 2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 to UTF8
9203 2452537 SELECT of remote sequence leaks cursors (ORA-1000)
9203 2487248 Dump / memory corruption if Event 10129 is set for a distributed query
9203 2490061 ORA-932 for remote SQL using TIMESTAMP datatype
9203 2519148 Memory leak from PL/SQL RPC to an older database version in a LOOP
9203 2533616 Materialized view refresh can use lots of CPU
9203 2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases
9203 2545840 Distributed query may see remote changes from AFTER the snapshot SCN
9203 2567290 Large packet over DBLINK may fail with ORA-12539
9203 2572944 SELECT over Oracle8i to Oracle9i DBLINK may fail with ORA-7445 [opidsi]
9203 2576353 ORA-7445[qxopqgcd] from remote query with user defined function
9203 2599290 OERI from 8.0 client querying NULLs and LONG over Oracle9i to Oracle9i DBLINK
9203 2608776 ORA-3106 in 8.0 client SELECTing pseudo column from Oracle9i server over DBLINK
9203 2622558 XA Open option to close precompiler cursors on XA_END (avoid ORA-24779 errors)
9203 2641473 OERI[OPIXRB-4] from V7 client binding SQLT_RID to 9.2 table over DBLINK
9203 2658212 OERI:[KKCHBYT] possible with _keep_remote_column_size = TRUE
9203 2694605 ORA-3118 possible when PL/SQL executed over a DBLINK
9203 2696120 OCCI client dump (kpuhhalo) on Commit/Rollback if using DML over DBLINK
9203 2698435 Repeated OERI:18260 / OERI:18186 if XA DBLINK errors at commit
9203 2701820 OERI[18250] / dump using migratable database links
9204 2117638 ORA-2063 / ORA-1445 possible from outer join over DB link with NULL sensitive predicates
9204 2419335 OERI:[qks3tInit] possible from STAR transformation
9204 2425679 Wrong results possible from select over DBLINK
9204 2449247 ORA-4080 from XDB committing changes in a distributed transaction
9204 2526424 PLS-215 from Oracle9i to Oracle8i PL/SQL reference to view with zero length character column/s
9204 2554178 CURRENT_SCHEMA signals ORA-1017 when the underlying object uses a DBLINK
9204 2665478 OERI[RWORUPO.1] from INSERT .. SELECT over DBLINK with ADT column
9204 2695242 ORA-22 OERI[18260] using MTS with shared DB links
9204 2712141 Wrong results from HASH join of view on remote query block
9204 2721462 ORA-7445 [KOPXCCC] from PL/SQL RPC over DB LINK
9204 2727446 Wrong results or ORA-904 from ANSI join between remote tables
9204 2741185 Fast refresh of MV on remote LOB columns may hang
9204 2758770 OERI:504 from Dispatcher/s when using TCP DB LINKS
9204 2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a DBLINK
9204 2836690 ROLLUP over DBLINK may fail with OERI:qks3tinit
9204 2866419 ORA-1461 from SQL over DB link between different character sets
9204 2876379 False ORA-24347 from INSERT over DB LINK between releases
9204 2886505 Create database link denial of service vulnerability
9204 2888719 Wrong results from colocated remote tables with OUTER join
9204 2894277 OERI[17200] accessing Oracle9i to Oracle8i remote object with BFILE column from PL/SQL
9204 2905850 OERI[qkaRmtView20] possible from SELECT over DBLINK with local PL/SQL function
9204 3042342 Create database link denial of service vulnerability

Datatypes Bugs

The following describes the datatypes bugs addressed in this patch set:

Any Data Bugs

The following table lists the any data bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 1758854 ORA-22922 accessing CLOB attribute of ADT in AnyData

LOB Bugs

The following table lists the LOB bugs, such as CLOB, BLOB, or BFILE, addressed in this patch set:

Fixed in Release Bug Number Description
9202 1785175 OERI:kcbgcur_9 from CLOB TO CHAR or BLOB TO RAW conversion
9202 1818720 Dump with PL/SQL and Java Stored Procedure returning NULL CLOB
9202 2166798 ORA-3124 inserting NULL into CLOB with UTF8 characterset
9202 2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
9202 2193313 PL/SQL CreateAbstractClob() dumps if LOB not freed
9202 2207959 Dump from COALESCE of PARTITIONED table with LOB
9202 2210922 OERI:[kola_set_locator-2] from string operations on virtual CLOB
9202 2234325 ALTER partitioned table with global FUNCTIONAL index and LOBS dumps in kkfiSetMemRep
9202 2242146 Inserting a virtual LOB into a LOB column dumps
9202 2255864 ABSTRACT LOB does not support multibyte data
9202 2258881 Unexpected ORA-22922 possible using TEMP LOBS
9202 2273837 Server Dump when JDBC THIN writes data to multibyte TEMP LOB
9202 2322759 DBMS_LOB.READ can leak "koh-kghu call" heap memory
9202 2326066 OERI[ktspffbmb-4] creating LOB column in AUTO SEGMENT SPACE MANAGEMENT
9202 2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
9202 2334318 ORA-942 accessing LOB through VIEW WITH CHECK OPTION
9202 2346568 ORA-22921 comparing CLOBS from different character sets
9202 2367256 Fix for Bug:2133357 not in Oracle9i (Corrupt LOBS after altering DB characterset)
9202 2371235 Memory leak passing LOB parameters to PL/SQL callouts in a loop
9202 2396270 FAILOVER: ORA-25401 after failover when fetching CLOB data
9202 2405258 Dictionary corruption / OERI:15265 from MOVE LOB to existing segment name
9202 2466076 DBMS_LOB.LOADCLOBFROMFILE() may dump for AL16UTF16 data
9202 2475163 Privilege errors modifying LOB in an ADT via a view
9203 2242133 Dump possible if SQL calls PL/SQL function which returns a LOB
9203 2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 to UTF8
9203 2495123 PLS-306 using DBMS_LOB.LOADFROMFILE after upgrade to 9.2
9203 2529036 LIKE against multi-byte CLOB can give wrong results
9203 2537320 SQL_REDO for large LOB operations is not executable
9203 2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
9203 2544428 Export may write bad LOB storage clause for TRANSPORT (ORA-22850 on IMPORT)
9203 2563206 CLOB data is corrupted when inserted from an 8.0 client to multibyte 9.2 server
9203 2586762 Direct LOB reads can result in ORA-4031 / excessive shared pool usage
9203 2642117 Overflow vulnerability in DIRECTORY parameter of BFILENAME
9203 2644285 OERI:2652 from LOB update with supplemental logging
9203 2645378 LOB data corruption after RECOVERY
9203 2646101 Data corruption binding a JDBC TEMP CLOB into an NCLOB column
9203 2656036 OERI/memory corruption selecting SQL_REDO for CLOB DMLS
9203 2656881 LOB data corrupt after migrating DB from single to multibyte
9203 2685942 OERI/dump possible mining LOB redo
9203 2696397 Blob.length() fails when selected with a Stream type (LONG, LONG RAW)
9203 2700006 JDBC Thin "Unexpected Packet" error with LOBS in multithreaded client
9203 2702872 Unnecessary library cache pin / lock activity during LOB reads
9203 2723384 ORACLE.SQL.CLOB.CREATETEMPORARY can leak TEMP LOBS
9204 1380218 getMetaData().getColumns() does not describe BLOB/CLOB/TIMESTAMP columns
9204 1615764 ORA-22922 accessing TEMP LOB in a REF CURSOR returned from PL/SQL
9204 2329001 ArrayOutOfBoundsException reading BLOB with JDBC Thin
9204 2643723 ORA-1555 possible using AUTO space managed LOB segments
9204 2708441 ORA-22275 using RETURNING CLAUSE for UPDATE of LOB
9204 2726398 OERI:kokegPinLob1 from VIEW with EXPRESSION on a CLOB column
9204 2741185 Fast refresh of MV on remote LOB columns may hang
9204 2747582 TEMPORARY LOB LEAK on PL/SQL <collection>.DELETE or assignment
9204 2774862 Dump (under ktspfpblk) can occur when writing to a LOB
9204 2777612 ORA-22922 getting length of temporary LOB on client
9204 2805382 Dump (kodpsloc) passing OBJECT with LOB to PL/SQL
9204 2847512 Temp LOB leak in DBURITYPE.GETBLOB()
9204 2894277 OERI[17200] accessing Oracle9i to Oracle8i remote object with BFILE column from PL/SQL
9204 2919655 LOBs may not reuse space with automatic undo management
9204 2944866 Free space in LOB table / tablespace not reused with ASSM
9204 3001947 Capture dumps transforming out of line LOB
9204 2767857 SQLLOAD of NULL LOB loads previous LOB value

Objects Bugs

The following table lists the objects bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1532054 ORA-604 / ORA-600 / Dump possible referencing TYPE in TABLE() clause
9202 1740494 PLS-801 [22914] with TABLE() expression
9202 1779188 OCI-21500 on SELECT of a FINAL ADT with an embedded non FINAL collection
9202 1788639 OERI:4882 from CREATE MATERIALIZED VIEW on OBJECT table
9202 1831941 OERI:koktcntv1 on ALTER TYPE when it has been recreated in another session
9202 1889003 ORA-30757 on query view hierarchy if user has no privilege on a SUBTYPE
9202 1941831 EXECUTE IMMEDIATE of CALL type constructor dumps in kkxmstcs
9202 2037285 Dump referencing TYPENAME.ATTRIBUTENAME in SQL in PL/SQL
9202 2158358 ORA-1062 SELECTing a NULL REF from an OBJECT view
9202 2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
9202 2193493 VARRAYs with embedded SUBSTITUTABLE TYPE may dump
9202 2204827 ORA-22905 on GRANT against VIEW using TABLE() function
9202 2211047 ORA-7445 [QCSPOBY] possible from CAST/MULTISET on subquery with ORDER BY
9202 2222308 Dump in qcsfoep() on CREATE TYPE BODY which references unqualified PL/SQL function
9202 2223449 ORA-29925 / ORA-932 from DML against table with functional DOMAIN index on ADT expression
9202 2223449 ORA-29925 / ORA-932 from DML against table with functional DOMAIN index on ADT expression
9202 2226328 Dump in nsoexc() on SELECT from VIEW with OBJECTS and CONNECT BY
9202 2232548 VARRAY number columns are not rounded / truncated
9202 2243589 Dump in KOKEIOD2M using NESTED TABLE columns in OUTER joins
9202 2246137 ArrayIndexOutOfBoundsException in oracle.jdbc.oracore.UnpickleContext.read_lengthBytes after changing between 32<->64 bit
9202 2259466 PL/SQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 or OERI:KOPE2_READSTR232
9202 2267728 OERI:[KOHCPI298] from TRUSTED CONSTRUCTOR function that returns a NULL ADT
9202 2271862 Dump selecting ALTERED collection type using JDBC
9202 2295440 Dump referencing ROWID when using TABLE() in an inline view
9202 2300104 CREATE VIEW OF TYPE .. UNDER .. does not export the UNDER clause
9202 2301875 ALTER TYPE MODIFY ATTRIBUTE does not change DESCRIBE information of ATTRIBUTE
9202 2309579 OERI:kokeicd2m1 on multi-table INSERT with an out-of-line column
9202 2311571 Oracle Type Translator does not generate destructor code for OBJECT attributes
9202 2329949 NOT FINAL methods can be invoked without privilege
9202 2349201 ORA-1647 importing TRANSPORTABLE set with partitioned object table
9202 2360357 ORA-2304 on CREATE OR REPLACE TYPE with Oracle Internet Directory
9202 2364710 OERI [12868] possible on DROP USER when GRANT exists on ALTERED TYPE
9202 2380475 Dictionary corruption from CREATE OR REPLACE SYNONYM on TYPE
9202 2381566 Large UPDATE of NESTED TABLE column shows excessive memory use
9202 2385206 OERI:723 possible after ORA-22813 error on objects
9202 2389429 ALL_COLL_TYPES may omit rows
9202 2391730 OERI:[KOTDATV5] evolving a type already evolved in another session
9202 2396474 ORA-7445 [KOXSS2GPAGE] querying inline view with aggregate on OBJECT column
9202 2416678 Memory leak calling OPAQUE TYPE member function
9202 2430504 Dump selecting from table with VARRAY and VPD policy
9202 2445330 ORA-1403 from DBMS_PICKLER.GET_TYPE_SHAPE for a type whose TDS length greater than 32000 bytes
9202 2475163 Privilege errors modifying LOB in an ADT via a view
9202 2508513 ORA-22813 / OERI:723 with large objects/collections
9202 3007386 ORA-6553 PLS-306 when table has FUNCTIONAL INDEX involving ADT attribute
9202 2064478 CREATE or REPLACE TYPE BODY can fail with OERI:[QCSRWAE1]
9202 2316195 OCI with COLLECTION may dump on OCIObjectFlush / OCITransCommit
9202 268221 PLS-717 calling TYPE member function mapped to a TRUSTED Callout
9203 1584155 DROP FORCE/RECREATE TYPE with DEPENDENCIES corrupts dictionary information
9203 1955577 Dump (in KOKEIS) using BINDS if TRIGGER updates nested table column
9203 2040114 OERI:[qcsrlidm1] from predicate with TYPE MEMBER method call
9203 2234028 CREATE TABLE OF <TYPE> AS SELECT can produce invalid table data
9203 2261722 Oracle8i export of Oracle9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
9203 2347596 Transport of OBJECT table may get index in wrong tablespace
9203 2448939 OCICacheFlush stores objects as the base type instead of the SUBTYPE
9203 2476514 ORA-22324 / OERI:[4883] adding method to OBJECT with REF dependencies
9203 2479354 Direct path load of column Objects give wrong results / dumps
9203 2551568 OERI:[rworupo.1] / wrong results from queries involving OBJECTS
9203 2564693 ORA-22813 from CAST(MULTISET(...))
9203 2599613 IMP-60 possible when object already exists in database
9203 2614464 ORA-979 from PL/SQL query with TABLE() function and PL/SQL bind in the GROUP BY clause
9203 2628768 ORA-922 possible with OVERFLOW and VARRAY clauses on an object IOT
9203 2658284 OERI:[QERPFFETCH1] possible during OBJECT table BULK SELECT
9203 2697938 UPDATE of object table sets columns to NULL with index only access
9203 2732590 Creating complex types with SUB TYPES in NOT FINAL MODE may dump (kopocue)
9203 3007386 ORA-6553 PLS-306 when table has FUNCTIONAL INDEX involving ADT attribute
9204 1758854 ORA-22922 accessing CLOB attribute of ADT in AnyData
9204 2186092 No data from TABLE (PL/SQL function) if function returns large collection
9204 2363698 ORA-1793 creating functional index on XML (or object) columns
9204 2474232 Dump in kksmal0 selecting object and rowid data
9204 2496699 Poor performance selecting from OBJECT TABLE with REFS
9204 2588285 ALTER TABLE MOVE of table containing REFs may dump
9204 2665478 OERI[RWORUPO.1] from INSERT.. SELECT over DBLINK with ADT column
9204 2708284 Loader misreads secondary datafiles for VARRAYs / Nested Tables
9204 2731243 False ORA-979 from scoped REFS in GROUP BY / ORDER BY
9204 2735873 Mutually recursive TYPES with can dump the shadow with Oracle8i to Oracle9i
9204 2749361 Create DOMAIN INDEX fails on SUBTYPED OBJECT
9204 2758168 ORA-7445 [KOKEIS] on REFRESH of remote MVIEW with VARRAY and TRIGGER
9204 2767486 ORA-600[PMUOCON2#1: INVALID CDS] when returning NULL ADT/collection through a JAVA callout
9204 2802560 SETID index not created automatically for nested table in an IOT
9204 2805382 Dump (kodpsloc) passing OBJECT with LOB to PL/SQL
9204 2860984 Bad plan possible with collection iterator (table/Cast)
9204 2881337 OERI:17011 on ALTER TABLE RENAME with user defined type column
9204 2924041 No rows may be returned when VIEW column is defined on CAST / MULTISET
9204 2823100 OracleConnectionCacheImpl over OCI driver leaks memory fetching Objects
9204 2856475 OCITypeArrayByName dumps if passed in type has been dropped and schema is null
9204 2862818 Bad export of NESTED table in LOCALLY managed tablespace - ORA-25150 or ORA-942 on import
9204 2883659 SELECT with TABLE FUNCTION from Oracle8.0 client fails with OERI [KOKEEAFI1]

Special Datatype Bugs

The following table lists the special datatype bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2528866 HTTPURITYPE fails to authenticate when the URL has a username/password

Timestamp Bugs

The following table lists the timestamp bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2269285 OERI:[QCTVCO : BFC] INSERTing '' to table with TIMESTAMP column and trigger
9202 2286804 Incorrect timezone conversion for some TIMESTAMPs for certain zones
9202 2339030 :OLD / :NEW contain garbage for TIMESTAMP WITH LOCAL TIMEZONE columns
9202 2354325 Fetching a TIMESTAMP with getTimestamp(int,Calendar) throws SQLException
9202 2378216 Retrieving a TIMESTAMP value using getTime() throws NumberFormatException
9202 2384272 JDBC getTime() of a TIMESTAMP does not return the correct Time value
9202 2420305 ORA-26041 from Direct path load of TIMESTAMP data on EBCDIC
9202 2502439 JDBC OCI returns INCORRECT nanoseconds value
9203 2227982 OCIIntervalSetYearMonth() may produce ORA-1873 errors
9203 2460091 2460091ORA-7445[pgmbiad_build_input] if PL/SQL calls Java callout with a TIMESTAMP parameter
9203 2490061 ORA-932 for remote SQL using TIMESTAMP datatype
9203 2601203 ORA-3106 from INSERT .. RETURNING a NULL into a TIMESTAMP column
9204 2547402 OERI[KDIC_CREATE_JOURNAL_TABLE_1] from REBUILD index ONLINE of TIMESTAMP key column
9204 2640192 JDBC may not work with TIMESTAMP data correctly if server version is Oracle8i
9204 2858755 OCCI client dumps fetching TIMESTAMPS from REF CURSOR
9204 1380218 getMetaData().getColumns() does not describe BLOB/CLOB/TIMESTAMP columns

Deadlock Bugs

The following table lists the deadlock bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2223234 Concurrent DML against a CLUSTER TBLE may deadlock
9202 2272671 DEADLOCK possible on CREATE INDEX ONLINE (KGL lock v. TT enqueue)
9202 2415134 SR enqueue deadlock possible
9202 2442539 SMONs may deadlock updating COL_USAGE$ in Oracle Real Applications Clusters
9203 2136347 ORA-4020 on CREATE OR REPLACE VIEW with SELF-REFERENTIAL CONSTRAINTS
9203 2235386 Improved diagnostics for ORA-60 deadlocks
9203 2479110 Self deadlock (on library cache pin) revalidating INVALID PL/SQL
9203 2652409 False ORA-60 possible in Oracle Real Applications Clusters/OPS environments
9203 2664217 Undetected deadlock (dc_objects V library cache lock) invalidating dependencies
9204 1994858 False deadlock/undeleted deadlock in XA
9204 2516513 ORA-60 from concurrent PDML on same table
9204 2554861 ORA-4020 while refreshing a MATERIALIZED VIEW
9204 2746688 ORA-4020 possible from DDL or TRUNCATE in PL/SQL
9204 2799097 DEADLOCK possible on concurrent EXCHANGE PARTITION (DC_TABLESPACE_QUOTAS)
9204 2864094 ORA-60 in SQL apply with multiple apply servers with rollback operations
9204 2930352 Deadlock from concurrent setFetchSize and commit in JDBC
9204 2938982 Deadlock using VARRAY in JDBC
9204 2976372 Creating a PL/SQL object intermittently fails with ORA-4021 in Oracle Real Applications Clusters

Domain Index Bugs

The following table lists the domain index bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2099345 Parameters are not passed properly to ODCIStats routines for STATIC TYPE METHODS
9202 2161360 DROP of OPERATOR corrupts dictionary - ORA-29836 on ALTER INDEXTYPE
9202 2223449 ORA-29925 / ORA-932 from DML against table with functional DOMAIN index on ADT expression
9202 2312728 2312728Query against partitioned DOMAIN index dumps if there are many partitions
9202 2366678 Passing parameters to CALLOUTS may dump or report ORA-600 errors
9202 2498186 DEPENDENCY$ corrupted on ALTER INDEXTYPE
9203 2467216 MERGE/SPLIT partition with LOCAL DOMAIN indexes and UPDATE GLOBAL INDEXES dumps
9203 2526334 OERI:25012 from AND EQUAL with B-Tree and DOMAIN index
9203 2628799 Blank data from Domain Index only scan fetching PK only for IOT
9203 2631842 DBMS_ODCI.ESTIMATE_CPU_UNIT results loose accuracy
9203 2660592 CBO may needlessly evaluate bitmap plans for Domain indexes
9204 2484969 CBO may make multiple calls to ODCIStats functions
9204 2749361 Create DOMAIN INDEX fails on SUBTYPED OBJECT

Error Occurs Bugs

The following table lists the error occurs bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1803897 Bad define conversions may fail with ORA-3115 rather than ORA-932
9202 2104392 OERI:[QCSFBDNP:1] from nested CONNECT BY with binds in START WITH or FROM clause
9202 2217015 ORA-4016 accessing recreated SEQUENCE after DROP USER CASCADE
9202 2245527 ORA-903/ORA-911 selecting from UNION view
9202 2258603 OERI:12327 possible on SELECT with uncorrected subquery
9202 2265030 OERI:[KGHFRF1] possible select from X$KTFBFE for a non-existent tablespace
9202 2266135 OERI [KTSXTFFS-3] possible from X$KTFBFE for TEMPORARY tablespaces
9202 2276981 OERI:16608 possible if a session DROPS a dependent object of a query
9202 2277191 OERI:QERPFALLOCATEX2 possible from SELECT
9202 2294821 Additional diagnostics for OERI:12700
9202 2306106 OERI:[qerfxFetch_01] possible - affects OEM
9202 2316137 OERI:[KKSSCL-INF-INL-LOOP] possible
9202 2332996 OERI:kokbcrwo1 from SELECT DISTINCT.. CURSOR() .. statements
9202 2340064 ORA-1841 when ADD_MONTHS function results in DECEMBER 9999
9202 2345060 ORA-600[kokvxsql1] can occur compiling a view
9202 2345538 OERI:kdsgrds from SERIALIZABLE transaction on row dependent table
9202 2348151 OERI:comp3 possible from compressed insert direct load
9202 2351255 GROUP BY with large group key can OERI:[15851]
9202 2353474 OERI:[kksscl-inf-inl-loop] possible (rare)
9202 2355622 OERI[2907] possible on TEMPFILES
9202 2358608 Concurrent ANALYZE and DDL on table may OERI:16607
9202 2361148 OERI:[qerrmoFBU1] may mask a real user error
9202 2365220 OERI:[KCBBXSV_6] possible on an SGA SHRINK
9202 2371613 OERI:12412 from CASE expression in SELECT FOR UPDATE
9202 2371937 ALTER TABLE may signal false ORA-928
9202 2385673 OERI:[kpoblblen: pos1] re executing SQL from PL/SQL with CURSOR_SPACE_FOR_TIME=TRUE
9202 2401670 Refinement of the fix for Bug:2361084 (ORA-1002)
9202 2407473 ORA-3106 possible on UPDATE of a LONG using character bind greater than 4000 bytes long
9202 2431567 Oracle errors may show wrong OS error
9202 2434873 OERI[kksscl-inf-inl-loop] during heavy load with CURSOR_SPACE_FOR_TIME=TRUE
9202 2438883 ORA-27544 can occur on connect if previous connect failed
9202 2443896 OERI:[12811] from concurrent SELECT and DDL (DROP) with SQL_TRACE=TRUE
9202 2446649 ORA-7445 [kkslod] / ORA-600[kksscl-inf-inl-loop] possible
9202 2479523 STARTUP FORCE may fail with OERI[KJPCR3]
9202 2520796 ORA-439 trying to enable VLM in Standard Edition
9203 2432911 OERI[6757] from HASH CLUSTER if INITRANS has been altered
9203 2436600 OERI:[KTFTHCF-1] possible from V$FILESTAT / DBA_DATA_FILES
9203 2496556 OERI[KDOURP-2] possible during CR rollback (rare)
9203 2501591 ORA-928 / ORA-4031 on "ALTER VIEW <sys_view> COMPILE" if REMOTE objects exist with same name
9203 2510810 ORA-911 / ORA-936 from ANALYZE .. VALIDATE STRUCTURE when USERNAME / TABLE_NAME contain special characters
9203 2539791 ORA-600[kksscl-inf-inl-loop] possible following process death
9203 2604343 ORA-12085 / OERI:1234 possible using non-empty RESOURCE_MANAGER_PLAN
9203 2617480 OERI:[KDISLE:NROWS][1] during INSERT into an INDEX
9203 2619827 ORA-903 / ORA-911 from ALTER VIEW COMPILE with UNION ALL in inline view
9203 2642031 ORA-979 from complex view merge of "THE" subquery.
9203 2662838 ORA-2095 attempting to modify SESSION modifiable parameter in SPFILE
9203 2678481 OERI[729] possible on SHUTDOWN
9203 2686862 OERI [qesmmaLogUnResSpc1] possible under load
9203 2701826 OERI[1236] possible
9204 2588505 OERI:[QESMMCVALSTAT4] on DELETE with PGA_AGGREGATE_TARGET set
9204 2588590 OERI[525] possible while growing the cursor hash table
9204 2619013 OERI:KCBRLS_1 can occur in ktuServiceNTP under load
9204 2727120 OERI:[13009] possible from SELECT FOR UPDATE of a LONG
9204 2728408 False ORA-8177 possible SELECTING data with SERIALIZABLE
9204 2883734 Many OERI:15212's if exception occurs when loading a child cursor
9204 2918820 ORA-911 can occur on SELECT using OUTLINES
9204 2929778 OERI[QKSWCCRW:1] possible

Excessive CPU Usage Bugs

The following table lists the excessive CPU usage bugs addressed in this patch set:

Fixed in Release Bug Number Description
9203 2533616 Materialized view refresh can use lots of CPU
9203 2580238 Reduce CPU usage of multiple DBW processes with Oracle Real Applications Clusters9203
9203 2610596 Huge CPU usage from Oracle Recovery Manager server when TAP not mounted with BACKUP_TAPE_IO_SLAVE=TRUE
9203 2617683 Query optimization may use more CPU than needed with fuzzy operators
9203 2647211 Implicit cursor FOR loop memory leak/CPU hit
9204 2740472 Shared servers burn CPU executing Java "wait()" call
9204 2785102 Query involving many partitions (greater than 1000) has high CPU/memory usage
9204 2834669 JDBC 9.2 thin uses more CPU (in client) than 8.1
9204 2842026 SQL APPLY coordinator can use excessive CPU
9204 2858886 LCK process may use excessive CPU

Export/Import Bugs

The following table lists the export/import bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2179567 Updatable snapshots do not work after 8.0 export to Oracle8i/Oracle9i import
9202 2249786 IMP-17 / ORA-24150 possible importing user RULE SET
9202 2249845 Export does not export SUPPLEMENTAL LOG syntax
9202 2300104 CREATE VIEW OF TYPE .. UNDER .. does not export the UNDER clause
9202 2308033 OERI:6191 / OERI:6193 possible on DIRECT mode EXPORT of long row with greater than or equal to 8k DB_BLOCK_SIZE
9202 2311919 FULL export with datafile greater than 1024M produces WRONG size datafiles in .DMP file
9202 2401529 IMP-17/ORA-1031 DBMS_RULE_EXIMP importing 9.0 export file into 9.2
9202 2488515 EXP-8/ORA-911 on DBMS_RULE_EXP_RL_INTERNAL if user names have double quotes
9202 2488515 EXP-8/ORA-911 on DBMS_RULE_EXP_RL_INTERNAL if usernames have double quotes
9203 2261722 Oracle8i export of Oracle9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
9203 2381172 IMPORT fails / corrupts the AQ dictionary with duplicate QUEUE_TABLE names
9203 2435257 IMP-3 / ORA-1031 in SYS.DBMS.DDL if IMP_FULL_DATABASE granted via a ROLE
9203 2448243 Full export from non DBA user may fail with ORA-1031 in SYS.LT_EXPORT_PKG
9203 2461455 ORA-7445 [qcdlgtd] or ORA-942 from IMPORT FROMUSER / TOUSER
9203 2488590 EXP-8 ORA-3113 exporting large CREATE OPERATOR statement
9203 2508813 ORA-16000 exporting from READ ONLY database
9203 2514079 Import of ALTERED CTXRULE index can fail with DRG-11000
9203 2598124 EXP-8 / ORA-1422 if queue and queue table have same name
9203 2598387 Export / OCI clients using prefetch may see corrupt data
9203 2599613 IMP-60 possible when object already exists in database
9203 2619341 Export may contain invalid SQL for CREATE SYNONYM in FULL export
9203 2629652 PLS-302 'EXPORT_RULE_SET' must be declared from EXPORT
9203 2687401 XDBSCHEMAs may not be imported to correct schema
9204 809293 ORA-4071 during IMPORT of trigger with SPACES in definition
9204 2519640 User level export slow (compared to DBA export)
9204 2631450 IMP-17 / ORA-6550 possible on exp/imp of large rule sets
9204 2672970 EXP-10 if username contains ".", ":" or "%"
9204 2685696 ORA-1422 from Export in package XDB.DBMS_XDBUTIL_INT
9204 2740454 Export of statistics may write bad details to the .DMP file
9204 2746788 Export does not error on DISK FULL conditions (IMP-9 on import)
9204 2750878 IMPORT does not work for Schema based XMLTable in multibyte
9204 2801371 IMP-58 / ORA-19007 importing XMLType table with XML schema
9204 2809130 Queue import can corrupt dictionary metadata if queue pre-exists
9204 2854856 ORA-911 can occur importing a trigger in a mixed case SCHEMA name
9204 2862818 Bad export of NESTED table in LOCALLY managed tablespace - ORA-25150 / ORA-942 on import
9204 2881018 EXP/IMP of Queues after DB upgrade to 9.2 fails
9204 2882923 ORA-1031 importing Queue table
9204 2900891 Oracle8i Export from 9.2 DB fails with EXP-8 ORA-904

External Tables Bugs

The following table lists the external tables bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1788921 ENH: Add OCI_ATT_IS_EXTERNAL attribute to show table is EXTERNAL
9202 2179558 ORA-7445[KOTGTSCH] possible selecting from external table
9202 2214266 Multibyte EXTERNAL TABLE with greater than 1 file may return wrong results
9202 2245711 TERMINATED BY " " with ENCLOSED BY may incorrectly reject rows
9202 2245909 SQLLoad with EXTERNAL_TABLE does not find DIRECTORY objects correctly
9203 2662576 EXTERNAL TABLE select may fail with OERI:[KPXSDPINIT_02]
9204 2710266 ORA-7445 [KKXMIXCX] with EXTERNAL TABLE in a subquery
9204 2862067 ORA-29913 from ZONED DATA TYPE in EXTERNAL TABLE
9204 2867563 OERI:KSMFRFG2 / memory corruption selecting from an EXTERNAL TABLE

Function-based Index Bugs

The following table lists the function-based index bugs addressed in this patch set:

Fixed in Release Bug Number Description
920-4 2799028 ENH: Remove Functional Index need for QUERY_REWRITE /QUERY_REWRITE_ENABLED
9202 2147213 Wrong results / dump possible using DESC functional index
9202 2148807 Function based index with GROUP BY / ORDER BY dumps in evaopn2
9202 2183412 Wrong results possible with DESC index
9202 2189463 ORA-7445 [EVAOPN2] with FUNCTIONAL INDEX on semi-join (EXISTS) predicate
9202 2209813 OERI:5213 possible on direct load into table with bitmapped functional index
9202 2234325 ALTER partitioned table with global FUNCTIONAL index and LOBS dumps in kkfiSetMemRep
9202 2277043 OERI:16221 from CREATE OR REPLACE VIEW depending on FUNCTIONAL index
9202 2281312 ORA-7445/dump possible on UPDATE of PRIMARY KEY enforced with a DESC index
9202 3007386 ORA-6553 PLS-306 when table has FUNCTIONAL INDEX involving ADT attribute
9203 2468542 ORA-7445 [EVAOPN2] with DECODE predicate involving FUNCTIONAL index
9203 2477249 Wrong results / Dump from INSERT AS SELECT with GROUP BY using FUNCTIONAL INDEX
9203 2607029 High memory use optimizing SQL with functional indexes and many expressions
9203 3007386 ORA-6553 PLS-306 when table has FUNCTIONAL INDEX involving ADT attribute
9204 2363698 ORA-1793 creating functional index on XML (or object) columns
9204 2671151 ORA-7455 [EVAOPN2] querying PARTITIONED table with functional index
9204 2687315 Parallel range scan of DESC index may dump (under QERPXSTART/QERPX_START/EVAOPN2)
9204 2705892 ORA-7445[qesaPackCols] using functional bitmap indexes
9204 2789620 Wrong results when DISTINCT list contains a functional index expression
9204 2803588 OERI[20083] using DBMS_STATS.GATHER_TABLE_STATS on table with bitmapped functional index
9204 2805335 Excessive shared pool memory use for parse of certain statements using functional indexes
9204 2908284 Dump in EVAOPN2 using DESCENDING functional index

Gateways/Heterogeneous Services Bugs

The following table lists the gateways/heterogeneous services bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1870073 HS may fail to write to trace files with absolute path names
9202 2021310 HS agent memory corruption / dump fetching data
9202 2031989 HS_PASSTHROUGH inserts BLANKS for DBCS data
9202 2083537 ORA-01457 selecting non-zero DECIMAL through Heterogeneous Services
9202 2167905 ORA-2072 / OERI:17147 with DB2 select with greater than 20 indexes when DBSTATS=YES
9202 2207382 OERI:12333 fetching from Oracle/DB2 in XA
9202 2273745 Job Queue processes selecting over HS link leaks file descriptors
9202 2282235 ORA-7445 possible from remote joins of Oracle and DB2 tables over HS
9202 2338866 Setting HS_TIME_ZONE gives incorrect values for implicit TIMEZONE columns
9202 2391827 ORA-2055 when running a procedure in a loop with a commit
9202 2408475 Memory leak for sessions connecting over HS
9202 2413560 Calling MQGET in loop eventually causes an ORA-4030
9202 2422277 TG4IFX describes NOT NULL columns as NULLABLE
9202 2422316 TG4IFMX INSERT to TEXT datatype fails
9202 2504285 CTAS through TG4DRDA can give bad NUMBER precision/scale
9203 2586586 Values after decimal place are shifted converting String to PACKED DECIMAL over HS
9203 2590687 DML over HS may dump
9203 2599708 Newer HS agent causes the older RDBMS server to fail
9204 2213722 HS/Callout connections do not write CID string to listener.log
9204 2562972 HS agent may leak memory with mixed character sets
9204 2586586 Values after decimal place are shifted converting String to PACKED DECIMAL over HS
9204 2679297 Non numeric characters can be inserted into a NUMBER column in HS
9204 2707096 Server memory leak on long running select over HS in PL/SQL block
9204 2723804 Index on remote table not used joining Oracle and Non-Oracle table
9204 2774988 ORA-1457 selecting NUMBER with SCALE/PRECISION over gateway
9204 2923299 CBO may reject index access for remote non-Oracle table

Globalization Bugs

The following table lists the globalization, formerly known as national language support, bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1231199 Wrong results possible from parallel queries where NLS_SORT is not BINARY
9202 1926886 Some Text Lexers do not support AL32UTF8
9202 1951553 Wrong results from PQ with ORDER BY NLSSORT
9202 2166798 ORA-3124 inserting NULL into CLOB with UTF8 characterset
9202 2200107 Wrong unicode mappings in WE8MACROMAN8 for "en dash"
9202 2219627 Character conversion problem between ZHT16DBCS and UNICODE
9202 2252369 NLS_LANG using UTF8 leads to ORA-12708 / ORA-12705 errors on startup on EBCDIC platforms
9202 2255864 ABSTRACT LOB does not support multibyte data
9202 2273837 Server Dump when JDBC THIN writes data to multibyte TEMP LOB
9202 2283232 ORA-1839 possible converting date to Hiraj calendar
9202 2291043 Client dump in lmsaicmt() creating many program contexts using OCIEnvInit() in non-US NLS env
9202 2321765 Scrollable ResultSet can return "?" for multibyte data
9202 2343219 NCHAR LIKE comparisons may not match on EBCDIC platforms
9202 2346368 ORA-6502 in multibyte using NLS_LENGTH_SEMANTICS=CHAR
9202 2352727 XMLType has poor performance in multibyte
9202 2367256 Fix for Bug:2133357 not in Oracle9i (Corrupt LOBS after altering DB characterset)
9202 2423226 Extra characters appended with REPLACE / RTRIM on multibyte shifted data
9202 2430006 Some JA16EUC characters not handled correctly
9202 2448615 Wrong results from HASH JOIN over DBLINK with multibyte data
9202 2471679 PL/SQL length validation differs from SQL for CHAR SEMANTICS
9202 2516119 LIKE pat ESCAPE with no escape character in pat spins in multibyte
9202 2527123 CL8EBCDIC1158 / CL8EBCDIC1158R NLS data missing
9203 2379746 Multibyte data corrupted by setPlsqlIndexTable()
9203 2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 to UTF8
9203 2455551 Blank padded comparison fails with NLS_COMP=ANSI & NLS_SORT<>BINARY
9203 2529036 LIKE against multi-byte CLOB can give wrong results
9203 2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases
9203 2616459 CHR() returns CHR(0) when NLS_SORT is set
9203 2635990 Java mappings for IANA character sets missing
9203 2649659 Invalid data in OCI7 client in non-blocking mode with NLS conversion
9203 2656881 LOB data corrupt after migrating DB from single to multibyte
9203 2675123 Client gets no data in some cases when NLS_LANG is UTF8
9203 2682894 ORA-1424 from LIKE expression on multibyte non-shifting character set
9204 1934372 SOUNDEX / FUZZY text queries give wrong results on EBCDIC platforms
9204 1951123 No error when PL/SQL copies multibyte CHAR into BIND which is too small
9204 2233987 ORA-1460 fromOracle8i toOracle9i SELECT when database uses AL32UTF8
9204 2249940 NLSSORT does not work for large strings in multibyte
9204 2511699 Silent data truncation inserting char literal into NVARCHAR2 column
9204 2588348 Particular multibyte sequences can spin in PL/SQL compilation
9204 2613581 JDBC missing CharacterConverter for JA16SJISTILDE and JA16EUCTILDE
9204 2627570 RPAD(str,n,CHR(0)) spins using multi-byte character set
9204 2651760 PL/SQL LENGTH/LENGTH2/LENGTH4/LENGTHC sometimes count BYTES not CHARACTERS
9204 2749165 Arabic Hijrah calendar gives incorrect results in Oracle9i
9204 2751460 ORA-3106 when Oracle8i client selects from 9.2 AL32UTF8 database
9204 2758545 NLS_LENGTH_SEMANTICS is not supported in JDBC
9204 2793768 getString() on ROWID column gets wrong data on EBCDIC platforms
9204 2801315 Fast refresh gets ORA-1401 with pre-Oracle9i Master with differing national character set
9204 2810543 Create MVIEW may ORA-12054 in JA16SJIS if tablename contains '@' byte in a character
9204 2818699 NLS code may try to read memory past the end of a string (dump)
9204 2854840 ALTER DATABASE CHARACTER SET may exhaust shared pool and/or RBS space
9204 2863236 JDBC can fetch illegal UTF data
9204 2864519 Translations for ITALIAN DAY NAMES are incorrect
9204 2866419 ORA-1461 from SQL over DB link between different character sets
9204 2924467 JDBC NLS mapping missing for BIG5-HKSCS
9204 2928676 CREATE MVIEW using LAG with PARTITION clause may spin in JA16SJIS
9204 2933426 Korean date format month names appear in English
9204 2964856 Wrong 'Day' / 'Mon' date masks for some languages
9204 2998476 DBA_FGA_AUDIT_TRAIL.SQL_TEXT may contain garbage (no charset conversion)

Hash Join Bugs

The following table lists the hash join bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2296247 Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY
9203 2514869 Dump (qerhjWalkHashBucket to kpofcr) from HASH JOIN OUTER with BINDs
9203 2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases
9204 2726276 Wrong SCORE() for plans with Text index below a HASH JOIN
9204 2727212 Wrong results from HASH join between CHAR column and VIEW column based on a BIND variable

Index Only Tables Bugs

The following table lists the index only tables bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2144939 OERI:[2006] inserting data into an IOT with mapping table
9202 2157502 OERI:4819 possible when partition maintenance is running against an IOT
9202 2210617 SELECT from corrupt IOT returns wrong results
9202 2218504 IOT inherits tablespace COMPRESS property
9202 2263160 ORA-25191 using DBMS_STATS.ALTER_SCHEMA_TAB_MONITORING with an IOT
9202 2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
9202 2378847 ORA-7445 [PRSPO_PROC_OPTS] creating IOT with NOMAPPING clause
9202 2485931 ORA-8102 from IOT DML with concurrent MOVE ONLINE
9202 2511906 ORA-8102 possible on update of IOT
9202 2515703 Dictionary corruption from concurrent partitioned IOT maintenance
9203 2566356 ONLINE MOVE of KEY-COMPRESSED IOT corrupts the IOT
9203 2628768 ORA-922 possible with OVERFLOW and VARRAY clauses on an object IOT
9203 2628799 Blank data from Domain Index only scan fetching PK only for IOT
9203 2629193 OERI:[711]..[KDIFXS - PREFIX CONTEXT] selecting COMPRESSed key IOT
9203 2707304 OERI:17059 / OERI:kqlupd2 / PLS-907 after adding partitions to Partitioned IOT
9203 2718814 DML/Rollback problems with SUPPLEMENTAL LOG GROUP on IOT
9204 2217233 ORA-7445 [kdtiGetRow] on buffered INSERT of NULL key into an IOT
9204 2471756 Dump inserting NULL into NOT NULL IOT column with CURSOR_SPACE_FOR_TIME=TRUE
9204 2697589 OERI:[kdiblbout:rowidIllegal] on INSERT into IOT with BITMAP indexes
9204 2718937 OERI:6033 from SELECT on IOT with COMPRESSED PRIMARY KEY
9204 2747643 Wrong results from MAX/MIN on IOT with GROUP BY
9204 2802560 SETID index not created automatically for nested table in an IOT
9204 2816978 Wrong results using secondary index on IOT to fetch OVERFLOW columns
9204 2856711 OERI[KDDIOTDCA] during ALTER TABLE DROP COLUMN on IOT with MAPPING table
9204 2882279 OERI[KTSSPAD_SEGMENT1] during ALTER IOT MOVE ONLINE OVERFLOW

Instance May Crash Bugs

The following table lists the system halt process spin bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2028564 ORA-7445 or OERI:17114 errors possible after OERI:729 - PMON may die
9202 2108072 OERI:1433 if LGWR archival is ASYNC and network congested
9202 2200934 PMON may crash in kssxdl cleaning up session which was enqueuing a message
9202 2200961 OERI:[529] in PMON after session dies when adding a subscriber‘
9202 2271499 CKPT may crash with instance if datafile cannot be accessed
9202 2308667 PMON may OERI:[KSSRMP1]
9202 2321616 ORA-7445 [kjctcommerr]/instance crash if different instance is killed
9202 2376087 PMON can crash the instance with OERI:[KJCCFMB:X!] if a process dies in a small timing window
9202 2389513 SMON may crash with ORA-7445 in kxsrod()
9202 2391877 PMON may crash the instance with OERI:[4157] if AUDITING is enabled
9202 2392166 Calling SERIALLY_REUSABLE PL/SQL from SQL can cause PMON to crash
9202 2472541 PMON ORA-7445 [kghxfr] after shared server gets ORA-4031
9203 2524784 PQ on Oracle Real Applications Clusters may crash the instance with OERI[KSLPSPR1]
9203 2548338 LGWR may CRASH with instance (ORA-340) after failure of a single log
9203 2590120 PMON may crash instance with ORA-600 [KTUABT_1:DROP/TRUNCATE NOT COMP]
9203 2649033 LMON may crash instance with ORA-227 errors
9203 2688442 SMON may crash instance with ORA-7445 [KSFD_OSDRQFIL]
9203 2695916 LCK PGA memory leak may crash instance
9203 2736672 LSP0 failure may crash instance
9203 2761238 Primary may crash if log cannot be transported to standby
9204 2329767 OERI:106 setting diagnostic EVENT against PMONs session
9204 2444568 Instance CRASH with OERI[2886] if ALTER.. READ ONLY dumps
9204 2529847 OERI [KCBVMAP] possible with VLM enabled
9204 2621133 OERI:kjbconsign:wip2 after block recovery during instance recovery
9204 2726601 OERI[4406] possible in SMON using automatic undo management
9204 2760836 PMON cleanup of dead shared servers or dispatcher can crash instance (OERI:26599/OERI:1115)
9204 2761238 Primary may crash if log cannot be transported to standby
9204 2780642 LMD may dump (in KJDDOPT/KJDDGMAK)
9204 2783981 LGWR may CRAH if an exception occurs when killing the network
9204 2793038 Session may die with ORA-4031 if shared pool exhausted when storing object level statistics
9204 2866612 Internal errors using Javelin within shared server connections
9204 2872299 OERI:2103/instance crash can occur if foreground hits data/index internal error
9204 2886505 Create database link denial of service vulnerability
9204 25324240 PMON/instance crash possible cleaning up dead process

Instance Startup Bugs

The following table lists the instance startup bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2252369 NLS_LANG using UTF8 leads to ORA-12708 / ORA-12705 errors on startup on EBCDIC platforms
9202 2332285 Unnecessary trace files are generated on startup/shutdown
9202 2347262 Hang during startup possible in SMU mode
9202 2360088 ORA-1092 on STARTUP if the firsT UNDO_TABLESPACE is OFFLINE (ORA-376 in alert)
9202 2549696 OERI:4406 on startup if system trigger hits ORA-4092
9203 2078899 OERI[4814] / OERI[kkdlgon4] on startup with DDL in SYSTEM TRIGGER
9203 2185189 OERI[26599] possible executing DBMS_JAVA.SERVER_STARTUP
9203 2387804 STARTUP command with invalid option reports internal error (SP2-642)
9203 2399093 ORA-16000 opening database READ ONLY
9203 2634796 Crash during Oracle Recovery Manager "proxy copy" can leave database unopenable
9203 2654862 Open of standby in READ ONLY mode may fail after upgrade (ORA-16000)
9204 2774331 OERI:[KCCWNC_RECTYPE][23] can occur during database open
9204 2796951 OERI:[KCBBINIT_5] on STARTUP with DBWR_IO_SLAVES on NUMA
9204 2798851 ORA-4031 possible from SMON during SHUTDOWN or STARTUP
9204 2825306 Instances may not start when configured nodes missing from cluster
9204 2974471 ORA-603 / OERI[17271] on instance startup with SQL_TRACE=TRUE and CURSOR_SPACE_FOR_TIME=TRUE
9204 2999004 OLS policy admin should not be allowed in database startup session

Intelligent Agent Bugs

The following table lists the Intelligent Agent bugs addressed in this patch set:

Fixed in Release Bug Number Description
9203 1473558 ALERT event triggered periodically when ALERT.LOG inaccessible
9203 1653586 DUMPFULL and DMPFULPCT events may fail without an error message
9203 1874903 Register ALERT event fails on OpenVMS
9203 2061886 CHUNKSML event test performs poorly on large databases
9203 2180332 TABLESPACE and SEGMENT details missing for MAX EXTENTS event
9203 2241006 DBSNMP dumps on startup if SNMP_RO.ORA too large
9203 2283515 TABLESPACE FULL event returns NMS-1005 / NMS-1078 for RAW device
9203 2288229 Invalid timezone returned by Agent to OMS on Linux
9203 2301903 ORA-1438 or ORA-1406 possible from ORAMOVELONG with large NUMBER columns
9203 2355062 DBSNMP.HOSTNAME not used by agent collection service
9203 2378422 Jobs fail when a PASSWORD_FILE is used
9203 2378428 DBSNMP.HOSTNAME should overrule HOSTNAME for discovery
9203 2423440 The "Chunk Small" event fails if the TABLESPACE not in DBA_FREE_SPACE
9203 2437916 AGENTCTL may dump on STOP AGENT command
9203 2438101 EMDDISCOVER fails on some platforms
9203 2440387 NMS-1078 evaluating a network mounted file system
9203 2445663 Small DBSNMP memory leak running jobs
9203 2467637 MIB value for oraDbSysParseCount cannot be queried
9203 2487889 Agent reports TNS-12538 errors for SQL*Plus jobs
9203 2506864 DBSNMPWD may die rather than restart DBSNMP
9204 1867995 The default agent discovery should not include any Fail Safe database
9204 2188033 Wrong time information for AGENTCTL STATUS BLACKOUT
9204 2245039 Agent cannot discover listeners for same hostname in different TCP domains
9204 2341518 Listener startup / shutdown via OEM may not use correct environment
9204 2344959 Listener UP/DOWN event does not fire if TNS_ADMIN is set
9204 2360564 Agent stops concurrent manager data collection after restart
9204 2373910 Target names greater than or equal to 32 characters long can crash the agent
9204 2376643 Migration of 817 jobs fails
9204 2395244 ORATCLSH "FILE TYPE" function fails for files greater than 2GB
9204 2414543 Listener Up/Down event does not get / set Oracle environment reliably
9204 2417955 Data Gatherer may not collect in accordance with collection settings
9204 2453901 CMan discovery script uses wrong logfile name
9204 2465214 The same listener may be discovered more than once by the Agent
9204 2529365 "VNI-4031: INVALID LISTENER NAME" registering net up/down event
9204 2613603 Agent Handle leak possible using User Defined Event
9204 2693902 DUMPFULL event does not expand '@' character from USER_DUMP_DEST
9204 2694931 DBSNMP consumes 100% CPU using Performance Manager
9204 2717009 Jobs or events fail with "Target no longer valid" after Oracle8i to Oracle9i 9.2 upgrade
9204 2727522 DG loader can fail with ODG-5113
9204 2737752 Oracle Net UpDown event wrongly signalled if listener password protected
9204 2746033 SNMP MIB walk times out if database is down
9204 2763918 Concurrent job execution can use same TEMPORARY filename giving errors
9204 2775447 SWAP FULL % notification is wrong on WINDOWS with multiple swap files
9204 2777812 NMS-312/NMS-1005 registering "Buffer Cache Hit %" / "In Memory Sort %" in Oracle Real Applications Clusters
9204 2808515 Tablespace Full event fails with "Event test ... failed" for RAC instance
9204 2809593 TABLESPACE FULL event does not work properly for locally managed TEMP tablespaces

Interoperability Bugs

The following table lists the interoperability bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2187428 ORA-06544 [84203] possible from client 8.0 PL/SQL to Oracle9i Server
9202 2255030 ORA-3106 possible from 8.0 client talking to Oracle8i / Oracle9i over a DBLINK
9202 2259259 MLOG$ entries may not be purged for Oracle9i master to Oracle8i snapshot site
9202 2266130 8.0 PL/SQL client may report a false ORA-04062
9202 2280027 OERI:504 possible from using SNAPSHOTs against Oracle8i
9202 2296516 Oracle9i ODBC driver cannot access a LONG column in an Oracle8i database
9202 2308496 9.2 client may dump talking to Oracle7 - should error on connect
9202 2411553 OERI:17271 from V7 XA client updating tables with SNAPSHOT on it
9202 2434384 Updatable snapshots with an Oracle8i MASTER do not work - Fast refresh fails (ORA-2064)
9203 2261722 Oracle8i export of Oracle9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
9203 2517719 ORA-3115 from setTimestamp() in JDBC 9.2 with an 8.0 database
9203 2519148 Memory leak from PL/SQL RPC to an older database version in a LOOP
9203 2551933 ORA-7445[ttcclr] from V7 protocol client
9203 2563206 CLOB data is corrupted when inserted from an 8.0 client to multibyte 9.2 server
9203 2572944 SELECT over Oracle8i to Oracle9i DBLINK may fail with ORA-7445 [opidsi]
9203 2599290 OERI from 8.0 client querying NULLs and LONG over Oracle9i to Oracle9i DBLINK
9203 2608776 ORA-3106 in 8.0 client SELECTing pseudo column from Oracle9i server over DBLINK
9203 2641473 OERI[OPIXRB-4] from V7 client binding SQLT_RID to 9.2 table over DBLINK
9204 2233987 ORA-1460 from Oracle8i to Oracle9i SELECT when database uses AL32UTF8
9204 2526424 PLS-215 from Oracle9i to Oracle8i PL/SQL reference to view with zero length character column/s
9204 2735873 Mutually recursive TYPES with can dump the shadow with Oracle8i to Oracle9i
9204 2751460 ORA-3106 when Oracle8i client selects from 9.2 AL32UTF8 database
9204 2767356 PLS-382 from client PL/SQL referencing TIMESTAMP in higher DB version
9204 2795727 Streams instantiation RPC may error when used between different versions
9204 2797571 SQL may hang from 7.3 to Oracle8i/Oracle9i if SELECT expression greater than 960 characters long
9204 2801315 Fast refresh gets ORA-1401 with pre-Oracle9i Master with differing national character set
9204 2805491 JMS-120 / PLS-306 using older JMS client (AQAPI.JAR) to 9.2 server
9204 2876379 False ORA-24347 from INSERT over DB LINK between releases
9204 2883659 SELECT with TABLE FUNCTION from Oracle8.0 client fails with OERI [KOKEEAFI1]
9204 2894277 OERI[17200] accessing Oracle9i to Oracle8i remote object with BFILE column from PL/SQL
9204 2900891 Oracle8i Export from 9.2 DB fails with EXP-8 ORA-904

Java Bugs

The following table lists the Java bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2514960 SSLUnknownErr exception using HTTPS / OracleSSLCredential in JVM
9204 2523297 PGA JavaVM memory leak using many large objects
9204 2538276 setAccessbleObject may core dump or give ReadOnlyObjectException
9204 2669172 JSSL does not work with JDK 1.4.1
9204 2740472 Shared servers burn CPU executing Java "wait()" call
9204 2760836 PMON cleanup of dead shared servers/dispatchers can crash instance (OERI:26599 /OERI:1115)
9204 2767486 ORA-600[PMUOCON2#1: INVALID CDS] when returning NULL ADT/collection through a JAVA callout
9204 2791857 Memory leak / ORA-4030 using Deflator class in Java stored procedure
9204 2793768 getString() on ROWID column gets wrong data on EBCDIC platforms
9204 2804724 Out of memory in JAVA POOL shows an ORA-4031 "shared pool" message
9204 2828825 OracleXAConnectionCacheImpl / OracleConnectionCacheTimeOutThread not Serializable
9204 2866612 Internal errors using JavaVM within shared server connections
9204 2866922 ClassNotFoundException using JNDI with RMI in JavaVM
9204 2875058 Repeat calls to JSP from PL/SQL can leak PGA memory
9204 2886182 ORA-7445[JOE_FINALIZE_SOME_OBJECTS] possible in Java VM
9204 2956462 NCOMP fails with java.lang.stackOverflowError
9204 3013905 JVM calls can cause PGA growth (in 4Mb chunks)
9203 2185189 OERI[26599] possible executing DBMS_JAVA.SERVER_STARTUP
9203 2460091 ORA-7445[pgmbiad_build_input] if PL/SQL calls Java callout with a TIMESTAMP parameter
9203 2503614 PL/SQL calling JSP with TIMESTAMP argument dumps
9203 2627474 Wrong results from CURSOR expression in JSP if first column is an ADT
9202 1818720 Dump with PL/SQL and Java Stored Procedure returning NULL CLOB
9202 2014766 Java TRIGGERS do not set :NEW variables to the new values
9202 2095829 Dump passing using setNull() to bind a NULL ADT in KPRB driver
9202 2289268 POLICYTABLE demo does not work in 9.2 as sess_sh does not exist
9202 2293968 SQLJTYPE Java classes invalid on downgrade from 9.2 to 9.0/8.1
9202 2311562 NullPointerException creating NUMBER array greater than 16376 elements in KPRB
9202 2395838 Memory leak in JVM on some platforms
9202 2403347 Memory leak in KPRB driver with statement caching enabled
9202 2415848 No removal script for catjava.sql - add catnojav.sql
9202 2476780 OJVMJAVA tool is missing from 9.2.0.1
9202 2520311 FAILOVER: JVM may crash after failover

JDBC Bugs

The following table lists the JDBC bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 993752 ResultSet.getMetaData describes FLOAT columns as NUMBER
9202 1987973 ArrayOutOfBoundsException from getPlsqlIndexTable of a null element
9202 2025426 Bad number data / NumberFormatException with leading 0's in number string in JDBC
9202 2123461 Multithread JDBC dumps in upibrk using connection pooling
9202 2232903 Cancel causes subsequent ORA-1013 if no current call in progress
9202 2246137 ArrayIndexOutOfBoundsException in oracle.jdbc.oracore.UnpickleContext.read_lengthBytes after changing between 32<->64 bit
9202 2258128 SQLException not thrown when calling stmt.executeUpdate("select ...")
9202 2263847 NullPointerException if DriverManager.setLogStream() called
9202 2271862 Dump selecting ALTERED collection type using JDBC
9202 2273837 Server Dump when JDBC THIN writes data to multibyte TEMP LOB
9202 2285052 NCHAR data is null padded instead of blank padded in JDBC thin
9202 2319370 JDBC OCI threaded application may dump in nsdo()
9202 2321765 Scrollable ResultSet can return "?" for multibyte data
9202 2351441 setObject() may throw ClassCastException even with fix for bug 2263645
9202 2352429 (FLOAT)getObject(n) returns 0.0 for NULL data
9202 2354325 Fetching a TIMESTAMP with getTimestamp(int,Calendar) throws SQLException
9202 2363615 getObject() of FLOAT returns java.math.BigDecimal
9202 2363882 Binding a null element in a non null PlsqlIndexTable throws an NullPointerException
9202 2378216 Retrieving a TIMESTAMP value using getTime() throws NumberFormatException
9202 2384272 JDBC getTime() of a TIMESTAMP does not return the correct Time value
9202 2387032 ClassCastException binding a Jpub ARRAY object using setObject()
9202 2389423 JDBC thick memory leak
9202 2394555 oracle.net.config.Config.systemName() may not include DOMAIN information
9202 2394922 SecurityException using JDBC in an applett
9202 2396763 Unnecessary parses using JDBC Thin
9202 2422803 ORA-1000 / cursor leak in JDBC THIN
9202 2427185 JDBC Thin does not support redirection to another NET listener
9202 2429208 defineColumnType throws ArrayIndexOutOfBoundsException with statement caching
9202 2478248 JDBC thin has no way to set TCP.NODELAY
9202 2502439 JDBC OCI returns INCORRECT nanoseconds value
9202 2503211 Java makefiles in DEMO.ZIP do not work (Windows)
9202 2505692 Trying to create a TypeDescriptor for a large object throws an exception
9203 2121433 ORA-1401 after type change between two AddBatches
9203 2379746 Multibyte data corrupted by setPlsqlIndexTable()
9203 2498661 getMetaData() throws NullPointerExeception if statement not executed
9203 2509105 JDBC with pooled OracleConnection slower in Oracle9i than Oracle8i
9203 2511780 Add JDBC XA support for LOOSE transactions
9203 2517719 ORA-3115 from setTimestamp() in JDBC 9.2 with an 8.0 database
9203 2543401 JDBC thin throws an Exception for wrong username/pwd with encryption enabled
9203 2548088 Connection URL & user name not in DMS Statistics
9203 2550971 NullPointerException from defineColumnType executed twice in KPRB
9203 2589186 Empty Timestamp is returned for NULL column value
9203 2608837 JSSL close of layered socket does not close base socket
9203 2623740 sendBatch() method may return incorrect row count
9203 2646101 Data corruption binding a JDBC TEMP CLOB into an NCLOB column
9203 2654607 OERI binding NULL REF type from JDBC Thin
9203 2657221 JDBC spins using Scrollable ResultSet with ORDER BY
9203 2659833 Client side errors during JDBC XA operations are ignored
9203 2668460 OracleTwoPhaseDriver.stepThinTwophase missing in Oracle 9.2
9203 2678338 Heuristically committed/rollback cases are not handled by JDBC XA (ORA-24756)
9203 2684915 CHAR.toString returns HEX values if input has invalid character
9203 2691131 set/getConnectionProperties not in OracleDataSource.
9203 2696397 Blob.length() fails when selected with a Stream type (LONG, LONG RAW)
9203 2698190 9Retain STACK trace for JDBC XA errors with fix for BUG 2659833
9203 2700006 JDBC Thin "Unexpected Packet" error with LOBS in multithreaded client
9203 2723384 ORACLE.SQL.CLOB.CREATETEMPORARY can leak TEMP LOBS
9203 2739638 ArrayIndexOutOfBoundsException from defineColumnType
9204 9204 JDBC XA returns XAER_RMERR instead of XAER_RMFAIL if DB is down
9204 1380218 getMetaData().getColumns() does not describe BLOB/CLOB/TIMESTAMP columns
9204 1834732 JDBC thin fails with ORA-3115 while trying to fetch a UROWID
9204 1841512 JDBC/THIN does not handle ORA-1403 correctly
9204 2213820 OraclePooledConnection is not Serializable
9204 2234882 SQLException on setMinLimit greater than 10 on OracleConnectionCacheImpl
9204 2329001 ArrayOutOfBoundsException reading BLOB with JDBC Thin
9204 2346116 "IO Exception" using JDBC THIN with 184-192 byte connect string
9204 2589566 SDU/TDU cannot be set/modified for THIN-JDBC connections
9204 2594726 JDBC Array insert greater than 65535 elements may product NULL rows / fail with ORA-6531
9204 2613581 JDBC missing CharacterConverter for JA16SJISTILDE and JA16EUCTILDE
9204 2632715 OracleDataSource.getConnection should not use DriverManager.getConnection
9204 2640192 JDBC may not work with TIMESTAMP data correctly if server version is Oracle8i
9204 2668460 OracleTwoPhaseDriver.stepThinTwophase missing in Oracle 9.2
9204 2671550 JMS getQueue() and getTopic() are slow with many queues in the DB
9204 2695913 JDBC thin client may hang / not honour query timeout
9204 2714820 Struct descriptor with OracleConnectionCache throws "logical connection no longer valid"
9204 2717235 JDBC XA recover followed by start throws XAException (XA_PROTO)
9204 2758545 NLS_LENGTH_SEMANTICS is not supported in JDBC
9204 2777813 JDBC Thin connection pool may drop below minLimit with inactivity timeout
9204 2783519 JDBC XA throws ORA-24762 instead of ORA-24756
9204 2785968 Cursor fetched from a Statement is child of a Connection
9204 2793750 ORA-31011 / ORA-19202 / server dump from JDBC setObject(XMLType)
9204 2794931 JDBC OCI does not resolve connect string using directory naming for SSL
9204 2797962 Broken JDBC connection pool connections are not closed
9204 2805491 JMS-120 / PLS-306 using older JMS client (AQAPI.JAR) to 9.2 server
9204 2808007 AQ/JMS does not get message notifications if DB does not know HOSTNAME of client
9204 2820065 TimeToLive does not work for OracleConnectionCacheImpl
9204 2821420 Client memory using CURSOR in JDBC with OCI driver
9204 2823100 OracleConnectionCacheImpl over OCI driver leaks memory fetching Objects
9204 2829878 getDOM returns NULL when XML document contains german characters
9204 2834669 JDBC 9.2 thin uses more CPU (in client) than 8.1
9204 2834792 JDBC Thin can have trouble connecting to cluster when ADDRESS_LIST used
9204 2848826 JDBC OCI file handle leak on failed login
9204 2857178 ORA-1000 from multi-threaded JMS client doing object enqueue/dequeue
9204 2858085 JDBC 'Bigger type length than Maximum' using CLOB/UTF8
9204 2863236 JDBC can fetch illegal UTF data
9204 2866576 JDBC OCI file handle leak on failed Connection attempts
9204 2880356 JDBC generates a lot of DMS metrics when Statement Caching is enabled
9204 2880768 TCP.NODELAY default should be ON for JDBC Thin
9204 2884131 Client memory leak when a REF CURSOR is selected but not used (no getXXX call)
9204 2897119 JDBC OCI heap error 17112 with setNativeXA(TRUE)
9204 2899289 OracleConnectionCacheImpl does not clear the cache if instance goes down
9204 2913161 JSSL incompatible with Suns JSSE in same JVM
9204 2924467 JDBC NLS mapping missing for BIG5-HKSCS
9204 2930352 Deadlock from concurrent setFetchSize and commit in JDBC
9204 2938982 Deadlock using VARRAY in JDBC
9204 2972552 Expose TCP.NODELAY as a JDBC System property

Job Queue Bugs

The following table lists the job queue bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2273745 Job Queue processes selecting over HS link leaks file descriptors
9203 2649244 JOBS may not run at scheduled intervals

Large File Bugs

The following table lists the large file bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2395244 ORATCLSH "FILE TYPE" function fails for files greater than 2GB

LDAP/Oracle Internet Directory Bugs

The following table lists the LDAP/Oracle Internet Directory bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1399887 DN cannot be longer than 255 characters
9202 1900178 OID binds to all IP addresses on multi-homed host
9202 2150432 LDAP server cannot handle multibyte orclpasswordattribute
9202 2197620 Subtree search results incorrect when the DN has "%" or "_"
9202 2250904 LDAP server file descriptor leak
9202 2275804 DBMS_LDAP leaks "session heap" memory
9202 2314755 BULKLOAD may not load some attributes
9202 2334728 "DSA unwilling to Perform" possible creating subscriber DIT
9202 2356142 OID bulkload slow with many binary attributes
9202 2356334 Verifiers cannot be modified if already hashed
9202 2372441 DBMS_LDAP_UTL.get_group_membership() server memory leak
9202 2385093 Change log corruption in OID replication
9202 2392901 Delete of entry with ACP causes complete REFRESH on CONSUMER
9202 2400552 LDAP query with wildcard can fail with "invalid DN syntax"
9202 2427622 OIDLDAPD dumps when modifying/deleting a null referral entry
9202 2435276 orclcommongroupsearchbase attribute is ignored - enterprise groups found ONLY under oracle context
9202 2447643 Binary attributes greater than 80 bytes will not synchronize properly
9202 2463666 DBMS_LDAP_UTL.CHECK_GROUP_PROPERTIES() can be slow
9202 2473527 OIDLDAP server dump when modifying expired password
9202 2483720 LDAP search with NOT and AND/OR filter may error
9202 2499991 Missing entries from one level search against OID
9202 2518863 LDAP search may fail with LDAP error 53 / ORA-936
9203 2382299 DBMS_LDAP_UTL may error for users not associated with "inetorgperson"
9203 2458526 Oracle Internet Directory Configuration Assistant /createDefaultSubscriber fails
9203 2483741 Oracle Internet Directory allows object to be deleted multiple times without error
9203 2515844 Memory leak using PL/SQL and LDAP
9204 2461769 DBMS_LDAP.normalize_dn_with_case does not do NLS translation
9204 2483734 ODS_CHG_STAT table cannot be reinitialized
9204 2602197 ENH: XDB should support LDAP groups within ACLs
9204 2623818 Oracle Internet Directory replication server may dump replicating Root DSE attributes
9204 2646966 OIDLDAPD may dump (in gslfcfRLoadVerifierProfiles) during LDAPMODIFY
9204 2754014 LDAPADDMT may dump if the LDIF file contains an error

Leak Bugs

The following describes the leak bugs addressed in this patch set:

Memory Leak or Growth Bugs

The following table lists the memory leak or growth bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2124770 Client memory leak in LDAP C-API
9202 2193939 FAILOVER: Client memory leak using TAF when repeatedly open/close connections
9202 2206438 High memory usage from DBMS_STATS.GATHER_TABLE_STATS on partitioned table
9202 2227360 QMN process leaks memory ("kprbalo temp mem")
9202 2281071 ORA-4030 / memory leak calling RPC in PL/SQL cursor loop
9202 2295845 OERI:729 if TRUNCATE PARTITION / ALTER TABLE MODIFY COLUMN interrupted
9202 2303271 OCCI memory leak calling getRef() on an object
9202 2322384 EXEC SQL OBJECT GET leaks memory
9202 2322759 DBMS_LOB.READ can leak "koh-kghu call" heap memory
9202 2324976 Objects may be allocated with session duration
9202 2371235 Memory leak passing LOB parameters to PL/SQL callouts in a loop
9202 2372441 DBMS_LDAP_UTL.get_group_membership() server memory leak
9202 2376673 Memory leak in OCCI
9202 2379136 SQL*Plus memory / LOB leak querying XMLType
9202 2381566 Large UPDATE of NESTED TABLE column shows excessive memory use
9202 2385206 OERI:723 possible after ORA-22813 error on objects
9202 2389423 DBC thick memory leak
9202 2391827 HS agent leaks memory which can lead to ORA-2055
9202 2395838 Memory leak in JVM on some platforms
9202 2403347 Memory leak in KPRB driver with statement caching enabled
9202 2408475 Memory leak for sessions connecting over HS
9202 2416245 Large memory leak using SDO_RELATE in a PL/SQL loop
9202 2416678 Memory leak calling OPAQUE TYPE member function
9202 2449579 DIAG process can leak memory
9202 2508513 ORA-22813 / OERI:723 with large objects/collections
9202 2559902 Memory leak creating CONTEXT/CTXXPATH index on schema XMLType col
9203 2093521 Memory leak using SAVE EXCEPTIONS with FORALL BULK operations
9203 2334377 Memory Leak from TABLE subquery against XMLType
9203 2441734 Win: Setting SQLNET.EXPIRE_TIME wastes stack memory
9203 2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 to UTF8
9203 2515844 Memory leak using PL/SQL and LDAP
9203 2519148 Memory leak from PL/SQL RPC to an older database version in a LOOP
9203 2547290 Refresh of Materialized View over DBLINK wastes memory (ORA-4030)
9203 2560808 Logical Standby apply slaves leak memory in Max Availability mode
9203 2605435 Client memory leak on TAF connection
9203 2607029 High memory use optimizing SQL with functional indexes and many expressions
9203 2642976 Memory growth on INSERT of XMLTYPE
9203 2643775 OERI:730 on shutdown using object level statistics
9203 2647211 Implicit cursor FOR loop memory leak / CPU hit
9203 2683414 Logminer may use excessive memory selecting redo for LONG columns
9203 2695916 LCK PGA memory leak - may crash instance
9203 2702333 Memory leak using PL/SQL associative array
9203 2707212 Memory leak from long running log mines
9203 2717317 Client memory leak from EXEC SQL CONTEXT ALLOCATE / FREE
9204 2378009 PGA memory leak from APPLY servers when using LOBS
9204 2441734 Win: Setting SQLNET.EXPIRE_TIME wastes stack memory
9204 2523297 PGA JavaVM memory using many large objects
9204 2544186 OCCI memory leak using to Test() from number to string conversion
9204 2562972 HS agent may leak memory with mixed character sets
9204 2667235 High memory consumption parsing bitmap access with many OR predicates
9204 2686584 PGA memory leak in PQ Query coordinator
9204 2688989 Client memory leak calling SQLALD with size=0
9204 2707096 Server memory leak on long running select over HS in PL/SQL block
9204 2707731 Memory leak in EXTPROC from CTX_DOC.IFILTER
9204 2760514 Memory leak calling a TABLE() function / pipeline function in a loop
9204 2763219 Client memory leak using OCIStmtPrepare with TAF connection
9204 2786968 Shared pool memory leak / ORA-4031 on repeated invalidate/execute of cursors
9204 2791857 Memory leak / ORA-4030 using Deflator class in Java stored procedure
9204 2805249 SGA shrink may not release memory back to the O/S on Solaris
9204 2810557 PRO client can leak memory when NLS_LOCAL=YES
9204 2817728 Shared pool memory leak / ORA-4031 when collecting segment statistics
9204 2821420 Client memory using CURSOR in JDBC with OCI driver
9204 2823100 OracleConnectionCacheImpl over OCI driver leaks memory fetching Objects
9204 2869329 Memory leak constructing XMLTypes from CLOBS or Strings
9204 2875058 Repeat calls to JSP from PL/SQL can leak PGA memory
9204 2880427 Client side memory leak using OCIXMLType APIs
9204 2883743 Pipelined functions leak memory for parameters with default values
9204 2884131 Client memory leak when a REF CURSOR is selected but not used (no getXXX call)
9204 2890022 Memory leak from XML queries within PL/SQL
9204 2901439 Memory leak using XDK for C in multithreaded application
9204 2908182 XMLType.transform() leaks memory
9204 2916024 PGA memory leak possible using OUTER JOIN with CONTAINS
9204 2958718 Memory leak if schema based document used on client side for printing / DOM operations
9204 2972701 Memory growth executing SQL/XML repeatedly in PL/SQL
9204 2980596 PL/SQL FOR LOOP performance hit & memory leak using implicit cursors
9204 3013905 JVM calls can cause PGA growth (in 4Mb chunks)

Resource Leak Bugs

The following table lists the resource leak, such as file handles, bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2250904 LDAP server file descriptor leak
9202 2251552 Cursor leak / ORA-1000 using CURSOR() expressions
9202 2273745 Job Queue processes selecting over HS link leaks file descriptors
9202 2379136 SQL*Plus memory / LOB leak querying XMLType
9202 2422803 ORA-1000 / cursor leak in JDBC THIN
9203 2452537 SELECT of remote sequence leaks cursors (ORA-1000)
9203 2517189 Handle leak on repeated CONNECT/DISCONNECT in OCI_THREADED mode
9203 2618958 File descriptor/handle leak from IPQ slaves over IPC
9203 2624737 Cursor leak (ORA-1000) selecting from X$KTFBUE
9203 2723384 ORACLE.SQL.CLOB.CREATETEMPORARY can leak TEMP LOBS
9204 2095311 ORA-1000 / cursor leak doing getXML() with a CURSOR() expression and setSkipRows()
9204 2479112 Oracle OLEDB transaction abort leaks cursors
9204 2747582 TEMPORARY LOB LEAK on PL/SQL <collection>.DELETE or assignment
9204 2847512 Temp LOB leak in DBURITYPE.GETBLOB()
9204 2848826 JDBC OCI file handle leak on failed login
9204 2859225 XDB file handle leak possible opening LPXUS.MSB
9204 2866576 JDBC OCI file handle leak on failed Connection attempts
9204 2871030 JMS leaks a cursor for each AQOracleQueueTable
9204 2994706 CRAWLER filtering may leak file descriptors

Literal Replacement Bugs

The following table lists the literal replacement bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2052836 Client dump possible using CALL statement with CURSOR_SHARING=FORCE
9202 2237610 OERI:[kgskbwt1] / OERI:[kskbind1] possible using CURSOR_SHARING
9202 2273604 CURSOR_SHARING=FORCE may not share cursors using a BETWEEN clause with CBO
9202 2308292 ORA-7445 [kkslhib] for INTO <bind> using CURSOR_SHARING and SESSION_CACHED_CURSORS
9202 2321000 Subquery with a ROWNUM predicate may hang using CURSOR SHARING
9202 2442097 INSERTS into USER-DEFINED TYPES with CURSOR_SHARING=FORCE does not share cursors
9203 2474192 OERI:[OPIBND1] on CREATE of TEXT INDEX with CURSOR_SHARING
9203 2508702 ORA-7445 [KKSLHIB] with CURSOR_SHARING=FORCE with INTO clause
9203 2604211 OERI:[KKSFBC-NEW-CHILD-THRESH-EXCEEDED] using literal replacement
9204 2643579 ORA-7445 [kxspoac] using CURSOR_SHARING=FORCE (or similar)
9204 2884469 OERI[729] possible using literal replacement

LogMiner Bugs

The following table lists the LogMiner bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2759170 Simultaneous DBMS_LOGMNR_D.BUILD may hang
9204 2879367 Logminer needs logs from all threads in RAC or no rows are returned
9204 2881035 OERI:17158 possible selecting from V$LOGMNR_CONTENTS
9204 2901586 LOGMINER / Streams apply of CTAS with greater than 122 columns dumps
9204 2942371 Redo for tables with row dependencies cannot be mined
9203 2537320 SQL_REDO for large LOB operations is not executable
9203 2590317 OERI:[krvxrptl:Cannot delete current l] selecting from V$LOGMNR_CONTENTS
9203 2656036 OERI/memory corruption selecting SQL_REDO for CLOB DMLS
9203 2666229 Log mining of LOB DMLs fails
9203 2683363 Incorrect translation of TEMPORARY TABLE DMLs in LogMiner
9203 2683414 Logminer may use excessive memory selecting redo for LONG columns
9203 2685942 OERI/dump possible mining LOB redo
9203 2691486 Mined data loss possible from LOB ERASE/TRIM/WRITE redo
9203 2707212 Memory leak from long running log mines
9202 2205649 ORA-29531 from DBMS_LOGMNR_CDC_PUBLISH.DROP_SUBSCRIBER_VIEW
9202 2259246 ORA-1280 if both DBMS_LOGMNR.CONTINUOUS_MINE an SCN range set
9202 2336819 2nd call to START_LOGMNR with DDL TRACKING fails
9202 2338739 DBMS_LOGMNR_CDC_PUBLISH / DBMS_CDC_PUBLISH may error with ORA-1426
9202 2479415 Dump / OERI with greater than 1 cursor selecting from V$LOGMNR_CONTENTS

MERGE Bugs

The following table lists the MERGE bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2141115 ORA-1008 / OERI:15212 from MERGE statement with BIND variables in the USING clause
9202 2262202 MERGE INTO .. INSERT .. RETURNING dumps - should ORA-933
9202 2336714 PARALLEL MERGE does not error if the UPDATE violates a CHECK CONSTRAINT
9203 2272566 MERGE statement may dump (ORA-7445) in insape instead of signalling ORA-1401
9203 2329059 DML monitoring does not track modifications by MERGE statements
9203 2339666 Parallel MERGE into composite partitioned table not performant
9203 2473741 Before row update trigger may not fire for MERGE statement
9203 2536531 MERGE on table with BITMAP index fails with OERI:[kauins:1]
9204 2691172 Incorrect cost computations for MERGE statements

Miscellaneous Bugs

The following table lists the miscellaneous bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1872981 ALTER SYSTEM QUIESCE RESTRICT still allows user sessions to get locks / ORA-54
9202 2106360 MODULE (V$SESSION/V$SQL) should default to the PROGRAM name
9202 2206480 PROCESS RESOURCE COUNT not accurate
9202 2207685 BATCH ERROR handling with INSERT..SELECT does not work
9202 2252932 V$SEGSTAT statistics not cleaned up on TRUNCATE / MOVE
9202 2293250 JOIN cannot be used as a table alias
9202 2367294 Invalidation of dependent objects is slow
9202 2372332 SPFILE entries are case sensitive
9202 2385294 Change default dynamic SGA granule reuse policy to LIFO
9202 2401318 No error raised when DB_CACHE_ADVICE and DB_BLOCK_BUFFERS set
9202 2419951 ORA-7445 [kghalf] possible from SYSTEMSTATE dump using ORADEBUG
9202 2430992 Waits possible on "FILE NUMBER TRANSLATION" latch
9202 2474452 Dumps possible pickling / unpickling collections
9202 2535965 ALTER SYSTEM SET FILE_MAPPING=TRUE fails (ORA-2097)
9203 2398069 Unnecessary "SEARCH IN KDISTI..." trace file messages
9203 2529763 Rename of 9.0.1 OMF file fails with ORA-1276
9203 2710910 ALL_SOURCE, USER_SOURCE and DBA_SOURCE views are slow
9204 2577016 ORA-938 from CASE expressions with NULL arguments
9204 2603538 AIX 5L: FILESYSTEMIO_OPTIONS parameter is not read from the init.ora file
9204 2689620 APPS install - cannot ANALYZE DUAL with O7_DICTIONARY_ACCESSIBILITY=FALSE
9204 2702723 Win: Performance bottleneck for thread specific data
9204 2725925 ORADEBUG "HANGANALYZE -G DEF" fails with OERI[KSDXREQ_0
9204 2782926 Diagnostic for when PMON cannot get ROW CACHE enqueue
9204 2783569 ROW_CACHE diagnostic output may dump (in ksdfmw)
9204 2786391 Diagnostic ERRORSTACK may dump (in kghalf)
9204 2801367 Diagnostic fix to dump more information on OERI:[skgxprrgn2]
9204 2845571 Tru64: ORA-7445 error message does not include failing function name
9204 2905433 Enhanced diagnostics for out of memory conditions during checkpoint
9204 2945011 VLM (USE_INDIRECT_DATA_BUFFERS=TRUE) does not work on Standard Edition Oracle

NUMA Bugs

The following table lists the NUMA bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1767169 Working sets not assigned to best DBW on NUMA
9204 2796951 OERI:[KCBBINIT_5] on STARTUP with DBWR_IO_SLAVES on NUMA

OCCI Bugs

The following table lists the OCCI bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 9202 OCCI REF destruction dumps if ref to pin() fails
9202 2245006 OCCI populating NESTED TABLE / VARRAY greater than 245 elements inserts corrupt data
9202 2303271 OCCI memory leak calling getRef() on an object
9202 2311292 OCCI client memory corruption
9202 2324342 next(1) fails for setDataBuffer with prefetch enabled
9202 2333038 ORA-24360 binding REF to PL/SQL from OCCI
9202 2335874 OCCI application may hang on commit
9202 2376673 Memory leak in OCCI
9203 2519017 OCCI:RESULTSET.GETOBJECT() dump for NULL objects
9203 2696120 OCCI client dump (kpuhhalo) on Commit/Rollback if using DML over DBLINK
9204 2268410 OCITypeByName setVector() does not work for type synonyms
9204 2544186 OCCI memory leak using toText() for number to string conversion
9204 2610331 OCCI getString() can return invalid values for NUMBER columns
9204 2784301 ENH: Add support for OCCI in Visual C++ V7
9204 2858755 OCCI client dumps fetching TIMESTAMPS from REF CURSOR

OCI Bugs

The following table lists the OCI bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1788921 ENH: Add OCI_ATT_IS_EXTERNAL attribute to show table is EXTERNAL
9202 2159595 Multithreaded OCI client may dump processing Oracle errors
9202 2286367 OERI:KPOSCWR2 / OERI:KPOSCF10 from OCIStmtFetch2 array fetch
9202 2291043 Client dump in lmsaicmt() creating many program contexts using OCIEnvInit() in non-US NLS env
9202 2316195 OCI with COLLECTION may dump on OCIObjectFlush / OCITransCommit
9202 2360115 OCI demo header lines longer than 79 characters (affects OS/390)
9202 2379327 Multithreaded client may hang when using BEQ adaptor
9202 2388400 OCI_ATTR_ROW_COUNT returns incorrect row count for piecewise fetches
9202 2406422 ORA-37 possible using OCI connection pooling in RAC environment
9202 2445917 User signal handler not called if SA_SIGINFO set
9202 2463295 Cache client access to error message files reduce file access
9203 1130195 OCIBindByPos "curelep" parameter wrong if PL/SQL deletes elements of C array
9203 1850169 ORA-1405 occurs if OCIBindDynamic() used for NULL PL/SQL OUT bind
9203 2019207 DYNAMIC bind callback functions not called properly with RETURNING clause
9203 2227982 OCIIntervalSetYearMonth() may produce ORA-1873 errors
9203 2235818 The SCALE of a NUMBER with no SCALE specified shows as 0
9203 2448939 OCICacheFlush stores objects as the base type instead of the SUBTYPE
9203 2449486 OCI_ATTR_CLIENT_IDENTIFIER attribute cannot be cleared once set
9203 2510357 ODESCR dumps with unaliased column expression length greater than= 960 chars
9203 2514005 Client may dump (kpurst) when calling OCIBreak / OCIReset
9203 2517189 Handle leak on repeated CONNECT/DISCONNECT in OCI_THREADED mode
9203 2539277 Client dump possible (ttcSetBuf) during fetch
9203 2598387 Export / OCI clients using prefetch may see corrupt data
9203 2616833 Non blocking OCI may not show error text for user PL/SQL errors (ORA-20000-ORA-20099)
9203 2624452 Redefinition of buffer length with OCIDefineByPos gets wrong no bytes for LONGS
9203 2635098 ODESCR may dump if unaliased column expression too long
9203 2641473 OERI[OPIXRB-4] from V7 client binding SQLT_RID to 9.2 table over DBLINK
9203 2645455 Control characters are trimmed from bind variables
9203 2649659 Invalid data in OCI7 client in non-blocking mode with NLS conversion
9203 2686200 FAILOVER dumps if OCI_ATTR_INTERNAL_NAME / OCI_ATTR_EXTERNAL_NAME set in UTF16 client
9204 2368369 Win: False ORA-3126 possible in OCI client on Windows using BEQ/IPC
9204 2400243 Lengths retrieved for VARCHAR array fetch not always ZERO for NULLs
9204 2478181 OERI:[KPOSCWR2] / OERI:[KPOSCF10] using OCIStmtFetch2 on big-endian platforms
9204 2479112 Oracle OLEDB transaction abort leaks cursors
9204 2661854 Symbol "interval" cannot be used in Pro/OCI code as it is defined in ocitrace
9204 2662826 Unable to connect to GLOBALLY IDENTIFIED user via SSL over OCIConnectionPool
9204 2673203 Dump (kpudsaattrg) from OCIParamGet after describe or procedure with zero parameters
9204 2699203 ORA-24371 possible on execute/fetch after failover
9204 2748765 OCI may fail to return data in UTF8
9204 2762016 Mutex problems from mixed V7 / V8 OCI calls
9204 2763032 OERI:[KPOSCWS0] possible from OCIStmtFetch2()
9204 2764565 ORA-21500 [17112] possible after failover
9204 2766270 ORA-1001 possible after failover
9204 2800779 OERI:[kolaHashFind:hash table] / ORA-21500 from OCILobLocatorAssign
9204 2856475 OCITypeArrayByName dumps if passed in type has been dropped and schema is null
9204 2880427 Client side memory leak using OCIXMLType APIs

ODBC Driver Bugs

The following table lists the ODBC driver bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1585197 ORA-1036 executing a stored procedure with a SQL Expression as a parameter
9202 2296516 Oracle9i ODBC driver cannot access a LONG column in an Oracle8i database

Online DDL Bugs

The following table lists the online DDL bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2702410 ORA-8104 / ORA-8106 occur on ALTER MOVE / REBUILD ONLINE

Optimizer Bugs

The following table lists the optimizer bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2109825 Incorrect cardinality estimate with OR predicate and NULL values
9202 2143154 Dump (in evaopn2) from view merging of semi joins
9202 2157655 GATHER_SCHEMA_STATS with GATHER STALE/GATHER EMPTY can fail to collect statistics
9202 2252824 ANALYZE TABLE with COLUMN STATISTICS may OERI:16515 or not collect statistics
9202 2262336 Compute statistics on COMPRESSed key index has wrong DISTINCT KEYS value
9202 2263517 DROP / EXCHANGE partition does not re-aggregate index statistics
9202 2273591 FIRST_ROWS_N can produce a much slower plan than expected
9202 2283254 Redundant filter predicates from FIRST_ROWS and concatenated index
9202 2287990 Bad plan possible from unnesting of multiple complex views
9202 2297645 Bad plan possible using CONTAINS() clause if DB_BLOCK_SIZE greater than 2KB
9202 2302662 Index join should be disallowed for SELECT FOR UPDATE (ORA-2014)
9202 2305613 ORA-7445 [kkodislike] from OR-expansion of LIKE on non-character expression
9202 2306067 ADD/COALESCE/MERGE/SPLIT PARTITION sets table statistics to NULL
9202 2307892 Poor plan possible with long inlist on multiple columns
9202 2324795 Join predicates not pushed into UNION ALL view with index access to CLUSTER
9202 2329325 CBO may choose FTS over index FFS for partitioned table
9202 2352376 Enhancement: Improve heuristic for subquery unnesting for partially matches indexed correlation predicates
9202 2363304 ORA-7445 [QKABXO] with FIRST_ROWS_N
9202 2384552 NO_PUSH_SUBQ hint may be ignored
9202 2394273 OERI:20084 possible from BITMAP MERGE over BITMAP CONVERSION to ROWIDS
9202 2397501 Dump / bad plan sometimes from HISTOGRAM statistics on JOIN columns
9202 2413264 Negative cost / bad plan for queries on partitioned table
9202 2418668 GATHER_SCHEMA_STATS() may fail in 9.2 for partitioned tables
9202 2424183 Wrong INDEX SELECTIVITY for multi-column IN-LIST predicate
9202 2426916 OERI:[KDISS_PIN_HDR: TOO MANY] on index skip scan
9202 2428537 ORA-7445 [MEMCPY] from DECODE() predicates in unmerged views
9202 2449515 Worse plan in 9.2 with unnested subquery & concatenated index
9202 2458455 Add ability to perform DISTINCT pushdown
9202 2469905 DBMS_STATS.GATHER..STATS may be slower in 9.2
9202 2538136 Complex View merging with subqueries may OERI:12327 with Bug:2417894
9203 2444517 ORA-918 possible with "_subquery_pruning_enabled"=true
9203 2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
9203 2474630 optimizer_dynamic_sampling greater than 1 forces CBO
9203 2487808 Poor join cardinality if both columns have histograms
9203 2489405 Re-ANALYZE after DELETE / UPDATE to NULL may get bad column statistics
9203 2534430 Poor plan possible from OR-expansion
9203 2539837 Wrong results using FIRST_ROWS_N with greater than 5 tables in FROM clause
9203 2542139 Long parse times possible if _B_TREE_BITMAP_PLANS=TRUE
9203 2603036 ORA-6533 gathering stats for partitioned table with DBMS_STATS
9203 2629376 DBMS_STATS has inaccurate estimation of NDV for small sample sizes
9203 2652654 DBMS_STATS can produce poor NDV column statistics
9203 2660592 CBO may needlessly evaluate bitmap plans for Domain indexes
9204 2212991 ORA-932 from Explain plan of TABLE(CAST(:BIND AS...) constructs
9204 2403965 ORA-1760 from DBMS_STATS gather stats against function based index on IOT
9204 2484969 CBO may make multiple calls to ODCIStats functions
9204 2691172 Incorrect cost computations for MERGE statements
9204 2706685 ORA-932 from PUSH_JOIN_UNION_VIEW with bind variables an UNION ALL view
9204 2742639 DBMS_STATS can produce Wrong statistics for LOCAL index with COMPOSITE partitioning
9204 2746855 OERI:EXPCMO_STRDEF1 from PUSH JOIN PREDICATE
9204 2782919 ORA-904 from DBMS_STATS to estimate statistics for a table with a functional index
9204 2787239 Suboptimal plan possible from TABLE / VIEW join with nullable table column
9204 2790432 Bad plan as INDEX SKIP SCAN cost LOWER than INDEX RANGE SCAN
9204 2803588 OERI[20083] using DBMS_STATS.GATHER_TABLE_STATS on table with bitmapped functional index
9204 2803588 OERI[20083] using DBMS_STATS.GATHER_TABLE_STATS on table with bitmapped functional index
9204 2808665 ORA-600[KKFI.QBCVFR] from predicate move around
9204 2839099 OERI:[QKSOPOPTASJLF1] during parse of ANTI/SEMI join with NVL/DECODE in correlation predicate
9204 2860984 Bad plan possible with collection iterator (table/Cast)
9204 2862290 Wrong column stats may be used if _PRED_MOVE_AROUND is enabled
9204 2871645 Complex view merging does not occur for recursive SQL more than depth 1
9204 2923299 CBO may reject index access for remote non-Oracle table
9204 2951740 Dump possible with fix for bug 2667235e
9204 2952255 Unexpected ORA-1445 during unnest of a subquery with ROWID column

Oracle Data Mining Bugs

The following table lists the Oracle Data Mining bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2702947 Enhance ABN rules output
9204 2770756 TX binning utility does not clean up temp tables
9204 2837853 Compute Lift invalid error message generated when no positive target values
9204 2904658 Attribute Importance results are incorrect for special cases
9204 2932601 Build ABN Model: Error message should be maximumbuildtime greater than or equal to 0 (not greater than 0)
9204 2941824 Validate restricted data types
9204 2941831 Single value target error message
9204 2944622 Get rules by content fails when rule length is the selection criterion
9204 2956602 Need GetRules API
9204 2967476 Inadequate binning can cause ABN model to fail
9204 2989926 Clustering Apply probabilities are biased for numeric attributes with outliers
9204 3010046 Model Seeker sample code gets exception in mining function settings creation phase

Oracle Disk Manager Bugs

The following table lists the Oracle Disk Manager bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2351682 ORA-1259 on DROP TABLESPACE when ODM enabled for RAW device
9202 2360437 CREATE DATABASE hangs with mix of ODM/non-ODM control files
9202 2382523 Oracle Recovery Manager backup to ODM fails
9202 2418614 In Oracle Real Applications Clusters "ALTER TABLESPACE READ-WRITE" fails under ODM
9202 2449721 Enabling ODM increases system calls
9203 2580111 CREATE DATABASE fails with ODM when DB_BLOCK_SIZE=32KB
9204 2624852 ORA-7445 [ksfd_odmbio] possible on IO error with ODM
9204 2753219 Database recovery using Oracle Recovery Manager fails when using ODM files
9204 2802588 With ODM archive log creation fails if archive log already exists

Oracle interMedia Images Bugs

The following table lists the Oracle interMedia images bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2452173 ORDImage.import fails with ORA-29400 in multibyte
9202 2495716 ProcessCopy errors with non latin character sets
9204 2592075 ORA-29270 possible importing media from HTTP sources
9204 2737581 interMedia install fails creating OrdSourceSvr
9204 2759147 "Warning:Type altered with compilation errors" on interMedia upgrade
9204 2865581 LZW compressed TIFF from ADOBE Photoshop 7 not readable
9204 2944659 Image processing may be slow due to not using Accelerated JARs
9204 2947010 PROCESSCOPY method does not release memory on completion

Oracle interMedia Video Bugs

The following table lists the Oracle interMedia video bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2444809 ORDVidea.setProperties slow for REAL Video data

Oracle Label Security Bugs

The following table lists the Oracle Label Security bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2499257 ORA-28115 from TO_DATA_LABEL on ad-hoc labels
9203 2735964 SA_USER_ADMIN.ADD_GROUPS() fails when given IN_DEF and IN_ROW
9204 2685869 Wrong results using PQO with OLS/VPD which uses application context
9204 2735033 OLS READ_CONTROL degrades SNAPSHOT REFRESH performance
9204 2756637 ORA-911 / ORA-936 inserting into OLS protected table
9204 2999004 OLS policy admin should not be allowed in database startup session

Oracle Names Bugs

The following table lists the Oracle names bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2488200 names.trace_timestamp does not work
9204 2387878 NAMESCTL may error after a 'STATUS' command (NNC-405 / TNS-12593)
9204 2864687 ENH: Increase NAMES.MAX_OPEN_CONNECTIONS upper limit

Oracle Net Bugs

The following table lists the Oracle Net bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1964080 Net Listener Vulnerability
9202 2123156 FAILOVER: V$SESSION.FAILOVER_METHOD / FAILOVER _TYPE may be wrong for second connection
9202 2179444 Unexpected ORA-3123 possible instead of ORA-3113 - affects TAF
9202 2187760 64 bit listener may crash intermittently when 32 bit ORACLE_HOME registers
9202 2194549 REMOTE_LISTENER may not work if LOCAL_LISTENER not set
9202 2210612 FAILOVER: Client may dump if query involves ROWID at failover time
9202 2222011 FAILOVER in a RAC environment can result in ORA-3113 at the client
9202 2237682 FAILOVER: Non SELECT SQL is reparsed on each execute after failover
9202 2308496 9.2 client may dump talking to Oracle7 - should error on connect
9202 2395416 Net overrun security vulnerability
9202 2396270 FAILOVER: ORA-25401 after failover when fetching CLOB data
9202 2399875 FAILOVER: PIECEWISE FETCH does not call callback function
9202 2405517 FAILOVER: OERI:[kclscrs_7] on FAILOVER in RAC
9202 2434834 LSNRCTL/CMAN/NAMES passwords do not match
9202 2447729 LISTENER may spin repeatedly logging "nsevwait_error" errors
9202 2454234 A 64 bit LISTENER may refuse load updates from a 32 bit server.
9202 2467947 LISTENER vulnerability
9202 2520311 FAILOVER: JVM may crash after failover
9203 2431526 Failover: ORA-1089 possible from shutdown IMMEDIATE
9203 2436572 FAILOVER: ORA-1 possible after FAILOVER during SELECT of an XMLType
9203 2540219 Listener denial of service vulnerability
9203 2655865 Re-registering services after listener reload can take 60 seconds
9204 1113588 New SQLNET.ORA parameter DEFAULT_SDU_SIZE
9204 2420679 Multithreaded client may dump due to non thread safe functions in LIBCLNTST9
9204 2589566 SDU/TDU cannot be set/modified for THIN-JDBC connections
9204 2593570 TNS-12564 / TNS-12520 possible with CONNECTION LOAD BALANCING
9204 2609103 OracleOCICOnnectionPool does not read the SQLNET.ORA file
9204 2752985 SQLNET.Expire_Time can dump if NET TRACE is enabled
9204 2755063 Database may cause TNS-1181 in the listener
9204 2812935 Listener load balancing does not work with long CONNECT descriptors
9204 2880768 TCP.NODELAY default should be ON for JDBC Thin
9204 2898021 Net Trace calls in client interrupt handler not async signal safe

Oracle OLAP Bugs

The following table lists the Oracle On Line Analytic Processing bugs addressed in this patch set:

Fixed in Release Bug Number Description
9203 2510750 ORA-35810 running XUMUTS.PLB on UTF8 database

Oracle Real Applications Clusters Bugs

The following table lists the Oracle Real Applications Clusters bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2108544 OERI:KCLFADB_2 possible in RAC environment
9202 2209142 Surviving node may HANG when PARALLEL_INSTANCE_GROUP set
9202 2232905 Diagnostic to dump information for corrupt library cache handles in OPS/RAC
9202 2273245 Internod PQ may fail with OERI:[KXFRSLVSETINFO1]
9202 2276622 ORA-29740 possible in RAC under heavy load
9202 2277188 OERI:kjbenterdlm possible in RAC
9202 2321616 ORA-7445 [kjctcommerr] / instance crash if a different instance is killed
9202 2351554 "post/wait queue" latch contention in RAC
9202 2353976 Instance crash can corrupt the database in RAC (database checkpoint greater than thread checkpoint)
9202 2372945 OERI:[KJPCRE2] possible connecting to instance in RAC or OPS environments
9202 2376087 PMON can crash the instance with OERI:[KJCCFMB:X!] if a process dies in a small timing window
9202 2377136 OERI:[KCLCHKINTEG_1] possible in RAC
9202 2385153 Shared pool LEAK on global enqueue timeouts in RAC
9202 2389807 "LKDEBUG -A PROC" does not work properly
9202 2390780 ORA-1538 reverting to UNDO_MANAGEMENT=MANUAL in RAC
9202 2404957 Memory needlessly allocated for GCS resources in EXCLUSIVE mode
9202 2405517 FAILOVER: OERI:[kclscrs_7] on FAILOVER in RAC
9202 2406422 ORA-37 possible using OCI connection pooling in RAC environment
9202 2418614 In RAC "ALTER TABLESPACE READ-WRITE" fails under ODM
9202 2427938 OERI:[KSIRES_1][KJUSERSTAT_BADLEVEL] on Ctrl-C in RAC/OPS
9202 2434915 OERI:6816 possible on SELECT SEQUENCE.NEXTVAL in RAC or OPS
9202 2438585 Lots of timeouts from "global cache ..." operations
9202 2442539 SMONs may deadlock updating COL_USAGE$ in RAC
9202 2475236 RAC performance issue using UDP IPC
9203 2438953 OERI[KCBGCUR_2] / OERI[6856] from RECO in RAC/OPS
9203 2479882 Permission changes may not propagate to all nodes
9203 2496772 ENH: Allow RAC load balancing by session counts rather than load
9203 2497219 OERI:[17065] / OERI:[17064] from XAOROLLBACK with AQ in OPS/RAC
9203 2498399 OERI:[KXFPRDP:1] / ORA-10388 if node is shutdown as PQ starts
9203 2499023 Diagnostic dump performed on SHUTDOWN ABORT of RAC instance
9203 2516493 LMS may dump with OERI[KJBRWRDONE:!W]
9203 2524784 PQ on RAC may crash the instance with OERI[KSLPSPR1]
9203 2542609 Corruption from CANCEL of managed standby if primary is RAC
9203 2560353 PQ load module may produce repeated name service publish requests
9203 2563162 Crash recovery may hang in RAC
9203 2580238 Reduce CPU usage of multiple DBW processes with RAC
9203 2594172 LMS may die with OERI:[KJBMPUPMASTER:DS]
9203 2605240 Row cache lock contention updating table with MATERIALIZED VIEW LOG in RAC
9203 2618958 File descriptor/handle leak from IPQ slaves over IPC
9203 2630846 In RAC the library cache pin owner list is not maintained correctly
9203 2633268 OERI:[kclwcrs_15] possible
9203 2649033 LMON may crash instance with ORA-227 errors
9203 2652409 False ORA-60 possible in RAC / OPS environments
9203 2654246 Hang possible in OPS due to local converts not occurring
9203 2657312 Under-posting of RAC receive buffers
9203 2689585 LMS might encounter ORA-600[504] during the simultaneous shutdown
9203 2695517 CR may SPIN after an instance crash
9203 2695916 LCK PGA memory leak - may crash instance
9203 2712701 Increased diagnostics for long enqueue timeouts in RAC
9204 1522211 Dequeue does not see enqueue from another RAC/OPS node for 5 minutes
9204 2480339 ORA-32734 can occur sending long ORADEBUG commands to remote nodes
9204 2537604 RAC graceful failover may result in corrupt new primary database
9204 2621133 OERI:kjbconsign:wip2 after block recovery during instance recovery
9204 2628232 ORA-600's from CR served block from a plugged in tablespace
9204 2677954 OERI:KJUHL1 can occur when MAX_COMMIT_PROPOGATION_DELAY <=700
9204 2683906 Excessive ROW CACHE LOCK waits using MATERIALIZED VIEW LOGs in RAC
9204 2706634 MANY PROCESS SLOW DOWN WHEN 240 SESSION INSERT AT THE SAME TIME
9204 2721812 OERI:KCCCHB_3 / stale value block possible
9204 2744066 Heavy load can lead to ORA-29740 in RAC
9204 2744449 Incorrect CLUSTER_INTERCONNECTS uses broadcast address
9204 2751251 More than 1 instance may be evicted in split-brain scenario
9204 2759173 OERI[KJBCLRSUSPECT:!SUS] possible as reconfiguration
9204 2762306 OERI:KCLFBAST_1 / OERI:KJMSM_EPC possible in RAC
9204 2768310 OERI[KJBRRCLAIM:DS] after cluster reconfiguration
9204 2772668 Setting CLUSTER_INTERCONNECTS opens a socket at IP address 0.0.0.0
9204 2780642 LMD may dump (in KJDDOPT / KJDDGMAK)
9204 2787377 Wrong results possible in RAC when MAX_COMMIT_PROPOGATION_DELAY=0
9204 2799826 OERI:549 possible
9204 2807799 OERI:[KJBRCHKINTEG:W] can occur when STALE conversion is processed
9204 2814565 Diagnostic to improve ENQUEUE block dump
9204 2825306 Instances may not start when configured nodes missing from cluster
9204 2834792 JDBC Thin can have trouble connecting to cluster when ADDRESS_LIST used
9204 2858886 LCK process may use excessive CPU
9204 2872299 OERI:2103 / instance crash can occur if foreground hits data/index internal error
9204 2873045 OERI:[KCLCHKBLK_2] possible in RAC
9204 2879367 Logminer needs logs from all threads in RAC or no rows are returned
9204 2905667 Instance terminated by CKPT due to ORA-1110 during shutdown in RAC
9204 2937108 DELETE CASCADE may spin in RAC
9204 2950375 OERI[2103] in RAC if LMD0 is producing a dump
9204 2976372 Creating a PL/SQL object intermittently fails with ORA-4021 in RAC
9204 2984331 Streams capture cannot startup on RAC after failover
9204 2990546 OERI:KCLFUSFAKE_4 possible in LMS process

Oracle Recovery Manager Bugs

The following table lists the Oracle Recovery Manager bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2323159 V$ARCHIVED_LOG may show STATUS="?" instead of a valid value if Oracle Recovery Manager has been used
9202 2334532 Not all backup pieces have a magic buffer written
9202 2336178 LIST BACKUP reports incorrect datafile name
9202 2382523 Oracle Recovery Manager backup to ODM fails
9202 2385857 Oracle Recovery Manager backup performance degrades over time for large DB_FILES
9202 2405244 ORA-7445 when Oracle Recovery Manager reported re-read of a corrupt mirrored block
9202 2458246 Oracle Recovery Manager thinks backups with SPFILE are OBSOLETE
9202 2478669 Oracle Recovery Manager uses existing DATAFILE copies at 2nd TSPITR (RMAN-6163)
9203 2484250 Oracle Recovery Manager CUMULATIVE BACKUP / MAINTENENCE may appear to hang (spin)
9203 2534017 DELETE/REPORT OBSOLETE lists wrong BACKUPSET if it contains READ ONLY or OFFLINE tablespace
9203 2541360 V$BACKUP_SPFILE records can get corrupted / RMAN-10031
9203 2610596 Huge CPU usage from Oracle Recovery Manager server when TAPE not mounted with BACKUP_TAPE_IO_SLAVE=TRUE
9203 2634796 Crash during Oracle Recovery Manager "proxy copy" can leave database unopenable
9204 2554861 ORA-60 in Oracle Recovery Manager BACKUP during RESYNC (DBMS_RCVCAT.SANITYCHECK)
9204 2666465 ORA-19653 possible during BACKUP CONTROLFILECOPY
9204 2715794 Intermittent ORA-19575 from Oracle Recovery Manager doing BACKUP during file RESIZE
9204 2719863 Oracle Recovery Manager may fail with ORA-1422 doing RESYNC CATALOG
9204 2753219 Database recovery using Oracle Recovery Manager fails when using ODM files
9204 2973616 Oracle Recovery Manager cannot restore corrupt backup pieces

Oracle Text Bugs

The following table lists the Oracle Text bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1926886 Some Text Lexers do not support AL32UTF8
9202 2055230 ORA-979 possible from Text query with in-line view and GROUP BY clause
9202 2202285 CTXLOAD -THESDUMP does not dump thesaurus properly
9202 2257361 ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
9202 2257375 Turkish language characters are not converted correctly with SPECIFIC or GENERIC base letter
9202 2286442 Nested WITHIN may miss hits
9202 2297645 Bad plan possible using CONTAINS() clause if DB_BLOCK_SIZE greater 2KB
9202 2320751 Wrong results possible from Text phrase search on XML document
9202 2327806 Japanese lexer as sublexer of multilexer may produce no tokens
9202 2344250 DRG-11614 errors possible from URL_DATASTORE to non-apache HTTP server
9202 2387002 CBO chooses inconsistent plans for TEXT queries with invalid query strings
9202 2401153 DRG-51311 possible after rebuilding CTXCAT index
9202 2443804 Add Oracle Text support for JA16SJISTILDE and JA16EUCTILDE
9202 2482535 CTX_CLS.TRAIN may ORA-7445[KRCIIBITMAP] with large number of training documents
9202 2498342 DRG-50953 from ExistsNode() on XPATH expression containing node() or text()
9202 2559902 Memory leak creating CONTEXT/CTXXPATH index on schema XMLType col
9203 1839270 Setting FILE_DATASTORE over 260 characters can corrupt server memory
9203 2274954 BASIC_LEXER CONTINUATION does not work for DOS documents with CR-LF line breaks
9203 2375782 NEAR operator may not return rows with several terms
9203 2464264 Dump / wrong results from Japanese Lexer with doublebyte punctuation
9203 2474192 OERI:[OPIBND1] on CREATE of TEXT INDEX with CURSOR_SHARING
9203 2489881 DRG-50603 indexing WORD in two LANGUAGES with MULTI_STOPLIST and PREFIX_INDEX
9203 2514079 Import of ALTERED CTXRULE index can fail with DRG-11000
9203 2537672 UPDATE on XMLtype column which has an XPATH index may dump
9203 2569357 Korean lexer does not remove QUOTES around tokens with WILDCARDS (%)
9203 2601175 Wrong results for German sharp-s with BASE_LETTER and ALTERNATE_SPELLING
9203 2601447 CTX_DOC.GIST() fails with DRG-10001
9203 2605166 OERI:koksctri1 during create TEXT index on EXTRACT() expression
9203 2610068 '_' character treated as a WILDCARD for CTXCAT indextype
9203 2617683 Query optimization may use more CPU than needed with fuzzy operators
9203 2629794 Parallel SYNC of TEXT index may be slow
9203 2636886 DRG-50603 from CTX_DLL.SYNC_INDEX with MULTI_STOPLIST index
9203 2663986 Missing rows querying CTXRULE index in sections (such as: 'CAT WITHIN MAMMAL')
9203 2676316 Poor performance / ORA-14098 after EXCHANGE PARTITION with TEXT index
9203 2684307 Mixed tokens not uppercased with BASE_LETTER in multibyte database
9203 2706319 CJK Lexers do not support AL32UTF8 surrogate pairs or private use characters
9203 2765871 Not all THEMES identified for documents with large paragraphs
9204 1934372 SOUNDEX / FUZZY text queries give wrong results on EBCDIC platforms
9204 2208113 Dump / memory corruption possible using USER FILTER for 10K document
9204 2269451 Dump possible Text indexing XML with attributes over 1019 characters long
9204 2451999 ORA-2332 creating TEXT index on XDBURITYPE / URITYPE / HTTPURITYPE column
9204 2453072 CTX_DOC.MARKUP may not perform THEME highlighting correctly
9204 2630331 Wrong results with BASELETTER and ALTERNATE SPELLING used together
9204 2679092 Text treats "combining diacritics" as break characters
9204 2689051 ORA-7445 [gxqnUnknownTokens] using CONTAINS and ABOUT together
9204 2707731 Memory leak (in EXTPROC) from CTX_DOC.IFILTER
9204 2726276 Wrong SCORE() for plans with Text index below a HASH JOIN
9204 2737882 CATSEARCH template query with NEAR and PHRASE dumps
9204 2749250 Dump possible using "WHERE CONTAINS ?SYN" on a term greater than 28 bytes long
9204 2749354 THEME HIGHLIGHT gets wrong offset for some documents
9204 2762817 OERI:[17092] [10388] possible when interrupting (Ctrl-C) a Parallel Query
9204 2775021 DRG-10528 occurs text indexing a table with a RAW primary key
9204 2804951 Exchange PARTITION on table with XMLType and TEXT index dumps
9204 2806236 Inefficient plan possible with TEXT query against PARTITIONED table
9204 2808055 ORA-7445 [zfmamatch] possible using Text SOUNDEX operator (!)
9204 2815379 ORA-7445 [LXYVALID] can occur creating TEXT index on a UTF8 document
9204 2818459 Text "FUZZY" query gets wrong results when using PREFIX INDEXING
9204 2852652 ORA-7445[dredrseek] with many ACCUM functions in text query
9204 2916024 PGA memory leak possible using OUTER JOIN with CONTAINS

Oracle Text INSO Filters Bugs

The following table lists the Oracle Text INSO Filters Bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1607797 DRG-11101 possible indexing DEPRECATED HTML features
9202 1910911 URLs greater than 64 bytes long are TRUNCATED in Word Perfect documents
9202 2169804 Indexing EXCEL spreadsheets which contain macros may fail with DRG-11207
9202 2235422 Indexing RTF with unknown control words fails with DRG-11207
9202 2266334 Filtering of MS-WORD documents fail if text in a table
9202 2279550 PDF documents containing special German characters are incorrectly filtered
9202 No Bug Number INSO filter update
9203 2661541 INSO_FILTER for BEQUEATH connections may fail with dynamic linker errors on UNIX
9204 2599336 CTXHX may hang/spin if a segmentation fault occurs

Oracle Type Translator Bugs

The following table lists the Oracle Type Translator bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2357255 Oracle Type Translator fails with ClassNotFoundException:oracle.jdbc.driver.OracleDriver
9204 2366879 Oracle Type Translator generates wrong code with GENERATE .. AS and REF syntax
9204 2381709 Baseclass name is generated in readSQL() when GENERATE AS is used

Parallel Query Bugs

The following table lists the parallel query bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 925366 Query with NESTED TABLE does not run parallel
9202 1231199 Wrong results possible from parallel queries where NLS_SORT is not BINARY
9202 1951553 Wrong results from PQ with ORDER BY NLSSORT
9202 2091962 PQ against composite partitioned table with INLIST on subpartition key may error (OERI:QERPXMOBJVI5)
9202 2185245 OERI:qkaPIdsmrg2 possible during PQ partition-wise join
9202 2234068 PDML may not achieve expected degree of parallelism
9202 2262196 Intermittent wrong results from PARALLEL partition wise join
9202 2268284 ORA-12842 possible during PQ if concurrent DDL occurs
9202 2273245 Internod PQ may fail with OERI:[KXFRSLVSETINFO1]
9202 2310541 OERI:711 .. [kdiulk - prefix context] possible during parallel rollback
9202 2314151 ORA-7445[kdudcp] from PARALLEL UPDATE / DELETE on JOIN VIEW
9202 2326268 PQ slaves may dump
9202 2327249 V$SYSSTAT may show huge incorrect values when using Parallel Query
9202 2333731 ORA-8103 possible in PQ slave
9202 2336289 OERI:[15713] possible setting up a PQ - rare timing condition
9202 2336572 ORA-1416 from PQ on views with constant expression in select list
9202 2347749 OERI:[KCFRBD_1] possible on PQ scan of a cluster
9202 2362461 OERI:[15709] possible due to PQ slave cleanup race condition
9202 2373278 CREATE INDEX in PARALLEL can fail with ORA-30562 in some locales
9202 2374649 DBMS_APPLICATION_INFO CLIENT_INFO not shown for PQ slaves
9202 2375998 PQ slaves may produce needless tracefiles
9202 2376821 Parallelization may not occur if PARALLEL index used on right of NL join
9202 2435787 PDML may hang for tables with referential integrity constraints
9202 2459355 OERI:XTYCSR3 from PQ Select with GROUP BY and PL/SQL function on an aggregate
9203 2175150 ORA-7445 [kcbldrcls] and ORA-10387 possible with parallel query
9203 2333947 Wrong results possible from PQ on PARTITIONED table
9203 2442125 Wrong results from PQ which compares a CHAR column to a BIND variable
9203 2498399 OERI:[KXFPRDP:1] / ORA-10388 if node is shutdown as PQ starts
9203 2524784 PQ on RAC may crash the instance with OERI[KSLPSPR1]
9203 2533038 PARALLEL_ADAPTIVE_MULTI_USER load calculation sensitive to IDLE sessions
9203 2569154 Wrong results from PQ with NL of BITMAP INDEX with ROWID predicate
9203 2618958 File descriptor/handle leak from IPQ slaves over IPC
9203 2618998 Dump from PDML with MONITORING on single partition
9203 2664654 Unnecessary partition access during PQ with NL join to partitioned table
9204 2186174 Excessive REDO generation from parallel rollback
9204 2329274 ORA-12839 / spurious errors from heavily concurrent DDL with partitioning or PQO
9204 2336663 Slow Parallel execution - Nested Loops with partitioned right table
9204 2516513 ORA-60 from concurrent PDML on same table
9204 2634407 Excessive 'IPC SEND COMPLETION SYNC' waits in IPQ
9204 2647811 ORA-14401 possible from OR expansion with PDML
9204 2685869 Wrong results using PQO with OLS/VPD which uses application context
9204 2686584 PGA memory leak in PQ Query coordinator
9204 2687315 Parallel range scan of DESC index may dump (under QERPXSTART/QERPX_START/EVAOPN2)
9204 2738120 "SHUTDOWN IMMEDIATE" may hang due to PQ activity
9204 2753856 Wrong results possible from PQ partition query with GROUP BY
9204 2754474 PQ may not be able to start new PQ slaves
9204 2762817 OERI:[17092] [10388] possible when interrupting (Ctrl-C) a Parallel Query
9204 2808431 Wrong results from PQ with OUTER JOIN
9204 2901331 ORA-1785 from PQ ORDER BY <CONSTANT> which is not in select list
9204 2934427 ORA-12805 on long running PQ when IDLE TIME set

Partitioned Tables Bugs

The following table lists the partitioned tables bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2073948 ORA-6550 possible referencing remote partitioned table after DDL performed on it
9202 2091962 PQ against composite partitioned table with INLIST on subpartition key may error (OERI:QERPXMOBJVI5)
9202 2134836 OIERI:QKABRIX1 possible with BITMAP and PARTITIONED index on NON-PARTITIONED table
9202 2143167 Compile time PARTITION PRUNING does not occur with RR or RRRR in NLS_DATE_FORMAT
9202 2157502 OERI:4819 possible when partition maintenance is running against an IOT
9202 2157655 GATHER_SCHEMA_STATS with GATHER STALE/GATHER EMPTY can fail to collect statistics
9202 2185245 OERI:qkaPIdsmrg2 possible during PQ partition-wise join
9202 2206438 High memory usage from DBMS_STATS.GATHER_TABLE_STATS on partitioned table
9202 2207959 Dump from COALESCE of PARTITIONED table with LOB
9202 2208882 SPIN for SQL against a VIEW which references an ALTERED LIST PARTITION table
9202 2234068 PDML may not achieve expected degree of parallelism
9202 2234325 ALTER partitioned table with global FUNCTIONAL index and LOBS dumps in kkfiSetMemRep
9202 2242753 OERI[SRSALE_2] possible from GROUP BY SORT on PARTITION row source
9202 2259470 Partition pruning does not occur if predicate contains an operator
9202 2262196 Intermittent wrong results from PARALLEL partition wise join
9202 2263517 DROP / EXCHANGE partition does not re-aggregate index statistics
9202 2288481 SQL on partitioned table when object is invalidated (such as ANALYZEd) can dump or OERI:15212
9202 2306067 ADD/COALESCE/MERGE/SPLIT PARTITION sets table statistics to NULL
9202 2329325 CBO may choose FTS over index FFS for partitioned table
9202 2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
9202 2363209 Wrong results possible from IS NULL on list partitioned table with DEFAULT partition
9202 2398190 OERI:[QKAGBY4] from INLIST and PARTITION ITERATOR over a GROUP BY
9202 2405013 ORA-8102 on ALTER TABLE MOVE PARTITION COMPRESS UPDATE GLOBAL INDEXES
9202 2407020 ALTER INDEX REBUILD PARTITION may OERI[6074]
9202 2411876 BULK BIND deletes cause incorrect delete counts in USER_TAB_MODIFICATIONS
9202 2413264 Negative cost / bad plan for queries on partitioned table
9202 2418668 GATHER_SCHEMA_STATS() may fail in 9.2 for partitioned tables
9202 2515703 Dictionary corruption from concurrent partitioned IOT maintenance
9203 2333947 Wrong results possible from PQ on PARTITIONED table
9203 2339666 Parallel MERGE into composite partitioned table not performant
9203 2467216 MERGE/SPLIT partition with LOCAL DOMAIN indexes and UPDATE GLOBAL INDEXES dumps
9203 2473601 OERI:[qkaPIdsqkn1] possible from index-join on partitioned tables
9203 2526164 SDO has poor query performance with large partitioned tables
9203 2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
9203 2552982 PRUNING does not occur on CONCAT KEY PARTITION with INLIST and range on keys
9203 2592966 OERI:[qkaPIdsqkn1] from AND EQUAL against partitioned table
9203 2606090 ORA-7445[LNXN2COPT] is pruning predicate contains subquery
9203 2617877 ORA-7445 [kkehbs] possible querying partitioned table
9203 2618998 Dump from PDML with MONITORING on single partition
9203 2625279 OERI[6763] during ANALYZE TABLE .. ESTIMATE STATISTICS with concurrent DROP
9203 2626347 OERI:17059 accessing view after ADD / SPLIT PARTITION
9203 2636685 Halt/ OERI:[17059] after adding a list value to a partition
9203 2664654 Unnecessary partition access during PQ with NL join to partitioned table
9203 2707304 OERI:17059 / OERI:kqlupd2 / PLS-907 after adding partitions to Partitioned IOT
9203 2729673 Wrong result from COMPOSITE PARTITIONING, INLIST and GLOBAL INDEX
9204 1266208 DML locking does not allow full partition independence - Unexpected ORA-54
9204 2329274 ORA-12839 / spurious errors from heavily concurrent DDL with partitioning or PQO
9204 2520911 OERI[QKAPIDSQKN1] from partition wise join with NL join
9204 2594803 EXCHANGE PARTITION with Unique constraints can be slow
9204 2597075 ORA-372 on direct load into PARTITION with an empty READ ONLY partition
9204 2660095 ORA-7445[kkpamDInfo] possible from query on partitioned table
9204 2669199 OERI:711 from SQL on PARTITIONED table with SUBQUERY pruning
9204 2671151 ORA-7455 [EVAOPN2] querying PARTITIONED table with functional index
9204 2683654 DROP TABLE for heavily PARTITIONED TABLE does not scale
9204 2707489 Partition pruning may not occur for HASH partitions
9204 2711197 DBMS_METADATA returns wrong DDL for INDEX on LIST PARTITIONED table
9204 2714596 DBMS_STATS may fail with ORA-6533 on ANALYZE of partitioned table
9204 2739444 ORA-7445 [qximirew] from SPATIAL query on PARTITIONED table
9204 2742639 DBMS_STATS can produce Wrong statistics for LOCAL index with COMPOSITE partitioning
9204 2753856 Wrong results possible from PQ partition query with GROUP BY
9204 2763473 Dump (in kcopre / kdddcp) on UPDATE of row in PARTITIONED table with ROW MOVEMENT
9204 2785102 Query involving many partitions (greater than 1000) has high CPU/memory use
9204 2787622 OERI[6034] on ALTER INDEX REBUILD SUBPARTITION
9204 2799097 DEADLOCK possible on concurrent EXCHANGE PARTITION (DC_TABLESPACE_QUOTAS)
9204 2804951 Exchange PARTITION on table with XMLType and TEXT index dumps
9204 2835542 REBUILD INDEX PARTITION ONLINE sometimes dumps in KDICRWS
9204 2843749 OERI[12455][PTI QKAQKN] during SELECT FOR UPDATE on PARTITIONED table
9204 2878338 INSERT into HASH PARTITION may fail with false ORA-2291
9204 2879257 OERI[16609] selecting from PARTITIONED table with CONSTRAINTS
9204 3051846 Local RTREE indexes on PARTITIONED table are invalid after SDO_GEOM update

Performance Bugs

The following describes the system halt bugs addressed in this patch set:

General Performance Bugs

The following table lists the general performance bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1767169 Working sets not assigned to best DBW on NUMA
9202 2237682 FAILOVER: Non SELECT SQL is reparsed on each execute after failover
9202 2307224 "ALTER INDEX .. REBUILD ONLINE" is slow
9202 2364823 Index range scan can be slower than Oracle9i 9.0 or earlier
9202 2384165 ENH: Small performance improvement for Oracle 8.0, Oracle8i, or Oracle9i Pro clients
9203 1721097 Inline query in SELECT list not in EXPLAIN PLAN
9203 1743159 A number of WAITs can occur under "null event"
9203 2414971 UTLXPLS.SQL may report incorrect OPTIMIZER USED and may raise ORA-6502
9203 2429929 V$SESSION_EVENT.SID has the wrong SID (out by 1)
9203 2602332 "buffer busy wait" waiter may sometimes not get posted
9203 2649563 ALL_TYPE_ATTRS view is SLOW for SQL with predicates on OWNER /TYPE_NAME
9203 2710321 X$KCCFN / V$DATAFILE much slower in Oracle9i than Oracle8i with many datafiles
9204 2186174 Excessive REDO generation from parallel rollback
9204 2379350 Unnecessary delays waiting on 'log file sync' (wait for timeout)
9204 2698133 TKPROF can spin with some trace files
9204 2726042 STATSPACK report omits segments created after the BEGIN snapshot

Query Performance Bugs

The following table lists the query performance bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2109825 Incorrect cardinality estimate with OR predicate and NULL values
9202 2273591 FIRST_ROWS_N can produce a much slower plan than expected
9202 2283254 Redundant filter predicates from FIRST_ROWS and concatenated index
9202 2287990 Bad plan possible from unnesting of multiple complex views
9202 2297645 Bad plan possible using CONTAINS() clause if DB_BLOCK_SIZE larger than 2KB
9202 2307892 Poor plan possible with long inlist on multiple columns
9202 2324795 Join predicates not pushed into UNION ALL view with index access to CLUSTER
9202 2329325 CBO may choose FTS over index FFS for partitioned table
9202 2352376 Enhancement: Improve heuristic for subquery unnesting for partially matches indexed correlation predicates
9202 2384552 NO_PUSH_SUBQ hint may be ignored
9202 2397501 Dump / bad plan sometimes from HISTOGRAM statistics on JOIN columns
9202 2413264 Negative cost / bad plan for queries on partitioned table
9202 2424183 Wrong INDEX SELECTIVITY for multi-column IN-LIST predicate
9202 2449515 Worse plan in 9.2 with unnested subquery & concatenated index
9202 2458455 Add ability to perform DISTINCT pushdown
9203 2474630 optimizer_dynamic_sampling greater than 1 forces CBO
9203 2487808 Poor join cardinality if both columns have histograms
9203 2534430 Poor plan possible from OR-expansion
9203 2542139 Long parse times possible if _B_TREE_BITMAP_PLANS=TRUE
9203 2660592 CBO may needlessly evaluate bitmap plans for Domain indexes
9204 2336663 Slow Parallel execution - Nested Loops with partitioned right table
9204 2496699 Poor performance selecting from OBJECT TABLE with REFS
9204 2670946 Performance of queries using DBA_SEGMENTS may be poor
9204 2671550 JMS getQueue() and getTopic() are slow with many queues in the DB
9204 2691172 Incorrect cost computations for MERGE statements
9204 2721432 UTL_HTTP has poor performance in Oracle9i
9204 2735033 OLS READ_CONTROL degrades SNAPSHOT REFRESH performance
9204 2740281 Transitive predicate not generated for RPAD()
9204 2747605 Poor "Enqueue" performance of non-persistent queue
9204 2754410 Multi-row insert SLOW with multiple FK constraints
9204 2786506 DBA_LOGSTDBY_PROGRESS view is slow
9204 2787239 Suboptimal plan possible from TABLE / VIEW join with nullable table column
9204 2790432 Bad plan as INDEX SKIP SCAN cost LOWER than INDEX RANGE SCAN
9204 2860984 Bad plan possible with collection iterator (table/Cast)
9204 2871645 Complex view merging does not occur for recursive SQL less than depth 1
9204 2910437 Inefficient plans on rewrite of SQL with GROUPING SETS and CASE expressions
9204 2923299 CBO may reject index access for remote non-Oracle table

Performance Monitoring Bugs

The following table lists the performance monitoring bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2803772 V$SESSION_WAIT.SECONDS_IN_WAIT resets each time SEQ# is incremented
9204 2843192 Change to "NULL EVENT" in V$SESSION_WAIT
9204 2988097 "buffer busy waits" segment statistics overestimates buffer busy waits

Physical Standby Database/Data Guard Bugs

The following table lists the physical standby database/Data Guard bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2108072 OERI:1433 if LGWR archival is ASYNC and network congested
9202 2330521 Mandatory standby destination failure not noticed
9202 2339282 MRP process cannot be restarted if it dies
9202 2503934 LGWR NETWORK RE-CONNECT stalls primary up to 2 minutes
9202 2504422 LGWR should not block on ASYNC cache buffer full
9202 2508640 LGWR/NOAFFIRM reverts to synchronous I/O for STANDBY REDO LOG files
9202 2508833 ORA-350 trying to DROP STANDBY REDO logfile
9203 2539160 ORA-16139 on "switchover to primary"
9203 2542609 Corruption from CANCEL of managed standby if primary is RAC
9203 2605652 STANDBY database may get ORA-338
9203 2632802 LGWR ASYNC or SYNC=PARALLEL archival may cause ORA-332 on STANDBY
9203 2643872 OERI:[KCRRNSFWA.2] possible
9203 2644178 Physical standby may fail with ORA-354 if primary archival fails
9203 2646214 In ASYNC mode LGWR may send a large number of messages
9203 2654862 Open of standby in READ ONLY mode may fail after upgrade (ORA-16000)
9203 2683226 LGWR ASYNC transport over WAN degrades throughput
9203 2722482 Better ALERT log message for LGWR ASYNC buffer full condition
9203 2736013 LGWR network IO optimization
9203 2740929 New STANDBY recovery may fail with ORA-16016
9203 2761238 Primary may crash if log cannot be transported to standby
9204 2217374 ORA-16132 on 'FORCE FAILOVER' after failed 'GRACEFUL FAILOVER'
9204 2452711 Graceful failover fails with ORA-16139
9204 2761238 Primary may crash if log cannot be transported to standby
9204 2763115 MRP0 may get ORA-365 after graceful switch over with secondary standby
9204 2783981 LGWR may CRASH if an exception occurs when killing the network server
9204 2786506 DBA_LOGSTDBY_PROGRESS view is slow
9204 2788481 ORA-1537 in STANDBY with STANDBY_FILE_MANAGEMENT=AUTO
9204 2825249 Rapid stop/start of Data Guard broker may not perform the start
9204 2842368 MRP may fail with ORA-365 on secondary standby after graceful switch over
9204 2843570 OERI:2103 possible on PRIMARY if secondary errors
9204 2899221 ORA-338 - standby redo log corruption

Platform-specific Bugs

The following table lists the platform-specific bugs addressed in this patch set:

Fixed in Release Bug Number Description
9203 2453925 AVMPING dumps core (SPARC64 bit 9.2 release)
9203 2490128 Process class missing from OS cart
9203 2746047 Siemens bug - DLMD’s DD_TS enqueue not cleaned during RCFG
9203 2749790 SIGBUS in XSCBIXLINBYTE2SEG during dynamic aggregate
9204 2882059 OLAP API library built incorrectly
9204 2917199 FTP operation with SB XMLTYPE stored as CLOB results in corrupt data

PL/SQL Bugs

This section describes the PL/SQL bugs addressed in this patch set. It includes the following categories:

General PL/SQL Bugs

The following table lists the general PL/SQL bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1740494 PLS-801 [22914] with TABLE() expression
9202 1870770 PLS-707 [2603] / Dump from BULK Bind with index variable
9202 1918751 ORA-6502 possible from UNION and CONCAT (||) with constant strings
9202 1941831 EXECUTE IMMEDIATE of CALL type constructor dumps in kkxmstcs
9202 2037285 Dump referencing TYPENAME.ATTRIBUTENAME in SQL in PL/SQL
9202 2073948 9ORA-6550 possible referencing remote partitioned table after DDL performed on it
9202 2119513 ARRAY BINDS to PL/SQL anonymous blocks treated wrongly in Oracle9i
9202 2166890 Hang / ORA-4021 possible using PL/SQL clients
9202 2171144 PLS-491 / PLS-217 compiling STANDARD with PL/SQL_V2_COMPATIBILITY=TRUE
9202 2187428 ORA-06544 [84203] possible from client 8.0 PL/SQL to Oracle9i Server
9202 2193313 PL/SQL CreateAbstractClob() dumps if LOB not freed
9202 2197703 Update of LONG with PL/SQL BULK BIND can update incorrectly
9202 2200057 OERI:[KKXMAGTC1] possible for OUT / IN OUT bind to PL/SQL
9202 2222308 Dump in qcsfoep() on CREATE TYPE BODY which references unqualified PL/SQL function
9202 2229315 BULK BIND on nested table with OBJECTS may dump / OERI
9202 2236731 BULK ROW COUNT returned from ARRAY insert may be wrong if constraint violated
9202 2240307 ORA-1007 not thrown when REF CURSOR column count != number of INTO items
9202 2259466 PL/SQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 / OERI:KOPE2_READSTR232
9202 2262758 ORA-7445 [pfripDr_purge_DL01_refs] possible from PL/SQL
9202 2266130 8.0 PL/SQL client may report a false ORA-04062
9202 2269035 Dump possible using BULK COLLECT with DATE types
9202 2281071 ORA-4030 / memory leak calling RPC in PL/SQL cursor loop
9202 2283252 OERI:[17285] from ORA errors on push/pop of autonomous transaction
9202 2286387 SQL%FOUND/NOTFOUND etc.. altered by COMMIT / ROLLBACK
9202 2290374 Dump using REF cursor with BULK COLLECT
9202 2309738 PL/SQL SELECT over DB link throws unexpected error instead of ORA-1403 / no_data_found
9202 2313914 OERI:KGHALF1 / hang calling RPC in debugger / plsded
9202 2340656 Private memory corruption possible from RAISE_APPLICATION_ERROR for long error messages
9202 2346368 ORA-6502 in multibyte using NLS_LENGTH_SEMANTICS=CHAR
9202 2351498 PL/SQL which references a function with insufficient privileges may not error on compilation
9202 2383449 ORA-7445 [pfrbnd] possible from ORDER BY LEVEL in PL/SQL
9202 2388768 Loading a WRAP file through OCI/JDBC fails (PLS-103)
9202 2391217 PLS-430 from PL/SQL Bulk Bind using an index
9202 2392166 Calling SERIALLY_REUSABLE PL/SQL from SQL can cause PMON to crash
9202 2407732 ORA-28576 from DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT
9202 2411876 BULK BIND deletes cause incorrect delete counts in USER_TAB_MODIFICATIONS
9202 2417912 Dump [pbedeupdate] from DBMS_DEBUG.DEBUG_ON called from NCOMPed code
9202 2422726 OERI[16201] possible when RECOMPILING a WRAPPED PACKAGE
9202 2437995 Cannot reset PL/SQL native mode related parameters - OERI:15419
9202 2471679 PL/SQL length validation differs from SQL for CHAR SEMANTICS
9203 1130195 OCIBindByPos "curelep" parameter wrong if PL/SQL deletes elements of C array
9203 1829296 False ORA-980 from PL/SQL referencing SYNONYM which uses a DBLINK
9203 1850169 ORA-1405 occurs if OCIBindDynamic() used for NULL PL/SQL OUT bind
9203 2093521 Memory leak using SAVE EXCEPTIONS with FORALL BULK operations
9203 2243411 PLS-597 from "FETCH..BULK COLLECT INTO"
9203 2399954 OERI:733 / OERI[KGHALF1] possible from PL/SQL execution using many cursors
9203 2425312 ENH: Include PL/SQL RPC information in 10046 trace
9203 2489526 PLS-801 [21076] / package corruption (in memory) recompiling PL/SQL
9203 2503614 PL/SQL calling JSP with TIMESTAMP argument dumps
9203 2519148 Memory leak from PL/SQL RPC to an older database version in a LOOP
9203 2556195 OERI:[SORPUT_1] / Wrong results using PIPELINED function in SQL
9203 2601203 ORA-3106 from INSERT .. RETURNING a NULL into a TIMESTAMP column
9203 2614464 ORA-979 from PL/SQL query with TABLE() function and PL/SQL bind in the GROUP BY clause
9203 2616833 Non blocking OCI may not show error text for user PL/SQL errors (ORA-20000-ORA-20099)
9203 2627946 Error text of RAISE_APPLICATION_ERROR may be lost
9203 2647211 Implicit cursor FOR loop memory leak / CPU hit
9203 2685935 Deletion of associative array element by KEY value does not work
9203 2694605 ORA-3118 possible when PL/SQL executed over a DBLINK
9203 2702333 Memory leak using PL/SQL associative array
9204 1615764 ORA-22922 accessing TEMP LOB in a REF CURSOR returned from PL/SQL
9204 2186092 No data from TABLE (PL/SQL function) if function returns large collection
9204 2280512 OERI:KOKVXSQL1 OERI:4814 on CREATE OR REPLACE of package with PIPELINED function
9204 2386460 ORA-7445 calling SYS.STANDARD functions directly from SQL
9204 2442346 ORA-2019 from REF cursor in invokers rights procedure
9204 2475002 OERI:kxwphTTGet1 deleting from transactional TEMP table from PL/SQL AUTONOMOUS transaction
9204 2518508 ORA-6502 / ORA-1460 calling PLQSL function directly from SQL
9204 2526424 PLS-215 from Oracle9i to Oracle8i PL/SQL reference to view with zero length character column/s
9204 2588348 Particular multibyte sequences can spin in PL/SQL compilation
9204 2598547 PL/SQL may hang/spin if there are a huge number of IF THEN .. ENDIF statements
9204 2614728 OERI[KOLSLNK509] possible with very large PL/SQL VARRAY index
9204 2651760 PL/SQL LENGTH/LENGTH2/LENGTH4/LENGTHC sometimes count BYTES not CHARACTERS
9204 2662683 Heap corruption from schema name overwriting memory in PL/SQL
9204 2678726 PLS-399 possible from SUM / AVG / STDDEV / VARIANCE
9204 2721462 ORA-7445 [KOPXCCC] from PL/SQL RPC over DB LINK
9204 2746688 ORA-4020 possible from DDL or TRUNCATE in PL/SQL
9204 2747582 TEMPORARY LOB LEAK on PL/SQL <collection>.DELETE or assignment
9204 2767356 PLS-382 from client PL/SQL referencing TIMESTAMP in higher DB version
9204 2767486 ORA-600[PMUOCON2#1: INVALID CDS] when returning NULL ADT/collection through a JAVA callout
9204 2769514 Memory leak calling a TABLE() function / pipeline function in a loop
9204 2783153 %ROWTYPE including UROWID column may dump / ORA-6544 [PFRRUN.C:BREAK]
9204 2783899 PIPE ROW inside CURSOR FOR LOOP gives PLS-707 (in old SQL FE only)
9204 2792142 ORA-6502 possible from PL/SQL with RAW/LONG/CHAR binds
9204 2805382 Dump (kodpsloc) passing OBJECT with LOB to PL/SQL
9204 2875058 Repeat calls to JSP from PL/SQL can leak PGA memory
9204 2883743 Pipelined functions leak memory for parameters with default values
9204 2892870 SQL using PL/SQL functions may dump
9204 2972701 Memory growth executing SQL/XML repeatedly in PL/SQL
9204 2980596 PL/SQL FOR LOOP performance hit & memory leak using implicit cursors

PL/SQL DBMS Package Bugs

The following table lists the PL/SQL DBMS Package Bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2184648 DBMS_OUTPUT does not output NCLOB data properly
9202 2263160 ORA-25191 using DBMS_STATS.ALTER_SCHEMA_TAB_MONITORING with an IOT
9202 2276418 UTL_HTTP.REQUEST does not use HTTP_PROXY environment variable nor SET_PROXY API
9202 2288868 DBMS_TRACE may dump in [PBT_SET_LOC]
9202 2358432 DBMS_SPACE_ADMIN.SEGMENT_DUMP() signals ORA-03211 for SMU Undo Segments
9202 2445330 ORA-1403 from DBMS_PICKLER.GET_TYPE_SHAPE for a type whose TDS length greater than 32000 bytes
9202 2507641 ORA-7445 [PEVM_CVTIN] after DBMS_SESSION.MODIFY_PACKAGE_STATE
9203 2410688 DBMS_SQL.PARSE of VARCHAR2S needs higher line width limit
9203 2444186 OERI[PSDISA:SESNUM] passing an invalid ID to DBMS_SESSION.IS_SESSION_ALIVE
9203 2566659 ORA-1555 running DBMS_PCLXUTIL.BUILD_PART_INDEX
9203 2603036 ORA-6533 gathering stats for partitioned table with DBMS_STATS
9203 2616047 DBMS_METADATA does not show full query of Materialized view if TEXT greater than 4000
9203 2629376 9DBMS_STATS has inaccurate estimation of NDV for small sample sizes
9203 2652654 DBMS_STATS can produce poor NDV column statistics
9204 2403965 ORA-1760 from DBMS_STATS gather stats against function based index on IOT
9204 2711197 DBMS_METADATA returns wrong DDL for INDEX on LIST PARTITIONED table
9204 2714596 DBMS_STATS may fail with ORA-6533 on ANALYZE of partitioned table
9204 2721432 UTL_HTTP has poor performance in Oracle9i
9204 2726042 STATSPACK report omits segments created after the BEGIN snapshot
9204 2734966 DBMS_METADATA does not extract metadata for DOMAIN INDEXES
9204 2782919 ORA-904 from DBMS_STATS to estimate statistics for a table with a functional index
9204 2813521 DBMS_OBFUSCATION_TOOLKIT.DES3GETKEY can product identical keys
9204 2818850 DBMS_METADATA.GET_XML does not include NOT NULL for primary key columns
9204 2869489 DBMS_STATS.GATHER_TABLE_STATS does not free TEMP extents
9204 2919423 DBMS_STATS can be slower in 9.2 than in Oracle8i

PL/SQL External Procedure (EXTPROC) Bugs

The following table lists the PL/SQL External Procedure (EXTPROC) Bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2222508 EXTPROC may dump freeing objects (in horccoX_ExecCalloutCallbackOut)
9202 2371235 Memory leak passing LOB parameters to PL/SQL callouts in a loop
9204 2707731 Memory leak (in EXTPROC) from CTX_DOC.IFILTER
9204 2716764 Extproc overflow vulnerability

Pro* Precompiler Bugs

The following table lists the Pro* Precompiler bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2255182 PROCOB generates bad code for EXEC SQL INCLUDE followed by ELSE
9202 2291043 Client dump in lmsaicmt() creating many program contexts using OCIEnvInit() in non-US NLS env
9202 2296498 ProC may dump if PASSWORD supplied interactively
9202 2296922 Large SQL may fail with ORA-972
9202 2300956 Pro client may dump if SQL uses CURSOR VARIABLES
9202 2316666 Cobol: SQLRowidGet may dump
9202 2321534 PROCOB generates bad code on 64 bit platforms for SQL-CONTEXT typed variables
9202 2322384 EXEC SQL OBJECT GET leaks memory
9202 2369763 ProC CODE=ANSI_C precompile error for "va_list"
9202 2384165 ENH: Small performance improvement for Oracle 8.0/Oracle8i/Oracle9i Pro clients
9202 2391185 ORA-1 returned from ROLLBACK if session has been killed (should get ORA-1012)
9202 2403646 Pro statement reparsed each time after an error
9202 2423571 Invalid Oracle numbers possible if Pro*COBOL uses COMP variables containing invalid COMP data
9202 2445917 User signal handler not called if SA_SIGINFO set
9202 2446447 MAKEFILE does not include THREADS=YES for CPDEMO1 and CPDEMO2
9202 2460104 ORA-24391 in precompiled code in 9.2
9202 2463295 Cache client access to error message files reduce file access
9202 2468606 Cobol: COMP-3 packed decimal can return incorrect number data
9203 1326752 Pro*COBOL PCB-S-400, PCB-I-556 errors for "PROCEDURE DIVISION USING COPY XYZ"
9203 1810960 Pro*COBOL signals PLS-103 errors for PL/SQL GOTO labels in code
9203 2513269 PCC-S-2014 if a SPACE appears after "\" in #elif
9203 2573812 Pro*COBOL generates bad code for CURSOR VARIABLES when COMP1=INTEGER
9203 2668683 Array binds to PL/SQL blocks may ORA-1458 or no data is fetched
9203 2672965 Pro client dump (sqlrdf) if cursor used for both dynamic method 3 and 4
9203 2688717 Pro client may get NULL rows with PREFETCH enabled
9203 2717317 Client memory leak from EXEC SQL CONTEXT ALLOCATE / FREE
9203 2765286 ORA-1458 from Pro ARRAY insert (9.2.0.2 only)
9203 2796974 MODADA clients may dump
9204 2661854 Symbol "interval" cannot be used in Pro/OCI code as it is defined in ocitrace
9204 2688989 Client memory leak calling SQLALD with size=0
9204 2810557 PRO client can leak memory when NLS_LOCAL=YES
9204 2914264 SQL-2116 from 64bit Pro*COBOL application
9204 2938434 Tru64: Cannot build CPDEMO1 CPDEMO2

Process Dumps Bugs

The following table lists the process dumps bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2219776 Dump possible during queries against X$KGLOB
9202 2222688 ORA-7445 [memcpy] from kpobvr() with bind greater than 2000 then bind = 0
9202 2236259 ORA-7445 [LXHCSN] possible during STARTUP
9202 2242955 Dump possible from INDEX JOIN access path against CLUSTER
9202 2251136 ORA-7445[KGLSUPD] from concurrent DROP/TRUNCATE and ANALYZE
9202 2253106 ORA-7445 [KSLGPRL] possible repeatedly selecting from V$LATCHHOLDER
9202 2311529 SHUTDOWN may dump with ORA-7445 [lxhcsn]
9202 2331804 OERI:SORSIK_2 possible from SEMI-JOIN and OR-Expansion
9202 2358756 Dump possible with TIMED_STATISTICS=TRUE
9202 2366678 Passing parameters to CALLOUTS may dump or report ORA-600 errors
9202 2386334 ORA-7445[QERUAROWPROCEDURE] possible from SELECT from UNION ALL view
9202 2421874 Dumps possible in opiodr() using resource limits or killing sessions
9202 2453215 ORA-7445[vopsvc] selecting ROWID from a complex join view
9202 2459191 ORA-7445 [EVADCD] from constant DECODE predicate
9202 2460603 OERI:[QERNSROWP] from DISTINCT, ORDER BY and GROUP BY
9203 2058579 CTAS referencing PL/SQL function may dump if shared pool flushes
9203 2272485 ORA-7445 / ORA-607 creating a clustered table using CTAS
9203 2311637 ORA-7445 IN QKKSKIPORDOPT() WITH RULE HINT
9203 2517736 Update of LONG with BIND may dump if cursor invalidated
9203 2526540 SIGFPE possible during optimization
9203 2560364 ORA-7445 [pegisc] from BITAND with BINARY_INTEGER arguments
9203 2563936 ORA-7445 [qcdottnc] from SELECT XXX() where "XXX" is not a type/function
9203 2640623 ORA-7445[ksupgpcl] possible in PMON during SHUTDOWN
9203 2663395 Stack corruption if write back of mirror broken block fails
9204 2649238 Resource manager may dump (in kmmpis)
9204 2713652 Dump (under kghrsc) possible from SELECT from V$SHARED_POOL_RESERVED
9204 2791172 Select from V$SQL_PLAN may dump (in msqopnws)
9204 2930301 SQL may dump in ktadmct

Query Rewrite Bugs

The following table lists the query rewrite bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1788639 OERI:4882 from CREATE MATERIALIZED VIEW on OBJECT table
9202 2113937 QUERY REWRITE may report ORA-00942 when not run as MV owner
9202 2150741 ORA-937 on rewrite for MV with aggregate expressions and no GROUP BY
9202 2176103 OERI:[KKQSRRE-1] on query rewrite with FIRST / LAST & aggregate
9202 2179567 Updatable snapshots do not work after Oracle 8.0 export to Oracle8i or Oracle9i import
9202 2259259 MLOG$ entries may not be purged for Oracle9i master to Oracle8i snapshot site
9202 2280027 OERI:504 possible from using SNAPSHOTs against Oracle8i
9202 2305302 MVIEW on single table with MAX/MIN does not FAST REFRESH
9202 2411553 OERI:17271 from V7 XA client updating tables with SNAPSHOT on it
9202 2461184 OERI:[kkqsfxvc-2] possible during query rewrite
9202 2482089 GROUPING SET QUERY gives wrong results on Query REWRITE
9203 2157903 MOVE of MVIEW corrupts the data or dumps (ORA-7445 [qerltRop] or similar)
9203 2328821 CREATE MATERIALIZED VIEW .. WITH GROUPING SET does not work after upgrade from to Oracle9i
9203 2375621 MATERIALIZED View dumps if only remote tables inside inline view
9203 2395714 SQL with subqueries may be slow after query rewrite
9203 2533616 Materialized view refresh can use lots of CPU
9203 2536041 OERI[KKQSADJP-1] with QUERY_REWRITE_ENABLED=TRUE
9203 2544257 Query rewrite only rewrites one branch of GROUP BY UNION ALL statement
9203 2547290 Refresh of Materialized View over DBLINK wastes memory (ORA-4030)
9203 2557893 ORA-7445[qsmmecin] from rewrite of nested subquery with correlation
9203 2605240 Row cache lock contention updating table with MATERIALIZED VIEW LOG in Oracle Real Applications Clusters
9203 2616047 DBMS_METADATA does not show full query of Materialized view if TEXT more than 4000
9203 2662211 FAST REFRESH of MV with subquery may be very slow
9204 2300229 Dump (in KQSADJP) using query rewrite
9204 2646480 ORA-97 from DBMS_MVIEW.refresh if MVIEW name more than 22 characters long
9204 2669565 ORA-24345 possible on COMPLETE REFRESH if character sets differ
9204 2670550 ORA-4020 while refreshing a MATERIALIZED VIEW
9204 2676499 Query rewrite may not occur when expected
9204 2683906 Excessive ROW CACHE LOCK waits using MATERIALIZED VIEW LOGs in Oracle Real Applications Clusters
9204 2735033 OLS READ_CONTROL degrades SNAPSHOT REFRESH performance
9204 2741185 Fast refresh of MV on remote LOB columns may hang
9204 2743995 QSM-502 / ORA-1426 from summary advisor
9204 2749304 CREATE SNAPSHOT char/varchar2 column length not adjusted for multibyte character set
9204 2758168 ORA-7445 [KOKEIS] on REFRESH of remote MVIEW with VARRAY and TRIGGER
9204 2763009 Wrong results possible from QUERY REWRITE
9204 2796802 OERI[QKAJOI:1] from SQL using WITH clause with query rewrite
9204 2801315 Fast refresh gets ORA-1401 with pre-Oracle9i Master with differing national character set
9204 2810543 Create MVIEW may ORA-12054 in JA16SJIS if tablename contains '@' byte in a character
9204 2869421 ORA-600 [12869] on COMPLETE REFRESH of SNAPSHOT on PREBUILT table
9204 2871237 OERI:KOKSCCD1 can occur CREATING a MATERIALIZED VIEW with object column
9204 2910437 Inefficient plans on rewrite of SQL with GROUPING SETS and CASE expressions
9204 2928676 CREATE MVIEW using LAG with PARTITION clause may spin in JA16SJIS
9204 2943492 Query rewrite to union may not occur
9204 2965003 QUERY REWRITE does not occur for many common XML constructs
9204 2976763 Failed DROP MVIEW can leave corrupt dictionary data - subsequent ORA-30382

Recovery Bugs

The following table lists the recovery bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2487487 LGWR may hang writing to greater than 1 archive destinations with NOAFFIRM
9202 2724548 ORA-1172 stuck recovery possible
9203 2388569 Halt possible in parallel transaction recovery
9203 2399093 ORA-16000 opening database READ ONLY
9203 2408817 V$RECOVERY_PROCESS.SOFAR may decrease during media recovery
9203 2424490 OPTIONAL LOG_ARCHIVE_DEST_X failures not written to ALERT LOG
9203 2449124 MAX_FAILURE in LOG_ARCHIVE_DEST_N does not work
9203 2555509 Parallel media recovery slower than needed
9203 2594513 ORA-7445 [kcrradinit] possible during ARCH cross-instance archival
9203 2605511 OERI[3672] changing tablespace READ-WRITE after incomplete recovery
9203 2645378 LOB data corruption after RECOVERY
9203 2662180 RECOVER UNTIL SCN may stop before expected SCN if log corrupt
9204 2370438 Media recovery with concurrent V$ select may fail with ORA-1157
9204 2504480 Archive trace file generated for every log switch
9204 2724548 ORA-1172 stuck recovery possible
9204 2879970 ORA-16040 occurs with more than 2 cross-instance archival destinations

Regression Bugs

The following table lists the regression bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1326752 PROCOB generates PCB-S-400 / PCB-I-556 error for "PROCEDURE DIVISION USING COPY XYZ.
9202 1818720 Dump with PL/SQL and Java Stored Procedure returning NULL CLOB
9202 1918751 ORA-6502 possible from UNION and CONCAT (||) with constant strings
9202 2104392 OERI:[QCSFBDNP:1] from nested CONNECT BY with binds in START WITH o FROM clause
9202 2119513 ARRAY BINDS to PL/SQL anonymous blocks treated wrongly in Oracle9i
9202 2143154 Dump (in evaopn2) from view merging of semi joins
9202 2174510 ORA-23308 / ORA-23309 replicating pre-created tables with FLOAT columns
9202 2185245 OERI:qkaPIdsmrg2 possible during PQ partition-wise join
9202 2189463 ORA-7445 [EVAOPN2] with FUNCTIONAL INDEX on semi-join (EXISTS) predicate
9202 2200057 OERI:[KKXMAGTC1] possible for OUT / IN OUT bind to PL/SQL
9202 2211262 Loader parameter COMMIT_DISCONTINUED does not work
9202 2234068 PDML may not achieve expected degree of parallelism
9202 2240307 ORA-1007 not thrown when REF CURSOR column count != number of INTO items
9202 2245455 SET LINESIZE greater than1024 may return blank data as output in SQL*Plus
9202 2251552 Cursor leak / ORA-1000 using CURSOR() expressions
9202 2252369 NLS_LANG using UTF8 leads to ORA-12708 / ORA-12705 errors on startup on EBCDIC platforms
9202 2263263 Wrong results possible from HASH or SMJ of view with columns based on join key
9202 2263847 NullPointerException if DriverManager.setLogStream() called
9202 2273604 CURSOR_SHARING=FORCE may not share cursors using a BETWEEN clause with CBO
9202 2273837 Server Dump when JDBC THIN writes data to multibyte TEMP LOB
9202 2276418 UTL_HTTP.REQUEST does not use HTTP_PROXY environment variable nor SET_PROXY API
9202 2280027 OERI:504 possible from using SNAPSHOTs against Oracle8i
9202 2286387 SQL%FOUND/NOTFOUND etc.. altered by COMMIT / ROLLBACK
9202 2286442 Nested WITHIN may miss hits
9202 2287990 Bad plan possible from unnesting of multiple complex views
9202 2288481 SQL on partitioned table when object is invalidated (suvch as ANALYZEd) can dump / OERI:15212
9202 2293250 JOIN cannot be used as a table alias
9202 2302662 Index join should be disallowed for SELECT FOR UPDATE (ORA-2014)
9202 2307224 "ALTER INDEX .. REBUILD ONLINE" is slow
9202 2308033 OERI:6191 / OERI:6193 possible on DIRECT mode EXPORT of long row with greater than or equal to 8k DB_BLOCK_SIZE
9202 2309738 PL/SQL SELECT over DB link throws unexpected error instead of ORA-1403 / no_data_found
9202 2311919 FULL export with datafile greater than 1024M produces WRONG size datafiles in .DMP file
9202 2314238 VARCHAR2 Bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
9202 2329325 CBO may choose FTS over index FFS for partitioned table
9202 2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
9202 2332996 OERI:kokbcrwo1 from SELECT DISTINCT .. CURSOR() .. statements
9202 2335874 OCCI application may halt on commit
9202 2351498 PL/SQL which references a function with insufficient privileges may not error on compilation
9202 2357255 Oracle Type Translator fails with ClassNotFoundException:oracle.jdbc.driver.OracleDriver
9202 2364823 Index range scan can be slower than 9.0 or earlier
9202 2370947 Shadow memory corruption / false ORA-1483 assigning NULL to COMP-3 bind
9202 2373145 DBVERIFY does not identify fractured blocks
9202 2383449 ORA-7445 [pfrbnd] possible from ORDER BY LEVEL in PL/SQL
9202 2384233 ORA-604 / ORA-1422 on CREATE / DROP table after upgrade
9202 2386334 ORA-7445[QERUAROWPROCEDURE] possible from SELECT from UNION ALL view
9202 2386401 LOADER may load incorrect values for PACKED DECIMAL data
9202 2388400 OCI_ATTR_ROW_COUNT returns incorrect row count for piecewise fetches
9202 2389423 JDBC thick memory leak
9202 2391185 ORA-1 returned from ROLLBACK if session has been killed (should get ORA-1012)
9202 2391217 PLS-430 from PL/SQL Bulk Bind using an index
9202 2407732 ORA-28576 from DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT
9202 2409601 OERI[!QSCHEMA] from DBMS_AQADM.VERIFY_QUEUE_TYPES if queue name does not include SCHEMA
9202 2413264 Negative cost / bad plan for queries on partitioned table
9202 2418668 GATHER_SCHEMA_STATS() may fail in 9.2 for partitioned tables
9202 2423689 ORA-7445 [INSBRP] on DML against a table with UNUSED columns with a TRIGGER
9202 2430006 Some JA16EUC characters not handled correctly
9202 2432864 DBVERIFY does not work properly on RAW or for different BLOCKSIZE
9202 2434384 Updatable snapshots with an Oracle8i MASTER do not work - Fast refresh fails (ORA-2064)
9202 2437484 DECODE() returns wrong results for empty string ('') compared to NULL
9202 2442097 INSERTS into USER-DEFINED TYPES with CURSOR_SHARING=FORCE does not share cursors
9202 2444809 ORDVidea.setProperties slow for REAL Video data
9202 2449515 Worse plan in 9.2 with unnested subquery & concatenated index
9202 2460104 ORA-24391 in precompiled code in 9.2
9202 2469905 DBMS_STATS.GATHER..STATS may be slower in 9.2
9202 2580648 Anonymous PL/SQL not shared with SQL_TRACE / TIMED_STATISTICS
9202 3007386 ORA-6553 PLS-306 when table has FUNCTIONAL INDEX involving ADT attribute
9202 2351255] GROUP BY with large group key can OERI:[15851]
9203 1829296 False ORA-980 from PL/SQL referencing SYNONYM which uses a DBLINK
9203 2191497 XA_END in PRO fails with ORA-24779 when using a DBLINK after an error
9203 2429929 V$SESSION_EVENT.SID has the wrong SID (out by 1)
9203 2452537 SELECT of remote sequence leaks cursors (ORA-1000)
9203 2461455 ORA-7445 [qcdlgtd] or ORA-942 from IMPORT FROMUSER / TOUSER
9203 2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
9203 2474192 OERI:[OPIBND1] on CREATE of TEXT INDEX with CURSOR_SHARING
9203 2484250 Oracle Recovery Manager CUMULATIVE BACKUP / MAINTENENCE may appear to hang (spin)
9203 2495123 PLS-306 using DBMS_LOB.LOADFROMFILE after upgrade to 9.2
9203 2502129 Wrong results possible depending on order of predicates
9203 2509105 JDBC with pooled OracleConnection slower in Oracle9i than Oracle8i
9203 2514005 Client may dump (kpurst) when calling OCIBreak / OCIReset
9203 2517719 ORA-3115 from setTimestamp() in JDBC 9.2 with an 8.0 database
9203 2518109 Wrong results possible when INDEX JOIN used in execution plan
9203 2526540 SIGFPE possible during optimization
9203 2531403 ORA-13249 creating SPATIAL index on attribute of object table
9203 2531519 OERI:[25012] from parallel direct load of bitmap managed segments
9203 2536041 OERI[KKQSADJP-1] with QUERY_REWRITE_ENABLED=TRUE
9203 2536531 MERGE on table with BITMAP index fails with OERI:[kauins:1]
9203 2539837 Wrong results using FIRST_ROWS_N with greater than 5 tables in FROM clause
9203 2545840 Distributed query may see remote changes from AFTER the snapshot SCN
9203 2547290 Refresh of Materialized View over DBLINK wastes memory (ORA-4030)
9203 2550971 NullPointerException from defineColumnType executed twice in KPRB
9203 2555509 Parallel media recovery slower than needed
9203 2556845 ORA-955 / ORA-14452 running concurrent transportable tablespace exports
9203 2563206 CLOB data is corrupted when inserted from an 8.0 client to multibyte 9.2 server
9203 2563296 Import may fail with server ORA-7445[kfpchkchar]
9203 2573812 Pro*Cobol generates bad code for CURSOR VARIABLES when COMP1=INTEGER
9203 2598043 False ORA-1410 accessing migrated Oracle7 table with ROWID= predicate
9203 2598387 Export / OCI clients using prefetch may see corrupt data
9203 2603036 ORA-6533 gathering stats for partitioned table with DBMS_STATS
9203 2607029 High memory use optimizing SQL with functional indexes and many expressions
9203 2614464 ORA-979 from PL/SQL query with TABLE() function and PL/SQL bind in the GROUP BY clause
9203 2616459 CHR() returns CHR(0) when NLS_SORT is set
9203 2624452 Redefinition of buffer length with OCIDefineByPos gets wrong no bytes for LONGS
9203 2626347 OERI:17059 accessing view after ADD / SPLIT PARTITION
9203 2627474 Wrong results from CURSOR expression in JSP if first column is an ADT
9203 2633193 Wrong results possible from DECODE in a NOT IN subquery
9203 2645455 Control characters are trimmed from bind variables
9203 2646865 ORA-7445 [INSBRP] from INSERT .. RETURNING with a trigger
9203 2647211 Implicit cursor FOR loop memory leak / CPU hit
9203 2648289 ORA-7445 [kkmdel] deleting from a table with BEFORE DELETE trigger
9203 2661541 INSO_FILTER for BEQUEATH connections may fail with dynamic linker errors on UNIX
9203 2663986 Missing rows querying CTXRULE index in sections (eg: 'CAT WITHIN MAMMAL')
9203 2666244 Library cache lock corruption possible
9203 2668460 OracleTwoPhaseDriver.stepThinTwophase missing in Oracle9i release 9.2
9203 2668683 Array binds to PL/SQL blocks may ORA-1458 or no data is fetched
9203 2673783 Wrong year values possible from DATE data types (apparently random)
9203 2675123 Client gets no data in some cases when NLS_LANG is UTF8
9203 2684307 Mixed tokens not uppercased with BASE_LETTER in multibyte database
9203 2684915 CHAR.toString returns HEX values if input has invalid character
9203 2696397 Blob.length() fails when selected with a Stream type (LONG, LONG RAW)
9203 2697938 UPDATE of object table sets columns to NULL with index only access
9203 2700006 JDBC Thin "Unexpected Packet" error with LOBS in multithreaded client
9203 2701820 OERI[18250] / dump using migratable database links
9203 2702942 DBMS_XMLDOM.APPENDCHILD() does not work properly
9203 2707304 OERI:17059 / OERI:kqlupd2 / PLS-907 after adding partitions to Partitioned IOT
9203 2710321 X$KCCFN / V$DATAFILE much slower in Oracle9i than Oracle8i with many datafiles
9203 2717317 Client memory leak from EXEC SQL CONTEXT ALLOCATE / FREE
9203 2728916 SGA memory for NETWORK BUFFERS increased (over 9.0)
9203 2729655 Direct load of PARTITION may not update bitmap index
9203 2735964 SA_USER_ADMIN.ADD_GROUPS() fails when given IN_DEF and IN_ROW
9203 2765286 ORA-1458 from Pro ARRAY insert (9.2.0.2 only)
9203 2796974 MODADA clients may dump
9203 3007386 ORA-6553 PLS-306 when table has FUNCTIONAL INDEX involving ADT attribute
9204 1615764 ORA-22922 accessing TEMP LOB in a REF CURSOR returned from PL/SQL
9204 1951123 No error when PL/SQL copies multibyte CHAR into BIND which is too small
9204 2117638 ORA-2063 / ORA-1445 possible from outer join over DB link with NULL sensitive predicates
9204 2474232 Dump in kksmal0 selecting object and rowid data
9204 2518508 ORA-6502 / ORA-1460 calling PLQSL function directly from SQL
9204 2628234 CONTINUEIF NEXT clause can result in data being incorrectly discarded
9204 2651760 PL/SQL LENGTH/LENGTH2/LENGTH4/LENGTHC sometimes count BYTES not CHARACTERS
9204 2663465 Wrong results from CHECK CONSTRAINTS on OUTER JOINED table
9204 2668460 OracleTwoPhaseDriver.stepThinTwophase missing in Oracle 9.2
9204 2688197 ORA-1408 adding UNIQUE / PK CONSTRAINT with COMPRESSED KEY index
9204 2700474 Wrong results from complex view merging of correlated subquery with GROUP BY
9204 2721432 UTL_HTTP has poor performance in Oracle9i
9204 2721462 ORA-7445 [KOPXCCC] from PL/SQL RPC over DB LINK
9204 2727446 Wrong results or ORA-904 from ANSI join between remote tables
9204 2731243 False ORA-979 from scoped REFS in GROUP BY / ORDER BY
9204 2731685 XAOROLLBACK does not interrupt long running query
9204 2735873 Mutually recursive TYPES with can dump the shadow with Oracle8i to Oracle9i
9204 2749165 Arabic Hijrah calendar gives incorrect results in Oracle9i
9204 2754410 Multi-row insert SLOW with multiple FK constraints
9204 2763032 OERI:[KPOSCWS0] possible from OCIStmtFetch2()
9204 2768278 OERI[KCBNEW_3] possible after DROP of Oracle8i segment in locally managed tablespace
9204 2789620 Wrong results when DISTINCT list contains a functional index expression
9204 2798851 ORA-4031 possible from SMON during SHUTDOWN or STARTUP
9204 2800779 OERI:[kolaHashFind:hash table] / ORA-21500 from OCILobLocatorAssign
9204 2803772 V$SESSION_WAIT.SECONDS_IN_WAIT resets each time SEQ# is incremented
9204 2861866 Wrong results from STAR transformation with WINDOW functions
9204 2913866 ORA-7445 [KWQAPAQN] when EVENT 10862 is set
9204 2924041 No rows may be returned when VIEW column is defined on CAST / MULTISET
9204 2974471 ORA-603 / OERI[17271] on instance startup with SQL_TRACE=TRUE and CURSOR_SPACE_FOR_TIME=TRUE
9204 2980596 PL/SQL FOR LOOP performance hit & memory leak using implicit cursors
9204 2886292] RFS at logical standby may fail with OERI[KCRRULFH.12.2]

Replication Bugs

The following table lists the replication bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2011927 ORA-02068 / dump in TTCI2U for snapshot with EMPTY_CLOB() data with heterogeneous databases
9202 2103527 INVALID OBJECTS remain after running CATREPR.SQL
9202 2174510 ORA-23308 / ORA-23309 replicating pre-created tables with FLOAT columns
9202 2177840 ORA-23399 on Migration from 8.0 to Oracle9i leaving REPLICATED table STATUS in ERROR
9202 2227755 Incorrect INSERT statement from OFFLINE INSTANTIATION with fractioned values
9202 2434384 Updatable snapshots with an Oracle8i MASTER do not work - Fast refresh fails (ORA-2064)
9203 2601708 Parallel propagation may hang
9204 2474818 ORA-3117 pushing a transaction using TIMESTAMP(0) WITH LOCAL TIME ZONE
9204 2685250 DBMS_REPCAT_RGT.INSTANTIATE_ONLINE adds orphaned entries to SLOG$
9204 2832116 ORA-1422 possible from ADD_MASTER_DATABASE if database has transported or numerous datafiles
9204 2844585 Intermittent ORA-23474 on replication objects

Row Level Security Bugs

The following table lists the row level security bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2716265 OERI[16608] can occur on SELECT using STAR transformation with RLS
9204 2998476 DBA_FGA_AUDIT_TRAIL.SQL_TEXT may contain garbage (no charset conversion)

Security or Denial of Service Bugs

The following table lists the security or denial of service bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2395416 Net overrun security vulnerability
9202 2467947 LISTENER vulnerability
9203 2528524 Clear text passwords visible in LIBRARY_CACHE dumps
9203 2540219 Listener denial of service vulnerability
9203 2581911 iSQL* Plus buffer overflow vulnerability
9203 2620726 Buffer overflow in Oracle server
9203 2642117 Overflow vulnerability in DIRECTORY parameter of BFILENAME
9203 2642267 TZ_OFFSET overflow vulnerability
9203 2642439 TO_TIMESTAMP_TZ overflow vulnerability
9204 2716764 Extproc overflow vulnerability
9204 2988114 Buffer overflows in EXTPROC of Oracle
9204 3058991 Buffer overflows in the XML database

Shared Pool Bugs

The following table lists the security or denial of service bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2264893 Recursive SQL under triggers can contribute to latch contention
9202 2272866 Client side PL/SQL can cause excessing "library cache lock" and latch gets
9202 2273604 CURSOR_SHARING=FORCE may not share cursors using a BETWEEN clause with CBO
9202 2283941 Changes to reduce contention on "library cache latch"
9202 2385153 Shared pool LEAK on global enqueue timeouts in Oracle Real Applications Clusters
9202 2580648 Anonymous PL/SQL not shared with SQL_TRACE / TIMED_STATISTICS
9203 2450264 Add event to improve cursor sharability
9203 2586762 Direct LOB reads can result in ORA-4031 / excessive shared pool usage
9203 2607029 High memory use optimizing SQL with functional indexes and many expressions
9203 2708134 FIRST_ROWS(K) HINT causes cursor not to be shared
9204 2748963 USE_STORED_OUTLINE may not share SQL / PL/SQL anonymous blocks
9204 2760217 Cursors not shared when CREATE_STORED_OUTLINES set to a category
9204 2786968 Shared pool memory leak / ORA-4031 on repeated invalidate/execute of cursors
9204 2798851 ORA-4031 possible from SMON during SHUTDOWN or STARTUP
9204 2805335 Excessive shared pool memory use for parse of certain statements using functional indexes
9204 2817728 Shared pool memory leak / ORA-4031 when collecting segment statistics
9204 2953931 ORA-4031 parsing query with numerous groupings

Shared Server Bugs

The following table lists the shared server bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2296198 Shared server may not process client message for about 30 seconds
9202 2334868 Break (ctrl-c) may not interrupt a long running operation on a SHARED SERVER
9202 2351854 Dispatchers may hang if ORA-4031 occurs
9202 2472541 PMON ORA-7445 [kghxfr] after shared server gets ORA-4031
9202 2506629 Dispatcher should time out on incomplete connect requests
9203 2567290 Large packet over DBLINK may fail with ORA-12539
9203 2701820 OERI[18250] / dump using migratable database links
9203 2728916 SGA memory for NETWORK BUFFERS increased (over 9.0)
9204 2421734 ORA-12518 connecting to Oracle8i shared server through 9.2 listener
9204 2621310 OERI:504 possible selecting from shared pool fixed tables in MTS
9204 2695242 ORA-22 OERI[18260] using MTS with shared DB links
9204 2740472 Shared servers burn CPU executing Java "wait()" call
9204 2745940 Fix for BUG 2622690 missing from Oracle 9.2
9204 2758770 OERI:504 from Dispatcher/s when using TCP DB LINKS
9204 2760836 PMON cleanup of dead shared servers/dispatchers can crash instance (OERI:26599 / OERI:1115)
9204 2866612 Internal errors using JavaVM within shared server connections

Space Management Bugs

The following describes the space management bugs addressed in this patch set:

Bitmap Managed Segments Bugs

The following table lists the bitmap managed segment bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2212656 OERI[ktspfupdst-1] possible during DML on bitmap managed segments
9202 2296597 RESUMABLE session may OERI:2006 with AUTOMATIC segment space management
9202 2326066 OERI[ktspffbmb-4] creating LOB column in AUTO SEGMENT SPACE MANAGEMENT
9202 2477368 Full table scan of AUTO space managed table may not return all rows
9202 2326948t DBV-111 using DBVERIFY SEGMENT_ID=... on a bitmap space managed segment
9203 2531519 OERI:[25012] from parallel direct load of bitmap managed segments
9203 2619867 OERI:[KCBGTCR_12] / ORA-8103 / ORA-1410 SELECTing from bitmap managed segment
9203 2676912 OERI[KTELRWI-2] from CREATE UNIQUE INDEX with Bitmap managed segment
9203 2685269 OERI[ktspstchg-1] on DELETE from bitmap managed table/index
9204 2559022 ORA-372 selecting from ASSM segment in READ ONLY tablespace / DB
9204 2643723 ORA-1555 possible using AUTO space managed LOB segments
9204 2722809 OERI:kcbgcur_9 on direct load into AUTO space managed segment
9204 2733904 ORA-600[KTSPNEXTL1:4] after interrupted TRUNCATE with automatic space management
9204 2917432 Free space may not be used in Auto space managed segment
9204 2944866 Free space in LOB table / tablespace not reused with ASSM
9204 2967417 OERI:KCOAPL_BLKCHECK may occur using Auto managed segment

Dictionary Managed Tablespaces Bugs

The following table lists the dictionary managed tablespaces bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2869489 DBMS_STATS.GATHER_TABLE_STATS does not free TEMP extents
9204 2893261 Index cluster space may grow unexpectedly as free space not used
9204 2919655 LOBs may not reuse space with automatic undo management

Locally Managed Tablespaces Bugs

The following table lists the locally managed tablespaces bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2198861 Transporting a locally managed tablespace gives OERI:[KTFBFGET-1] at the TARGET
9202 2406802 OERI[kcbgtcr_3] / OERI[kcbcxx_1] after DROP TABLE in locally managed tablespace
9202 2414972 OERI:[kcbnew]/OERI:[kcbgtcr_3] after resize in LOCALLY MANAGED tablespace
9203 2569255 OERI:KCBGTCR_5 dropping segment upgrade fromOracle8i
9204 2747978 OERI[KCBNEW_3] after resize of locally managed tablespace
9204 2768278 OERI[KCBNEW_3] possible after DROP of Oracle8i segment in locally managed tablespace
9204 2862818 Bad export of NESTED table in LOCALLY managed tablespace - ORA-25150 or ORA-942 on import

Spatial Data Bugs

The following table lists the spatial data bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2172055 SDO_INTERSECTION may generate NULL geometries
9202 2211515 Spatial query may SPIN if TOLERANCE is too large
9202 2239348 SDO_GEOM.RELATE / UNION can return UNKNOWN MASK / NULL or ORA-7445 [mdirf2g]
9202 2324468 Wrong results from SDO_WITHIN_DISTANCE with BUFFER and R-TREE INDEX
9202 2334976 Incorrect measures generated by SDO_AGGR_LRS_CONCAT for geodetic data
9202 2341491 ORA-13050 possible on SDO_BUFFER of valid SDO geometry
9202 2412341 FALSE EASTING and FALSE NORTHING parameters are always in METERS
9202 2416245 Large memory leak using SDO_RELATE in a PL/SQL loop
9203 2526164 SDO has poor query performance with large partitioned tables
9203 2531403 ORA-13249 creating SPATIAL index on attribute of object table
9203 2545415 ORA-29902 from VIEWPORT_TRANSFORM
9203 2548412 Oracle9iNTERSECTION containing ARCS may dump
9204 2559269 OERI [KOHDTF048]/memory growth from large INSERT as SELECT with spatial data
9204 2556295 SDO_INTERSECTION fails with large GEOMETRIES (ORA-21779)
9203 2582293 SYNCHRONIZE after DEFERRED may fail after UPDATES
9203 2588406 ARC validates after failing (ORA-13349) with smaller tolerance
9203 2592406 Dump possible SYNCHRONIZING a DEFERRED spatial index
9203 2622496 SDO_RELATE returns wrong results on ARCS with reasonable tolerance
9203 2626372 INTERSECTION of POLYGON with HOLE and POLYGON returns NULL
9203 2633138 Dump from SDO_RELATE with convexhull
9203 2637320 Dump from SDO_CONVEXHULL
9203 2638946 Creation of local partitioned spatial index may fail
9203 2653232 Spatial queries can exceed CPU RESOURCE_LIMIT as CPU not updated
9203 2669515 VALIDATE GEOMETRY may dump
9203 2671089 UNION of GEODETIC GEOMETRIES returns INVALID GEOMETRY (ORA-13349)
9203 2673154 SDO RELATE may show different relationships depending on TOLERANCE
9203 2679773 "CREATE INDEX ... LOCAL UNUSABLE" should create dummy indexes
9203 2682980 Add DBMS_PCLXUTIL to support parallel spatial index build
9203 2685914 SDO_WITHIN_DISTANCE may return wrong answer for geodetic data
9203 2685976 SDO_RELATE with SDO_BUFFER AROUND WINDOW gives wrong answer
9203 2692602 OBJECT tables cannot be indexed by SDO
9203 2694899 "ALTER INDEX REBUILD PARTITION <NO PARAMETERS>" should use previous parameters
9203 2696860 Wrong results from SDO_WITHIN_DISTANCE for MULTI-POINT Geometry when parallel to the axis
9203 2723677 ORA-955 adding a partition to a spatial table with a LOCAL SPATIAL index
9203 2727824 SDO_WITHIN_DISTANCE fails with 2D window against 3D data indexed 2D
9204 2739444 ORA-7445 [qximirew] from SPATIAL query on PARTITIONED table
9204 2936628 Improve error reporting for ORA-13249 errors
9204 3011800 Definition of ALL_SDO_INDEX_INFO is incorrect and can give wrong results
9204 3034125 MGA94 systems are incorrect

Spatial RTREE Bugs

The following table lists the spatial RTREE bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2468979 ORA-13249/ORA-6502 creating partitioned RTREE spatial index in parallel
9203 1941373 SDO_TUNE functions show no output for RTREEs
9203 2534045 OERI:kghuichk_07 using SDO_RELATE against RTREE with Circular Arc Geometry
9203 2671434 SDO_RELATE can be very slow with RTREE
9203 2768576 SDO_RELATE (point - line) for CONTAINS on RTREE returns WRONG RESULT
9204 3051846 Local RTREE indexes on PARTITIONED table are invalid after SDO_GEOM update

SQL*Loader Bugs

The following table lists the SQL*Loader bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2182152 Incorrect record skipping / RECNUM values during continued load
9202 2209813 OERI:5213 possible on direct load into table with bitmapped functional index
9202 2211262 Loader parameter COMMIT_DISCONTINUED does not work
9202 2245909 SQLLoad with EXTERNAL_TABLE does not find DIRECTORY objects correctly
9202 2275942 ORA-7445 [klcfcfre] possible from DIRECT LOAD of large input file
9202 2332700 Conventional load can reject a row which should be loaded if CTRL-C occurs
9202 2386401 LOADER may load incorrect values for PACKED DECIMAL data
9202 2418454 Direct load may fail with OERI:[klaprs_40] loading large data files
9202 2420305 ORA-26041 from Direct path load of TIMESTAMP data on EBCDIC
9202 2448081 DIRECT load loads PACKED DECIMALS exceeding specified precision / scale
9202 2468782 Direct load with SQL expression in CONTROL file can fail / store incorrect data
9202 2474033 OERI[KTSPTRM_BMB-3] possible from parallel direct load
9202 2477651 Parallel direct load may report success on failure
9203 2479354 Direct path load of column Objects give wrong results / dumps
9203 2501800 ORA-7445 [kdblailb] from Direct path load into a COMPRESSed table
9203 2513944 Oracle9i loader performance slow with multiple INTO clauses with failed WHEN clauses
9203 2729655 Direct load of PARTITION may not update bitmap index
9204 2392885 Direct path load may fail with OERI:kcbgcur_9 / OERI:ktfduedel2
9204 2597075 ORA-372 on direct load into PARTITION with an empty READ ONLY partition
9204 2628234 CONTINUEIF NEXT clause can result in data being incorrectly discarded
9204 2708284 Loader misreads secondary datafiles for VARRAYs / Nested Tables
9204 2743239 Wrong results from LOADER NULLIF / DEFAULTIF clauses
9204 2767857 SQLLOAD of NULL LOB loads previous LOB value
9204 2823031 OERI[KLAPRS_30] possible from direct load if there are data conversion errors

SQL*Plus Bugs

The following table lists the SQL*Plus bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1764458 COPY TABLE with RAW datatype column does not copy correctly
9202 2117791 SQL*Plus cannot open SQL file with no extension after SET SUFFIX '' or ""
9202 2245455 SET LINESIZE greater than1024 may return blank data as output in SQL*Plus
9202 2261290 iSQL*Plus "DESCRIBE" does not show PL/SQL PROCEDURE parameters
9202 2278758 iSQL*Plus set SERVEROUTPUT to 0 causes subsequent errors
9202 2287093 System Variables to Instance wrong in iSQL*Plus
9202 2298683 SQL*Plus truncates TNS description strings to 160 bytes
9202 2357300 BROWSE button sometimes doesn't work in iSQL*Plus
9202 2367783 SQL*Plus may spin if it selects an incomplete multibyte character
9202 2379136 SQL*Plus memory / LOB leak querying XMLType
9203 1854041 SQL*Plus GUI may dump with increased LINESIZE
9203 2097904 Zeroed out AUTOTRACE statistics shown when connected as SYSDBA
9203 2157907 SQL*Plus select of CLOB/NCLOB Unicode surrogate pairs shows incorrect data
9203 2387804 STARTUP command with invalid option reports internal error (SP2-642)
9203 2471872 Quoted parameter to SQL*Plus is ignored
9203 2480427 Setting AUTOTRACE in iSQL*Plus in the System Variables page does not show errors
9203 2494108 Multi line heading output order wrong with SET MARKUP HTML PREFORMAT ON
9203 2538083 SQL*Plus /NOLOG fails with SP-2 when NLS_LANG is HEBREW_ISRAEL
9203 2581911 iSQL*Plus buffer overflow vulnerability
9203 2652845 SQL*Plus client may get ORA-25402 after TAF failover if no previous SQL issued
9204 2661516 SHOW MARKUP may hang in SQL*Plus

SQLJ Bugs

The following table lists the SQLJ bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2357847 SQLJ cannot distinguish same PACKAGE . FUNCTION in different schemas
9203 1743466 False SQLJException "Invalid column name" with JDK 1.3
9204 2920832 SQLJ errors using ForUpdate in iterator declaration

Star Transformation Bugs

The following table lists the star transformation bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2279891 ORA-900 from temp table STAR transformation
9202 2286794 Dump in evaopn2 if STAR transformation FACT table has greater than 1 bitmap index on a join column
9202 2289081 Wrong results from STAR_TRANSFORMATION with TEMP table generation with OR predicates
9202 2316487 ORA-604 / ORA-942 with STAR_TRANSFORMATION_ENABLED=TRUE
9202 2364585 STAR transformation may dump (EVAOPN2) if fact column is leading prefix of bitmap index
9202 2376273 Memory corruption using LEADING hint with STAR transformation
9202 2417032 ORA-907 from STAR_TRANSFORMATION and inline UNION view
9202 2476322 Temp Table STAR TRANSFORMATION may show negative cost
9203 2499014 STAR_TRANSFORMATION_ENABLED=TRUE can generate unnecessary semijoin subqueries
9203 2522549 Wrong results possible with STAR_TRANSFORMATION_ENABLED=TRUE
9203 2540375 ORA-918 possible with STAR_TRANSFORMATION_ENABLED=TRUE
9203 2550212 'TEMP TABLE GENERATION' can give very poor query performance
9203 2559375 Wrong results from STAR_TRANSFORMATION_ENABLED due to transitively generated predicates
9203 2698687 Dump in qes3tCleanLockInfo from temp table transformation
9203 2708898 STAR_TRANSFORMATION with a WINDOW function may dump (evaopn2)
9203 2711788 Wrong results possible from STAR transformation with OR predicates
9203 2767539 Dump (in qerpxStart) possible from TEMP TABLE TRANSFORMATION with WINDOW function
9204 2419335 OERI:[qks3tInit] possible from STAR transformation
9204 2656634 Dump (qerpxStart) from temp table transformation with HAVING clause
9204 2687687 Wrong results from TEMP TABLE transformation if same DIMENSION tables joined to multiple FACT columns
9204 2690677 OERI / wrong results from STAR TRANSFORMATION with VIEW as FACT table
9204 2716265 OERI[16608] can occur on SELECT using STAR transformation with RLS
9204 2767303 Wrong results from TEMP TABLE STAR TRANSFORMATION
9204 2773781 Dump in vopscv with STAR transformation
9204 2823907 Wrong results from STAR query with inlist predicate
9204 2861866 Wrong results from STAR transformation with WINDOW functions
9204 2884797 TEMP table star transformation with INDEX JOIN can fail with ORA-1733
9204 2930188 Dump possible using Star transformation with index joins

Streams/Logical Standby Bugs

The following table lists the streams/logical standby bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2228694 DBMS_LOGSTDBY.BUILD returns ORA-16108
9202 No Bug Number 9.2.0.2 is mandatory minimum patch level for Streams / Logical Standby
9203 2376027 SUPPLEMENTAL LOG GROUP has a limit of 33 columns (ORA-2257)
9203 2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
9203 2552188 Certain DDLs can cause capture to die (OERI:KNLCFGETOBJINFO:GTA)
9203 2560808 Logical Standby apply slaves leak memory in Max Availability mode
9203 2615349 PQ traces generated in Streams / Logical Standby
9203 2621671 Memory leak in logical standby
9203 2623859 ORA-1400 possible during DBMS_APPLY_ADM
9203 2623931 Capture may not start after upgrade from 9201 to 9202
9203 2641682 Logical standby apply skip DDL may not skip all operations and error/stop
9203 2644200 Logical standby may stall with large DDL transactions
9203 2644381 Streams with log shipping stalls
9203 2654469 Streams capture does not handle EMPTY_LOBS properly
9203 2662771 Logfiles not registered with logical standby logminer session
9203 2666229 Log mining of LOB DMLs fails
9203 2681977 Logical standby may not maintain some tables from upgraded database
9203 2691474 Lowering MAX_EVENTS_RECORDED does not free rows in DBA_LOGSTDBY_EVENTS
9203 2691486 Mined data loss possible from LOB ERASE/TRIM/WRITE redo
9203 2692936 Apply engine may hang
9203 2693159 Fetch slave may hang
9203 2694760 ORA-1405 from DBMS_STREAMS_ADM.ADD_SCHEMA_RULES etc.
9203 2701643 OERI [krvxmds_MemberDictSet]/ORA-7445 mining redo from upgraded database
9203 2702392 Hang / dump possible mining redo
9203 2709359 Dump/errors restarting logical standby with AGE SPILL data present
9203 2715979 Apply may fail for tables with PRIMARY KEY DEFERRABLE
9203 2718814 DML/Rollback problems with SUPPLEMENTAL LOG GROUP on IOT
9203 2728053 Logminer checkpointing may not happen for long time
9203 2732343 Streams capture update of LOB data greater than 32K gives wrong length on APPLY
9203 2736124 DBA_APPLY_ERROR.MESSAGE_COUNT value incorrect
9203 2736672 LSP0 failure may crash instance
9204 2378009 PGA memory leak from APPLY servers when using LOBS
9204 2378852 Cannot drop APPLY process after DROP USER CASCADE of APPLY user
9204 2470696 Logical Standby apply process may hang (logical standby cache latch)
9204 2523462 9OERI[KNALSEMTE-2] possible instantiating a new DB or table in STREAMS
9204 2569360 Streams fails replicating table DDL where the DDL text is greater than 64K bytes long.
9204 2576404 OERI[723] in RFS from logical standby database switch over
9204 2624754 Streams APPLY can be slow when there is no primary key defined
9204 2707250 After propagation is dropped DBMS_STREAMS_ADM.REMOVE_RULE does not remove the rule
9204 2709452 GLOBAL_NAME not stored in CANONICAL form in LOGMINER dictionary
9204 2721063 DBMS_LOGSTDBY.SKIP_TRANSACTION fails with OERI:KNAHSPX11 / ORA-1403
9204 2748160 PLS-306 possible from logical standby
9204 2750401 DEFERRABLE UNIQUE CONSTRAINTS can cause LOGICAL STANDBY apply errors
9204 2755889 ORA-7445[KWREVAS1] dropping LOGADMIN user with STREAMS
9204 2757099 ORA-1403 when Data Guard Manager tries to create a Logical Standby
9204 2757906 Block or crash recovery redo causes ORA-1403 in STREAMS/LOGICAL STANDBY APPLY
9204 2762475 DIRECT PATH LOAD not replicated by streams / logical standby apply
9204 2770025 OERI[KWQPFDPSE:QNAME] on SHUTDOWN of STREAMS database
9204 2787823 LOGICAL STANDBY APPLY may fail with OERI:15714
9204 2795727 Streams instantiation RPC may error when used between different versions
9204 2797392 Streams / logical standby does not replicate DDL from PL/SQL "EXECUTE IMMEDIATE"
9204 2805798 APPLY process aborts with ORA-1426 during "no progress" checking
9204 2809828 Dump (in krvuprlcr) from AGE-UNSPILL
9204 2830288 DROP_PROPAGATION fails with ORA-24010 if QUEUES already dropped
9204 2834337 ORA-600 [KNGOLCPY] in CAPTURE process with external LOBS
9204 2842026 SQL APPLY coordinator can use excessive CPU
9204 2864094 ORA-60 in SQL apply with multiple apply servers with rollback operations
9204 2880313 Creating 2nd capture or reset START_SCN can need very old logfiles
9204 2880324 Cannot restart CAPTURE after resetting START_SCN in a RAC environment
9204 2882140 OERI:knacdc2 in LSP0 during PDML rollback
9204 2883634 OERI[2006] during UPDATE with SUPPLEMENTAL LOGGING and trailing nulls
9204 2886292 RFS at logical standby may fail with OERI[KCRRULFH.12.2]
9204 2900276 CAPTURED_SCN / APPLIED_SCN not updated after CHECKPOINT
9204 2901586 LOGMINER / Streams apply of CTAS with greater than 122 columns dumps
9204 2902091 NULL body from dequeue of LCRs as XMLType message from AQ Anydata queue
9204 2912596 OERI:[KNLLXANYTS2XML:2] using TIMESTAMPs with Streams
9204 2919457 Create Unique index can cause ORA-1403 during apply of DML
9204 2919570 ORA-1403 during apply after ADD or DROP COLUMN
9204 2941476 Not all rows of CTAS on primary propagated
9204 2942371 Redo for tables with row dependencies cannot be mined
9204 2942624 Data loss possible at APPLY
9204 2944485 Streams still does work for LOB changes marked as uninteresting
9204 2948842 Streams capture constructs LCRs for uninteresting tables with LOB columns
9204 2975563 Streams CAPTURE performance degrades when PARALLELISM greater than 1 for large transactions
9204 2976295 DBMS_APPLY_ADM.EXECUTE_ERROR does not apply the errors
9204 2984331 Streams capture cannot startup on RAC after failover
9204 2996902 Duplicate messages possible with UNSCHEDULE / SCHEDULE_PROPOGATION
9204 3001947 Capture dumps transforming out of line LOB

System Halt Bugs

The following describes the system halt bugs addressed in this patch set:

System Halt Involving Shared Resource Bugs

The following table lists the system halt involving shared resource bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2166890 Halt/ORA-4021 possible using PL/SQL clients
9202 2208882 SPIN for SQL against a VIEW which references an ALTERED LIST PARTITION table
9202 2209142 Surviving node may HANG when PARALLEL_INSTANCE_GROUP set
9202 2272671 DEADLOCK possible on CREATE INDEX ONLINE (KGL lock v. TT enqueue)
9202 2351854 Dispatchers may halt if ORA-4031 occurs
9202 2442539 SMONs may deadlock updating COL_USAGE$ in Oracle Real Applications Clusters
9202 2487487 LGWR may halt writing to more than one archive destinations with NOAFFIRM
9203 2479110 Self deadlock (on library cache pin) revalidating INVALID PL/SQL
9203 2563162 Crash recovery may halt in Oracle Real Applications Clusters
9203 2636685 Halt/OERI:[17059] after adding a list value to a partition
9203 2664217 Undetected deadlock (dc_objects V library cache lock) invalidating dependencies
9203 2666244 Library cache lock corruption possible
9204 2727744 Foreground processes/SMON may hang waiting for row cache lock (rare)
9204 2742518 Accessing X$GLOBALCONTEXT may fail with OERI:525/halts the database
9204 2828026 Interrupted sessions may fail with ORA-600 [1158] /database can halt
9204 2840233 OERI[510].. [SHRED POOL] can occur/database halts

Process Halt Bugs

The following table lists the process halt bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2223234 Concurrent DML against a CLUSTER TABLE may deadlock
9202 2296198 Shared server may not process client message for about 30 seconds
9202 2299898 Client may halt processing LONG data
9202 2321000 Subquery with ROWNUM predicate may halt using CURSOR SHARING
9202 2347262 Halt during startup possible in SMU mode
9202 2379327 Multithreaded client may halt when using BEQ adaptor
9202 2415134 SR enqueue deadlock possible
9202 2435787 PDML may halt for tables with referential integrity constraints
9203 2320407 Session may halt on row cache enqueue if SQL_TRACE=true
9203 2370520 EMON halt message notifications not delivered
9203 2388569 Halt possible in parallel transaction recovery
9203 2601708 Parallel propagation may halt
9203 2692936 Apply engine may halt
9203 2702392 Halt/dump possible mining redo
9204 2470696 Logical Standby apply process may halt (logical standby cache latch)
9204 2661516 SHOW MARKUP may halt in SQL*Plus
9204 2706634 Many process slow down when 240 session insert at the same time
9204 2738120 SHUTDOWN IMMEDIATE may halt due to PQ activity
9204 2741185 Fast refresh of MV on remote LOB columns may halt
9204 2759170 Simultaneous DBMS_LOGMNR_D.BUILD may halt
9204 2797571 SQL may halt from 7.3 to Oracle8i or Oracle9i if SELECT expression greater than 960 characters
9204 2912869 Sessions halt on "library cache lock" during ALTER TABLE.. MODIFY PARTITION..REBUILD..

Process Spin Bugs

The following table lists the process spin bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2090827 Spin in KDIFIND() possible updating indexed table (rare)
9202 2208882 Spin for SQL against a VIEW which references an ALTERED LIST PARTITION table
9202 2211515 spatial query may spin if TOLERANCE is too large
9202 2238718 Spin possible due to corrupt block on mirrored datafile
9202 2282891 Select from V$SQLTEXT may spin if HASH_VALUE is given as a predicated
9202 2306331 Halt/OERI:[17059] on view after SET_KEY or SET_DML_INVOCATION on base table
9202 2367783 SQL*Plus may spin if it selects an incomplete multibyte character
9202 2480451 Spin in KDB4CHK possible if block is corrupt
9202 2516119 LIKE pat ESCAPE with no escape character in pat spins in multibyte
9203 2484250 Oracle Recovery Manager CUMULATIVE BACKUP/MAINTENANCE may appear to halt (spin)
9203 2550212 TEMP TABLE GENERATION can give very poor query performance
9203 2636685 Halt/OERI:[17059] after adding a list value to a partition
9203 2657221 JDBC spins using Scrollable ResultSet with ORDER BY
9203 2695517 CR may spin after an instance crash
9204 2397300 CPU Spin form concurrent AQ dequeue of same message without commit/rollback
9204 2588348 Particular multibyte sequences can spin in PL/SQL compilation
9204 2598547 PL/SQL may halt/spin if there are a huge number of IF THEN..ENDIF statements
9204 2599336 CTXHX may halt/spin if segmentation fault occurs
9204 2627570 RPAD9str,n,CHR(0)) spins using multibyte character set
9204 2698133 TKPROF can spin with some trace files
9204 2928676 CREATE MVIEW using LAG with PARTITION clause may spin in JA16SJIS
9204 2937108 DELETE CASCADE may spin in Oracle Real Applications Clusters

System Managed Undo Bugs

The following table lists the system managed undo bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2053110 SMU may report ORA-30036 when undo space is available
9202 2347262 Halt during startup possible in SMU mode
9202 2358432 DBMS_SPACE_ADMIN.SEGMENT_DUMP() signals ORA-03211 for SMU Undo Segments
9202 2360088 ORA-1092 on STARTUP if the firsT UNDO_TABLESPACE is OFFLINE (ORA-376 in alert)
9202 2390780 ORA-1538 reverting to UNDO_MANAGEMENT=MANUAL in Oracle Real Applications Clusters
9202 2439695 OERI[4191] possible on shrink of system managed undo segment
9204 2431450 SMU Undo corruption possible on instance crash
9204 2621669 ORA-30036 possible in high concurrency with SMU
9204 2629434 Self DEADLOCK possible on HW enqueue using SMU
9204 2726601 OERI[4406] possible in SMON using automatic undo management
9204 2954560 OERI:KCBRLS_1 can occur in kteuPropagateTime() using SMU
9204 2919655 LOBs may not reuse space with automatic undo management

Transparent Application Failover Bugs

The following table lists the transparent application failover bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2193939 FAILOVER: Client memory leak using TAF when repeatedly open/close connections
9203 2496780 TAF client may dump if failover occurs during SELECT of LONG column
9203 2542693 Repeated ORA-0000 after failover
9203 2605435 Client memory leak on TAF connection
9203 2652845 SQL*Plus client may get ORA-25402 after TAF failover if no previous SQL issued
9203 2686200 FAILOVER dumps if OCI_ATTR_INTERNAL_NAME / OCI_ATTR_EXTERNAL_NAME set in UTF16 client
9204 2652886 ORA-25402 can occur on ROLLBACK after failover
9204 2699203 ORA-24371 possible on execute/fetch after failover
9204 2763219 Client memory leak using OCIStmtPrepare with TAF connection
9204 2764565 ORA-21500 [17112] possible after failover
9204 2766270 ORA-1001 possible after failover
9204 2841983 ORA-1089 on TAF connection after SHUTDOWN IMMEDIATE

Transportable Tablespaces Bugs

The following table lists the transportable tablespaces bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1993176 Transportable sets cannot contain a HASH CLUSTER
9202 2160802 OERI:PITL1 possible plugging Oracle8i tablespace into Oracle9i
9202 2198861 Transporting a locally managed tablespace gives OERI:[KTFBFGET-1] at the TARGET
9202 2349201 ORA-1647 importing TRANSPORTABLE set with partitioned object table
9202 2387007 ENH: Allow UNUSED COLUMNS to be TRANSPORTED
9202 2518865 Transportable tablespace with LONG may miss column data
9202 2803911 Target sees corrupt data in TRANSPORTED tablespace with UNUSED columns
9203 2347596 Transport of OBJECT table may get index in wrong tablespace
9203 2518758 ORA-1460 IMPORTING metadata for TRANSPORT of table with LONG column
9203 2544428 Export may write bad LOB storage clause for TRANSPORT (ORA-22850 on IMPORT)
9203 2544536 Transportable tablespace export may produce bad export
9203 2551267 OERI:[kkdxptcn1] during TRANSPORT import of tables with LONG columns
9203 2555141 OERI:[PITL1] using an TRANSPORTED table created in Oracle8i (or earlier)
9203 2556845 ORA-955 / ORA-14452 running concurrent transportable tablespace exports
9203 2563296 Import may fail with server ORA-7445[kfpchkchar]
9203 2803911 Target sees corrupt data in TRANSPORTED tablespace with UNUSED columns
9204 1874320 Constraints needlessly revalidated during import of transported tablespace metadata
9204 2628232 ORA-600's from CR served block from a plugged in tablespace
9204 2767834 Transportable tablespace export may be slow with many tablespaces
9204 2918098 ORA-29353 from transportable tablespace export with numerous tablespaces

Trigger Bugs

The following table lists the trigger bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2014766 Java TRIGGERS do not set :NEW variables to the new values
9202 2138987 OERI:kohdtgde1 / OERI:koxsihread1 possible executing a trigger
9202 2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
9202 2264893 Recursive SQL under triggers can contribute to latch contention
9202 2269285 OERI:[QCTVCO : BFC] INSERTing '' to table with TIMESTAMP column and trigger
9202 2273417 RECO may not recover IN-DOUBT transactions when LOGON triggers exist
9202 2322586 ORA-7445 [QERLTIDLM] using APPEND hint in trigger
9202 2339030 :OLD / :NEW contain garbage for TIMESTAMP WITH LOCAL TIMEZONE columns
9202 2423689 ORA-7445 [INSBRP] on DML against a table with UNUSED columns with a TRIGGER
9203 1955577 Dump (in KOKEIS) using BINDS if TRIGGER updates nested table column
9203 2078899 OERI[4814] / OERI[kkdlgon4] on startup with DDL in SYSTEM TRIGGER
9203 2473741 Before row update trigger may not fire for MERGE statement
9203 2646865 ORA-7445 [INSBRP] from INSERT .. RETURNING with a trigger
9203 2648289 ORA-7445 [kkmdel] deleting from a table with BEFORE DELETE trigger
9204 809293 ORA-4071 during IMPORT of trigger with SPACES in definition
9204 2758168 ORA-7445 [KOKEIS] on REFRESH of remote MVIEW with VARRAY and TRIGGER
9204 2854856 ORA-911 can occur importing a trigger in a mixed case SCHEMA name

Truncate Bugs

The following table lists the truncate bugs addressed in this patch set:

Fixed in Release Bug Number Description
9204 2733904 ORA-600[KTSPNEXTL1:4] after interrupted TRUNCATE with automatic space management

Ultra Search Bugs

The following table lists the Ultra Search bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2280521 Edit Attribute Mapping page has incorrect Mapping
9202 2318866 Unable to DELETE GROUP in multibyte
9202 2328192 ORA-1407 changing data source from USING DISPLAY URL to NOT USING
9202 2335396 Exception when DELETE ATTRIBUTE LOV with long MBC name
9202 2349367 Admin tool cannot detect PRIMARY KEYS when base table not in the instance schema
9202 2350367 Need option to allow CRAWLER to ignore Robot Exclusion rules
9202 2350381 Different instances share same search attribute space
9202 2382986 WKG-10900 possible after renaming a search attribute
9202 2386775 Ultrasearch EMAIL schedule may error with PLS-201
9202 2391052 Crawler may not object ROBOTS.TXT rule
9202 2406868 SQLEXCEPTION searching for "*" (asterisk)
9202 2422743 Crawler rate slows over time
9202 2427164 NUMBER Attribute values not deleted on re-crawl
9202 2428263 Inconsistent document checksum for document due to MIMETYPE
9202 2464769 Unable to view greater than 1 remote crawler profile
9202 2569663 Crawler filtering fails for JA16EUC
9203 2650812 Multiple "/" in URL from HTTP redirection
9203 2673282 WKG-30008 crawling a FILE-DATASOURCE with greater than 127 character FILENAME
9203 2695209 CRAWLER may not find files in a directory in file data store
9203 2709760 MAKE of sample fails with portal_global_code.jsp cannot be read
9204 2503935 Crawler converts special characters in URLs
9204 2760102 Crawl depth is reset to 0 for redirected URLs
9204 2791768 CRAWLER indexes URLs that have been commented out in ASP
9204 2835533 Email CRAWLER may stop or halt processing '>' in mail recipient address
9204 2875360 CRAWLER ROBOT EXCLUSION does not work
9204 2994706 CRAWLER filtering may leak file descriptors

Upgrade and Downgrade Bugs

The following table lists the upgrade and downgrade bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2177840 ORA-23399 on Migration from Oracle 8.0 to Oracle9i leaving REPLICATED table STATUS in ERROR
9202 2293968 SQLJTYPE Java classes invalid on downgrade from release 9.2 to release 9.0 or 8.1
9202 2324679 INVALID AQ$ objects after downgrade to Oracle8i
9202 2334789 Patch set scripts loose GRANTS on DBMS_LOCK_ALLOCATED
9202 2343833 ORA-29552 from oracle.xdb.XMLType.createXML after 901 upgrade/downgrade
9202 2384233 ORA-604 or ORA-1422 on CREATE / DROP table after upgrade
9202 2385207 OERI:16206 on upgrade to 9.0/9.2
9202 2401353 Java setup may fail with ORA-1422 in initjvmaux.rollbacksetup
9202 2422299 SDO upgrade may signal ORA-2260
9202 2424746 2424746Unexpected ORA-24033 enqueuing an AQ message after upgrade to release 9.2
9202 2395193 OERI:4414 / ORA-1403 on dequeue of pre-9.2 enqueued messages
9203 2328821 CREATE MATERIALIZED VIEW .. WITH GROUPING SET does not work after upgrade from to Oracle9i
9203 2529763 Rename of 9.0.1 OMF file fails with ORA-1276
9203 2569255 OERI:KCBGTCR_5 dropping segment upgrade from Oracle8i
9203 2591284 Upgrade to Oracle9i may fail leaving bad KOTTD$ type information in dictionary
9203 2598043 False ORA-1410 accessing migrated Oracle7 table with ROWID= predicate
9203 2607128 OERI:[qmxiUnpPacked2] if CATPATCH.SQL/XDBPATCH.SQL fails
9203 2623931 Capture may not start after upgrade from 9201 to 9202
9203 2629917 ORA-20000 error downgrading from Oracle9i to Oracle8i
9203 2642848 OERI:16206 possible on release 9.2 to release 8.1 downgrade
9203 2654862 Open of standby in READ ONLY mode may fail after upgrade (ORA-16000)
9203 2685546 XMLCONCAT function should be dropped after release 9.2.0.1 to 9.2.0.2 upgrade
9204 2722510 ORA-7445 on DEQUEUE after database upgrade from Oracle8i
9204 2757441 Duplicate rules upgrading from 8.1 or 9.0 - ORA-24033 during enqueue
9204 2759147 "Warning:Type altered with compilation errors" on interMedia upgrade
9204 2798855 AQ rules views may become INVALID after upgrade to 9.2
9204 2881018 EXP/IMP of Queues after DB upgrade to 9.2 fails
9204 2881164 OER:19491 / OERI:KOCTXIN700 / OERI:19490 upgrading pre-Oracle9i to Oracle9i or later
9204 2949941 Rules engine objects may become invalid after upgrade

Wallet Manager Bugs

The following table lists the Wallet Manager bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2347682 Cannot load certificate with SUBJECT_NAME with AVA type IA5_STRING
9203 2494999 Wallet Manager will not import CA certificate
9203 2623513 Wallet Manager hangs importing CERTIFICATE with BMPSTRING encoding
9204 2697057 Certain certificates cannot be imported into ORACLE WALLET MANAGER
9204 2907257 Non ASCII data not displayed correctly in certificate request

Wrong Results Bugs

The following table lists the wrong results bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 1231199 Wrong results possible from parallel queries where NLS_SORT is not BINARY
9202 1951553 Wrong results from PQ with ORDER BY NLSSORT
9202 2147213 Wrong results / dump possible using DESC functional index
9202 2161906 Wrong results possible using ROWNUM / LEVEL in predicates / GROUP BY with multiple views
9202 2183412 Wrong results possible with DESC index
9202 2202561 Wrong results possible from CHECK CONSTRAINT with empty string ''
9202 2206022 Wrong results / OERIs from DML on UPDATE JOIN VIEW with STORED OUTLINE
9202 2210617 SELECT from corrupt IOT returns wrong results
9202 2214266 Multibyte EXTERNAL TABLE with greater than 1 file may return wrong results
9202 2221401 Queries with complex view may return wrong results if predicates have implicit type conversion
9202 2252055 Wrong result from OR-expanded plan with inequality SMJ
9202 2257375 Turkish language characters are not converted correctly with SPECIFIC or GENERIC base letter
9202 2258035 Wrong results possible from Max/Min/Count(DISTINCT) on top of window function
9202 2262196 Intermittent wrong results from PARALLEL partition wise join
9202 2263263 Wrong results possible from HASH or SMJ of view with columns based on join key
9202 2286442 Nested WITHIN may miss hits
9202 2289081 Wrong results from STAR_TRANSFORMATION with TEMP table generation with OR predicates
9202 2296247 Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY
9202 2296307 Wrong results possible from DISTINCT on VIEW with AGGREGATES and SUBQUERIES
9202 2314238 VARCHAR2 Bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
9202 2320751 Wrong results possible from Text phrase search on XML document
9202 2324468 Wrong results from SDO_WITHIN_DISTANCE with BUFFER and R-TREE INDEX
9202 2327249 V$SYSSTAT may show huge incorrect values when using Parallel Query
9202 2338661 Wrong results possible from ANSI outer join
9202 2343219 NCHAR LIKE comparisons may not match on EBCDIC platforms
9202 2352429 (FLOAT)getObject(n) returns 0.0 for NULL data
9202 2352928 Wrong results / dump from FULL OUTER JOIN to SUBQUERY with GROUP BY
9202 2360043 LEFT OUTER JOIN may produce incorrect results instead of ORA-1799
9202 2363209 Wrong results possible from IS NULL on list partitioned table with DEFAULT partition
9202 2383138 Wrong results from ANTI-JOIN to single table subquery with constant "FALSE" predicate
9202 2384272 JDBC getTime() of a TIMESTAMP does not return the correct Time value
9202 2388008 Wrong results from ANSI outer join with 'const <relop> col'
9202 2388400 OCI_ATTR_ROW_COUNT returns incorrect row count for piecewise fetches
9202 2389429 ALL_COLL_TYPES may omit rows
9202 2393988 WRONG RESULT WHEN USING DECODE WITH COST BASED OPTIMIZER
9202 2397402 Dump / Wrong result with many INLIST predicates on non-indexed column
9202 2404234 Wrong results from predicate push into view with CONNECT BY and join
9202 2411876 BULK BIND deletes cause incorrect delete counts in USER_TAB_MODIFICATIONS
9202 2417894 ORA-7445 [EVAMINMAX] / wrong results from complex view if aggregate correlated to SUBQUERY
9202 2423226 Extra characters appended with REPLACE / RTRIM on multibyte shifted data
9202 2437484 DECODE() returns wrong results for empty string ('') compared to NULL
9202 2448615 Wrong results from HASH JOIN over DBLINK with multibyte data
9202 2468606 Cobol: COMP-3 packed decimal can return incorrect number data
9202 2474692 V$BUFFER_POOL_STATISTICS DBBGET and CONGET are wrong
9202 2477368 Full table scan of AUTO space managed table may not return all rows
9202 2481002 V$FILESTAT.AVGIOTIM is incorrect
9202 2482089 GROUPING SET QUERY gives wrong results on Query REWRITE
9202 2597503 Cursors with SYNONYM specific policies may not be shared properly
9203 2333947 Wrong results possible from PQ on PARTITIONED table
9203 2375782 NEAR operator may not return rows with several terms
9203 2408817 V$RECOVERY_PROCESS.SOFAR may decrease during media recovery
9203 2429929 V$SESSION_EVENT.SID has the wrong SID (out by 1)
9203 2442125 Wrong results from PQ which compares a CHAR column to a BIND variable
9203 2452631 Wrong results with CHECK CONSTRAINTS on OUTER JOIN columns
9203 2455551 Blank padded comparison fails with NLS_COMP=ANSI & NLS_SORT<>BINARY
9203 2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
9203 2477249 Wrong results / Dump from INSERT AS SELECT with GROUP BY using FUNCTIONAL INDEX
9203 2502129 Wrong results possible depending on order of predicates
9203 2516097 Wrong results from multiple aggregations on constant outer join view columns
9203 2518109 Wrong results possible when INDEX JOIN used in execution plan
9203 2522549 Wrong results possible with STAR_TRANSFORMATION_ENABLED=TRUE
9203 2529036 LIKE against multi-byte CLOB can give wrong results
9203 2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases
9203 2539837 Wrong results using FIRST_ROWS_N with greater than 5 tables in FROM clause
9203 2545840 Distributed query may see remote changes from AFTER the snapshot SCN
9203 2551568 OERI:[rworupo.1] / wrong results from queries involving OBJECTS
9203 2556195 OERI:[SORPUT_1] / Wrong results using PIPELINED function in SQL
9203 2559375 Wrong results from STAR_TRANSFORMATION_ENABLED due to transitively generated predicates
9203 2569154 Wrong results from PQ with NL of BITMAP INDEX with ROWID predicate
9203 2586586 Values after decimal place are shifted converting String to PACKED DECIMAL over HS
9203 2589186 Empty Timestamp is returned for NULL column value
9203 2601175 Wrong results for German sharp-s with BASE_LETTER and ALTERNATE_SPELLING
9203 2610068 '_' character treated as a WILDCARD for CTXCAT indextype
9203 2616459 CHR() returns CHR(0) when NLS_SORT is set
9203 2622496 SDO_RELATE returns wrong results on ARCS with reasonable tolerance
9203 2624452 Redefinition of buffer length with OCIDefineByPos gets wrong no bytes for LONGS
9203 2627474 Wrong results from CURSOR expression in JSP if first column is an ADT
9203 2628799 Blank data from Domain Index only scan fetching PK only for IOT
9203 2630054 ORA-7445 [EVAOPN2] / wrong results from CASE expression
9203 2633193 Wrong results possible from DECODE in a NOT IN subquery
9203 2649659 Invalid data in OCI7 client in non-blocking mode with NLS conversion
9203 2656627 Wrong results from ANSI OUTER JOIN with CONSTANT predicates in ON clause
9203 2658851 Wrong results from SEMIJOIN on CLUSTERED column
9203 2663986 Missing rows querying CTXRULE index in sections (such as: 'CAT WITHIN MAMMAL')
9203 2673783 Wrong year values possible from DATE data types (apparently random)
9203 2675123 Client gets no data in some cases when NLS_LANG is UTF8
9203 2684307 Mixed tokens not uppercased with BASE_LETTER in multibyte database
9203 2685914 SDO_WITHIN_DISTANCE may return wrong answer for geodetic data
9203 2688717 Pro client may get NULL rows with PREFETCH enabled
9203 2711788 Wrong results possible from STAR transformation with OR predicates
9203 2729655 Direct load of PARTITION may not update bitmap index
9203 2729673 Wrong result from COMPOSITE PARTITIONING, INLIST and GLOBAL INDEX
9203 2768576 SDO_RELATE (point - line) for CONTAINS on RTREE returns WRONG RESULT
9204 1934372 SOUNDEX / FUZZY text queries give wrong results on EBCDIC platforms
9204 1951123 No error when PL/SQL copies multibyte CHAR into BIND which is too small
9204 2186092 No data from TABLE (PL/SQL function) if function returns large collection
9204 2379769 Wrong results possible with composite BTREE BITMAP plan if there are trailing NULLS
9204 2400243 Lengths retrieved for VARCHAR array fetch not always ZERO for NULLs
9204 2404927 ORA-1858 / wrong results from PREDICATE_MOVE_AROUND
9204 2414581 V$SQL_PLAN may return an incomplete plan
9204 2425679 Wrong results possible from select over DBLINK
9204 2446423 Wrong results from buffered PREFETCH with AND-EQUAL
9204 2516097 Wrong results from multiple aggregations on constant outer join view columns
9204 2586586 Values after decimal place are shifted converting String to PACKED DECIMAL over HS
9204 2610331 OCCI getString() can return invalid values for NUMBER columns
9204 2630331 Wrong results with BASELETTER and ALTERNATE SPELLING used together
9204 2635664 VPD policy groups may not respond to the driving application context
9204 2651760 PL/SQL LENGTH/LENGTH2/LENGTH4/LENGTHC sometimes count BYTES not CHARACTERS
9204 2663465 Wrong results from CHECK CONSTRAINTS on OUTER JOINED table
9204 2679062 Wrong results possible from multi-column INLIST
9204 2681037 FOR UPDATE with non-mergeable view in IN-subquery can return duplicate rows
9204 2683540 Wrong results from INDEX RANGE SCAN (MAX/MIN) with a join
9204 2685869 Wrong results using PQO with OLS/VPD which uses application context
9204 2687687 Wrong results from TEMP TABLE transformation if same DIMENSION tables joined to multiple FACT columns
9204 2688053 Wrong results using GROUPING SETS
9204 2690677 OERI / wrong results from STAR TRANSFORMATION with VIEW as FACT table
9204 2700474 Wrong results from complex view merging of correlated subquery with GROUP BY
9204 2712141 Wrong results from HASH join of view on remote query block
9204 2723141 Wrong results from NOT EXIST with subquery which has constant FALSE predicate
9204 2726276 Wrong SCORE() for plans with Text index below a HASH JOIN
9204 2726517 Unusual values in V$SGASTAT "miscellaneous" row
9204 2727212 Wrong results from HASH join between CHAR column and VIEW column based on a BIND variable
9204 2727446 Wrong results or ORA-904 from ANSI join between remote tables
9204 2739068 Wrong results comparing CONSTANTS with SUBQUERIES using COUNT()
9204 2747052 Wrong results from queries with bitmap index access with large OR-chains
9204 2747643 Wrong results from MAX/MIN on IOT with GROUP BY
9204 2753856 Wrong results possible from PQ partition query with GROUP BY
9204 2757568 V$TRANSACTION may not show all active transactions
9204 2758545 NLS_LENGTH_SEMANTICS is not supported in JDBC
9204 2763009 Wrong results possible from QUERY REWRITE
9204 2767303 Wrong results from TEMP TABLE STAR TRANSFORMATION
9204 2773831 Wrong results possible from GROUPING SETS with OUTER JOIN
9204 2778506 Wrong results from optimizer mode FIRST_ROWS_XX
9204 2787377 Wrong results possible in RAC when MAX_COMMIT_PROPOGATION_DELAY=0
9204 2789620 Wrong results when DISTINCT list contains a functional index expression
9204 2793768 getString() on ROWID column gets wrong data on EBCDIC platforms
9204 2803772 V$SESSION_WAIT.SECONDS_IN_WAIT resets each time SEQ# is incremented
9204 2808431 Wrong results from PQ with OUTER JOIN
9204 2816978 Wrong results using secondary index on IOT to fetch OVERFLOW columns
9204 2818459 Text "FUZZY" query gets wrong results when using PREFIX INDEXING
9204 2823907 Wrong results from STAR query with inlist predicate
9204 2829723 Wrong results from ANSI OUTER JOIN when join condition does not reference both sides
9204 2853688 Wrong results from Multi-column SORT/MERGE JOIN if Semi-join eliminated
9204 2854146 Query with Sort-Merge-Join can produce wrong results
9204 2859263 DBA_TEMP_FILES / X$KTFTHC can return wrong results
9204 2888719 Wrong results from colocated remote tables with OUTER join
9204 2903059 DBMS_XMLDOM.WRITETOCLOB/WRITETOBUFFER returns incorrect data
9204 2907128 DELETE using an INDEX ONLY path may delete the wrong number of rows
9204 2909084 RENAME of a VIEW with CHAR column can cause wrong results for subsequent SQL
9204 2920925 Wrong results from queries with single OR predicate which is not null safe
9204 2924041 No rows may be returned when VIEW column is defined on CAST / MULTISET
9204 2963556 Wrong results from SQL using table lookup prefetch with more than 64kb rows in child row source
9204 3011800 Definition of ALL_SDO_INDEX_INFO is incorrect and can give wrong results

XA/Distributed Transactions Bugs

The following table lists the XA/distributed transactions bugs addressed in this patch set:

Fixed in Release Bug Number Description
9202 2207382 OERI:12333 fetching from Oracle/DB2 in XA
9202 2411553 OERI:17271 from V7 XA client updating tables with SNAPSHOT on it
9203 2191497 XA_END in PRO fails with ORA-24779 when using a DBLINK after an error
9203 2497219 OERI:[17065] / OERI:[17064] from XAOROLLBACK with AQ in OPS/RAC
9203 2511780 Add JDBC XA support for LOOSE transactions
9203 2622558 XA Open option to close precompiler cursors on XA_END (avoid ORA-24779 errors)
9203 2638483 XAER_RMERR returned on XA_COMMIT instead of XA_RETRY
9203 2659833 Client side errors during JDBC XA operations are ignored
9203 2678338 Heuristically committed/rollback cases are not handled by JDBC XA (ORA-24756)
9203 2698435 Repeated OERI:18260 / OERI:18186 if XA DBLINK errors at commit
9204 2494790 Undo quote discrepancies may be reported for global transactions
9204 2713152 XA trace EVENT:10126 produces garbage XID values in the trace
9204 2717235 JDBC XA recover followed by start throws XAException (XA_PROTO)
9204 2731685 XAOROLLBACK does not interrupt long running query
9204 2783519 JDBC XA throws ORA-24762 instead of ORA-24756
9204 2784688 False ORA-2051 on concurrent xa_end / xa_prepare of tightly coupled transaction branches
9204 2881276 JDBC XA returns XAER_RMERR instead of XAER_RMFAIL if DB is down
9204 2897119 JDBC OCI heap error 17112 with setNativeXA(TRUE)
9204 2901457 OERI:ktcdso-1 from XA read only branch with commit time callback

XDB Bugs

The following table lists the XDB bugs addressed in this patch set:

<
Fixed in Release Bug Number Description
9203 2332184 ORA-7445[kope2upic] from XML.ToObject()
9203 2334377 Memory Leak from TABLE subquery against XMLType
9203 2337501 Repeated elements with non-identical types cannot be handled
9203 2412825 Listing an XDB folder may be very slow
9203 2483617 DBMS_XSLPROCESSOR.SELECTNODES may dump in qmxGetNumChildren
9203 2486954 ORA-4031 / Dump from concurrent DGURIServlet access to SQLX XMLType view
9203 2491404 Cannot find files with multibyte names (with a "\" byte)
9203 2535425 XDB wrong result possible from EXISTSNODE with "/*"
9203 2537917 OERI:729 possible with XDB
9203 2553163 XDB may dump in QMUBANINS
9203 2558798 Add indexes to XDB$RESOURCE improve XDB performance
9203 2587723 OERI:[kolasaWrite-3] / OERI:[ksmovrflow] possible with XDB
9203 2587768 XDB internal fix
9203 2591551 OERI:[qesmmaLogUnResSpc1] with XDB
9203 2595396 Dump in KGEADP possible with XDB
9203 2600262 XDB may not show correct content of XMLType column
9203 2605166 OERI:koksctri1 during create TEXT index on EXTRACT() expression
9203 2611590 OERI:[17003] running XDBRELOD.SQL
9203 2615657 XMLTYPE is always pickled as LOB/TEXT (never ADT)
9203 2616549 OERI:QMR_CB_PR1 possible in XDB
9203 2619800 XML files with non-default extensions not treated as XML in XDB
9203 2621345 Using IOTs for NESTED TABLES wastes space in XDB
9203 2622151 Incorrect query rewrite of XPATHS on schemas with Subs groups
9203 2622913 OERI:[qmtsSetTypeInfo9] possible
9203 2642976 Memory growth on INSERT of XMLTYPE
9203 2648408 OERI:[QMTSGETCOMPLEXINFO1] on RegisterSchema
9203 2676936 DBMS_XMLDOM, DBMS_XMLPROCESSOR not NAMESPACE aware
9203 2678676 ProcessXSL / Transform truncates output at 4000 characters
9203 2687401 XDBSCHEMAs may not be imported to correct schema
9203 2712908 Create VIEW may hang creating view over XMLSEQUENCE
9203