梦幻之旅

DEBUG - 天道酬勤

   :: 首页 :: 新随笔 :: 联系 :: 聚合  :: 管理 ::
  671 随笔 :: 6 文章 :: 256 评论 :: 0 Trackbacks
java.sql.SQLException: ORA-00600: 内部错误代码, 参数: [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)
------------------------------------------------------------------------------------------------------------------------------
//在网上找到如下解决方法:

ORA-00600的解决过程

今天收到大量邮件,有如下报错

ORA-00600: internal error code, arguments: [kkslhsh1], [101], [], [], [], [], [], []


由于数据库主业务正常,只是其他小功能出现这样的故障,所以看到600,倒也没什么。

没有METALINK帐号,我只好从各种日志去看有没有什么发现,基本上所有的警告都是指向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

曾经遇到过一次600,把对象给重建就解决了,这次也尝试这样,把SQL对于的某个表给重建,但是故障依然。

尝试根据ORA-600和[kkslhsh1]字段搜索,发现出现一个BUG是关于cursor_sharing设置为FORCE,由于出现ORA-600的数据库设置是FORCE,直觉告诉我和这个有关系,于是采取如下操作:

1 修改参数

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的原因和相关的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




posted on 2009-01-13 14:30 HUIKK 阅读(10367) 评论(0)  编辑  收藏 所属分类: DataBase

只有注册用户登录后才能发表评论。


网站导航: