Database ORA-00600 of a provincial telecommunications industry company [15160]

Database ORA-00600 of a provincial telecommunications industry company [15160]

Systems: HP-UX B .11.31

RAC: YES

Database Version: 10.2.0.4

1. Background

: 39dbrac database Node 2, found a lot of ORA-600 errors in the alert Log, the analysis is the table test_wait statistical information error caused, re-analyze the statistical information of the table, eliminate errors.
 
2. DBRAC database error handling process

1. view the alert Log as follows:

Wed Feb 26 10:11:18 2014

Errors in file/Oracle/admin/dbrac/udump/dbrac2_ora_14794.trc:

ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

Wed Feb 26 10:12:29 2014

Errors in file/oracle/admin/dbrac/udump/dbrac2_ora_14794.trc:

ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

Wed Feb 26 10:13:39 2014

Errors in file/oracle/admin/dbrac/udump/dbrac2_ora_29891.trc:

ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

2. Continue to analyze the trace log as follows:

/Oracle/admin/dbrac/udump/dbrac2_ora_29891.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

ORACLE_HOME =/oracle/product/10.2.0/db

System name: HP-UX

Node name: dbrac2

Release: B .11.31

Version: U

Machine: ia64

Instance name: dbrac2

Redo thread mounted by this instance: 2

Oracle process number: 121

Unix process pid: 29891, image: oracle @ dbrac2

 

* ** Action name :() 10:13:39. 698

* ** Module name :( BusiMonitor @ ccjkp1 (TNS V1-V3) 10:13:39. 698

* ** Service name: (dbrac) 10:13:39. 698

* ** Session id: (1491.11581) 10:13:39. 698

* ** 10:13:39. 698

Ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

Current SQL statement for this session:

Select'm-6M-LM-PM-EM-IM-OM-PM-PM-JM-} M-> M-] test_waitM-SM-P '| count (1) |'m-LM-uM-<M-GM-BM-<M-QM-OM-VM-XM-3M -, m-JM-1M-# M-, M-NM-4M-<M-0M-JM-1M-GM-eM-@ M-mM-# M -! 'Fr

Om test_wait where recvtime <sysdate-10/1440 and stepnow = 0 having
Count (1)> = 1
----- Call Stack Trace -----

Calling call entry argument values in hex

Location type point (? Means dubious value)

----------------------------------------------------------------------------

Ksedst () + 64 call ksedst1 () 000000000? 000000001?

Ksedmp () + 2176 call ksedst () 000000000?

C000000000000C9F?

40010000003eca500?

000000000? 000000000?

000000000?

Ksfdmp () + 48 call ksedmp () 000000003?

Kgeriv () + 336 call ksfdmp () C000000000000695?

000000003?

40010000009382ba0?

000020127? 000000000?

000000000? 000000000?

000000000?

Kgesiv () + 192 call kgeriv () 6000000000031370?

6000000000032428?

400100000018d14c0?

000000000?

9ffffffffee7e8?

3. Further analysis is to have the following SQL trigger ORA-600

Select'm-6M-LM-PM-EM-IM-OM-PM-PM-JM-} M-> M-] test_waitM-SM-P '| count (1) |'m-LM-uM-<M-GM-BM-<M-QM-OM-VM-XM-3M -, m-JM-1M-# M-, M-NM-4M-<M-0M-JM-1M-GM-eM-@ M-mM-# M -! 'Fr

Om test_wait where recvtime <sysdate-10/1440 and stepnow = 0 having count (1)> = 1

For more details, please continue to read the highlights on the next page:

-------------------------------------- Split line --------------------------------------

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

-------------------------------------- Split line --------------------------------------

1 2 Next Page