当前位置: 代码迷 >> SQL >> SQL 异常: ORA-00600: 内部异常代码, 参数: [qcsfbdnp:1], [], [], [], []
  详细解决方案

SQL 异常: ORA-00600: 内部异常代码, 参数: [qcsfbdnp:1], [], [], [], []

热度:1136   发布时间:2016-05-05 11:42:19.0
SQL 错误: ORA-00600: 内部错误代码, 参数: [qcsfbdnp:1], [], [], [], []


call CREATEZHIBIAOPART2('cy_prop_reason','2014-02-18','PropReason');commit;call CY_ALL_GAOJINSHUCHU('2014-02-18');commit;


在行 145 上开始执行命令时出错:call CY_ALL_GAOJINSHUCHU('2014-02-18')错误报告:SQL 错误: ORA-00600: 内部错误代码, 参数: [qcsfbdnp:1], [], [], [], [], [], [], [], [], [], [], []ORA-06512: 在 "SCOTT.CY_ALL_GAOJINSHUCHU", line 121400600. 00000 -  "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"*Cause:    This is the generic internal error number for Oracle program           exceptions.	This indicates that a process has encountered an           exceptional condition.*Action:   Report as a bug - the first argument is the internal error number



merge into (              select ttime,thour,sum_flag,mo,fault_type,                     CURRENT_INDEX_VALUE as INDEX_VALUE,CH_RAT              from CY_PROP_REASON               where ttime=YESTORDAY                    and RESON_ATTRIBUTE='KPI'                    --and mo='FR3SAL3'      ) cp using (              select wm_concat(ttime) as WM_CONCAT_TTIME,thour,sum_flag,mo,max(FAULT_TYPE) as max_fault_type,                     avg(CURRENT_INDEX_VALUE) as INDEX_AVG_VALUE                     --,wm_concat(fault_description) as fault_description              from(                  select ttime,thour,sum_flag,mo,fault_type,fault_description,CURRENT_INDEX_VALUE                  from CY_PROP_REASON                   where ttime in (YESTORDAY,TWO_DAYS_AGO,THREE_DAYS_AGO)                  and RESON_ATTRIBUTE='KPI'                  --and mo='FR3SAL3'                  order by ttime,thour,sum_flag,mo              ) group by thour,sum_flag,mo      ) cpsum on (           cp.thour=cpsum.thour and          cp.sum_flag=cpsum.sum_flag and          cp.mo=cpsum.mo and          cp.fault_type=cpsum.max_fault_type      )      when matched then      update set cp.CH_RAT=decode(cpsum.INDEX_AVG_VALUE-cp.INDEX_VALUE,                                  0,'0.0%',                                  null,null,                                  decode(cpsum.INDEX_AVG_VALUE,0,'0.0%',                                         to_char((cpsum.INDEX_AVG_VALUE-cp.INDEX_VALUE)*100/cpsum.INDEX_AVG_VALUE,'99990.99')||'%'                                         )                           );




Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\Administrator>sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on 星期五 2月 21 14:56:50 2014Copyright (c) 1982, 2010, Oracle.  All rights reserved.SP2-0640: 未连接SQL> conn [email protected]:1521/fsyd as sysdba已连接。会话已更改。SQL> show parameter cursor_sharingNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------cursor_sharing                       string      EXACTSQL> alter system set cursor_sharing=similar scope=both;系统已更改。SQL> show parameter cursor_sharingNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------cursor_sharing                       string      SIMILARSQL>





