SQL ORA-00600: error: internal error code, parameters: [qcsfbdnp:1], [], [], [],

Recommended for you: Get network issues from WhatsUp Gold. Not end users.


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


Error at line 145 to execute a command:
call CY_ALL_GAOJINSHUCHU('2014-02-18')
The error report:
SQL ORA-00600: error: internal error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: in "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 version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved. 

C:\Users\Administrator>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Friday, February 21 14:56:50 2014

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

Not connected to the SP2-0640
SQL> conn sys/fsyd@192.168.1.108:1521/fsyd as sysdba
The connected. 

The session has changed. 

SQL> show parameter cursor_sharing

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

The system has been changed. 

SQL> show parameter cursor_sharing

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





The following content from other sites:

Java.sql.SQLException: ORA-00600: internal error code, parameters: [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)
------------------------------------------------------------------------------------------------------------------------------
//Find the following solutions on the Internet:

Solving process of ORA-00600

Received a lot of mail today, the following error

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

Because the database principal business, but other small features such failure, so to see the 600, but also didn't what. 

No METALINK account, I had from the various log to see what is not found, basically all the warnings are pointers to 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

Had a 600, to object to the reconstruction is solved, this time also try this, the SQL for a table to the reconstruction, but the fault is still. 

Try to search based on the ORA-600 and [kkslhsh1] fields, found a BUG on the cursor_sharing is set to FORCE, the ORA-600 database is FORCE, intuition told me and this relationship, then take the following operation: 

1 modify the parameters

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 clear look at the shared pool

SQL> alter system flush shared_pool;

System altered.

Check the error reporting function, normal! Below enclosed some 600 BUG and 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





The other answers:



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;


This seems to be a BUg Oracle, I met several times
In 9205 other 10g repair, there will be occasional
Refer to the metalink Doc ID: Note:248095.1 
In addition, the parameter you should have little problem

Your symptoms much like Bug 2458655  
As far as I know, CURSOR_SHARING = SIMILAR is very easy to cause the error from [qctcte1]
Unfortunately, my OPN account can not be submitted to tar

9.2.0.4 I have ORA-00600: internal error code, parameters: [qmxiUnpPacked2], [121], [], [], [], [], [], []
select 1 from resource_view where any_path = '/xdbconfig.xml'
Try to remove the XDB scheme, no problem. 


TO Fenng said
I will be set to CURSOR_SHARING = force, I changed back to try

Problem solved, thank you!
The CURSOR_SHARING = force commented on the line
 
The CURSOR_SHARING Oracle function I doubt do not play the positive role, seems to be just Oracle an action to technology promotion for it, maybe the development team attempted to use this slip by? Ha ha.





  Generally this error message, that may be encountered in Oracle bug: 1725012. The error text is about: java.sql.SQLException: ORA-00600: internal error code, parameters:  [ttcgcshnd-1],  [0],  [],  [],  [],  [],  [],  [] 

   In fact, this does not mean that your database or database connection problems, this is only Oracle inside the bug, so as long as they can keep the error screen, you can resume normal. 

   The Oracle method for screening event is to use the Event event, Events event is an important diagnostic tool and problem of Oracle solution, most of the time required by the Events settings to block or change the behavior of a Oracle, here is an example, used to increase the Events event set: 

SQL> alter system set event="10841 trace name context forever" scope=spfile;

   By setting the above events, especially the 10841 event, can shield and solve the above mentioned ORA-00600 error. 

   At the same time, it is also a method to solve the JDBC Driver problem in Oracle9i for Thin. 

   Finally, after the best setup, restart Oracle. 





