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

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.