下面的内容来自其他网站:

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帐号,我只好从各种日志去看有没有什么发现,基本上所有的警告都是指向UGARepeat 31 timesC7D6C90 00000000 [....] qmxdplsuga * qmxdplsuga_p [C7D6C94, C7D6C98) = 00000000qmpauga * qmpauga_p [C7D6C98, C7D6C9C) = 00000000qmxtcug * qmxtcuga_p [C7D6C9C, C7D6CA0) = 00000000qsmguga * qsmgu_p [C7D6CA0, C7D6CA4) = 00000000struct _xsawuga * xsawuga_p [C7D6CA4, C7D6CA8) = 00000000struct _xsoquga * xsoquga_p [C7D6CA8, C7D6CAC) = 00000000ub4 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.00SQL> show parameter cursor_sharingNAME TYPE VALUE------------------------------------ -------------------------------- ------------------------------cursor_sharing string SIMILAR2 清空一下共享池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



其他答案:

SELECT a.DWDM, a.cszjc, a.csyxjc, a.byyxjc, a.RZYL, a.YZYL, a.nljzyl,         b.cszjc, b.csyxjc, b.byyxjc, b.RZYL, b.YZYL, b.nljzyl,        c.cszjc, c.csyxjc, c.byyxjc, c.RZYL, c.YZYL, c.nljzyl,         d.cszjc, d.csyxjc, d.byyxjc, d.RZYL, d.YZYL, d.nljzyl,         e.cszjc, e.csyxjc, e.byyxjc, e.RZYL, e.YZYL, e.nljzyl from dbc042 a FULL OUTER join dbc042 b on a.dwdm=b.dwdm and b.ny='200403' and b.cslb LIKE '06%' AND b.xjbz='0' FULL OUTER join dbc042 c on a.dwdm=c.dwdm and c.ny='200403' and c.cslb LIKE '00%' AND c.xjbz='0' FULL OUTER join dbc042 d on a.dwdm=d.dwdm a;这个似乎是Oracle 的一个BUg,我遇见过几次在9205 中修复了个别的,10g 中偶尔也会出现参考metalink Doc ID:  Note:248095.1 此外,你的初始化参数应该有点问题你的症状非常像Bug 2458655  据我所知,CURSOR_SHARING = SIMILAR 很容易引起 [qctcte1]的错误可惜,我的opn 帐号不能提交tar我的9.2.0.4也有ORA-00600: 内部错误代码,参数: [qmxiUnpPacked2], [121], [], [], [], [], [], []select 1 from resource_view where any_path = '/xdbconfig.xml'试着移去XDB方案,没问题了。TO Fenng说的没错我将设成 CURSOR_SHARING = force 了,我改回来试试问题解决了,谢谢大家!把CURSOR_SHARING = force 注释掉就行了 Oracle的这个CURSOR_SHARING的功能我怀疑根本起不到正面的作用,似乎只是Oracle为了技术宣传而作的一个动作而已,也或许是开发小组企图用这个蒙混过关? 呵呵..




  一般出现这样的错误提示,表示可能是遇到了Oracle的bug: 1725012。错误的全文大概是:java.sql.SQLException:  ORA-00600:  内部错误代码,参数:  [ttcgcshnd-1],  [0],  [],  [],  [],  [],  [],  []    其实这样并不表示你的数据库或者数据库连接出了问题,这只是Oracle内部的bug,所以只要能够把这个错误屏蔽,就能恢复正常。   那Oracle里面用来屏蔽事件的方法就是使用Event事件,Events事件是Oracle的重要诊断工具及问题解决办法,很多时候需要通过Events设置来屏蔽或者更改Oracle的行为,下面是一个例子,用来增加Events事件设置:SQL> alter system set event="10841 trace name context forever" scope=spfile;   通过设置以上事件,特别是10841事件,可以屏蔽和解决这个上面提到的ORA-00600错误。   同时,这也是用于解决Oracle9i中JDBC Thin Driver问题的一个方法。   最后,设置完毕之后,最好重新启动Oracle。



