Identifikace chyby

adrci> show alert
ADR Home = /u01/app/oracle/diag/rdbms/racdb/racdb1:
*************************************************************************
2014-05-21 17:54:38.965000 +02:00
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_93406.trc (incident=109298):
ORA-00600: internal error code, arguments: [qcsfbdnp:1], [PIDPERS], [], [0], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/racdb/racdb1/incident/incdir_109298/racdb1_ora_93406_i109298.trc
2014-05-21 17:54:40.395000 +02:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Dumping diagnostic data in directory=[cdmp_20140521175440], requested by (instance=1, osid=93406), summary=[incident=109298].
2014-05-21 17:54:42.149000 +02:00
Sweep [inc][109298]: completed
Sweep [inc2][109298]: completed
adrci> show problem
ADR Home = /u01/app/oracle/diag/rdbms/racdb/racdb1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME 
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 600 [kkdlGetBaseUser2:authIdType] 45329 2014-05-09 09:39:58.726000 +02:00
2 ORA 600 [qcsfbdnp:1] 109298 2014-05-21 17:54:38.965000 +02:00

Detailní popis chyby

adrci> show incident -mode detail -p "incident_id=109298"
ADR Home = /u01/app/oracle/diag/rdbms/racdb/racdb1:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
 INCIDENT_ID 109298
 STATUS ready
 CREATE_TIME 2014-05-21 17:54:38.965000 +02:00
 PROBLEM_ID 2
 CLOSE_TIME <NULL>
 FLOOD_CONTROLLED none
 ERROR_FACILITY ORA
 ERROR_NUMBER 600
 ERROR_ARG1 qcsfbdnp:1
 ERROR_ARG2 PIDPERS
 ERROR_ARG3 <NULL>
 ERROR_ARG4 0
 ERROR_ARG5 <NULL>
 ERROR_ARG6 <NULL>
 ERROR_ARG7 <NULL>
 ERROR_ARG8 <NULL>
 ERROR_ARG9 <NULL>
 ERROR_ARG10 <NULL>
 ERROR_ARG11 <NULL>
 ERROR_ARG12 <NULL>
 SIGNALLING_COMPONENT SQL_Parser
 SIGNALLING_SUBCOMPONENT <NULL>
 SUSPECT_COMPONENT <NULL>
 SUSPECT_SUBCOMPONENT <NULL>
 ECID <NULL>
 IMPACTS 0
 PROBLEM_KEY ORA 600 [qcsfbdnp:1]
 FIRST_INCIDENT 54866
 FIRSTINC_TIME 2014-05-14 17:21:37.793000 +02:00
 LAST_INCIDENT 109298
 LASTINC_TIME 2014-05-21 17:54:38.965000 +02:00
 IMPACT1 0
 IMPACT2 0
 IMPACT3 0
 IMPACT4 0
 KEY_NAME Client ProcId
 KEY_VALUE oracle@dbserver1 (TNS V1-V3).93406_139949757630176
 KEY_NAME PQ
 KEY_VALUE (0, 1400687678)
 KEY_NAME ProcId
 KEY_VALUE 57.59
 KEY_NAME SID
 KEY_VALUE 183.10565
 OWNER_ID 1
 INCIDENT_FILE /u01/app/oracle/diag/rdbms/racdb/racdb1/incident/incdir_109298/racdb1_ora_93406_i109298.trc
 OWNER_ID 1
 INCIDENT_FILE /u01/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_93406.trc
1 rows fetched

Odkaz na trace soubor

adrci> show tracefile -I 109298
 diag/rdbms/racdb/racdb1/incident/incdir_109298/racdb1_ora_93406_i109298.trc
Vytvoření package
adrci> ips create package problem 2 correlate all
Created package 2 based on problem id 2, correlation level all
adrci> ips generate package 2 in "/home/oracle"
Generated package 2 in file /home/oracle/ORA600qcs_20140522095647_COM_1.zip, mode complete
[oracle@dbserver1 ~]$ ls -ltr
total 22440
-rw-r--r-- 1 oracle oinstall 22921585 May 22 10:00 ORA600qcs_20140522095647_COM_1.zip

Pak jen poslat pře My Oracle suppot do Oracle.



Komentáře