java.sql.SQLException: ORA-00600: 內(nèi)部錯誤代碼, 參數(shù): [kkslhsh1], [101], [], [], [], [], [], []
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:945)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1159)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1605)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1570)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Wrapper$$EnhancerByProxool$$546b7d9b.executeUpdate(<generated>)
at com.roadway.edmail.dbtool.DBSql.execute(DBSql.java:600)
at com.roadway.edmail.dbtool.DBSql.execute(DBSql.java:505)
at com.roadway.edmail.dbtool.DBSql.execute(DBSql.java:433)
at com.roadway.edmail.dbtool.DBSqlUtil.excuteSqlToBoolean(DBSqlUtil.java:61)
at com.roadway.edmail.bo.address.ImportEmailsBO.insertAddrLstAll(ImportEmailsBO.java:167)
at com.roadway.edmail.bo.address.ImportEmailsBO.insertAddrFine(ImportEmailsBO.java:142)
at com.roadway.edmail.bo.address.ImportEmailsBO.importEmails(ImportEmailsBO.java:84)
at com.roadway.edmail.struts.action.address.ExeImportEmailAction.execute(ExeImportEmailAction.java:99)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.roadway.edmail.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:20)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
------------------------------------------------------------------------------------------------------------------------------
//在網(wǎng)上找到如下解決方法:
ORA-00600的解決過程
今天收到大量郵件，有如下報錯
ORA-00600: internal error code, arguments: [kkslhsh1], [101], [], [],
[], [], [], []
由于數(shù)據(jù)庫主業(yè)務(wù)正常，只是其他小功能出現(xiàn)這樣的故障，所以看到600，倒也沒什么。
沒有METALINK帳號，我只好從各種日志去看有沒有什么發(fā)現(xiàn)，基本上所有的警告都是指向UGA
Repeat 31 times
C7D6C90 00000000 [....]
qmxdplsuga * qmxdplsuga_p
[C7D6C94, C7D6C98) = 00000000
qmpauga * qmpauga_p [C7D6C98, C7D6C9C) =
00000000
qmxtcug * qmxtcuga_p [C7D6C9C, C7D6CA0) = 00000000
qsmguga *
qsmgu_p [C7D6CA0, C7D6CA4) = 00000000
struct _xsawuga * xsawuga_p [C7D6CA4,
C7D6CA8) = 00000000
struct _xsoquga * xsoquga_p [C7D6CA8, C7D6CAC) =
00000000
ub4 ksmugmg2 [C7D6CAC, C7D6CB0) = 0000CDCD
曾經(jīng)遇到過一次600，把對象給重建就解決了，這次也嘗試這樣，把SQL對于的某個表給重建，但是故障依然。
嘗試根據(jù)ORA-600和[kkslhsh1]字段搜索，發(fā)現(xiàn)出現(xiàn)一個BUG是關(guān)于cursor_sharing設(shè)置為FORCE，由于出現(xiàn)ORA-600的數(shù)據(jù)庫設(shè)置是FORCE，直覺告訴我和這個有關(guān)系，于是采取如下操作：
1 修改參數(shù)
SQL> alter system set cursor_sharing=similar;
System altered.
Elapsed: 00:00:00.00
SQL> show parameter cursor_sharing
NAME TYPE VALUE
------------------------------------
--------------------------------
------------------------------
cursor_sharing string SIMILAR
2 清空一下共享池
SQL> alter system flush shared_pool;
System altered.
再檢查這個報錯的功能，正常了！下面附上一些600 BUG的原因和相關(guān)的PATCH
# Bugs Fixed by 9.2.0.4.0 Patch 5:
# --------------------------------
#
PSEBUG BASEBUG COMPONENT DESCRIPTION
# ----------- --------------
--------------------
--------------------------------------------------------------------------------
#"3553329:
3397811: PLSQL: RECEIVING ORA-29279 WHEN USING UTL_SMTP WITH STALKER INTERNET
MAIL SERVER",
#"3378795: 2994212: RDBMS: WRONG RESULTS IF NO INDEX AND NEED A
TRANSITIVE PREDICATE IN A SUBQUERY",
#"3378356: 3114347: RDBMS:
ORA-00600:[KRVXSASAI10] RAISED IN THE ROLE BUILDER (P001)",
#"3364494:
3070702: RDBMS: ORADEBUG DOES NOT WORK FULLY ON WINDOWS",
#"3364126: 3091504:
RDBMS: UPDATING OBJECT WITH VARRAY ATTRIBUTE - ORA-07445: CORE
DUMP",
#"3363884: 3319403: RDBMS: MERGE LABEL REQUEST ON TOP OF 9.2.0.4 FOR
BUGS 2742886,2751494,2921174,3084900,3",
#"3356662: 3092670: RDBMS: QUERY
RESULT USING INLINE VIEW DO NOT MATCH THOSE WITHOUT INLINE",
#"3356142:
2990413: RDBMS: ORA-600 [MSQOPNWS_SYS] DURING UPDATE OF PARTITION
TABLE",
#"3355676: 3113248: RDBMS: CUSTOM OPERATOR FAILING WITH PARTITIONED
DOMAIN INDEX ORA-03113",
#"3355116: 3320474: CORE : DATABASE SHOULD SUPPORT
LARGE TIMEZONE LIST BY DEFAULT",
#"3353986: 3343278: RDBMS: INVERSE GROUP
OPTION WILL BECOME INVALID AFTER DATABASE RESTARTED",
#"3353912: 3296654:
RDBMS: ORA-600[510],ORA-600[504] AND MANY ORA-600[17175]S CAUSES INSTANCE
HANG",
#"3351192: 3085399: RDBMS: QUERY USING CBO GIVES WRONG RESULTS. QUERY
WITH RBO IS CORRECT",
#"3349552: 3328129: WMT : VERISIGN CLASS2/CLASS3 PCA
CERTS EXPIRED AND MUST BE REPLACED METALINK 260559.1",
#"3349343: 3255452:
RDBMS: ORA-600 [RWORUPO.2] [62] [40] DURING REFERSH OF SNAPSHOT GROUP CONTAINING
GOMETR",
#"3349339: 3258242: RDBMS: AQ PROPAGATION HALTED AFTER NODES
CRASH",
#"3342824: 3314371: RDBMs: PLEASE PROVIDE MLR FOR STREAMS ON TOP OF
9.2.0.4",
#"3340659: 3252706: RDBMS: PSRC: 9.2.0.4 DOES NOT RETURN ORA-104,
NEW CONNECTION HUNG",
#"3338434: 3138341: RDBMS: WRONG DATATYPES ARE RETURNED
FROM SP WHEN CAST IS USED",
#"3338395: 2697174: XDB : ORA-00600 - OPTIONAL
ATTRIBUTE WITH DEFAULT VALUE QMXGENDEFAULTS1 SQL*PLUS CORE",
#"3337064:
3052467: RDBMS: CORE DUMP AT QERUAROWPROCEDURE()+100",
#"3334962: 3208807:
RDBMS: LNS PROCESS WRITES TOO MANY LINES TO TRACE FILE, FILLING IT
UP",
#"3334895: 2865031: RDBMS: CREATE MATERIALIZED VIEW ON SELF-JOINED TABLE
FAILS WITH ORA-00904",
#"3333852: 2817542: WMT : ORACLE WALLET MANAGER DOES
NOT IMPORT CERTIFICATE FILE",
#"3330468: 3282805: RDBMS: TRUNCATE TABLE SCANS
FOR SMALL TABLES ENTIRE BUFFERCACHE",
#"3326339: 3189950: PLSQL : ALTER
SYSTEM KILL SESSION DOES NOT WORK FOR INFINITY LOOP PL/SQL .",
#"3326079:
2990413: RDBMS: ORA-600 [MSQOPNWS_SYS] DURING UPDATE OF PARTITION
TABLE",
#"3312905: 3070246: RDBMS: DATABASE HUNG DUE TO LIBRARY CACHE LATCH
PILE UP",
#"3311287: 3111497: RDBMS: XA-OCI CALLS THROW 25408 USER ERROR ON
TAF RECONNECT",
#"3311102: 3001262: RDBMS: ORA-7445 IN
QERUAROWPROCEDURE()+260 BY OLAPI ALLKEEPREMOVETEST",
#"3303418: 3280318:
RDBMS: DBMS_STATS.GATHER_TABLE_STATS ORA-3113 ORA-472 INSTANCE
CRASH",
#"3136514: 3110923: RDBMS: CRASH WITH ''ORDER BY DESC'' ON A CONSTANT
COLUMN ORA-3113",
#"3380937: 2788438: RDBMS: ORA-3113 IN QUERY INVOLVING
ROWNUM, HASH JOIN, GROUP BY AND VIEW",
#"3381095: 3041166: RDBMS: WRONG
RESULTS FROM SELECT OVER DBLINK",
#"3392221: 2623901: RDBMS: MTI ON TABLES
WITH TRIGGERS, TRIGGER EXECUTE CORRECTLY ONLY FOR THE FIRST
TABLE",
#"3393010: 3242483: RDBMS: PATCH FOR BUG 2586586 ONLY SOLVES PARTLY
DECIMAL SCALE ISSUE",
#"3395027: 2864062: CORE : TIMESTAMPLTZ(..,TIMESTAMP)
FAILS IN JDK1.4 WITH NONDEFAULT SESSION TIMEZONE",
#"3395446: 3134348: RDBMS:
EXTERNAL TABLE MEMORY LEAK IN "ALLOC ENVIRONM" SUBHEAP",
#"3401495: 3398004:
JDBC : MLR 9.2.0.4 MERGE LABEL REQUEST FOR BUGS 3350693 &
3369719",
#"3401779: 2962298: NET : ORA-12152 ARFET TESTING FIX FRO BUG
2718410",
#"3402247: 3065750: RDBMS: AFTER FIXES IN BUG 2718410 & 2962298
APP WILL STILL GET ORA-1000",
#"3404044: 2934659: RDBMS: 9203 SLOWER THAN
8174 SELECT FROM A REMOTE TABLE AND COMMIT LOCALLY",
#"3405025: 3212441:
NLSRTL: CORRUPTION OF INVALID ISO CHARACTERS",
#"3405182: 3293688: RDBMS:
ORA-600[504],ORA-600[510] OCCURS REPEATEDLY",
#"3411361: 3240633: RDBMS:
DBMS_LOGSTDBY.INSTANTIATE_TABLE GIVES ORA-6502 CHARACTER STRING BUFFER TOO
SMALL",
#"3411420: 3007630: RDBMS: SIGSEGV IN KSMUDR OR
STRLEN",
#"3415512: 2808926: RDBMS: ORA-600 [2866]: MEDIA RECOVERY
FAILS",
#"3415569: 2919120: XDB : FULL EXPORT FAILS WITH
ORA-1422",
#"3425613: 3125427: OSNS : ORA-12638 USING KERBEROS ON WINDOWS
2003 SERVER",
#"3426844: 3361288: XDB : AFTER REGISTERING XML SCHEMA IN
AL32UTF8 DATABASE, EXPORT FAILS WITH ORA-24324",
#"3438326: 3093940: RDBMS:
BY DEFAULT NCR TRACING IS ENABLED IN HS",
#"3443580: 3423193: RDBMS: MERGE
LABEL REQUEST ON TOP OF 9.2.0.4",
#"3386274: 2860212: PLSQL : FUNCTION
RETURNS NO VALUE IN SERVER/SERVER INTEROP TEST FOR DATE TIME",
#"3320539:
3000017: PLSQL : ADS1158R2:ORA-04062: SIGNATURE OF PACKAGE
'APPS.CSC_ACTION_ASSEMBLER_PVT' HAS BE",
#"3404932: 3398004: JDBC : MLR
9.2.0.4 MERGE LABEL REQUEST FOR BUGS 3350693 & 3369719",
#"3446519:
2560983: RDBMS: SYSDBA DOES NOT FAILOVER WHEN TAF IS IMPLEMENTED",
#"3450796:
3037432: RDBMS: SECOND INSTANCE DOES NOT COME UP WITH ERROR KCL: B11: CHECKSUM
ERROR",
#"3461597: 3316345: RDBMS: ENHANCE THE CHECKS ON INTERCONNECT BLOCKS
BY A CHECK FOR THE CORRECT DBA",
#"3462804: 2896849: NLSRTL: COREDUMP WHEN
NLS_SORT=FRENCH_M, CANADIAN_M OR DANISH_M",
#"3462808: 3107421: XDB : DROP
STATEMENTS NEED TO REMOVED FROM DBMSXMLT.SQL",
#"3465703: 3142474: RDBMS :
ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KCLPRED_5]",
#"3465474: 3234034:
NLSRTL: ORA-474 CRASHING INSTANCE ON A DAILY BASIS",
#"3454474: 3045623:
RDBMS : ORA-600 [KKSLHSH1] WHEN SETTING
CURSOR_SHARING=FORCE",
#"3468893: 3128395: RTREE : CONCURRENT UPDATES -
CAUSING DUPLICATE AND MISSING ROWIDS",
#"3473945: 3406157: RDBMS :
OCISESSIONGET ON OCI SESSION POOL RETURNS A SESSION FOR A DIFFERENT
USER",
#"3474966: 2933538: RDBMS : 9.2 GSI -- PQ QCSID WAITING FOREVER ON PX
DEQ: PARSE REPLY",
#"3474968: 2660356: RDBMS : ORA-12015 WHEN FAST REFRESHING
A MV USING ROWID",
#"3474969: 2642436: RDBMS : INCORRECT CARDINALITY OF DELTA
MV IN MV REFRESH",
#"3474970: 2981747: RDBMS : ORA-600 [KDIINS0: PID
MISMATCH] RUNNING CNUPTRX.SQL DURING APPS UPGRADE",
#"3474972: 3193124: RDBMS
: MERGE LABEL REQUEST FOR THE FIXES FOR BUGS 3116063 AND 3108046 ON TOP OF
9.2.0.4",
#"3474973: 3059276: RDBMS : DYNAMIC SAMPLING NOT ENABLED IN CERTAIN
CASES",
#"3474974: 3157344: RDBMS: ORA-00904 RAISED WHEN COMPLEX MVIEW
REFRESHED USING FAST METHOD",
#"3474975: 3167234: RDBMS: SUB-OPTIMAL
EXECUTION PLAN WITH 'FOR UPDATE'",
#"3477237: 3060261: RDBMS: ENQUEUE_TIME
AND START_TIME AHEAD OF SYSDATE",
#"3477420: 3316839: RDBMS: MLR FOR BUG
3056297, 3074405, 3220073, 3272011 ON 9.2.0.4",
#"3480069: 2453893: RDBMS:
ORA-00600:[KGHUCLIENTASP_03] ORA-7445 [KGHFRMRG()+80] SELECT EXTERNAL
TABLE",
#"3480641: 2909346: RDBMS: INEFFICIENT USE OF SGA USING LOB
ODCIINDEX",
#"3482591: 2619861: RDBMS: ERROR WITH OUTER JOIN ON CHAR/NCHAR,
VARCHAR2/NVARCHAR2 COLUMNS",
#"3484821: 2380066: RDBMS: TEMPORARY LOB SCAN
FOR ADTS -- USE TDS",
#"3485923: 2417344: RDBMS: ORA-600 [KSSRMP1] AND PMON
HANG AFTER FAILED/KILLING RMAN SESSION",
#"3486686: 3380026: RDBMS: PSRC:
DIFFERENT EXECUTION PLAN IS SELECTED BETWEEN R9.2.0.3 AND
R9.2.0.4",
#"3487218: 3483519: RDBMS: MERGED LABEL FOR BUGS 2660356, 3391999
ON TOP OF 9.2.0.4",
#"3488597: 2907034: XDB : ORA-4030: LOADING 7.5 MEG
SCHEMA BASED DOCUMENT VIA CREATERESOURCE",
#"3493275: 3231814: RDBMS:
REGISTERED CALLBACK FAILS AFTER RE-SUBSCRIPTION, SYS.REG$ NOT CLEANED
PROPERLY",
#"3493443: 3123232: RDBMS: ORA-600 [KSULOGET4] ON MANY DIFFERENT
STATEMENTS IN WIN2K RAC ENVIRONMENT",
#"3498088: 3352413: RDBMS: ORA-8102
ERROR ON DICTIONARY OBJECT",
#"3501826: 2896403: RDBMS: 9203 REGRESSION: CORE
DUMP WHEN DOING A CTAS WITH A UNION AND AN ORDER BY",
#"3521208: 3236491:
RDBMS: APPSST:DBI:GSITST:LOAD: ORA-32332 IS RAISED DURING REFRESH OF
MVIEW",
#"3521214: 2436624: PLSQL : PL/SQL CODE FAILS WITH PLS-00801:
INTERNAL ERROR [2102]",
#"3524377: 3274939: RDBMS: ORA-01426 WHEN PERFORMING
DDL/DML ON A PARTICULAR TABLE",
#"3524392: 2764106: RDBMS: ORA-600 [2662]
BRINGS THE DATABASE DOWN",
#"3524409: 2899477: RDBMS: ORA-600[2662] CAUSES
INSTANCE CRASH",
#"3524429: 3030298: RDBMS: ORA-600[2103] OCCURED WHEN WE
EXECUTED 'DROP TABLESPACE AND DATAFILES' ON PARALL",
#"3524440: 3077651:
RDBMS: PMON PROCESS WAS HANGING OR DBWR CRASH",
#"3524455: 3080929: RDBMS:
STAR : WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!",
#"3524473: 3045275:
RDBMS: TRUNCATE TEMP TABLE - POOR QUERY PERFORMANCE ON SECOND
RUN",
#"3524484: 2908532: RDBMS: SMON REPORTED ORA-604 AND ORA-1000 ENDLESSLY
DURING STARTUP",
#"3524506: 2959556: RDBMS: DB CANNOT BE OPENED DUE TO
ORA-600 [4000]",
#"3524518: 3077789: RDBMS: WHEN BOTH DB_FILES AND PROCESSES
ARE LARGE VALUES, ORA-64 ERROR OCCURS",
#"3524534: 3089086: RDBMS: ORA-600
[17172] LEADS TO ORA 600 [510] AND ORA-600[17175]",
#"3524550: 2823021:
RDBMS: COLUMN PGA_MAX_MEM IN V$PROCESS CONTAINS WRONG VALUES",
#"3524567:
2959490: RDBMS: SELECT FROM VIEW WITH ORDER BY ALWAYS RETURNS ROWID OF LAST ROW
IN VIEW",
#"3524583: 3150705: RDBMS: FXD: KGI SHOULD LIMIT CACHING WHEN MAX
OPEN CURSORS IS SET HIGH (4031)",
#"3524601: 3150680: RDBMS: INTERNAL:
SESSION CACHED CURSORS CACHES PINS UNNECESSARILY",
#"3528964: 3469775: XDB :
DBMS_XMLGEN.CONVERT CAUSES ORA-600[17112]",
#
# Bugs Fixed by 9.2.0.4.0
Patch 3:
# --------------------------------
# PSEBUG BASEBUG COMPONENT
DESCRIPTION
# ----------- ------------- -------------------
--------------------------------------------------------------------------------
#"3278727:
3203188: XDB : FXD: TRIGGERS INCORRECTLY EVALUATE TO NULL ON :NEW AND :OLD ON
XMLTYPE COLUMNS",
#"3278143: 3140038: RDBMS: XAORECOVER BLOCKED BY LONG
RUNNING QUERY",
#"3276041: 3041387: RDBMS: ORA-600: INTERNAL ERROR CODE,
ARGUMENTS: [KOPI2_READLEN083]",
#"3276031: 3153721: RDBMS: ORA-00979: NOT A
GROUP BY EXPRESSION",
#"3275494: 3265841: DRGEN: MLR BACKPORT OF BUG 2801345
AND 3254366 ON TOP OF VERSION 9.2.0.4",
#"3275254: 3212268: RDBMS: PROCEDURE
RUN USING DBMS_JOBS IN UTF8 DB TRIMS RESULTING CLOB TO 65381
CHARS",
#"3271505: 3229958: RDBMS: AQ PROPAGATION SCHEDULES AND
OWNER_INSTANCE FAIL TO FALLBACK TO PRIMARY INSTANCE",
#"3270462: 2949113: XDB
: REGISTERSCHEMA DOES NOT ROLLBACK CORRECTLY WITH INVALID CHARS IN
URL",
#"3266991: 3135311: RDBMS: WRONG RESULT DOING 'SELECT SYS_CONTEXT
('USERENV', 'TERMINAL') AS X FROM DUAL'",
#"3262619: 2874489: RDBMS:
EXCESSIVE REDO GENERATED ON INSERTS TO GLOBAL TEMPORARY TABLE",
#"3260850:
1782381: RDBMS: EXCESSIVE SGA MEMORY ALLOCATION WITH LARGE NUMBER OF
JOBS",
#"3260847: 2954868: RDBMS: CORRUPT CR BLOCK (ORA-600 [KCOAPL_BLKCHK])
FROM IOT OR COMPRESSED INDEX",
#"3260844: 3124179: RDBMS: ORA-600 [12333]
INSERT USING A DBLINK",
#"3260366: 3143899: MGMTAPI: REPCA : DATABASE
REGISTRATION IN SSL ONLY MODE THROWS SERVICEALIASEXCEPTION",
#"3255938:
2942047: RDBMS: SMALL CHANCE OF SGA CORRUPTION DURING SIDE-CHANNEL MSG
PROCESSING",
#"3253700: 3163798: RDBMS: ORA-600 [KSSRMP1] AND THE DB
CRASHED",
#"3253320: 3250585: RDBMS: MERGE LABEL REQUEST ON TOP OF 9.2.0.4
FOR 2003-S24",
#"3248097: 3106363: RDBMS: SA_SESSION.SET_LABEL LEAKS MEMORY:
'KPMALLOC'",
#"3245784: 3038759: RDBMS: KKXSARFCH() DOESN'T RESET PGAPLS
CORRECTLY",
#"3245654: 2956991: RDBMS: ORA-14504 ERROR DURING DBMS_STATS
'GATHER STALE' ANALYSIS",
#"3243183: 2539128: PLSQL : UTL_FILE - WRONG
FILESIZE AND BLOCK_SIZE",
#"3240411: 2740939: RDBMS: ORA-600
[KWQIDMCRETRY:SUB-NAME] WHEN DEQUEUING MESSAGES FROM EXCEPTION
QUEUE",
#"3231241: 2794250: MGMTAPI: NEED DEBUGGING TOOLS FOR
NETCA",
#"3228038: 2671021: RDBMS: MVIEW TAKES A DIFFERENT PATH THEN THE
DEFINITION QUERY ITSELF",
#"3226817: 3226109: RDBMS: SECURITY ALERT 59 -
MERGE LABEL REQUEST OF 3206469 ON TOP OF 9.2.0.4",
#"3225690: 2944007: RDBMS:
9I-GSI-ORA-00600 : [KCOAPL_BLKCHK], [72], [31644]",
#"3224930: 3005551:
RDBMS: ORA-600[510] AND ORA-600[17175][255] POSSIBLE AFTER PREVIOUS HEAP
ERR",
#"3224902: 2821879: RDBMS: WRONG RESULTS FOR QUERIES ON PIPELINE
FUNCTIONS INVOLVING NULLS ",
#"3283039: 3121812: RDBMS: DROP AND EXCHANGE
PARTITION DONT SHOW UP IN USER_TAB_MODIFICATIONS",
#"3281223: 3125001: RDBMS:
CRM - 9.2 PMON CRASH WITH ORA-00600 [1115]",
#"3282122: 3101739: RDBMS:
ORACLE GETS ORA-3113 EVERY TIME WITH CORE WHEN EXECUTING SQL",
#"3287502:
3047390: RDBMS: MAXIMUM AVAILABILITY REQUIRES 1 STANDBY DB TO OPEN PRIMARY
INSTANCE",
#"3289591: 3033868: RDBMS: ORA-600 [KWQIDJQP0] EXEC
SYS.DBMS_AQADM_SYS.REGISTER_DRIVER()",
#"3288849: 3118399: RDBMS: CORE DUMP
ALTER TYPE ADD WHEN DEPENDENTS FORM SOFT CYCLIC DEPENDENCY",
#"3288882:
3160246: RDBMS: CRM1159UP: APPSST:AQ SUBSCRIBER_TYPE 65 THAT LEADS TO ERROR
ORA-24026",
#"3288839: 3267327: RDBMS: ORA-00600 [KOPUTILCVTO2N], ON 'ALTER
TABLE .. UPGRADE' COMMAND",
#"3289715: 3243639: RDBMS: PRIMARY MAY BE STALLED
MORE THAN NET_TIMEOUT SECONDS",
#"3290716: 3052846: RDBMS: ORA-07445:
EXCEPTION ENCOUNTERED: CORE DUMP [KSLPSTEVENT()+2156] [SIGSEGV]",
#"3291583:
3271271: RDBMS: QMON CAN DEADLOCK WITH JOB QUEUE PROCESSES",
#"3292190:
3281551: RDBMS: EXTEND INTERCONNECT_CHECKSUMS TO 'FAKE BLOCK
HEADERS'",
#"3292314: 1736740: KERNEL: TEMPBLOB.OPEN (BLOB.MODE_READWRITE)
FAILED IN KPRB",
#"3293397: 2679662: RDBMS: OCISTMTPREPARE NOT ALLOWED IN OCI
STATEMENT CACHE MODE",
#"3294181: 2563301: RDBMS: ORA-00600: INTERNAL ERROR
CODE, ARGUMENTS: [KSSRMP1], ",
#"3296718: 2623901: RDBMS: MTI ON TABLES WITH
TRIGGERS, TRIGGER EXECUTE CORRECTLY ONLY FOR THE FIRST TABLE",
#"3297346:
3297346: RDBMS: CONVERTED TO 3DES168, DATABASE WON'T AUTOSTART",
#"3297835:
3296047: CONS : MERGE LABEL REQUEST FOR 991 ORACLE CONS ON TOP OF
9.2.0.4",
#"3299929: 3253153: RDBMS: RFS: CONTROLFILE ENQUEUE UNAVAILABLE ON
STANDBY DURING MANAGED RECOVERY START",
#"3300025: 2943173: RDBMS: DIFFERENT
BUFFER GETS USING A DIFFERENT ORDER OF THE SAME WHERE CONDITIONS",
#
#
Bugs Fixed by 9.2.0.4.0 Patch 2:
# --------------------------------
#
PSEBUG BASEBUG COMPONENT DESCRIPTION
# ----------- -------------
------------------ ----------------------------------
# 3106659: 3079678:
RDBMS: SERVER CRASH POSSIBLE
# 3107435: 3010012: RDBMS: ORA-3113 ON ALTER
TABLE ENABLE FOREIGN KEY CONSTRAINT WITH CHAR COLUMN
# 3110656: 2968571:
RDBMS: DBMS_STATS.GATHER_TABLE_STATS FAILS WITH ORA-933 WHEN ESTIMATE PERCENT
< 8.
# 3112188: 2420940: CRAWLER: HTTP COOKIES NOT RECOGNIZED BY
CRAWLER
# 3112604: 3019273: RDBMS: ONCE SET_LABEL() IS EXECUTED, SESSION HEAP
CONTINUES TO GROW UP WITH EVERY SQL
# 3113295: 2870605: RDBMS:
9I-CRM-PLS-00306: WRONG NUMBER OR TYPES OF ARGUMENTS IN CALL TO ON COMPILING A
P
# 3114155: 3018017: RDBMS: INSERT INTO TABLE WITHOUT POLICY APPLIED RETURNS
ORA-28113
# 3114166: 2968709: RDBMS: LIBRARY CACHE PIN CONTENTION AFTER
8.1.7.4 TO 9.2.0.3 UPGRADE
# 3114370: 2991842: RDBMS: WRONG RESULT USING "OR"
SQL CONDITION WITH NLS_NCHARA_CHARASET=AL16UTF16
# 3114667: 2906041: RDBMS:
ORA-1062 WHEN SELECTING FROM OBJECT VIEW USING UNIONED OBJ. TABLES
# 3120940:
2964015: RDBMS: ALTERING A TYPE RESULTS IN ORA-3113 ERROR
# 3121859: 2549186:
RDBMS: REF CURSOR DATA IS FETCHED AS NON UCS2 DATA AFTER THE FIRST FETCH IN
UTF16 MODE
# 3122505: 3035145: RDBMS: OCCI STATEMENT DOES NOT EVALUATE
NULL/NOT NULL CORRECTLY AFTER NUMBER::SETNULL()
# 3122649: 3039491: NLSDATA:
SOME JA16EUCTILDE CHARACTERS NOT HANDLED CORRECTLY
# 3122844: 2608044: RDBMS:
ORA-01461 WHEN COMPILING JAVA STORED PROCEDURE ON 9I DATABASE
# 3124074:
2620541: RDBMS: ORA-7445 KXSPOAC W/ CURSOR_SHARING = FORCE; 8.1.7.4
#
3124208: 2827098: RDBMS: CTAS OR INSERT SELECT TAKES EXCESSIVE TIME COMPARED TO
STANDALONE SELECT
# 3124223: 2987506: RDBMS: DBMS_TRANSFORM FAILS TO CONVERT
A TYPE CORRECTLY WHEN USING JSP
# 3125024: 2758287: RDBMS: AFTER SETUP
MULTI-MASTER REPLICATION ENVIRONMENT DELETE RULE CHANGES.
# 3126964: 3118055:
RDBMS: PROPAGATION NO LONGER WORKS AFTER SHUTDOWN AND STARTUP
# 3127772:
2684459: ADMIN: CAN NOT ACCESS TABLE DS DETAILS PAGE FOR A TABLE DS BASED ON A
REMOTE TABLE
# 3127797: 3004610: RDBMS: SYNONYM POLICIES MAY NOT BE ENFORCED
WHEN ACCESS IS THROUGH ANOTHER SYNONYM
# 3129499: 2799139: RDBMS: AFTER
UPGRADE FROM 92 TO 10I, CAPTURE ABORTED WITH ORA-01280: IN TRACE
# 3130418:
2736734: RDBMS: EXECUTION PLAN CHOSEN BY CBO FOR DOMAIN INDEX IS WRONG
#
3131394: 2355645: RDBMS: OCI-21500: INTERNAL ERROR CODE: [KOPUIGPFX1] ON IMPORT
OF POPULATED TABLE.
# 3131871: 3039078: RDBMS: COLUMN LOST PRECISION WHEN
CREATE TABLE AS SELECT USING HS
# 3131993: 3078144: RDBMS: ORA-00904 INVALID
IDENTIFIER WHEN ANALYZING OBJECTS USING FND_STATS/DBMS_STATS
# 3132721:
3077778: RDBMS: ORA-3242 WHILE TRYING TO MIGRATE SYSTEM TO LOCALLY MANAGED
#
3134515: 2489781: PLSQL : ALTER PACKAGE COMPILE DEBUG FAILS IF THERE IS A
FORWARD RECORD REFERENCE.
# 3136121: 2971081: PLSQL : BEING MULTIBYTE
CHARACTER IS POSSIBLE TO HANG IN CREATE PROCEDURE
# 3136514: 3110923: RDBMS:
CRASH WITH ''ORDER BY DESC'' ON A CONSTANT COLUMN ORA-3113
# 3138097:
3121872: RDBMS: NO LINK$ ACCESS IN SELECT ANY DICTIONARY
# 3138769: 2980403:
RDBMS: ORA-4045 ORA-942 ON FIRST COMPLETE REFRESH OF A MATERIALIZED VIEW USING
DBLINK
# 3142475: 2820295: RDBMS: INCONSISTENT METADATA OF NUMERIC COLUMN IN
VIEW
# 3143612: 2167574: RDBMS: DEQUEUE CORE DUMPS WHEN PAYLOAD IS A
NON-FINAL OBJECT TYPE
# 3144132: 2994216: NET : DISPATCHER CONSMES 100% CPU
WHEN POOL=ON
# 3144263: 3031083: RDBMS: BACKGROUND_DUMP_DEST CHANGED NOT
BEFORE SERVICE RESTARTED
# 3144311: 3028021: RDBMS: CREATE CONTROLFILE FAILS
IF ORACLE (<=) 7.2 DATAFILES EXIST
# 3145128: 3114490: XDB : ORA-600
[KPOTCPRC: UGA DEPTH EXCEEDED] GENERATED WHEN RUNNING SYS.DBMS_XMLGEN
#
3145133: 3112212: RDBMS: REGISTER SCHEMA HANGS, 100% CPU USAGE.
# 3147036:
3071843: RDBMS: PASSWORD_LOCK_TIME ONLY LOCKS THE FIRST TIME BUT LEAVE FUTURE
ATTEMPTS WIDE OPEN
# 3147943: 2819504: RDBMS: ORA-12801 AND ORA-904 ERROR
WITH QUERY IN 9.2.0.2
# 3151967: 2740481: RDBMS: ORA-1591 WHEN INSERTING A
ROW THAT HAS NO RELATION WITH THE IN-DOUBT TXN
# 3152015: 2988739: RDBMS:
ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KOPP2UPIC#329], [], [], [], []
#
3153238: 2900761: RDBMS: ORA-979 WITH CORRELATED SUBQUERIES, GROUP BY AND
TRUNC
# 3160121: 3063241: RDBMS: IDENTICAL ISSUE TO BUG 2860984 IS NOT
RESOLVED BY SUN64BIT PATCH.
# 3163395: 3123030: RDBMS: ARRAY OF HANDLES
REG.SUBSCRIP--> ORA-1435 USING OCISUBSCRIPTIONUNREGISTER
# 3165000:
2997536: RDBMS: SUBSCRIPTION CALLBACK IS NOT CALLED IN TKP8B047 WHEN CLIENT 10I
AND SERVER 817
# 3165020: 2715491: DRGEN: MEMORY GROWS AND ORA-4030 WHEN
USING LEXER ATTRIBUTE INDEX_STEMS=GERMAN
# 3166251: 2972936: DRGEN: NLS:
WRONG RESULT RETURNED WHEN USING INPATH ATTRIBUTE WITH JAPANESE_VGRAM_LEXER
#
3174621: 2825036: XDB : ORA-00600 OCCURS WHEN REGISTER XML SCHEMA
# 3174632:
3134829: XDB : FXD: ORA-972 WHEN USING XMLTYPE VIEW AND ELEMENT NAME IS TOO
LONG
# 3175296: 2827119: RDBMS: DEDICATED SERVER DOWN WHEN JDBC APPLICATION
QUERY LONG SQL STATEMENT
# 3177931: 2740805: RADIUS: CLIENT OS USER INFO NOT
SEEN ON DATABASE WHEN RADIUS COFIG ON CLEINT AND SERVER
# 3180808: 2794250:
MGMTAPI: NEED DEBUGGING TOOLS FOR NETCA
# 3182728: 3086883: RDBMS: OCCI: NOT
ABLE TO INSERT MORE THAN 64K DATA INTO A LONG RAW COLUMN
# 3183669: 3120033:
RDBMS: ORA-00471: DBWR PROCESS TERMINATED WITH ERROR, WHEN RUNNING DATABASE
#
3183904: 2899668: RDBMS: FXD: OLREDEF: DBMS_REDEFINITION.START_REDEF_TABLE ON
UTF8 DB FAIL W/ LPX-00217
# 3188137: 3041411: RDBMS: ROW UPDATE TRIGGER FIRES
INCORRECTLY ON MERGE STATEMENT
# 3191139: 3105912: RDBMS: OCI_ATTR_ATTEMPTS
IS NEVER SET TO THE RETRY_COUNT VALUE AFTER A ROLLBACK
# 3192331: 2829071:
PLSQL : ORA-600:[15419] ERROR DEBUGGING TASK DATABASE PACKAGE
# 3195055:
2615473: PLSQL : USE OF UTL_HTTP WITH MTS RESULTS IN A CIRCUITS LEAK
#
3197063: 2596292: ORA_AGENT: AGENT PASSWORD ENCRYPTION WITH THE SNMP_RW.ORA IN A
FAILSAFE ENVIRONMENT FAILS
# 3198989: 3192983: RDBMS: VARRAYS OF SCALAR ARE
NOT BEING HANDLED CORRECTLY
# 3199041: 2760327: XDB : ORA-00600:FTP GET
[QMXMAN_BADEL], SELECT SB XMLTYPE [QMXSQCREEXLEN2]
# 3199664: 3197856: RDBMS:
PLEASE PROVIDE A MERGE LABEL FOR BUGS 5 STREAMS BUGS ON TOP OF 9.2.0.4
#
3200708: 2926080: DRGEN: NESTED LOOPS PLAN WITH TEXT INDEX AS INNER TABLE LEAKS
MEMORY (DREXRGETNEWQX:D)
# 3206826: 3119025: RDBMS: PSRC: ORA-7445 [KKOGTP]
SELECTING FROM TABLE WITH CONSTRAINT USING CBO
# 3207106: 2121126: NET :
DATABASE LINK HANG IN CONNECT PHASE ON NETWORK ERROR
# 3207562: 3167234:
RDBMS: SUB-OPTIMAL EXECUTION PLAN WITH "FOR UPDATE"
# 3207567: 3131210:
RDBMS: ORA-0600 WITH DYNAMIC SAMPLING
# 3208168: 2839655: CORE : LXDPRL.C:
ORA-00600: [17147] - KGH CHUNK HEADER OVERWRITTEN (LRGU)
# 3208175: 2839655:
NLSRTL: LXDPRL.C: ORA-00600: [17147] - KGH CHUNK HEADER OVERWRITTEN (LRGU)
#
3210878: 3127957: XDB : ORA-600 [QMXSQCREEXNS] ON INSERT INTO SCHEMA BASED TABLE
WITH TRIGGER
# 3211895: 3161240: RDBMS: PSRC: ORA-3113 USING 10862 EVENT WHEN
EXECUTING DBMS_AQADM.CREATE_QUEUE_TABLE
# 3212507: 3138734: RDBMS: EXP-56
ORA-31600: INVALID INPUT 100000001 FOR PARAMETER HANDLE IN SET FILTER
#
3213076: 3174874: RDBMS: FUNC OFLNG() FAILS USING LDA THAT WAS ACTIVATED BY
OCISVCCTXTOLDA()
# 3213777: 3210293: CONS : MERGE LABEL REQUEST FOR 991
ORACLE CONS ON TOP OF 9.2.0.4 (2003-S34)
# 3214563: 3001020: RDBMS: ORA-00600
: [20056], [2], [1104336195], [183], [1304466975], [8]
# 3217026: 3119368:
PLSQL : PL/SQL REPLACE FUNCTION WHEN NULL W/RETURN CHAR
# 3218356: 3157284:
OSNS : ORA-12699 WHEN USING FIPS-140 WITH 9.2.0.4 WINDOWS 2000
# 3218387:
2986228: RDBMS: BAD QUERY PERF WITH CASE STATEMENT AFTER MIGRATION FROM 8174 TO
9203
# 3218395: 2978512: RDBMS: JAVA SQL PARSER: SOMETIMES RETURNING OUTPUT
VARIABLES AS BIND VARIABLES
# 3218398: 3068705: RDBMS: 9203 OCI8 WHEN USING
MULTICONSUMER QUEUES DOES NOT WORK
# 3218419: 2982297: RDBMS: NEED TO PROVIDE
A 9.2.X VERSION OF THE FIX TO BUG 2651669
# 3222656: 3185622: RDBMS: EXPIRED
MESSAGES DELIVERED TWICE BY SOURCE QUEUE AND EXCEPTION QUEUE