{"id":1813,"date":"2016-03-26T15:21:07","date_gmt":"2016-03-26T12:21:07","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1813"},"modified":"2016-10-21T15:22:55","modified_gmt":"2016-10-21T12:22:55","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-10200-to-ora-10500","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-10200-to-ora-10500\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-10200 to ORA-10500"},"content":{"rendered":"

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

\n
ORA-10243: simulated error for test\u00a0string\u00a0of K2GTAB latch cleanup<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0levels 1..6 for insert, 7..11 for delete<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10244: make tranids in error msgs print as 0.0.0 (for testing)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0also makes “alter system enable distributed recovery” synchronous<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10259: get error message text from remote using explicit call<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0for npigem coverage testing (normally called only for V5 remote)<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10260: limit size (string<\/i>) of the PGA heap set by event 10261 exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The PGA memory use exceeded the limit set by the event 10261.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check event 10261 settings.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10261: Limit the size of the PGA heap<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the limit is one kilobyte times the level of the event. If the pga grows bigger than this signal an internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10262: Don’t check for memory leaks<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Setting this event to level one causes memory leak checking to be disabled. Setting this event to any other non-zero number allows that number to be used as a threshold value when checking for memory leaks in the PGA, SGA, and UGA heaps.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10263: Don’t free empty PGA heap extents<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This is useful for debugging since watchpoints are lost on free<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10265: Keep random system generated output out of error messages<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0so test system files don’t diff<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10266: Trace OSD stack usage<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Porters should implement this to help them debug their stack implementations. It should be used in at least smcstk().<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10267: Inhibit KSEDMP for testing<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Some tests may generate internal or fatal errors on purpose.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0LEVEL used by KSEDMP is one less than level of this event.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10268: Don’t do forward coalesce when deleting extents<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0setting this event keeps kts from coalescing forward at each extent when dropping a temp segment.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10269: Don’t do coalesces of free space in SMON<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0setting this event prevents SMON from doing free space coalesces<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10270: Debug shared cursors<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Enables debugging code in shared cursor management modules<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10281: maximum time to wait for process creation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0used to override the default SPMXWAIT, level = timeout in sec.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-10282: Inhibit signalling of other backgrounds when one dies<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Used in KSB<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10284: simulate zero\/infinite asynch I\/O buffering<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Used in KCF, level=1 out of space (red), level=2 infinite (green)<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10452: Cannot do block media recovery; media recovery session may be in progress<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A media recovery, RMAN, or flashback database session may have been in progress when an attempt was made to perform block media recovery on the standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check for and cancel any conflicting recovery session and perform block media recovery on the standby database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10456: cannot open standby database; media recovery session may be in progress<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A media recovery, RMAN, or flashback database session may have been in progress on a mounted instance of a standby database when an attempt was made to open the standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check for and cancel any conflicting recovery session and open the standby database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10457: cannot close standby database due to active media recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A media recovery session was in progress on a standby database when an attempt was made to close the standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Cancel the media recovery session and close the standby database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10458: standby database requires recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A standby database was in a state requiring media recovery when an attempt was made to open the standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Perform the necessary recovery and open the standby database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10459: cannot start media recovery on standby database; conflicting state detected<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform media recovery on a standby database while another instance was performing recovery on the standby database, had the standby database open, or a data file move operation was in progress.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Close the standby on all other instances, cancel any conflicting recovery session or data file move operation, and perform manual recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10469: error creating control file backup, no checkpoint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The control file being backed up did not contain a valid control file checkpoint. Therefore the control file could not be backed up, as such a backup would not be usable later for recovery. A common cause for this situation is that you executed CREATE CONTROLFILE, which mounts the database, but not ALTER DATABASE OPEN, to open the database. The latter operation generates a valid control file checkpoint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Open the database with ALTER DATABASE OPEN …, which results in a valid control file checkpoint. Run the backup operation again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10481: Backup data block for data file has an unlogged change<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Flashback was enabled for the data file when the backup data block used for block media recovery had an unlogged change.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the data file from the flashback set or use a backup block that does not contain an unlogged change to perform block media recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10482: Automatic block repair cannot repair an offline or read-only data file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Automatic block repair failed when trying to repair an offline or read-only data file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Bring the data file online in read\/write mode.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10485: Real-Time Query cannot be enabled while applying migration redo.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Real-Time Query feature was enabled when an attempt was made to recover through migration redo generated during primary upgrades or downgrades.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Close the standby database in order to recover through migration redo. Reenable the Real-Time Query feature afterwards.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10546: Cannot perform block media recovery; standby database does not have requisite redo.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform block media recovery on the standby database when the necessary redo was not available.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait until the necessary redo is available and reattempt block media recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10547: Cannot perform block media recovery; standby database is not caught up with primary.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform block media recovery on the standby database up to scn %s, which is greater than the highest scn of %s yet applied at the standby.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recover the standby up to scn %s and reattempt block media recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10548: Cannot perform block media recovery on a read-only plugged-in datafile.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform block media recovery on a read-only plugged-in datafile.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Convert the plugged-in datafile to read\/write and reattempt block media recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10549: Cannot perform block media recovery using a read-only plugged-in backup datafile.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform block media recovery using a backup of a read-only plugged-in datafile.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reattempt block media recovery using a backup taken after the plugged-in datafile has been converted to read\/write.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-10200 to ORA-10500 ORA-10243: simulated error for test\u00a0string\u00a0of K2GTAB latch cleanup Cause:\u00a0levels 1..6 for insert, 7..11 for delete Action:\u00a0None ORA-10244: make tranids in error msgs print as 0.0.0 (for testing) Cause:\u00a0also makes “alter system enable distributed recovery” synchronous Action:\u00a0None ORA-10259: get error message text from remote using…<\/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-1813","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-tf","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1813","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=1813"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1813\/revisions"}],"predecessor-version":[{"id":1814,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1813\/revisions\/1814"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1813"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}