Oracle 11g RAC自动打GI PSU补丁(11.2.0.4.8)
时间： 23:58:14
&&&& 阅读：1851
&&&& 评论：
&&&& 收藏：0
标签：&&&&&&一、准备工作1，数据库环境操作系统版本&& : Redhat 6.5 x64 & 数据库版本&&&& : Oracle 11.2.0.4 x64 RAC & &Grid&&&&&&&&&& : 11.2.0.4 & & Oracle database: 11.2.0.4本文出自:http://koumm./2，准备内容GI PSU : p040_Linux-x86-64.zip & &OPatch : p000_Linux-x86-64.zip & &DB PSU : p040_Linux-x86-64.zip 仅单实例使用。OPatch下载地址： & 说明：GI PSU包括DB PSU,CPU。二、更新OPatch版本，必须要更新说明：分别在两个节点更新OPatch版本。1. 更新OPatch版本，需要更新到11.2.0.3.11，OPatch直接压缩替换就可以了。(1) 上传p000_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限，也可以采用/tmp目录。 & (2) root用户下将原OPatch目录改名。mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatchbk & mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatchBK2. grid目录OPatch替换(1) root用户 & cd /u01/software/;chown grid:oinstall p000_Linux-x86-64.zip(2) grid用户su - grid & cd /u01/software/ & &unzip p000_Linux-x86-64.zip(3) root用户cd /u01/software/ & mv OPatch /u01/app/11.2.0/grid/(4) grid用户测试su - grid & /u01/app/11.2.0/grid/OPatch/opatch versionOPatch Version: 11.2.0.3.11 & OPatch succeeded.3. oracle目录OPatch替换(1) root用户cd /u01/software/;chown oracle:oinstall p000_Linux-x86-64.zip(2) oracle用户su - oracle & cd /u01/software/ & &unzip p000_Linux-x86-64.zip(3) root用户cd /u01/software/ & mv OPatch /u01/app/oracle/product/11.2.0/db_1/(4) oracle用户测试su - oracle/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch versionOPatch Version: 11.2.0.3.11 & OPatch succeeded.三、分别在节点1和节点2分别生成ocm.rsp文件。# su - oracle$ cd& /u01/software & $ /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp & &$ lsocm.rsp四、开始升级GI PSU软件包说明：一定要按照顺序一个一个节点的打。1. grid用户下解决GI PSU补丁包(1) root用户操作cd /u01/software/;chown grid:oinstall p040_Linux-x86-64.zip(2) grid用户操作su& - grid & cd /u01/software/ & &unzip p040_Linux-x86-64.zip2. 测试兼容性su - grid$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/52649 -oh $ORACLE_HOME & &$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/52642 -oh $ORACLE_HOME & & $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/52635 -oh $ORACLE_HOME过程略过…3、开始升级GRIDroot用户依次节点1，节点2上执行。# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/software/ -oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rspExecuting /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn
-oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_paramsThis is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto_10-09-05.logThis file will show your detected configuration and all the steps that opatchauto attempted to do on your system: & /u01/app/11.2.0/grid/cfgtoollogs/opatchauto_10-09-05.report.log 10:09:05: Starting Clusterware Patch Setup & Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsStopping CRS... & Stopped CRS successfullypatch /u01/software/52635& apply successful for home& /u01/app/11.2.0/grid & &patch /u01/software/52649& apply successful for home& /u01/app/11.2.0/grid & & patch /u01/software/52642& apply successful for home& /u01/app/11.2.0/gridStarting CRS... & Installing Trace File Analyzer & &CRS-4123: Oracle High Availability Services has been started.opatch auto succeeded.4. 检查升级情况# su - grid$ /u01/app/11.2.0/grid/OPatch/opatch lsinv&&& &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Oracle Interim Patch Installer version 11.2.0.3.11 & &Copyright (c) 2015, Oracle Corporation.& All rights reserved.Oracle Home&&&&&& : /u01/app/11.2.0/grid & &Central Inventory : /u01/app/oraInventory & &&& from&&&&&&&&&& : /u01/app/11.2.0/grid/oraInst.loc & &OPatch version&&& : 11.2.0.3.11 & &OUI version&&&&&& : 11.2.0.4.0 & &Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_10-31-49AM_1.logLsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory_10-31-49AM.txt-------------------------------------------------------------------------------- & Local Machine Information:: & &Hostname: db1 & &ARU platform id: 226 & &ARU platform description:: Linux x86-64Installed Top-level Products (1):Oracle Grid Infrastructure 11g&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& 11.2.0.4.0 & There are 1 products installed in this Oracle Home.Interim patches (3) :Patch& &&&& : applied on Fri Dec 25 10:22:50 CST 2015 & Unique Patch ID:&
& &Patch description:& "ACFS Patch Set Update : 11.2.0.4.8 ()" & &&& Created on 3 Sep :11 hrs PST8PDT & &&& Bugs fixed: & &&&&& 503605 & &&&&& 053182 & &&&&& 321597 & &&&&& 681968 & &&&&& 475946Patch& &&&& : applied on Fri Dec 25 10:19:11 CST 2015 & Unique Patch ID:&
& &Patch description:& "OCW Patch Set Update : 11.2.0.4.8 ()" & &&& Created on 2 Sep :49 hrs PST8PDT & &&& Bugs fixed: & &&&&& 750548 & &&&&& 962892 & &&&&& 991403 & &&&&& 995001 & &&&&& 917869 & &&&&& 746251 & &&&&& 378120 & &&&&& 168690 & &&&&& 928658 & &&&&& 172091 & &&&&& 120545 & &&&&& 744838 & &&&&& 348155 & &&&&& 551223 & &&&&& 558324 & &&&&& 284825 & &&&&& 159489 & &&&&& 281493 & &&&&& 076173 & &&&&& 777968 & &&&&& 885321 & &&&&& 876500 & &&&&& 209968 & &&&&& 867761 & &&&&& 447588 & &&&&& 920201Patch& &&&& : applied on Fri Dec 25 10:16:29 CST 2015 & Unique Patch ID:&
& &Patch description:& "Database Patch Set Update : 11.2.0.4.8 ()" & &&& Created on 1 Sep :44 hrs & & Sub-patch& ; "Database Patch Set Update : 11.2.0.4.7 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.6 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.5 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.4 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.3 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.2 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.1 ()" & &&& Bugs fixed: & &&&&& 506699 & &&&&& 284817 & &&&&& 449815 & &&&&& 478514 & &&&&& 929165 & &&&&& 264060 & &&&&& 951456 & &&&&& 915271 & &&&&& 136473 & &&&&& 588480 & &&&&& 883252 & &&&&& 611721 & &&&&& 482502 & &&&&& 174582 & &&&&& 875449 & &&&&& 184721 & &&&&& 723434 & &&&&& 891943 & &&&&& 913355 & &&&&& 043574 & &&&&& 155762 & &&&&& 027426 & &&&&& 498382 & &&&&& 344544 & &&&&& 835048 & &&&&& 761775 & &&&&& 990359 & &&&&& 133975 & &&&&& 255, 655634 & &&&&& 348614 & &&&&& 285317 & &&&&& 346671 & &&&&& 851160 & &&&&& 360606 & &&&&& 299015 & &&&&& 905058 & &&&&& 972568 & &&&&& 186905 & &&&&& 674024 & &&&&& 121551 & &&&&& 456514 & &&&&& 889583 & &&&&& 615136 & &&&&& 323222 & &&&&& 031668 & &&&&& 716305 & &&&&& 903536 & &&&&& 721717 & &&&&& 972570 & &&&&& 246576 & &&&&& 786278 & &&&&& 787259 & &&&&& 051858 & &&&&& 296213 & &&&&& 568,
& &&&&& 238511 & &&&&& 364061&Rac system comprising of multiple nodes & & Local node = db1 & && Remote node = db2--------------------------------------------------------------------------------OPatch succeeded.$ /u01/app/11.2.0/grid/OPatch/opatch lspatches;ACFS Patch Set Update : 11.2.0.4.8 () & ;OCW Patch Set Update : 11.2.0.4.8 () & &;Database Patch Set Update : 11.2.0.4.8 ()OPatch succeeded.五、打database PSU补丁1. 准备工作(1) Root用户下，重新给PSU补丁包赋予权限cd /u01/software/;chown oracle:oinstall p040_Linux-x86-64.zip(2) oracle用户su - oracle & cd /u01/software/ & &unzip p040_Linux-x86-64.zip2. Oracle用户下检查兼容性$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/52635 -oh $ORACLE_HOME---------------------------------------------------- & 示例： & &Oracle Interim Patch Installer version 11.2.0.3.11 & &Copyright (c) 2015, Oracle Corporation.& All rights reserved.PREREQ sessionOracle Home&&&&&& : /u01/app/11.2.0/grid & Central Inventory : /u01/app/oraInventory & &&& from&&&&&&&&&& : /u01/app/11.2.0/grid/oraInst.loc & &OPatch version&&& : 11.2.0.3.11 & &OUI version&&&&&& : 11.2.0.4.0 & &Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_16-21-46PM_1.logInvoking prereq "checkconflictagainstohwithdetail"Prereq "checkConflictAgainstOHWithDetail" passed. & OPatch succeeded. & &----------------------------------------------------3. 开启自动打补丁 root用户依次节点1，节点2上人执行。# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /u01/software/ -oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf /u01/software/ocm.rspExecuting /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn
-oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_paramsThis is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto_10-43-07.logThis file will show your detected configuration and all the steps that opatchauto attempted to do on your system: & /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto_10-43-07.report.log 10:43:07: Starting Clusterware Patch Setup & Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsStopping RAC /u01/app/oracle/product/11.2.0/db_1 ... & Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfullypatch /u01/software/52635& apply successful for home& /u01/app/oracle/product/11.2.0/db_1 & &patch /u01/software/52649/custom/server/& apply successful for home& /u01/app/oracle/product/11.2.0/db_1Starting RAC /u01/app/oracle/product/11.2.0/db_1 ... & Started RAC /u01/app/oracle/product/11.2.0/db_1 successfullyopatch auto succeeded.4. 检查升级情况$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv&&& &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Patch& &&&& : applied on Fri Dec 18 17:38:24 CST 2015 & &Unique Patch ID:&
& &Patch description:& "Database Patch Set Update : 11.2.0.4.8 ()" & &&& Created on 1 Sep :44 hrs & & Sub-patch& ; "Database Patch Set Update : 11.2.0.4.7 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.6 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.5 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.4 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.3 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.2 ()" & &Sub-patch& ; "Database Patch Set Update : 11.2.0.4.1 ()" & &&& Bugs fixed: & &...$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches;Database Patch Set Update : 11.2.0.4.8 () & ;ACFS Patch Set Update : 11.2.0.4.8 () & &;OCW Patch Set Update : 11.2.0.4.8 () & &OPatch succeeded.六、升级数据库数据字典数据库启动，并加载修改SQL Files到数据库$ sqlplus / as sysdba & & SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 25 11:26:02 2015Copyright (c) , Oracle.& All rights reserved.Connected to: & Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production & &With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, & &Data Mining and Real Application Testing optionsSQL& select open_mode from v$OPEN_MODE & -------------------- & &READ WRITESQL& & &SQL&SQL& @?/rdbms/admin/catbundle.sql psu applySQL& & &执行完后我们可以查到PSU更新信息： & &SQL&set line 150 & col ACTION_TIME for a30 & &col ACTION for a8 & &col NAMESPACE for a8 & &col VERSION for a10 & &col BUNDLE_SERIES for a5 & &col COMMENTS for a20 & &select * from dba_registry_ & &&ACTION_TIME&&&&&&&&&&&&&&&&&&& ACTION&& NAMESPAC VERSION&&&&&&&&&&& ID BUNDL COMMENTS & ------------------------------ -------- -------- ---------- ---------- ----- -------------------- & &24-AUG-13 12.03.45.119862 PM&& APPLY&&& SERVER&& 11.2.0.4&&&&&&&&&&& 0 PSU&& Patchset 11.2.0.2.0 & &22-DEC-15 03.53.27.330912 PM&& APPLY&&& SERVER&& 11.2.0.4&&&&&&&&&&& 0 PSU&& Patchset 11.2.0.2.0 & &25-DEC-15 11.54.19.486765 AM&& APPLY&&& SERVER&& 11.2.0.4&&&&&&&&&&& 8 PSU&& PSU 11.2.0.4.83 rows selected.SQL& & &小节：自动打还是比较顺利的，没有出现手动打出现的问题，在此记录。本文出自 “” 博客，请务必保留此出处标签：&&&&&&
&&国之画&&&& &&&&chrome插件&&
版权所有 京ICP备号-2
迷上了代码！11.2.0.4 Patch Set - List of Bug Fixes by Problem Type (Doc ID ) - oracle - ITkeyowrd
11.2.0.4 Patch Set - List of Bug Fixes by Problem Type (Doc ID )
Bugs fixed in the 11.2.0.4 Patch Set
See&&for Support Status and Alerts affecting 11.2.0 releases.
This note lists customer bugs fixed in the 11.2.0.4 Patch Set which are not already fixed in an earlier 11.2 Patch Set.&
ie: This is the list of fixes added in 11.2.0.4
Bugs are listed by product. RDBMS (Server) bugs are listed under significant headings relating to either a feature or a characteristic of the bug. Some bugs are listed in more than one section. Each bug number is hyperlinked to a&.
'*'&indicates that an alert exists for that issue.
'+'&indicates a particularly notable issue / bug.
'I'&indicates an install issue / bug included for completeness.
'P'&indicates a port specific bug.
Fixed&versions use &BPnn& to indicate Exadata bundle&nn.
&OERI:xxxx& may be used as shorthand for&ORA-600 [xxxx].
Notable exceptions and omissions
Enterprise Manager / Database Control&fixes are&NOT&listed.
Port specific bug fixes are not usually listed .
Alerted and Notable issues fixed in 11.2.0.4
* Dictionary corruption / ORA-959 due to DROP TABLESPACE. This bug is alerted in&
* ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds]. Corruption in Rollback with Clusterwide Global Transactions in RAC. This bug is alerted in&
+ wrong results / OERI:[kkooqb: bsj not used] with star transformation
+ Registration of 11.2 database fails against 12.1 CRS stack (required fix for 11g DB with 12c GI)
+ Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug
+ Hang / SGA memory corruption / ORA-7445 [kglic0] when using multiple shared pool subpools
+ PMON block recovery loop - instance hang
+ Cannot drop/replace trigger in editioning environment
+ wrong results when execution plan shows nested loop batching
+ ORA-1206 in SOURCE database after RMAN duplicate
P* Solaris / HP: ORA-29701 raised in ASM i/o path. This bug is alerted in&
P+ Solaris: Process spin and/or ASM and DB crash if RAC instance up for & 248 days
P+ AIX: Excess &work USLA heap& process memory use in 11.2 on AIX
11.2.0.4 Bug Categories
11.2.0.4 Bug Fixes by Category
P Windows: ORA-12638 &credential retrieval failed& using Kerberos with database service running as local user
okinit: &asn.1 identifier doesn't match expected value& when using AES enctype
okinit fails when the communication with the KDC is over TCP
ORA-600: [17281], [1001] when selecting ref cursors via JDBC thin and not explicitly closing then
ResultSet.getRow() incorrectly returns rowcount instead of 0 after all rows are fetched (next() returns false).
ORA-22925 when retrieving a LOB larger than 2gb via JDBC thin
The 11.2 JDBC driver handles embedded CALL statements differently to 11.1
JDBC thin app sends scale value of 0 or 9 for Timestamp binds causing many child cursors
Connection/login failure with &IOError: undefined error& if os username contains specific multi-byte character
Using newer time zones with JDBC fails with &The database session time zone is not supported&
DatabaseMetaData.getColumns() returns unexpected values in COLUMN_SIZE and DECIMAL_DIGITS for INTEGER columns
ORA-932 using JSP with ADT argument
PreparedStatement executeBatch() fails with ORA-1460 while execute() works
JDBC Statement.cancel can cause ORA-1013 from a Rollback
JDBC class NTFConnection creates runaway threads
Atlantic/Jan_Mayen mapping in ZONEIDMAP.java does not match the database value
JDBC cannot connect to RAC using shared server when the DISPATCHERS parameter has POOL=ON and redirection occurs - superseded
oracle.sql.TIMESTAMP.TimeZoneConvert() returns wrong results
JDBC program shows high cursor version count and high bind mismatch count
ORA-4043 using JDBC OCI; JDBC thin works
oracle.jdbc.pool.OracleDataSourceFactory ignores connection properties when creating an OracleDataSource
JDBC Thin ResultSet.isBeforeFirst() always returns true when Calling a PLSQL
JDBC still uses the RULE hint for certain queries on ALL_SYNONYMS which degrades performance
With the patch for bug
installed JDBC cannot connect using shared server when the DISPATCHERS parameter has POOL=ON and no redirection occurs
Calling getMetaData() on a StructDescriptor.gives poor performance selecting from ALL_TYPE_ATTRS
The JDBC SQL parser treats literals containing the word RETURN as though they were a RETURN[ING] ... INTO clause
OutOfMemory exception when executing a plsql statement with 280+ VARCHAR2 parameters in JDBC
JDBC NTFConnection threads are stuck waiting and consuming CPU
97 06 02 23 93 63 39 19 00 77 88 69 91 68 15 68 84 14 06 49 75 59 09
db2 sql error -803 no longer mapped to ora-00001
85 65 82 06
87 03 89494
Dispatcher dies with ORA-7445 [nstimexp] error
JDBC thin fails to connect via a SCAN listener when using TCPS and SSL
11.2 client overrides an application's SIGINT signal handler
TCP handlers block if listener registration is restricted to IPC with COST
the client queries dns server with type ipv6 to resolve the scan ip
ORA-12552 may be signaled with BEQ connection
crsd fails to startup after adding many users and os groups
Diagnostic enhancement to support dynamic network trace at process level
7 23 37 54 86 66 26
wrong results (incorrect aggregation) on compressed cubes
9 06 12 51 33 46 10 37 83 01 24 76 98 76 75 03 66 07 17 06 01 33 99 32 68 51 03 83 93 67 32 30 83 76 78 89 97 69 66 10 50 26 64 46 16 11 74 17 92 81 91 14 46 01
11g Database cannot be started with a 12c Clusterware
61 12 88 67 99894
Diagnostic enhancement to summarize sub-pool allocations in ORA-4031 trace files
Optimization to handle insert of &255 columns
&WITH& subqueries cannot be materialized inside a global transaction
&WITH& subqueries cannot be materialized inside a global transaction (or PLSQL RPC over DBlink)
Enhancement request which allows ability to selectively remove slow clients from Emon Notification mechanism
support named_pipe on asmcmd cp command
support of getfattr/setfattr on dbfs_client
Allow CBQT for some DML / DDL
Enhancement to CBO for Exadata
DBMS_RESOURCE_MANAGER.SWITCH_CONSUMER_GROUP_FOR_SESS does not accept CANCEL_SQL
Enhancement to all move of XMLSchemas objects from one schema to another schema
Active duplicate should work when connected to Standby as source DB
Improve switchover performance by changing default values
Enh: Database upgrade always gathers statistics
Bind Peeking is disabled for remote queries
Improvement on timestamp_to_scn performance
Extend DBMS_OBJECTS_UTILS to allow a recompile of a list of types
ORA-600 [3020] / ORA-333 Recovery of datafile or async transport do not read mirror if there is a stale block
Enh: EHCC does not support index maintenance on domain indexes for OCIDirPath
improve performance for serial/low dop smart scans
Startup hangs waiting for row cache lock due to open transaction against UNDO$
Diagnostic enhancement to dump ulimits to trace file for ORA-4030 etc..
Caching of statfs space usage
UTL_RECOMP is not aware of Edition based redefinition
dNFS needs to support SNMP calls over management interface
Enhancement to add DBFW-ASO integration support to the Oracle database
Add External table preprocessor support for Datapump dump files - superseded
Dynamic sampling not used on predicates with user functions
Enh: provide some control over DBMS_STATS index clustering factor computation
Enhancement to allow RMAN conversion of backups cross-endian cross-platform
Improved diagnostics for ORA-600 [729]
Diagnostic Enhancement to dump all kksfrmsp[] elements of kksfr frame structures
New Procedure dbms_xstream_gg_adm.set_checkpoint_scn
Archiver stuck but no ORA-19xxx error in alert log (messages need changing)
Integrate ASM with OAK lib
Enh: Add lkdebug command to manually adjust LMS priorities
High buffer gets for insert statement - rejection list does not fire
in-memory parallel optimizations for EHCC
V$STANDBY_LOG LAST_CHANGE# / LAST_TIME are misleading
improve asm offline handling after cell failure
Reduction of X pins to invalidate temp table
Improvement to reduce brownout time
Diagnostic enhancement to reduce shared pool latch hold time for heapdumps
Enhanacement to add Write-back flash cache resilvering support
Enhancement for ASM write-back flash cache resilvering support
Enhancement to allow move of XMLSchema objects owned by one schema to another schema - superseded
Add CLOB_CS option to WRC replay for capture files that suffer from bug
Additional alert log messages for capture / apply
Enhancement to detect the MSSM self-loop issue using DBMS_SPACE.FREE_BLOCKS
Add option to rootcrs.pl / rooha.pl to reset permissions
recovery datablock read from flash cache
Increase default log buffer read size to speed up instance/crash recovery
GoldenGate RDBMS Patch version reflected in DATABASE_PROPERTIES
Excessive buffer gets by UPDATE on OLTP compressed table
Diagnostic enhancement for DBWR to trace when a buffer cannot be written repeatively
Managed standby recovery should report nologging redo
Diagnostic enhancement to report ORA-600 on attempt to migrate private locks/pins
Finer grained control for ORA-14403 / ORA-14776 errors on SELECT .. FOR UPDATE .. SKIP LOCKED
Enhancement: ability to choose sort unique / sort group by over hash unique / hash group by based on the number of rows to process
Diagnostic enhancement for write validation
Evolved types and data do not export/import correctly with DataPump
After TTS import, RMAN incorrectly considers archivelogs created as obsolete
ORA-16014 SRL archived log is lost after graceful failover with CIA dest
ORA-600 / corruption after splitting REFERENCE partitioned table with encrypted data in parent table
LogMiner omits rowid/key information for LOB related LCRs
ORA-600 [3020] / ORA-333 Recovery of datafile or async transport do not read mirror if there is a stale block
ORA-600 [6856] on interrupt / kill using a global temporary table
CREATE TABLE fails with ORA-600 [kddummy_blkchk] with large datafile
ORA-600 [kdzhFindHeadPiece: unnewed & 1] from load into HCC table
ORA-8103 or similar from queries on partitioned table in standby
Dump block when it is found valid in a reread after it was found corrupt
Streams rule conditions like get_command_type() = 'delete' do not work
ORA-1122 ORA-1207 on Startup due to IO error during checkpoint of previous instance
Assorted Internal Errors during optimization due to corrupt statistics
corruption on securefiles with multiple writeappend calls by interleaved DMLs - superseded
ftp of a file into dbfs may get cropped file content
ERROR: failed to repair extent..... extent does not exist...
Bad supplemental redo for UPDATE / Streams capture aborts with ORA-600 [knglcflassert], [2751]
DB_BLOCK_CHECKING for OLTP table is slow with TDE
RMAN dump good block after reread finds valid data
ORA-600 [kcbgtcr_1] on transported IOT with key compression
Alert log reports misleading &Corrupt Block& message for TEMP blocks
Assorted errors Logminer with CLOBs using multi-byte characterset
* Dictionary corruption / ORA-959 due to DROP TABLESPACE. This bug is alerted in&
Online redefinition corrupts dictionary / ORA-600[kqd-objerror$] from DROP USER
ORA-600 / ORA-8103 UNUSABLE state of partitioned index is not carried across by TABLESPACE transport using DataPump
ORA-1950 occurs when executing DML after EXCHANGE PARTITION and DROP USER
ORA-959 after DEFAULT tablespace of schema dropped / renamed
View based on a pipelined function has incorrect data types
Export / Import of a Materialized View log gives corrupt including / excluding New Values option
ORA-31011 ORA-19202 after character conversion of CLOB in IOT from single byte to UTF8 using &csalter.sql&
Datapump transport_tablespaces produces wrong dictionary metadata causing errors like ORA-7445 [qeaeMinmax] / ORA-1858 etc...
Drop Materialized View log fails to clear out SYS.SNAP_LOADERTIME$ dependencies
View based on a pipelined function may loose precision/scale
Dictionary corruption / ORA-600 [kqludp2] adding duplicate variable to evaluation context
Corruption / ORA-600 after ALTER TABLE of a LONG to CLOB
Tablespace transport of XDB data puts multiple entries in XDB$TTSET causing subsequent errors
hcc ctas error leaves entry in compression$
Downgrade script to 10g can leave 11g TAB$ dictionary entries (ORA-1426)
Wrong entries for description column in DBA_TRIGGERS using synonyms
ORA-39126,ORA-1426,ORA-6512 occurs when running expdp
ORA-600 [qesmaGetTblSeg1] from deferred segment creation in RAC
ALTER TYPE DROP of attribute of embedded type leaves typeid column
ORA-600 [kqludp2] on DDL after schema migration to another user
ORA-600 [kcbgtcr_1] on transported IOT with key compression
Dictionary corruption when invalidating Editioned synonym
ORA-14097 from exchange partition
Exchange partition with virtual column may corrupt column statistics - superseded
DBV reports false SCN corruption code 6054 / 6056 - &csc higher than block scn& for V7 block
False inconsistency by ANALYZE TABLE VALIDATE STRUCTURE ONLINE in invalid_rows for PARTITION table
Direct path creates bad functional index on LOB column
Insert as Select with LOG ERRORS INTO slower than expected / corruption using IGNORE_ROW_ON_DUPKEY_INDEX hint
SMON may crash with ORA-600 [kcbgcur_3] or ORA-600 [kcbnew_3] during Transaction recovery
ORA-600 [6101] INDEX corruption with cross platform transported redo
ORA-1499 ORA-8102 ORA-600 [kdsgrp1] Bitmap Index / Table mismatch
Several errors by corrupt blocks shifted by 2 bytes in buffer cache during recovery caused by INDEX redo apply
Wrong results on IOT secondary index after DML
ORA-600 [25029] / ORA-600 [kcbgtcr_1] on create bitmap index
* ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds]. Corruption in Rollback with Clusterwide Global Transactions in RAC. This bug is alerted in&
+ Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug
P Solaris: ASM 11.2.0.3 on solaris discovers slices that start on cylinder 0
ORA-600 [koklcpb2c-read_src2] or ORA-22294 from DBMS_LOB.CONVERTTOCLOB
Logical corruption with triggers and foreign key constraints
Character strings that exceed the column size loaded by SQL*Loader in multibyte
Insert as Select with LOG ERRORS INTO slower than expected / corruption using IGNORE_ROW_ON_DUPKEY_INDEX hint
SMON may crash with ORA-600 [kcbgcur_3] or ORA-600 [kcbnew_3] during Transaction recovery
Deadlock / undetected FK violation from DML on REFERENCE partitioned table
ORA-600 [3020] / ORA-333 Recovery of datafile or async transport do not read mirror if there is a stale block
Capture process creates LCR with NULL value when table is compressed / cannot mine redo
ORA-31011 ORA-19202 after character conversion of CLOB in IOT from single byte to UTF8 using &csalter.sql&
Datapump transport_tablespaces produces wrong dictionary metadata causing errors like ORA-7445 [qeaeMinmax] / ORA-1858 etc...
ora-600 [ktspfmb_add1], [] occurred, then cannot recover with ora-600[25027]
Conventional INSERT in parallel into partitioned table can corrupt local index
LOB data may be out of sync when load BFILE to NCLOB using DBMS_LOB.LOADFROMFILE
default column value not propagated
GoldenGate ignores changes to NOLOGGING objects.
Wrong data inserted by INSERT .. SELECT if virtual columns present
varchar2 accepts more than 4000 bytes inserting from dblink
11.2 dequeue gives duplicate messages with high concurrency
OCI-21500 / ORA-600 after XML datapump export / import
Chained Rows in Compressed (EHCC) Tables are not Updated / Deleted
Refresh produces wrong results for ON-COMMIT MV in specific case
DBMS_XMLDOM.SetDoctype generates empty double quotes when sysid or pubid is NULL
Wrong data in MView after fast refresh with partitioned MView
ORA-1122 ORA-1207 on Startup due to IO error during checkpoint of previous instance
Replay produces wrong results for CLOB data in multibyte database
corruption on securefiles with multiple writeappend calls by interleaved DMLs - superseded
Network link export/import of partitioned table loads all rows into single partition
GET_ROW_TEXT returns incorrect value for DATE column
SGA memory corruption / ORA-7445 when modifying uncompressed blocks of an HCC-compressed segment
Adding a column with DEFAULT and NOT NULL constraint disabled causes problems
wrong results with descending range scan
Logminer adds incorrect columns in presence of DEFAULT VALUE column and trailing NULLs
NOT NULL constraint ignored inserting NULL to NOT NULL LOB column (missing ORA-1400)
Compound trigger inserts a NULL value into TIMESTAMP column
Duplicate entries when processing large XML data
Wrong result on temporary table with parallel execution
Logical corruption of IOT secondary indexes in cases where the key is all NULL
ORA-600 [kdblkcheckerror] [6126] / ORA-600 [17182] for DELETE / INSERT (QMD / QMI) in COMPRESS BASIC table due to negative avsp
Logical data corruption from dataPump export/import of XMLType across character sets
Wrong results from fast refresh MView having outer joins
SELECT FOR UPDATE returns wrong result when function based index used
ORA-7445 / Unique constraint violated with _optimizer_join_factorization = true
Wrong results on mview complete refresh over database link
Incorrect conversion exporting/importing attribute values from binary XML tables
Wrong results in create materialized view with subqueries
Possible data loss durings Securefile writes - can cause ORA-600 etc..
At Streams destination an insert into LOB stored as Securefile fails with ORA-22926 / piecewise update may miss data
DBMS_LOB.substr truncates input after 24991 bytes with multibyte characterset
UPDATE sets wrong column values when using virtual columns with an index on predicate
Binary XML data may not be readable after Tablespace transport
Wrong results from CTAS with an IOT and functional secondary index
+ Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug
+ ORA-1206 in SOURCE database after RMAN duplicate
DBMS_SPACE_ADMIN.TABLESPACE_FIX_BITMAPS fails with ORA-600 [kddummy_blkchk] / ORA-600 [kdBlkCheckError] / ORA-607
Rare ASM corruption after disk resync
ora-600 [ktspfmb_add1], [] occurred, then cannot recover with ora-600[25027]
PQ slave dies with ORA-600 [kdblddr_2]
ORA-600 [kdzhFindHeadPiece: unnewed & 1] from load into HCC table
Dump block when it is found valid in a reread after it was found corrupt
Lost write type corruption using ASM in 11.2.0.3
ORA-600 [kclchkblk_4] when doing flash back
ORA-600 [6120] / corruption of IOT in cross platform transported tablespace
Bad redo / ORA-600 [kdBlkCheckError] .. [6135] for opcode 19.1 redo
RMAN dump good block after reread finds valid data
ORA-600 [3020] in Bystander standby recovers wrong log after failover / ORA-752 if db_lost_write_protect is enabled
Hang from concurrent drop / create of materialized views
Create materialized view or drop materialized view encountered ORA-60
deadlock in ASM processes with concurrent operations
Deadlock / undetected FK violation from DML on REFERENCE partitioned table
With optimizer_use_pending_statistics = true TRUNCATE table may fail with ORA-4020 self deadlock
Redefinition causing deadlock between &row cache lock& and &library cache lock&
dbms_assert.sql_object_name / dbms_utility.name_resolve self deadlock (ora-04020)
Deadlock of PS and BF locks during parallel query operations
&create or replace outline& raises ora-04020
ORA-4020 / deadlock dropping a materialized view
Structured XMLIndex type descriptor dictionary cache is not populated properly
UTL_RECOMP.RECOMP_PARALLEL can deadlock in an Editioned environment
Library cache deadlock if table has no statistics
Sessions running TRUNCATE causing a deadlock, even if the constraints are disabled
Hang from global transaction in RAC with clusterwide global transactions enabled
Hang / deadlock involving ACCOUNT_STATUS object for concurrent LOGON and ALTER USER
Drop materialized view hangs
Deadlock waiting for 'library cache: mutex x' while producing an ORA-4031 diagnostic dump
Deadlock between parallel query and resource manager call
Locks on dc_users kept too long
mutex deadlock having SQL baselines on recursive dictionary cursor
Database hangs when executing multiple MV DDL's in parallel
Deadlock on CUBE during build
ORA-60 deadlock detected while executing expdp
Deadlock between ALTER TABLE ... SHRINK SPACE and concurrent SELECT
Deadlock between partition maintenance and parallel query operations
dbfs hangs with deadlock between file remove and file concatenation
TRUNCATE table hangs in RAC with &reliable message& wait if fix
Part of fix
missing from 11.2.0.3 - disabled deadlock detection for Cursor build locks (on $BUILD$)
SELECT FOR UPDATE deadlock with waits for 'buffer busy waits' or 'enq: TX - contention'
ORA-4020 deadlock from concurrent rebuild index partition of a join index
Rare instance hang: deadlock between 'row cache lock' and 'cursor: pin S wait for X'
XML schema migration process errors out with ORA-4020
self deadlock in 'library cache pin' with pipeline function and edition
Self deadlock in 'library cache pin' in a function using type and Edition
Active Dataguard Hangs waiting for library cache lock on DBINSTANCE namespace with possible deadlock
P AIX: Unrealistic CPU Time / DB time with 11.2.0.3 for IBM AIX
Diagnostic enhancement to summarize sub-pool allocations in ORA-4031 trace files
Hang manager may trigger unnecessary SYSTEMSTATE dumps on ASM instance
Hang Manager enhancement to report suspicious hangs to circular files
Event 10235 level 512 can cause false ORA-7445 errors
V$PGA_TARGET_ADVICE view returns fewer (no) rows for larger setting of PGA_AGGREGATE_TARGET
Patch to help minimize impact of lost changes on undo related data dictionary tables as in bug
ORA-7445 or large byte counts in PGA memory detail summaries
blocker for wait event &gc current request& not identified by hanganalyze
Call Stack Corruption using query rewrite and dblinks
V$DB_OBJECT_CACHE.SHARABLE_MEM show excessive amount of memory used
&table scan rows gotten& statistic is incorrect for ehcc
dumping header of temp files in mount mode could raise ora-1157 and ora-1110
Diagnostic enhancement to dump ulimits to trace file for ORA-4030 etc..
Incident file is not generated correctly on VxFS
Excessive trace files containing kwqieQNC messages generated by propagation
Wrong results with SQL_TRACE or 10046 or STATISTICS_LEVEL=ALL / Slow Parse
Limit mirror side diagnostic dumps in kclblkdump()
Many trace files generated with &redo_gen: verifying populated key&
It takes time to detect an Archiver hung on I/O
Improved diagnostics for ORA-600 [729]
ORA-7445 [kfkrqDump] in ASM dumping PROCESSSTATE
Diagnostic Enhancement to dump all kksfrmsp[] elements of kksfr frame structures
Diagnostic enhancement for Result Cache
Diagnosability issue - mutex wait &idn& value truncated in session wait output in tracefile
gipcd log information grows too fast
diagcollection.pl --afterdate doesn't always work
Enable automatic tracing for ORA-600 [kfmdSlvLeaveWrt1] in ASM
Dump block when it is found valid in a reread after it was found corrupt
statistics &parse count (total)& and &session cursor cache hits& miscounted
Enabling LMS trace 10899 affects performance and produces very large LMS trace
ORA-600 [15709] trace produces very large systemstate trace
crsd oraagent log grows up too fast
Diagnostic enhancement to reduce shared pool latch hold time for heapdumps
Problems with optimizer cursor sharing diagnostics
Diagnostic enhancement for server side XA API tracing
Diagnostic to help for ORA-7445 [delprecg] when executing delete
Ensure automatically generated systemstate dumps write into separate files
Additional RAC diagnostic for ora-7445[kjbrdrmcvtq()]
Add additional diagnosability trace in ASM
Overcounted 'physical read optimized' statistic with writeback flash
Additional diagnostics for error ORA-27550
Provide details on AIX/HP-UX when check on ora.net1.network fails
Hang manager can incorrectly ignore a hang
RMAN dump good block after reread finds valid data
ORA-7445 [kgitrc] writing trace for some other error
Diagnostic enhancement for DBWR to trace when a buffer cannot be written repeatively
Diagnostic enhancement to report ORA-600 on attempt to migrate private locks/pins
Diagnostic enhancement for write validation
* Dictionary corruption / ORA-959 due to DROP TABLESPACE. This bug is alerted in&
* ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds]. Corruption in Rollback with Clusterwide Global Transactions in RAC. This bug is alerted in&
+ Registration of 11.2 database fails against 12.1 CRS stack (required fix for 11g DB with 12c GI)
+ Cannot drop/replace trigger in editioning environment
+ ORA-1206 in SOURCE database after RMAN duplicate
P Windows:KUP-4027 is reported with external table if file name includes 0x5c as a part of multibyte character
P Windows: High load may cause TCP interconnect port exhaustion
P Solaris: nslookup return value breaks oracle DB for RAC install
P HPIA: ORA-313 and ORA-312 followed by ORA-600 [kcidr_io_check_common_2] for files in RAW Devices
Datapump EXPDP export of GRANTS fails with ORA-39127 / ORA-6502
ORA-372 reported against read-only tablespaces when executing DBMS_SPACE
Replay errors after capturing a workload with CURSOR_SHARING=FORCE
ORA-1400 raised when bind variables are not bound as expected
SGA memory leak possible for &KSN WaitID& memory when using shared servers
RMAN restore controlfile for standby does not create correct controlfile type
Different error raised after quota granted/revoked when resumable_timeout enabled
ora-1489 from dbms_stats on multicharacter table
ORA-39126 / ORA-1427 from EXPDP of IOT with XMLTYPE in overflow segment
orion fails with ora-27061: waiting for async i/os failed
error ora-39726 while dropping column on compressed partitioned table
Exchange partiton table involving function based index fails with ORA-14130
Imp utility fails with error IMP-9 / IMP-27 when importing large LOB data
Create materialized view or drop materialized view encountered ORA-60
ASMCMD alert log created with wrong ownership
ORA-29275 when selecting from V$SQL_MONITOR
Log archive dest alternate location not checked correctly
DBMS_MVIEW.explain_rewrite may fail or produce incomplete message in multibyte character set database
Data pump import fails for logon trigger with &ORA-4072 invalid trigger type&
ORA-01219 with stored outlines
ORA-12801 / ORA-60 / ORA-600 [13030] from PDML in RAC
DBMS_STATS.COPY_TABLE_STATS assumes local index partition names match table partition names
INSERT using WITH clause may fail with ORA-28115 if temp table used
ora-979 with query rewrite
ORA-26010 from impdp after adding a column with &DEFAULT xx NOT NULL&
Parallel query may fail with ORA-1008/ORA-12801
DBSNMP.BSLN_INTERNAL reports ORA-6502 running BSLN_MAINTAIN_STATS_JOB
Duplicate rows in V$MUTEX_SLEEP / Mnnn traces show &KEWROCISTMTEXEC ... ORA-00001 ...& messages
Not able to start DRCP on Data Guard active physical standby
Assorted errors referencing ROWID from a view with subquery
Logical Standby Apply stops for some NLS_SORT values (ORA-26674)
BACKUP INCREMENTAL FROM SCN on standby throws RMAN-06764
ORA-28394 occurs when a NULL value is inserted in the table with TDE and a Materialized View Log
Unnecessary ORA-32550 raised
Logical Standby skips some rows inserted after instantiate table and may produce ORA-26786 ORA-26787
Data Pump transportable tablespace import fails with ORA-39002 / ORA-39322 with TIMESTAMP data
ora-911 with ANALYZE TABLE VALIDATE STRUCTURE CASCADE FAST if table has special characters
ORA-24330 &internal OCI error& during DML
ORA-1422 from dbms_xmlstorage_manage.renameCollectionTable
ORA-2264 from ALTER TABLE statement
ORA-4031 with hint /*+ CURSOR_SHARING_EXACT */ - excessive &KKSSP^nn& memory
expdp fails with ORA-6502 when TABLES=... has a very large number of tables
Wrong results / unstable Exec Plan / ORA-979 from SQL using positional binds in PL/SQL
LSX-249 on schemavalidate() with NLS_NUMERIC_CHARACTERS=',.'
ORA-28267 from JDBC issuing SQL over DB link to 10g DB ( relates to E2E_CONTEXT namespace)
Active duplicate should work when connected to Standby as source DB
flashback query which passes scn value via bind variable fails with ora-8181
SQL*loader-502 error at loading of CLOB data
Direct load insert may result in ORA-1 errors during concurrent online index rebuild operation
ORA-12008 / ORA-904 during fast refresh of MAV with functional indexes
ORA-2063, ORA-1719 with distributed query with OUTER join if remote database is prior to 11.2
Fix of bug 7148689 can cause ora-1719 for query with outer join and ORs
Restore of compressed backup can signal ORA-19863
All children output even with maintain DOM false (schema validation fails)
Alter materialized view compile makes an INVALID Mview when definition includes TO_LOB(column)
Data pump export fails with ORA-39126 / ORA-1690
ORA-604/ORA-3212 during startup by SYSOPER
ORA-21602 during DBMS_STREAMS.CONVERT_LCR_TO_XML when extra attribute TXN_NAME is used
Apply process fails with ORA-26714 due to ORA-1400
ORA-30091 from IMPDP with TIMESTAMP columns
Create XMLIndex does not use existing tablespaces for partitions
ORA-22933 / ORA-955 / ORA-2306 Creating a private synonym
Standby Statspack install fails with ORA-2085 when standby DB enforces global naming (GLOBAL_NAMES=TRUE)
With optimizer_use_pending_statistics = true TRUNCATE table may fail with ORA-4020 self deadlock
ORA-600 / ORA-8103 UNUSABLE state of partitioned index is not carried across by TABLESPACE transport using DataPump
CREATE DISKGROUP fails with ORA-15018 ORA-600 [17090]
Redefinition causing deadlock between &row cache lock& and &library cache lock&
ORA-30175 from remote SQL involving a TIMESTAMP
dbms_assert.sql_object_name / dbms_utility.name_resolve self deadlock (ora-04020)
ORA-1427 when executing DBMS_HM.run_check
DBMS_XSLPROCESSOR.clob2file fails with ORA-1426 for large(&2g) CLOBs
ORA-1790 / ORA-600 [kkqtsetop.1] / ORA-1789 during SET operation query with redundant WHERE conditions
ORA-4029 &error ORA-7445 occurred& from DBMS_I_INDEX_UTL
Wrong ORA-14403 raised by SELECT FOR UPDATE SKIP LOCKED - superseded
insert into table with unusable domain index doesn't honor skip_unusable_indexes
ORA-12801 / ORA-904 on INSERT AS SELECT across DBLINK run in parallel
Invalid ORA-30937 adding collection member with repetitive insertChildXML/appendChildXML
ORA-1291 &missing logfile& from adhoc logminer
RMAN-3002 ORA-1: unique constraint (ckp_u1) violated after dataguard switchover
ORA-600[qesmagetpamr-nullctx] / ORA-14091 with distributed query with local partition table
ORA-30439 / ORA_12008 / ORA-8176 on refresh of multiple materialized views at once
ora-00979 by grant on view created based on type
ORA-1950 occurs when executing DML after EXCHANGE PARTITION and DROP USER
ORA-1 on SYS.I_TABPART_BOPART$ When Doing SPLIT SUBPARTITION on Table with a Child Reference-Partitioned Table
LPX-210 from IMPDP of XMLType data with REMAP_SCHEMA
RMAN-6054 or ORA-308 restoring the database
Standby DB overwrites symbolic link for datafile REUSE
Windows: asmcmd CP does not accept capital drive letter on Windows platforms
Deadlock of PS and BF locks during parallel query operations
ORA-30175 from remote select using TIMESTAMP WITH TIME ZONE data types
ORA-1400 on SQL Apply / logical standby for LONG / LONG RAW columns if table has a LOB
ORA-1555 / unexpected space use for partitioned Securefile Lob
ORA-25191 running automatic system generated job GATHER_OPTIMIZER_STATS
Select of DATE column gets ORA-28500 over HS
dbms_stats raises ora-1476 with approx_global granularity
Cannot drop empty datafile from tablespace with duplicated relative file no (ORA-3262)
ORA-904 &XMLTYPE invalid identifier& using XMLTYPE in a DEFAULT column value clause
ORA-600 [ktspfmdb:objdchk_kcbnew_3] after purging single consumer queue table
ORA-959 after DEFAULT tablespace of schema dropped / renamed
Frequent ORA-338 during controlfile restore with ASYNC Data Guard
ORA-64445 / ORA-64430 from inPlaceEvolve
Unable to actualize objects into child Edition - ORA-955 - superseded
Data pump import of a table with an XMLType column fails with ORA-600 [klxpr_30]
Scheduled jobs running late spawning new processes / ORA-18 possible on jobs
ORA-4030 due to &KGL Iterator information&
ORA-12899 when executing DBMS_STATS with multi-byte object name
Tablespace Point in Time Recovery (TSPITR) of read only tablespace fails with ORA-1644
ORA-600 [ztsmdwl failed] is raised while executing CTAS
DBUA fails during upgrade process with ORA-44
ORA-22813 inserting into table of XMLType
&create or replace outline& raises ora-04020
ORA-14403 on select with WITH clause and concurrent partition DDL
ORA-12899 updating WRH$_SEG_STAT_OBJ
Streams apply aborts with ora-26752 , ora-26892 w/ xml-binary
Cannot create second application vip on the different subnet on 11.2
Switchover fails with ORA-1093
ORA-600 [3020] / ORA-333 Recovery of datafile or async transport do not read mirror if there is a stale block
ORA-4020 / deadlock dropping a materialized view
SQL apply fails with ORA-932 when XMLQuery has NUMBER binds
Drop directory in asmcmd fails with ORA-600[kfaDelTree00]
srvctl config listener -l listener -s 1 returns PRCN-2037 when one node is down
ORA-2292 refreshing a materialized view with a primary key on it
ORA-4030 (callheap,qerrmbv[]: qerrmobnd) from distributed query with subquery
OCISessionGet() returns ORA-24399 after failover
Disabled invalid table trigger can still block DML with Editions (ORA-4098)
RMAN import catalog error- ORA-2291 &integrity constraint SITE_TFATT_F2 violated&
&consider fresh& gets ORA-3001 against writable materialized views
ORA-1014 on RMAN backup after switchover/failover on new primary site with IO slaves
ORA-28112 using mixed case identifiers for RLS policy function
Missing public synonym ALL_TRANSFORMATIONS
ora-904 WITH CONNECT BY and dblink
ORA-1031 setting resumable_timeout in PQ slave (eg during MVIEW refresh)
dumping header of temp files in mount mode could raise ora-1157 and ora-1110
ORA-12008 when _mv_refresh_use_stats=true
SQL Tuning advisor / EXPLAIN PLAN gets ORA-932 for bind on inlined view for a DATE column
Import fails due to system generated name in table with XMLType column
&ORA-979: not a group by expression& not reported when it should
SYSTEM tablespace grows (mon_mods_all$ and col_usage$)
Capture dies with ORA-1346 after source database fails over to standby or hangs after OPEN RESETLOGS
DBMS_FILE_TRANSFER raises ORA-15080/ORA-15081/ORA-19502/HARD CHECK FAILED messages in Exadata
ORA-1466 querying a Global Temporary Table in a READ ONLY transaction
DBMS_SCHEDULER.RUN_CHAIN with STEP_STATE_LIST not working
ORA-31011 ORA-19202 after character conversion of CLOB in IOT from single byte to UTF8 using &csalter.sql&
ORA-27302 or ORA-27369 running EXECUTABLE job as SYSDBA OS user other than code owner
Datapump transport_tablespaces produces wrong dictionary metadata causing errors like ORA-7445 [qeaeMinmax] / ORA-1858 etc...
ora-979 / Dump on kkqctSetNoDecryptToEncryptOpn with group by over encrypted columns
Long parse time / hang / ORA-979 for SQL with nested CASE expressions with CURSOR_SHARING enabled
Select against V$ACCESS / V$OPEN_CURSORS fails with ORA-4029
ORA-12018 / ORA-904 refreshing MView using CONVERT_TO_STD_GEOM with a Spatial index
Smart Scan fails with ORA-27618
Missing END markers in supplemental log data for UPDATE to table with & 255 columns
Unexpected ORA-2303 creating a TYPE in a child Edition
ORA-1031 &insufficient privileges& when granting privileges
Drop Materialized View log fails to clear out SYS.SNAP_LOADERTIME$ dependencies
Structured XMLIndex type descriptor dictionary cache is not populated properly
LMS hangs with &SGA: allocation forcing component growth& wait event when auto SGA tuning is enabled
Multiple records in LOGMNR_SESSION$ causing V$DATAGUARD_STATS to raise ORA-1422
High version_count / ORA-942 on statements where DDLs happen over the objects.
ORA-932 creating an OUTLINE with a LOB bind
xa_commit() returns XA_RBROLLBACK but prepared transaction remains on server
Invalid ORA-1427 from XML query involving &fn:collection&
SHRINK SPACE receives ORA-16211 on real time apply logical standby
ORA-1790 from DESCRIBE of query with a SET operation and a BIND in the select list
Unnecessary ORA-4031 for &large pool&,&PX msg pool& from PQ slaves
ORA-8102 signaled by q000* processes operating on queues with retention
ORA-1031 when connecting as SYSDBA if Unix group member list is large
ora-12801 and ORA-1460 with parallel query
ORA-600 [25027] [ts#] [1] or false ORA-1 during dml while index is being rebuilt online
apply aborts with ora-26798, ora-26804 with xml-binary
ORA-1499 ORA-8102 ORA-600 [kdsgrp1] Bitmap Index / Table mismatch
Materialized View defining query length & 64k raises ORA-32411
Shared pool leak of &KGLHD& memory when using multiple subpools
SMON reports ORA-604/ORA-1 on SYS.SMON_SCN_TIME_TIM_IDX
Slow parsing of large number of subqueries eligible for coalescing.
CLOB -& string conversion errors for NULLs with UPI client
ORA-3113, ORA-3114 for query over database link after restarting remote DB
RMAN duplicate fails with catalog and auxiliary DB credentials stored in wallet
ORA-1476 while outputting the AWR report
ORA-30091 selecting TIMESTAMP WITH TIME ZONE column from remote table
DRG-50857 from IMPDP of Text index with Sections
ORA-29516 from stored Java calling Runtime.exec() to invoke an external process
ORA-4025 when cursor is obsoleted which uses literal replacement
DBNEWID [ nid ] does not allow TARGET=/ (NID-106)
ORA-6502 setting IGNORE_TRANSACTION for Capture with name & 17 characters
ORA-2097 / ORA-1031 refreshing materialized view in ASM environment
Excessive memory use by DIAG / DIA0
ORA-29981 with select query with database Change notification
data pump of a table fails with ORA-39126 ORA-6502 lpx-00217
ORA-1733 from SELECT FOR UPDATE of CLOB with nested views
Data mining query gets ORA-4030
wrc mode=get_tables errors out with ORA-21500 / ORA-12899
Unexpected ORA-28000 / account locked on heavily loaded system
ORA-2372 / ORA-26093 ORA/-2374 during datapump import
ORA-308 cannot open archived log when dNFS is enabled
ORA-4031 with high &KTC latch subh& memory usage
ORA-1000 Maximum open cursors exceeded in Logical Standby database
GoldenGate may raise ORA-26926
ORA-14766 during SQLLOADER data loading with parallelism
ORA-4030 / excess PGA memory use with XDB XML queries
Many child cursors / ORA-4031 with large allocation in KGLH0 using extended cursor sharing
ORA-30992 ORA-1858 from XMLType.schemavalidate() when NLS_TERRITORY set
ORA-1289 from DBMS_STREAMS_ADM.get_scn_mapping if DB has two archive destinations
ORA-7445 [kghalo] / memory errors / ORA-4030 from XMLForest / XMLElement
ORA-3146 from AQ propogation from 11.2.0.3 to 11.2.0.2
ORA-979 when using user-defined operator in GROUP BY
Unexpected ORA-976 using LEVEL / PRIOR / ROWNUM in an ANSI &ON& filter predicate
Errors from SQLLDR loads into non-partitioned tables with deferred segment creation
ORA-14401 by SQL*Loader direct path load with &SUBPARTITION FOR& clause
Logminer raises OERI:krvxruts004 / GoldenGate raises ORA-26914
Intermittent ORA-29861 on DML on table with XMLINDEX with concurrent DBMS_STATS
ORA-6502 generating HTML AWR report using awrrpt.sql in Multibyte characterset database
ora-26666 by GoldenGate Integrated Extract
Creation of RAC service gets error PRCN-2043
ORA-22324, ORA-22332, ORA-972 when trying to alter a user defined type
Duriing EXPDP/IMPDP the DM process fails with ORA-7445 [nszgclient] if an AFTER LOGON trigger exists
Insert / Merge SQLs with a subquery may not report ORA-904 when they should, or may report ORA-904 when they should not
ORA-1866 &the datetime class is invalid& from SELECT with function based index
MERGE statement using WITH clauses is not allowed with batch errors
RMAN retry timeout of snapshot controlfile enqueue is too short
DBMS_SCHEDULER.disable fails with ORA-911 when schema name is & 25 characters
ORA-918 from ANSI SQL over database link with 30 character column name
Apply proces stops with ORA-1918 &user 'xx' does not exist&
ORA-19875 on Restore After Catalog of Backuppiece From Multi-Section Backup
ora-1719 with subquery coalescing
ORA-21780 selecting an XMLElement
ORA-20001 &illegal sample percent 0.001 ...& from DBMS_STATS
ORA-29952 when rebuilding an XMLIndex partition
SQL apply fails with ORA-28221 &REPLACE not specified& for certain &USER& and &ROLE& DDLs
EXP/IMP disabled in Database Vault environment
ORA-22275 from user defined UPD conflict resolution with CLOBs
DBA_SCHEDULER_WINDOW_LOG shows warning &Window opened but resource plan switch failed&
ACFS-5062 when there is no 'ora.registry.acfs' resource
Queries raise ora-904 if extended stats/virtual columns use a dropped/unused column
GoldenGate raises OGG-01755
RAC hang/crash/ORA-29771 due to deadlock involving &latch:gc element&
ORA-19563 from RMAN convert on datafile copy transferred with DBMS_FILE_TRANSFER
ORA-12899 creating table with virtual columns based on a DATE type
Orphan rows in MV metadata can cause ORA-32422 on DBMS_REDEFINITION.start_redef_table
ORA-10637 occurs on SHRINK of a partitioned table with deferred segments
Unexpected ORA-1427 error with single row subquery
ORA-41400 during ALTER DATABASE CHARACTER SET internal_use internal_convert
PQ slave dies with ORA-600 [kdblddr_2]
OCI-21500 / ORA-600 after XML datapump export / import
ora-904 on dyn sampling sql on collection with fix for 6708183 enabled
False ORA-4016 occurs even though sequence exists (especially after exp/imp seq)
ORA-8102 on UPDATE statement with subquery for an indexed column
ORA-10663 when shrinking a master table of an MVIEW with primary key
Import fails with ORA-1031 for some TIMESTAMP data
ORA-16534 from the broker when setting apply-off
DB instance terminated due to ORA-29770 in RAC
Segment advisor leaks private memory - ORA-4030 (koh-kghu call ,pmuccst: adt/record)
ORA-1089 over database link involving transitioned primary
ORA-600 [kdzhFindHeadPiece: unnewed & 1] from load into HCC table
Local session to DB is lost if remote DB is shut down
RMAN-6004 / ORA-2298 datafile missing after RMAN resync for DB with transported tablespace
ora-932 with ADT and Join Elimination
CVU does not check the ASM running status
RMAN duplication erroneously fails with ORA-19804 using fast recovery area
ORA-1867 from Datapump or DBMS_METADATA.GET_DDL for INTERVAL partition using &TO MONTH& clause
A high CPU_COUNT can cause ORA-68 for parallel_max_servers
Downgrade script to 10g can leave 11g TAB$ dictionary entries (ORA-1426)
ORA-1426 during DBMS_REDEFINITION.start_redef_table
ORA-8103 or similar from queries on partitioned table in standby
ORA-1031 from Streams queries when Database Vault in use / blank username in DV audit
Instance recovery waits for 1 minutes with error ORA-16040
dbms_dbverify may fail with dbv-111: oci failure (4157) ora-600 [kudbvslfw1]
ORA-16014 SRL archived log is lost after graceful failover with CIA dest
Excessive KQR X PO& allocations in a RAC environment (can cause ORA-4031)
Query rewrite fails with named views in queries / errors or wrong results after rewrite
ORA-1078/OERI:kspgip1 with parallel_servers_target
ORA-1403 raised by GoldenGate
ORA-16014 after activation of standby database
Query using DBA_TABLESPACES (X$KCFISTSA) can leak cursors and give wrong results
ORA-12012 / ORA-6502 from Segment Advisor (DBMS_SPACE/DBMS_ADVISOR) for LOB segments
ORA-51106 / ORA-48101 / ORA-48102 repeating in alert log
OCI migratable session code fails with ORA-21500
ORA-16000 in read only database - superseded
ORA-1017 while connecting as SYSDBA with enterprise users
False ora-01489 on recursive WITH clause when concatenating columns
ORA-1878 dequeuing from single consumer queue using dequeue by condition
False ORA-1779 from UPDATE
ORA-600 [opiodr: call 2] can occur if some other error occurs
ORA-1122 ORA-1207 on Startup due to IO error during checkpoint of previous instance
STATSPACK.snap returns ORA-1
ORA-21700 / ORA-7445 from ODCI domain index and PLSQL with partitions
WRH$_SQL_PLAN not purged leading to excessive SYSAUX tablespace growth
&LGWR-LNS wait on channel& following NSA process termination
ORA-1741 &illegal zero-length identifier& in dbfs_client trace
ORA-8103 during insert / update of basicfile LOB in assm segment using space search cache
ORA-942 from a query with star_transformation_enabled=true and subquery partition pruning in RAC
enabling/disabling constraints makes dml timeout
ORA-600 [qkebCreateConstantOpn1] / ORA-1861 from SQL on partitioned table
ORA-14403 from CREATE TABLE as SELECT operation against a partitioned table
ORA-10655 on sql apply after shrink space check ddls
Parallel / direct path DDL fails in hybrid columnar compression table
Apply ORA-1 on insert into partitioned source table rather than target change table
Attempts to drop views in old Editions results in ORA-4063
Deleting an ASM file that doesn't exist signals ORA-15012
ORA-904 from SPA compare trial instead of ORA-13793
RMAN duplicate excluding & 1000 tablespaces fails
ORA-1719 on ANSI Full Outer Joins with ORs
IMPDP fails with ORA-31693/ORA-6502/ORA-1403
ORA-937 error from SQL with non referenced window functions
ORA-24346 during workload capture pre-processing
ORA-4031 with high memory utilization in the 'init_heap_kfsg' subheap / &ASM map headers& under 'init_heap_kfsg'
IMPDP fails to import function names with special characters associated with a VPD policy
DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE gets ORA-1008 if bind variables are not captured
ORA-60016 altering retention of Securefiles RANGE partitions
ORA-30052 on flashback version query
MMAN failing to donate granules despite unused PGA (possible ORA-4031)
Parallel MERGE statement with error logging clause fails with ORA-1722
ORA-917 parsing SQL with indicator binds with CURSOR_SHARING
RMAN DUPLICATE fails with RMAN-6054
ORA-9925 can occur writing audit if ORACLE_PATH is set
AQ propagation reports ORA-30757 and ORA-21522 when DBs have different character set
ORA-22053 &overflow error& from HS connection
ORA-14297 occurs on second execution of EXCHANGE PARTITION
ORA-7445 [lxregmatpush] / spin when using REGEXP_SUBSTR
ORA-16000 in PQ slave in READ ONLY database with FGA
ORA-4030 occurs at 16gb of PGA even if it could grow much larger
ORA-942 using LOB through Editioned View across schema boundary
dbms_shared_pool.purge raised ora-6570 on obsoleted child cursors
ORA-10655 on sql apply after shrink space check ddls
ora-30927 on active data guard
ora-01115 during smart scan if there is offline disk in a mirrored disk
ORA-1400 creating Materialized View with ANSI join if patch
installed - superseded
ORA-1122 ORA-1208 after database crash when alter database end backup was ongoing
ORA-1452 during upgrade to 11.2 creating index on WRI$_OPTSTAT_SYNOPSIS_PARTGRP
SQL involving XMLTABLE() may report a false ORA-933 or ORA-2000
Online Create / rebuild index on NVarchar2 column fails with ORA-910
ORA-2292 using RESTRICT_ALL_REF_CONS hint and SET CONSTRAINT=Immediate
A query with table function and CAST() encounters ORA-932
ORA-15287 setting ASM &storage.type& to &zfssa&
Wrong results / errors from string operations on XMLType
FBDA may spin or signal error if tracked table has special column name
ORA-942 on DMLs after an illegal drop of a MV log (if fix
ORA-24315 using recnum column type
EXPDP of transportable tablespace fails with ORA-39126 / ORA-01422
Adding a column with DEFAULT and NOT NULL constraint disabled causes problems
ORA-6553: PLS-801: [pklsdlp:dependency verification] in ADG
ORA-976 in 11.2.0.3 on query with ANSI join that ran successfully in 11.2.0.2
Build deferred remote MV refresh can fail with ORA-12899
DIA-49309, DIA-48001 from SQLTCB
Under DV realm ALTER TABLE UPDATE INDEXES PARALLEL fails withORA-14327
ORA-4031 in ASM as default memory parameters values for 11.2 ASM instances low
ORA-1427 from DBMS_OBJECTS_UTILS.UPGRADE_DICT_IMAGE during upgrade
Logminer adds incorrect columns in presence of DEFAULT VALUE column and trailing NULLs
DBMS_STATS.GATHER_TABLE_STATS INCREMENTAL fails with ORA-20005
ORA-32319 with ON-COMMIT MView and remote fast refresh MView
ORA-28667 when redefining IOT table with copy_constraints = TRUE
False ORA-979 from query with PLSQL function predicate and ROWNUM
ORA-22294 during copy of a Securefile
db crashes while writing a datafile whose resync ends half created (uncommitted)
ORA-1219 during FSFO (fast start failover)
Sort runs out of temp space in RAC even when temp space is available
DBMS_STAT_FUNCS.NORMAL_DIST_FIT errors with ORA-907
DBMS_REDEFINITION fails in XA with ORA-2054 / ORA-2051
Datapump TABLE_EXISTS_ACTION=REPLACE import of AQ table gets ORA-24019
IMPDP reports wrong number of rows imported / ORA-1426 for very large numbers of rows (&2Gb)
RMAN-6004 / ORA-1455 from RMAN with recovery catalog
ORA-12008 / ORA-1031 during refresh of MView containg XMLType CLOB
ORA-] / ORA-600 [knclprstr:str] with fix
present at Streams target when using TIMESTAMP data
lwc returns ora-01280 instead of real error.
ORA-9925 can occur writing audit if ORACLE_PATH is set
ORA-] on server due to bad bind attempt in client
capture process dies with ora-22275 invalid lob locator
Direct path insert on non-local domain index fails with SKIP_UNUSABLE_INDEXES=False
ORA-39126 error on impdp of partitioned table with virtual column
ORA-12008 / &ORA-1426 numeric overflow& on MV refresh
ORA-4025 with CURSOR_SHARING / Dynamic Sampling
RMAN fails with incorrect error ORA-907, when supplied date format is incorrect
Apply process fails with ORA-1461
ORA-6570 raised when trying to unkeep obsoleted child cursors in 11.2.0.3
XDB install fails due to not checking the correct tablespace block size
ORA-1775 may be reported masking some other error
ORA-1422 raised by DBMS_XPLAN
ORA-1466 from FLASHBACK query / excess FDA space use
Streams automatic merge job fails with ORA-26883 in RAC
ERROR:ORA-31011 ERROR:ORA-19202 ERROR:LPX-224 SQL:XMLAGG
Materialized view refresh with parameter nested=true fails with ORA-23401
Not able to read spfile from ASM diskgroup and disk with sector size of 4096
Wrong results with query involving range partitioned empty table - superseded
Suboptimal plan for V$ queries / ORA-12850 from GV$ queries
Part of fix
missing from 11.2.0.3 - disabled deadlock detection for Cursor build locks (on $BUILD$)
ORA-38500 from DBMS_METADATA_DIFF
ALTER TABLE .. SHRINK SPACE against base table of join mview fails with ORA-10663
lwcapture sometimes abends when re-attaching to logminer
ORA-19022 from XML query
UPDATE fails with ORA-1779
RMAN duplicate fails with ORA-19505 with duplexed archivelog
SQL fails with ORA-1467 from fast aggregation
Inter node parallel flashback query fails with ORA-1555
False ORA-6508 errors in Editioned environment
ORA-38729 from FLASHBACK to guaranteed restore point on standby
ORA-1466 in read only transaction after upgrade from 9i
SOAP fault when processing NULL values in XML DB native web services
ORA-4020 deadlock from concurrent rebuild index partition of a join index
ORA-30757 propagating between different TIMEZONE DST versions
Connecting as non-SYS user produces ORA-4024 with SQL profile on dictionary SQL
Wrong Results / False ORA-1578 in SuperCluster
ORA-23605 when setting MAX_SGA_SIZE, MAXIMUM_SCN
ORA-38729 not enough flashback database log data to do flashback
RMAN tape restore failover fails ORA-7445 [ksfqrbuf]
ORA-14766 / ORA-14403 during concurrent partition maintenance
ORA-15242 can't set storage.type to ZFSSA [dnfs specific]
Excessive Memory usage with Extended Cursor Sharing
ORA-904 on merge statement after upgrading from 10.2.0.5 to 11.2.0.3
Replication between 11g and 10g database after 11g upgrade errors using SYS.XMLTYPE
ORA-979 from a valid query with bind in GROUP BY clause
ORA-932 ora ORA-7445 under kokscold()
ORA-604, ORA-448, ORA-600 messages signalled incorrectly on apply error shutdown
ORA-4031 / Queries against SYS_FBA_TRACKEDTABLES not shared (do not use binds)
add tempfile at physical standby fails with ORA-1119, ORA-27086
At Streams destination an insert into LOB stored as Securefile fails with ORA-22926 / piecewise update may miss data
DNFS: ORA-27041 on create tablespace, although tablespace is created
Wrong Results / ORA-600 [qesmagettblseg1] / ORA-8103 at physical standby with fix for bug
PRVG-11005 &database is not defined in this cluster& running cluvfy
False ORA-942 on schema with identical objects and SQLs
User interrupt (Ctrl-C) can cause ACFSK-58 errors in messages file with ACFS
MERGE statement on an Editioned View fails with ORA-904
ORA-12060 creating set query mview on prebuilt table with NUMBER(s,p) column with scale/precision
Apply instance dies, leaves system datafile fuzzy, no recovery
Flashback database fails with ORA-38754 / ORA-38729 on standby
ORA-4031 / excess shared pool memory using Securefiles
Assorted errors Logminer with CLOBs using multi-byte characterset
Error ORA-28008 returned using sqlplus &password command& for SYS account only
RMAN resync catalog very slow with many ORA-1
ORA-1403 in GCR0 process on standby instance
XML schema migration process errors out with ORA-4020
Enqueue / Dequeue intermittently gets ORA-25231 &cannot dequeue because consumer_name ..&
ORA-