ORA-00600: 内部错误代码, 参数: [qcsfbdnp:1], [], [], [], [], [], [], []-600 create or replace package my_utility  as  function qu_chong(in_col in varchar2) return varchar2;  pragma RESTRICT_REFERENCES(qu_chong,'WNDS');end;/create or replace package body my_utility  as    function qu_chong(in_col in varchar2) return varchar2    as      rel varchar2(2000);    begin    select to_char(ltrim(sys_connect_by_path(r,';'),';')) into rel from    (       select  t.*,count(*) over(partition by t.c) cnt from      (        select *        from        (          select r,c,id,min(id) over(partition by r) m_id          from          (            with t as            (              select ';'||in_col||';' c from dual            )            select c,regexp_substr(c,'[^;]{1,}',1,level) r,level id from t            connect by level<=length(regexp_replace(c,'[^;]',''))          )        )        where id=m_id      ) t    )    where level=cnt    connect by prior c=c and               prior id<id;    dbms_output.put_line(rel);               return rel;    exception when others then      dbms_output.put_line(sqlerrm||sqlcode);      rel:=' ';      return rel;    end;end;/select my_utility.qu_chong('Hello;World') from dualORA-00600: 内部错误代码, 参数: [qcsfbdnp:1], [], [], [], [], [], [], []-600据说是oracle bug,我的版本是:10.2.0.1类似问题:见下一页。




环境:hp-ux11+jboss3.2.6+oracle9201最近系统使用并发数高了点,应用系统老出现宕机情况。。数据库日志中报好多600内部错误,请各位大虾帮忙分析下是什么原因?。。。Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16382.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:25:52 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:36:42 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:46:43 2008。。。具体日志信息请看附件。附件: alert_ahltpm.log.txt (2008-5-20 16:58, 18.35 KB) / 下载次数 4http://www.itpub.net/forum.php?mod=attachment&aid=NTMwODE2fDU0YzIxNGMxfDEzOTI5NjY2MTh8MHww附件: ahltpm_ora_25128.trc.txt (2008-5-20 16:58, 2.64 MB) / 下载次数 4http://www.itpub.net/forum.php?mod=attachment&aid=NTMwODE3fDQ4ZmQ4OThmfDEzOTI5NjY2MTh8MHww学习中,在网上查了一下有一篇这样的贴子看是否对你有所帮助http://www.blogjava.net/itstarting/archive/2007/08/31/141614.htmlORA-00600是Oracle的内部错误。何谓内部错误,就是Oracle也认为是uncheck的错误了。我是在执行查询时出现了这样的提示,用的是9.2.0.1版本,我查了好长时间,当时的第一反应就是:完了,Oracle的BUG,要打补丁了。后来找到了一个论坛,这里:http://oracle.ittoolbox.com/grou ... 325619?cv=expanded#。有高人指点,终于解决了。我的解决方法很简单,变更了一个参数:STAR_TRANSFORMATION_ENABLED从原来的TRUE改为FALSE。


