Menu de navegação

[PabloParticipante]

Foi dar uma conferida no EM e ele me alerto sobre um incident error e olhando o log tenho a seguinte mensagem.

Errors in file /opt/oracle/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_29808.trc (incident=33954):
ORA-00600: internal error code, arguments: [qsmqLockUnlock-2], [84476], [], [], [], [], [], [], [], [], [], []

Porém não tenho tido problemas em trabalhar com o banco, mas gostaria de saber o que posso fazer para resolver este problema?

[PabloParticipante]

Trace file

Trace file /opt/oracle/diag/rdbms/orcl/orcl/trace/WINT_ora_29808.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11gR2/db
System name: Linux
Node name: wtserver
Release: 3.0.76-0.11-default
Version: #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990)
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 43
Unix process pid: 29808, image: oracle@wtserver

*** 2013-11-05 12:05:28.964
*** SESSION ID:(337.49046) 2013-11-05 12:05:28.964
*** CLIENT ID:() 2013-11-05 12:05:28.964
*** SERVICE NAME:(SYS$USERS) 2013-11-05 12:05:28.964
*** MODULE NAME:(PCINFTAB.exe) 2013-11-05 12:05:28.964
*** ACTION NAME:() 2013-11-05 12:05:28.964

——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :

*** 2013-11-05 12:05:33.370
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :

*** 2013-11-05 12:05:33.842
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TRG_GRAVAR_PCCLIENT_CGEENTAUX
Trigger Owner : DELTA
Trigger Name : TINS_PCCLIENT_ATUCX_BEF
Trigger Owner : DELTA
Trigger Name : TRG_PCCLIENTLOG
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMAUSR
Trigger Name : TK_ELIMINA_COORDENADAS_CLIENTE
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCLIENT
trigger sublist 4 :

*** 2013-11-05 12:08:00.017
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
trigger sublist 4 :

*** 2013-11-05 12:08:15.035
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
trigger sublist 4 :

*** 2013-11-05 12:08:22.997
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
trigger sublist 4 :

*** 2013-11-05 12:08:27.775
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
trigger sublist 4 :
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSCONFIGERP
trigger sublist 4 :

*** 2013-11-05 12:09:51.278
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSFILIAL
Trigger Owner : DELTA
Trigger Name : TRIGGER_PCFILIAL_PROXNUMNOTA
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRIGGER_PCFILIAL_PROXNUMNOTA
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSFILIAL
trigger sublist 4 :

*** 2013-11-05 12:09:53.108
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSFILIAL
Trigger Owner : DELTA
Trigger Name : TRIGGER_PCFILIAL_PROXNUMNOTA
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TRIGGER_PCFILIAL_PROXNUMNOTA
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSFILIAL
trigger sublist 4 :

*** 2013-11-05 12:12:01.587
——–Dumping Sorted Master Trigger List ——–
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSTRIBUT
Trigger Owner : DELTA
Trigger Name : TINS_PCTRIBUT_ATUCX_BEF
——–Dumping Trigger Sublists ——–
trigger sublist 0 :
trigger sublist 1 :
Trigger Owner : DELTA
Trigger Name : TINS_PCTRIBUT_ATUCX_BEF
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : MXMASALESUSR2
Trigger Name : TK_SYNC_FV_MXSTRIBUT
trigger sublist 4 :

*** 2013-11-05 12:12:05.697
Incident 33954 created, dump file: /opt/oracle/diag/rdbms/orcl/orcl/incident/incdir_33954/WINT_ora_29808_i33954.trc
ORA-00600: internal error code, arguments: [qsmqLockUnlock-2], [84476], [], [], [], [], [], [], [], [], [], []

Incident 33955 created, dump file: /opt/oracle/diag/rdbms/orcl/orcl/incident/incdir_33955/WINT_ora_29808_i33955.trc
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [qsmqLockUnlock-2], [84476], [], [], [], [], [], [], [], [], [], []

kgefec: fatal error 0

[rmanParticipante]

@Pablo

Abre um SR no suporte da Oracle.

[Autor]

Posts