Database report ORA-00600: Internal error code, parameter: [17059], and generate a large number of trace log files

Source: Internet
Author: User
Tags mutex session id

User feedback database server disk space usage exhausted. View after logging in to the server, discovering that the database generated a large number of trace logs and found ora-600 errors in the alert log

Alert Log Information:

Fri Jul -  .: -: +  -ErrorsinchFile D:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_53832.trc (incident=35764): ORA-00600: Internal error code, parameters: [17059], [0xdd7e984d0], [0xdd7e98d68], [0xe17ad9658], [], [], [], [], [], [], [], []fri Jul -  .: -: on  -Sweep [inc][39570]: completedsweep [inc][39568]: completedsweep [inc][39466]: completedsweep [inc][35764]: Completedfri Jul -  .: -:Ten  -Dde:problem Key'ORA [17059]'was completely flood controlled (0x6) Further messages for  ThisProblem key would be suppressed forUp toTenMinutes

Trace file Contents:

*** -- -- -  .: *:20.058SESSION ID: (42.1215) -- -- -  .: *:20.058CLIENT ID: (server#thread- the) -- -- -  .: *:20.058SERVICE NAME: (sys$users) -- -- -  .: *:20.058MODULE NAME: (JDBC Thin Client) -- -- -  .: *:20.058ACTION NAME: () -- -- -  .: *:20.058libraryhandle:address=17ad9658 hash=931b2cd4 lockmode=n pinmode=0Loadlockmode=0status=Vald objectname:name=select Invokedid, Timeconfig, Lasttime, Nexttime, NextTime2, handlerclz from Bi_schd_timer WHERE nvl (To_char (nexttime ), :"Sys_b_0") = :"sys_b_1"or (Nexttime >=:"sys_b_2"and Nexttime <:"Sys_b_3") Fullhashvalue=EE068DCFA54C7CEA1FF5ED5C931B2CD4 Namespace=sql Area (xx) Type=cursor (xx) identifier=2468031700owneridn= theStatistics:invalidationcount=0Executioncount=32768Loadcount=32769activelocks=1Totallockcount=43844Totalpincount=1Counters:brokencount=1Revocablepointer=1keepdependency=32768keephandle=32768Bucketinuse=43841Handleinuse=43841Concurrency:dependencymutex=17ad9708 (0,11073,0,0) mutex=17ad9780 ( the,1409403,3395054,6) Flags=ron/pin/tim/pn0/dbn/[10012841] Waiterslists:lock=17ad96e8[17ad96e8,17ad96e8] Pin=17ad96f8[17ad96c8,17ad96c8] Timestamp:current= -- the- -  A: -: tolibraryobject:address=d7e984d0 heapmask=0000-0001-0001flags=exs[0000] Flags2=[0000] Publicflags=[0000] Datablocks:block: #='0'NAME=PCUR^931B2CD4 pins=0Change=NONE Heap=17ad95a0 pointer=d7e985b8 extent=d7e98450 flags=i/-/p/a/-/-freedlocation=0Alloc=1.515625Size=4.000000Loadtime=17207577371childtable:size='32768'Child:id='0'table=d7e99380 Reference=d7e98e20 handle=17ad9248 Child:id='1'table=d7e99380 reference=d7e99188 handle=17ad8558 Child:id='2'table=d7e99380 reference=d7e869b0 handle=17ad7868 ... Child:id='32767'Table=31d8e5e8 reference=31d624c0 handle=163589d8 namespacedump:parent cursor:sql_id=1zxgdbk9jqb6n Parent=0000000dd7e985b8 maxchild=32769Plk=y ppn=n kgx Cleanup ...*** -- -- -  .: *:20.885KGX Atomic Operation Log 0000000e16076e40 Mutex 0000000e17ad9780 ( the,0) IDN 931b2cd4 oper EXCL Library Cache uid theEfd5Whr102Slp0Oper=0pt1=17ad9658 pt2=0pt3=0Pt4=0pt5=0ub4=0Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_12308.trcOracle Database 11g Enterprise Edition Release11.2.0.1.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application testing optionslibraryhandle:address< /c7>=17ad9658 hash=931b2cd4 lockmode=n pinmode=0Loadlockmode=0 


Login Database View:

Found Cursor_sharing is set to Smilar, modified to exact after error elimination

sql> Show parameter cursorname                                 TYPE        VALUE---------------------------------------------------- -------------------------cursor_sharing                       string      similarsqlset cursor _sharing=exact scope=both; System altered. SQL>

Other similar errors can be referenced in the MOS documentation:

Understanding and diagnosing ORA-600 [17059] Errors (Doc ID 1683417.1)
Bug 9689310-excessive child Cursors/high version_count/ora-600 [17059] due to bind mismatch (Doc ID 9689310.8)

Database report ORA-00600: Internal error code, parameter: [17059], and generate a large number of trace log files

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.