`

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 1214
00600. 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 /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 2月 21 14:56:50 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SP2-0640: 未连接
SQL> conn sys/fsyd@192.168.1.108:1521/fsyd as sysdba
已连接。

会话已更改。

SQL> show parameter cursor_sharing

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cursor_sharing                       string      EXACT
SQL> alter system set cursor_sharing=similar scope=both;

系统已更改。

SQL> show parameter cursor_sharing

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cursor_sharing                       string      SIMILAR
SQL>





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

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



其他答案： 



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 dual

ORA-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 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:36:42 2008
Errors 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) / 下载次数 4
http://www.itpub.net/forum.php?mod=attachment&aid=NTMwODE2fDU0YzIxNGMxfDEzOTI5NjY2MTh8MHww

附件: ahltpm_ora_25128.trc.txt (2008-5-20 16:58, 2.64 MB) / 下载次数 4
http://www.itpub.net/forum.php?mod=attachment&aid=NTMwODE3fDQ4ZmQ4OThmfDEzOTI5NjY2MTh8MHww


学习中,在网上查了一下有一篇这样的贴子看是否对你有所帮助
http://www.blogjava.net/itstarting/archive/2007/08/31/141614.html
ORA-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:41

From 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:         PUBLISHED


Fact(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 test2
IS
        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 test2
BEGIN test2; END;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qcsfbdnp:1], [], [], [], [], [], [], []
ORA-06512: at "SCOTT.TEST2", line 5
ORA-06512: at "SCOTT.TEST2", line 35
ORA-06512: at line 1


Symptom(s)
~~~~~~~~~~
ORA-00600: internal error code, arguments: [qcsfbdnp:1], [], [], [], [], [], [], []


Cause
~~~~~
Bug 2104392

Fix
~~~~
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 test2
IS
         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 cursor
Succeeded second cursor
PL/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 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 66
All dispatchers and shared servers shutdown
Mon May 12 18:44:20 2008
ALTER DATABASE CLOSE NORMAL
Mon May 12 18:44:20 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon May 12 18:44:20 2008
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 14
Successful close of redo thread 1.
Mon May 12 18:44:21 2008
Completed: ALTER DATABASE CLOSE NORMAL
Mon May 12 18:44:21 2008
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon May 12 19:00:12 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting 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          = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Mon May 12 19:00:18 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon May 12 19:00:18 2008
ALTER DATABASE   MOUNT
Mon May 12 19:00:22 2008
Successful mount of redo thread 1, with mount id 3174821506.
Mon May 12 19:00:22 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Mon May 12 19:00:22 2008
ALTER DATABASE OPEN
Mon May 12 19:00:23 2008
Thread 1 opened at log sequence 14
  Current log# 2 seq# 14 mem# 0: /oradata1/ahltpm/redo02.log
Successful open of redo thread 1.
Mon May 12 19:00:23 2008
SMON: enabling cache recovery
Mon May 12 19:00:23 2008
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon May 12 19:00:23 2008
SMON: enabling tx recovery
Mon May 12 19:00:23 2008
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Mon May 12 19:03:00 2008
ALTER SYSTEM SET open_cursors=3000 SCOPE=BOTH;
Tue May 13 09:15:31 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16165.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 09:43:22 2008
Errors 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 1024M
Tue May 13 09:52:58 2008
Completed: /* OracleOEM */ ALTER TABLESPACE "UNDOTBS1" ADD DA
Tue May 13 10:20:45 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16382.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:25:52 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:36:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:46:43 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:48:44 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16382.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:50:52 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16596.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:54:10 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 11:36:57 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:18:56 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:20:57 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:20:57 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17076.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:31:25 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:39:40 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:14:10 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17272.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:16:13 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:17:19 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:20:27 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17356.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:21:16 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:35:14 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17356.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:44:04 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:46:06 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17319.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:47:54 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 16:00:06 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 16:00:06 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 16:00:11 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:21:57 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20705.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:41:45 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20559.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:43:46 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20635.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:43:46 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20705.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:43:46 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20643.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:49:01 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:19:21 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20917.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:21:49 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:30:16 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:31:09 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:38:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20915.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:41:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:41:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21000.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 11:11:07 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 11:15:06 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 11:35:04 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21000.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 15:18:33 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21608.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 15:55:31 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21737.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 16:11:37 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21737.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 16:47:41 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21336.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 17:08:11 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21955.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 17:48:17 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21604.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 18:20:54 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22014.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 19:20:30 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22312.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 19:22:32 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22357.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 19:26:58 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22401.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 19:52:30 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22403.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:14:36 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22278.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:25:11 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22403.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:25:33 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22584.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:25:50 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22357.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:26:05 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22278.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:40:24 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22584.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 08:46:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24819.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 08:48:02 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24981.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:55:28 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25128.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:08 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25249.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25126.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25253.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24981.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25255.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25057.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25242.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25244.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:01 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25246.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:01 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24819.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 10:00:29 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25128.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 10:33:53 2008
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Thu May 15 10:38:13 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25244.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 10:44:28 2008
Created Undo Segment _SYSSMU12$
Undo Segment 12 Onlined
Thu May 15 10:46:03 2008
Created Undo Segment _SYSSMU13$
Undo Segment 13 Onlined
Thu May 15 14:25:19 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25936.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 14:38:30 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 14:41:51 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25999.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 16:46:17 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 17:06:23 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 17:06:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_26232.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 07:20:51 2008
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
Fri May 16 08:47:55 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29205.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 08:50:58 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29309.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 09:02:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29244.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 09:20:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29244.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 09:51:25 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29362.trc:
ORA-00600: 内部错误代码，参数: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 10:25:08 2008
Errors 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')||'%'
                                         )
                           );
分享到：
| Oracle Trace文件的生成及查看
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    解决Exception java.sql.SQLException ORA-00600 内部错误代码

    在oracle里面运行一下，解决Exception java.sql.SQLException ORA-00600 内部错误代码

    启动oracle数据库报错：ORA-00600

    在Oracle数据库管理中，"ORA-00600"是一个内部错误代码，通常表示数据库遇到了一个未知或未处理的内部错误。这个错误是由于多种原因引起的，包括数据文件损坏、控制文件问题、实例恢复不完整或者软件bug等。在描述中...

    ORA-00600【4194】.pdf

    Oracle 错误代码 ORA-00600 是一个内部错误代码，通常是由数据库内部机制引起的。该错误代码可以有多种不同的参数，例如在本文中的 [4194]。在这里，我们将讨论如何处理通过隐含参数恢复报错处理时出现的 ORA-00600...

    oracle11g 内部参数出错问题

    Oracle 11g 内部错误代码 ORA-00600 是一个非常通用的错误，它表示数据库遇到了一个无法处理的内部错误或异常情况。这个错误通常涉及到Oracle数据库的底层结构，如数据块、索引或者内存管理等，且参数列表可以提供...

    oracle特有的错误：ORA-01036：非法的变量名/编号

    在Oracle数据库系统中，"ORA-01036：非法的变量名/编号"是一个常见的错误，通常出现在PL/SQL代码或者SQL查询语句中，当你尝试使用一个不正确或者未定义的变量时，Oracle数据库会抛出这个错误。这个错误可能是由于...

    oracle报错（ORA-00600）问题处理

    Oracle数据库在运行过程中可能会遇到各种错误，其中ORA-00600是一个内部错误代码，表示遇到了数据库系统内部无法处理的异常情况。这个错误通常与数据库的底层结构或数据不一致有关，它不是一个通用错误，而是针对...

    oracle+ora-各种常见java.sq

    - `java.sql.SQLException: ORA-00900: invalid SQL statement`: 执行的SQL语句有语法错误。检查SQL命令并修正语法错误。 5. **表或对象不存在** - `java.sql.SQLException: ORA-00942: table or view does not ...

    Oracle SQL Developer连接报错(ORA-12505)的解决方案(两种)

    之前用PL/SQL DEVELOPER和SQLPLUS 登录数据库都没有问题，就是应用程序通过JDBC连接Oracle时无法成功连接，出现ORA-12505错误listener does not currently know of SID given in connect descriptor

    ORA-00600: internal error code, arguments [4194]错误

    NULL 博文链接：https://gembler.iteye.com/blog/346242

    如何处理错误ORA-29275：部分多字节字符

    ### 如何处理错误ORA-29275：部分多字节字符 #### 问题背景与描述 在Oracle数据库操作过程中，用户可能会遇到一个特定的错误提示——ORA-29275：部分多字节字符。这一错误通常出现在执行查询`SELECT * FROM V$...

    p8922013_10204_Linux-x86-64.zipORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059

    3. **联系Oracle支持**：由于ORA-00600是内部错误，可能需要Oracle官方的技术支持来解析错误代码和参数的含义，以及提供解决方案。 4. **应用补丁**：像题目中提供的8922013这样的补丁，可能就是为了解决特定的ORA-...

    ORA-04052p5731178_92080_WINNT.zip

    ORA-00604: 递归SQL层1出现错误 ORA-03106: 致命的双工通信协议错误 ORA-02063: 紧接着line(源于dblink) 以及 ORA-04052: 在查找远程对象时出错 ORA-00604: 递归SQL层1出现错误 ORA-03120: 双工转换例行程序：整数...

    ORA-00060: 等待资源时检测到死锁--oracle 数据库表死锁异常

    在Oracle数据库系统中，"ORA-00060: 等待资源时检测到死锁" 是一个常见的错误提示，它表明两个或多个事务在执行过程中陷入了无法继续进行的状态，因为彼此都在等待对方释放资源。这种情况通常发生在并发操作中，比如...

    ORACLE8I数据库应用EXP工具时ORA-06553报错的解决方法.pdf

    ORACLE8I数据库应用EXP工具时ORA-06553报错的解决方法 摘要：本文主要解决ORACLE 8I数据库应用EXP工具时ORA-06553报错的问题，分析出现问题的原因，并提供了正确的解决方法和措施。 知识点1：Oracle 8I数据库EXP...

    oracle网络配置(listener_ora-sqlnet_ora-tnsnames_ora).mht

    oracle网络配置(listener_ora-sqlnet_ora-tnsnames_ora).mht

    Oracle 10g启动后报ORA-16038错误的解决方法

    ORA-00312: online log 1 thread 1: '/oradata/10g/db/instant/redo01.log' ``` 此错误表明，在尝试归档序列号为230的日志文件时出现了问题，并且达到了恢复文件目的地大小的限制。同时给出了具体的问题文件路径为`...

    Ora-00600 [Qerltcuseriterget_1], [1], [1], [] and Ora-1502 (Doc ID 1432485.1)

    在提供的文档中，ORA-00600错误参数为[qerltcUserIterGet_1],[1],[1],[],[],[],[],[],[],[],[],[]。其中[qerltcUserIterGet_1]指向了具体的内部函数，而后面的数字参数则是该函数调用时的特定上下文信息。 **常见...

Magicbox
Global site tag (gtag.js) - Google Analytics