作者: terry_wu040802    时间: 2008-5-20 17:41From metalink:Subject:         ORA-600 [qcsfbdnp:1] Using Nested CONNECT BY Queries With PL/SQL Variables          Doc ID:         Note:208409.1         Type:         PROBLEM          Last Revision Date:         22-AUG-2004         Status:         PUBLISHEDFact(s)~~~~~~~~Using nested CONNECT BY Queries with PL/SQL Variables fails with ORA-600 [qcsfbdnp:1].For Example:CREATE TABLE TREE1 (parent number(38), child number(38));CREATE TABLE TREE2 (parent number(38), child number(38));CREATE TABLE LINK (one number(38), two number(38));CREATE OR REPLACE PROCEDURE test2IS        CURSOR breaks(arg1 PLS_INTEGER, arg2 PLS_INTEGER)  IS        SELECT child               FROM tree1               START WITH child IN                      (SELECT one                         FROM link                            WHERE two IN                                 (SELECT parent                                    FROM tree2                                   START WITH child = arg1                                   CONNECT BY child = PRIOR parent)                     AND one = arg2)               CONNECT BY parent = PRIOR child;        CURSOR works IS        SELECT child                     FROM tree1                     START WITH child IN                      (SELECT one                         FROM link                            WHERE two IN                                 (SELECT parent                                    FROM tree2                                   START WITH child = 1                                   CONNECT BY child = PRIOR parent)                          AND one = 2)                    CONNECT BY parent = PRIOR child;BEGIN      OPEN works;      CLOSE works;      dbms_output.put_line('Succeeded first cursor');      OPEN breaks(1, 2);      CLOSE breaks;END;/SQL> exec test2BEGIN test2; END;*ERROR at line 1:ORA-00600: internal error code, arguments: [qcsfbdnp:1], [], [], [], [], [], [], []ORA-06512: at "SCOTT.TEST2", line 5ORA-06512: at "SCOTT.TEST2", line 35ORA-06512: at line 1Symptom(s)~~~~~~~~~~ORA-00600: internal error code, arguments: [qcsfbdnp:1], [], [], [], [], [], [], []Cause~~~~~Bug 2104392Fix~~~~The above Bug has been fixed in the 9.0.1.4 and 9.2.0.2 patchsets.One off patch is available for 9.2.0.1 and 9.0.1.3 on some platforms.Apply the patchset or one-off patch.Workaround~~~~~~~~~~~Use a subquery to select the PL/SQL arguments with aliases and use these aliases inside the query instead of actual PL/SQL arguments.For Example:CREATE OR REPLACE PROCEDURE test2IS         CURSOR breaks(arg1 PLS_INTEGER, arg2 PLS_INTEGER)  IS  SELECT child        FROM tree1 , (select arg1 alias1 , arg2 alias2 from dual ) argtable        START WITH child IN         (SELECT one     FROM link        WHERE two IN      (SELECT parent         FROM tree2        START WITH child = argtable.alias1        CONNECT BY child = PRIOR parent)        AND one =  argtable.alias2)       CONNECT BY parent = PRIOR child;         CURSOR works IS  SELECT child        FROM tree1        START WITH child IN         (SELECT one     FROM link        WHERE two IN      (SELECT parent         FROM tree2        START WITH child = 1        CONNECT BY child = PRIOR parent)             AND one = 2)       CONNECT BY parent = PRIOR child;BEGIN       OPEN works;       CLOSE works;       dbms_output.put_line('Succeeded first cursor');       OPEN breaks(1, 2);       CLOSE breaks;       dbms_output.put_line('Succeeded second cursor');END;/SQL> exec test2;Succeeded first cursorSucceeded second cursorPL/SQL procedure successfully completed.SQL>References~~~~~~~~~~Bug 2104392  ORA-600 [QCSFBDNP:1] USING NESTED CONNECT BY QUERIES WITH PL/SQL VARIABLES






附件:


alert_ahltpm.log.txt 的内容如下:

