{"id":1845,"date":"2016-04-01T11:50:12","date_gmt":"2016-04-01T08:50:12","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1845"},"modified":"2016-10-24T11:52:13","modified_gmt":"2016-10-24T08:52:13","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-10700-to-ora-10900","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-10700-to-ora-10900\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-10700 to ORA-10900"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-10700 to ORA-10900<\/strong><\/p>\n

\n
ORA-10700: Alter access violation exception handler<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Use this event to control what the VMS exception handler does when it encounters an access violation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Level: >=10 Suspend current process on access violation *** SET THIS EVENT ONLY UNDER THE SUPERVISION OF ORACLE DEVELOPMENT ***<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10701: Dump direct loader index keys<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Dumps index keys at various points in a direct load based on the value of this event.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10702: Application continuity debugging was not enabled.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Application continuity debugging was not enabled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enable application continuity debugging. Level: 0x0001: Transaction intention debugging<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10704: Print out information about what enqueues are being obtained<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, prints out arguments to calls to ksqcmi and ksqlrl and the return values.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Level indicates details: Level: 1-4: print out basic info for ksqlrl, ksqcmi 5-9: also print out stuff in callbacks: ksqlac, ksqlop 10+: also print out time for each line<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10706: Print out information about global enqueue manipulation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, prints out activity in ksi routines.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Level indicates details: 0-4: show args for each main call 5-9: also indicate callbacks 10+: also printout time for each line<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10707: Simulate process death for instance registration<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, process commits suicide to test instance registration recovery code.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Level indicates where the process will die<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10828: memory allocator error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error in the memory allocator<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the trace files and other relevant output<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10841: Default un-inintialized charact set form to SQLCS_IMPLICIT<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0client side, such as JDBC-THIN 8i client sends 0 as charset form<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This event sets charset form as SQLCS_IMPLICIT when it is 0<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10842: Event for OCI Tracing and Statistics Info<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This event is meant for tracing OCI Calls and getting statistics<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This event sets tracing OCI Calls and gets statistics info<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10848: OCI Non Blocking not supported with\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt made to set connection as non-blocking with another feature that does not support non-blocking.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use blocking connection.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10852: Enable tracing for Enqueue Dequeue Operations<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0NA<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0THIS IS NOT A USER ERROR NUMBER\/MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10854: Sets poll count used for AQ listen code under RAC<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0NA<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0THIS IS NOT A USER ERROR NUMBER\/MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-10862: resolve default queue owner to current user in enqueue\/dequeue<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0resolve default queue owner to current user in enqueue\/dequeue.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0turn on if client wish to resolve the default queue owner to the current user. If not turned on, the default queue owner will be resolved to the login user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10863: Control behavior of buffered background operations<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0NA<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0THIS IS NOT A USER ERROR NUMBER\/MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10865: Control tracing of notification operations<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0NA<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0THIS IS NOT A USER ERROR NUMBER\/MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10873: file\u00a0string<\/i>\u00a0needs to be either taken out of backup mode or media recovered<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to open a database after an instance failure or SHUTDOWN ABORT interrupted an online backup.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the indicated file is not a restored backup, then issue the ALTER DATABASE END BACKUP command and open the database. If the file is a restored online backup, then apply media recovery to it and open the database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10877: error signaled in parallel recovery slave\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel recovery logmerger reached an exception condition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the following error message for the cause, and consult your error manual for the appropriate action.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10878: parallel recovery slave died unexpectedly<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel recovery slave died unexpectedly, PMON cleaning up the process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services. See trace file for more details.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10879: error signaled in parallel recovery slave\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel recovery slave reached an exception condition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the following error message for the cause, and consult your error manual for the appropriate action.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10900: extent manager fault insertion event #string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0causes faults to be generated in instrumented extent code<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0this should only be enabled for internal testing<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-10700 to ORA-10900 ORA-10700: Alter access violation exception handler Cause:\u00a0Use this event to control what the VMS exception handler does when it encounters an access violation. Action:\u00a0Level: >=10 Suspend current process on access violation *** SET THIS EVENT ONLY UNDER THE SUPERVISION OF ORACLE DEVELOPMENT *** ORA-10701:…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1845","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-tL","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1845"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1845\/revisions"}],"predecessor-version":[{"id":1846,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1845\/revisions\/1846"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1845"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}