Internal ORA-00600: error code, parameters: [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

Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []-600

Is said to be Oracle bug, my version is: 10.2.0.1

A similar problem: see next page. 





Environmental Science: hp-ux11+jboss3.2.6+oracle9201
Recently the number of concurrent systems using high point, the application system of old crash situation.. Database log report a lot of 600 internal error, please prawns help analyze what is the reason?
. . . 
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16382.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:25:52 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:36:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:46:43 2008
. . . 
The log information please see the attachment. 
Accessories: alert_ahltpm.log.txt (2008-5-20 16:58, 18.35 KB) / download times 4
 ;aid=NTMwODE2fDU0YzIxNGMxfDEzOTI5NjY2MTh8MHww

Accessories: ahltpm_ora_25128.trc.txt (2008-5-20 16:58, 2.64 MB) / download times 4
 ;aid=NTMwODE3fDQ4ZmQ4OThmfDEzOTI5NjY2MTh8MHww


The study, in the online search a bit with a such posts to see whether has the help to you
 
ORA-00600 is an internal error Oracle. What is the internal error, Oracle is considered to be uncheck error. 

I am in the query is executed the emergence of such a prompt, use the 9.2.0.1 version, I looked for a long time, the first reaction is: when finished, Oracle BUG, to be patched. 

Later found a forum, here:... 325619? Cv=expanded#. Expert advice, finally solved. 
My solution is simple, change a parameter: 
STAR_TRANSFORMATION_ENABLED from TRUE to FALSE. 




Author: terry_wu040802 time: 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






Annex:


Alert_ahltpm.log.txt is as follows:

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:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 09:43:22 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16344.trc:
Internal ORA-00600: error code, parameters: [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:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:25:52 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:36:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:46:43 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:48:44 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16382.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:50:52 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16596.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 10:54:10 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16562.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 11:36:57 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:18:56 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:20:57 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:20:57 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17076.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:31:25 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 14:39:40 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:14:10 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17272.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:16:13 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:17:19 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:20:27 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17356.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:21:16 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:35:14 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17356.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:44:04 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:46:06 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17319.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 15:47:54 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 16:00:06 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16630.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 16:00:06 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_16882.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Tue May 13 16:00:11 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_17230.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:21:57 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20705.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:41:45 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20559.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:43:46 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20635.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:43:46 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20705.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:43:46 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20643.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 09:49:01 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:19:21 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20917.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:21:49 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:30:16 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:31:09 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:38:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20915.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:41:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 10:41:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21000.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 11:11:07 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20765.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 11:15:06 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_20774.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 11:35:04 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21000.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 15:18:33 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21608.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 15:55:31 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21737.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 16:11:37 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21737.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 16:47:41 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21336.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 17:08:11 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21955.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 17:48:17 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_21604.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 18:20:54 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22014.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 19:20:30 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22312.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 19:22:32 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22357.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 19:26:58 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22401.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 19:52:30 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22403.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:14:36 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22278.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:25:11 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22403.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:25:33 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22584.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:25:50 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22357.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:26:05 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22278.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Wed May 14 20:40:24 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_22584.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 08:46:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24819.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 08:48:02 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24981.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:55:28 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25128.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:08 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25249.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25126.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25253.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24981.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:57:59 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25255.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25057.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25242.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:00 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25244.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:01 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25246.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 09:58:01 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_24819.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 10:00:29 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25128.trc:
Internal ORA-00600: error code, parameters: [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:
Internal ORA-00600: error code, parameters: [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:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 14:38:30 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 14:41:51 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25999.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 16:46:17 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 17:06:23 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_25750.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Thu May 15 17:06:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_26232.trc:
Internal ORA-00600: error code, parameters: [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:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 08:50:58 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29309.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 09:02:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29244.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 09:20:42 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29244.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 09:51:25 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29362.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []
Fri May 16 10:25:08 2008
Errors in file /opt/oracle/admin/ahltpm/udump/ahltpm_ora_29311.trc:
Internal ORA-00600: error code, parameters: [qcsfbdnp:1], [], [], [], [], [], [], []



Ahltpm_ora_25128.trc.txt too much content not posted.


The final solution is:

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')||'%'
                                         )
                           );
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Clare at August 08, 2014 - 5:15 AM