Mon May 12 18:44:14 2008Shutting down instance: further logons disabledShutting down instance (immediate)License high water mark = 66All dispatchers and shared servers shutdownMon May 12 18:44:20 2008ALTER DATABASE CLOSE NORMALMon May 12 18:44:20 2008SMON: disabling tx recoverySMON: disabling cache recoveryMon May 12 18:44:20 2008Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeThread 1 closed at log sequence 14Successful close of redo thread 1.Mon May 12 18:44:21 2008Completed: ALTER DATABASE CLOSE NORMALMon May 12 18:44:21 2008ALTER DATABASE DISMOUNTCompleted: ALTER DATABASE DISMOUNTARCH: Archiving is disabledShutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeARCH: Archiving is disabledShutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeMon May 12 19:00:12 2008Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0SCN scheme 1Using log_archive_dest parameter default valueLICENSE_MAX_USERS = 0SYS auditing is disabledStarting up ORACLE RDBMS Version: 9.2.0.1.0.System parameters with non-default values:  processes                = 150  timed_statistics         = TRUE  shared_pool_size         = 318767104  large_pool_size          = 251658240  java_pool_size           = 67108864  control_files            = /oradata1/ahltpm/control01.ctl, /oradata1/ahltpm/control02.ctl, /oradata1/ahltpm/control03.ctl  db_block_size            = 8192  db_cache_size            = 838860800  compatible               = 9.2.0.0.0  db_file_multiblock_read_count= 16  fast_start_mttr_target   = 300  undo_management          = AUTO  undo_tablespace          = UNDOTBS1  undo_retention           = 10800  remote_login_passwordfile= EXCLUSIVE  db_domain                =   instance_name            = ahltpm  dispatchers              = (PROTOCOL=TCP) (SERVICE=ahltpmXDB)  job_queue_processes      = 10  hash_join_enabled        = TRUE  background_dump_dest     = /opt/oracle/admin/ahltpm/bdump  user_dump_dest           = /opt/oracle/admin/ahltpm/udump  core_dump_dest           = /opt/oracle/admin/ahltpm/cdump  sort_area_size           = 524288  db_name                  = ahltpm  open_cursors             = 300  star_transformation_enabled= FALSE  query_rewrite_enabled    = FALSE  pga_aggregate_target     = 25165824  aq_tm_processes          = 1PMON started with pid=2DBW0 started with pid=3LGWR started with pid=4CKPT started with pid=5SMON started with pid=6RECO started with pid=7CJQ0 started with pid=8QMN0 started with pid=9Mon May 12 19:00:18 2008starting up 1 shared server(s) ...starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...Mon May 12 19:00:18 2008ALTER DATABASE   MOUNTMon May 12 19:00:22 2008Successful mount of redo thread 1, with mount id 3174821506.Mon May 12 19:00:22 2008Database mounted in Exclusive Mode.Completed: ALTER DATABASE   MOUNTMon May 12 19:00:22 2008ALTER DATABASE OPENMon May 12 19:00:23 2008Thread 1 opened at log sequence 14  Current log# 2 seq# 14 mem# 0: /oradata1/ahltpm/redo02.logSuccessful open of redo thread 1.Mon May 12 19:00:23 2008SMON: enabling cache recoveryMon May 12 19:00:23 2008Undo Segment 1 OnlinedUndo Segment 2 OnlinedUndo Segment 3 OnlinedUndo Segment 4 OnlinedUndo Segment 5 OnlinedUndo Segment 6 OnlinedUndo Segment 7 OnlinedUndo Segment 8 OnlinedUndo Segment 9 OnlinedUndo Segment 10 OnlinedSuccessfully onlined Undo Tablespace 1.Mon May 12 19:00:23 2008SMON: enabling tx recoveryMon May 12 19:00:23 2008Database Characterset is ZHS16GBKreplication_dependency_tracking turned off (no async multimaster replication found)Completed: ALTER DATABASE OPENMon May 12 19:03:00 2008ALTER SYSTEM SET open_cursors=3000 SCOPE=BOTH;Tue May 13 09:15:31 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16165.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 09:43:22 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16344.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 09:48:28 2008/* OracleOEM */ ALTER TABLESPACE "UNDOTBS1" ADD DATAFILE '/oradata1/ahltpm/undotbs02.dbf' SIZE 1024MTue May 13 09:52:58 2008Completed: /* OracleOEM */ ALTER TABLESPACE "UNDOTBS1" ADD DATue May 13 10:20:45 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16382.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:25:52 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:36:42 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:46:43 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:48:44 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16382.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:50:52 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16596.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 10:54:10 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 11:36:57 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 14:18:56 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 14:20:57 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 14:20:57 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17076.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 14:31:25 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 14:39:40 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:14:10 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17272.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:16:13 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:17:19 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:20:27 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17356.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:21:16 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:35:14 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17356.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:44:04 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:46:06 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17319.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 15:47:54 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 16:00:06 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 16:00:06 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Tue May 13 16:00:11 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 09:21:57 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20705.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 09:41:45 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20559.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 09:43:46 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20635.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 09:43:46 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20705.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 09:43:46 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20643.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 09:49:01 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 10:19:21 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20917.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 10:21:49 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 10:30:16 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 10:31:09 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 10:38:59 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20915.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 10:41:00 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 10:41:00 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21000.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 11:11:07 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 11:15:06 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 11:35:04 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21000.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 15:18:33 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21608.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 15:55:31 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21737.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 16:11:37 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21737.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 16:47:41 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21336.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 17:08:11 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21955.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 17:48:17 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21604.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 18:20:54 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22014.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 19:20:30 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22312.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 19:22:32 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22357.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 19:26:58 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22401.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 19:52:30 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22403.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 20:14:36 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22278.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 20:25:11 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22403.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 20:25:33 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22584.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 20:25:50 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22357.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 20:26:05 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22278.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Wed May 14 20:40:24 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22584.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 08:46:00 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24819.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 08:48:02 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24981.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:55:28 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25128.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:57:08 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25249.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:57:59 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25126.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:57:59 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25253.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:57:59 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24981.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:57:59 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25255.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:58:00 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25057.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:58:00 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25242.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:58:00 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25244.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:58:01 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25246.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 09:58:01 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24819.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 10:00:29 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25128.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 10:33:53 2008Created Undo Segment _SYSSMU11$Undo Segment 11 OnlinedThu May 15 10:38:13 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25244.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 10:44:28 2008Created Undo Segment _SYSSMU12$Undo Segment 12 OnlinedThu May 15 10:46:03 2008Created Undo Segment _SYSSMU13$Undo Segment 13 OnlinedThu May 15 14:25:19 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25936.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 14:38:30 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 14:41:51 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25999.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 16:46:17 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 17:06:23 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Thu May 15 17:06:42 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_26232.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Fri May 16 07:20:51 2008SMON offlining US=11SMON offlining US=12SMON offlining US=13Fri May 16 08:47:55 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29205.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Fri May 16 08:50:58 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29309.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Fri May 16 09:02:42 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29244.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Fri May 16 09:20:42 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29244.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Fri May 16 09:51:25 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29362.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []Fri May 16 10:25:08 2008Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29311.trc:ORA-00600: 内部错误代码,参数: [qcsfbdnp:1], [], [], [], [], [], [], []


ahltpm_ora_25128.trc.txt的内容太多不贴了。


最后的解决办法是:

merge into CY_PROP_REASON cp using (              select wm_concat(ttime) as WM_CONCAT_TTIME,thour,sum_flag,mo,max(FAULT_TYPE) as max_fault_type,                     avg(CURRENT_INDEX_VALUE) as INDEX_AVG_VALUE,max(RESON_ATTRIBUTE) as RESON_ATTRIBUTE                     --,wm_concat(fault_description) as fault_description              from(                  select ttime,thour,sum_flag,mo,fault_type,fault_description,CURRENT_INDEX_VALUE,RESON_ATTRIBUTE                  from CY_PROP_REASON                   where ttime in (YESTORDAY,TWO_DAYS_AGO,THREE_DAYS_AGO)                  and RESON_ATTRIBUTE='KPI'                  --and mo='FR3SAL3'                  order by ttime,thour,sum_flag,mo              ) group by thour,sum_flag,mo      ) cpsum on (           cp.ttime=YESTORDAY and          cp.thour=cpsum.thour and          cp.sum_flag=cpsum.sum_flag and          cp.mo=cpsum.mo and          cp.fault_type=cpsum.max_fault_type and          cp.RESON_ATTRIBUTE=cpsum.RESON_ATTRIBUTE       )      when matched then      update set cp.CH_RAT=decode(cpsum.INDEX_AVG_VALUE-cp.CURRENT_INDEX_VALUE,                                  0,'0.0%',                                  null,null,                                  decode(cpsum.INDEX_AVG_VALUE,0,'0.0%',                                         to_char((cpsum.INDEX_AVG_VALUE-cp.CURRENT_INDEX_VALUE)*100/cpsum.INDEX_AVG_VALUE,'99990.99')||'%'                                         )                           );