{"id":2183,"date":"2016-09-02T11:05:53","date_gmt":"2016-09-02T08:05:53","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2183"},"modified":"2017-01-23T11:07:33","modified_gmt":"2017-01-23T08:07:33","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-10260-to-ora-10590","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-10260-to-ora-10590\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10260 to ORA-10590"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10260 to ORA-10590<\/strong><\/p>\n

\n
ORA-10260: PGA limit (string<\/i>\u00a0MB) exceeded – process terminated<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Resource Manager SESSION_PGA_LIMIT directive was exceeded because the process used too much program global area (PGA) memory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the complexity of the update or query, or contact your database administrator for more information.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10261: limit the size of the PGA heap<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The limit was one kilobyte times the level of the event. If the PGA grows bigger than this, signal an external error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10262: Don’t check for memory leaks<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10263: Don’t free empty PGA heap extents<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This is useful for debugging since watchpoints are lost on free<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10265: Keep random system generated output out of error messages<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0so test system files don’t diff<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10266: Trace OSD stack usage<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Porters should implement this to help them debug their stack implementations. It should be used in at least smcstk().<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10267: Inhibit KSEDMP for testing<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Some tests may generate internal or fatal errors on purpose.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0LEVEL used by KSEDMP is one less than level of this event.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10268: Don’t do forward coalesce when deleting extents<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0setting this event keeps kts from coalescing forward at each extent when dropping a temp segment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10269: Don’t do coalesces of free space in SMON<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0setting this event prevents SMON from doing free space coalesces<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10270: Debug shared cursors<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Enables debugging code in shared cursor management modules<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10271: distributed transaction after COLLECT<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10272: distributed transaction before PREPARE<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10273: distributed transaction after PREPARE<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10274: distributed transaction before COMMIT<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10275: distributed transaction after COMMIT<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10276: distributed transaction before FORGET<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10277: Cursor sharing (or not) related event (used for testing)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10278: Internal testing<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10279: Simulate block corruption in kdb4chk<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10280: Internal testing – segmentation fault during crash recovery<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10281: maximum time to wait for process creation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0used to override the default SPMXWAIT, level = timeout in sec.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10282: Inhibit signalling of other backgrounds when one dies<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Used in KSB<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10284: simulate zero\/infinite asynch I\/O buffering<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Used in KCF, level=1 out of space (red), level=2 infinite (green)<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-10285: Simulate control file header corruption<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10286: Simulate control file open error<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10287: Simulate archiver error<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10288: Do not check block type in ktrget<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10289: Do block dumps to trace file in hex rather than fromatted<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10290: Internal sequence tracing event<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10291: die in tbsdrv to test control file undo<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10294: ksrpc tracing<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10296: disable ORA-379<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10298: ksfd i\/o tracing<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10299: Trace prefetch tracking decisions made by CKPT<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10301: Enable LCK timeout table consistency check<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10319: Trace PGA statistics maintenance<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10320: Enable data layer (kdtgrs) tracing of space management calls<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10322: CBO don’t simplify inlist predicates<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10323: before committing an add datafile command<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10324: Enable better checking of redo logs errors<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10336: Do remote object transfer using remote SQL<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10338: CBO don’t use inlist iterator with function-based indexes<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10339: CBO disable DECODE simplification<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10341: Simulate out of PGA memory in DBWR during object reuse<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10342: Raise unknown exception in ACQ_ADD when checkpointing<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10343: Raise an out of memory exception-OER 4031 in ACQ_ADD<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10345: validate queue when linking or unlinking a buffer<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10346: check that all buffers for checkpoint have been written<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10347: dump active checkpoint entries and checkpoint buffers<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10349: do not allow ckpt to complete<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10350: Simulate more than one object & tsn id in object reuse<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10351: size of slots<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10352: report direct path statistics<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10353: number of slots<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10354: turn on direct read path for parallel query<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10355: turn on direct read path for scans<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10356: turn on hint usage for direct read<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10357: turn on debug information for direct path<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10358: Simulate out of PGA memory in cache advisory reset<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10359: turn off updates to control file for direct writes<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10365: turn on debug information for adaptive direct reads<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10366: kgnfs tracing<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10367: kgodm tracing<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10368: maximum number of internal errors a process will tolerate<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10369: test SQL monitoring feature<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10375: turn on checks for statistics rollups<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10376: enable archive compression loads<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10378: force hard process\/range affinity<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10380: kxfp latch cleanup testing event<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10381: kxfp latch cleanup testing event<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10383: auto parallelization testing event<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10384: parallel dataflow scheduler tracing<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10385: parallel table scan range sampling method<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10386: parallel SQL hash and range statistics<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10390: Trace parallel query slave execution<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10391: trace PX granule allocation\/assignment<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10392: parallel query debugging bits<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10393: print parallel query statistics<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10394: generate a fake load to test adaptive and load balancing<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10395: adjust sample size for range table queues<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10397: suppress verbose parallel coordinator error reporting<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10398: enable timeouts in parallel query threads<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10399: trace buffer allocation<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10400: turn on system state dumps for shutdown debugging<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10401: turn on IPC (ksxp) debugging<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10402: turn on IPC (skgxp) debugging<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10403: fake CPU number for default degree of parallelism<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10404: crash dbwr after write<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10405: emulate broken mirrors<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10406: enable datetime TIMESTAMP, INTERVAL datatype creation<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10407: enable datetime TIME datatype creation<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10408: disable OLAP builtin window function usage<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10409: enable granule memset and block invalidation at startup<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10450: signal ctrl-c in kdddca (drop column) after n rows<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10451: Force heap segment compression bypassing compatibility checks<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10452: Cannot do block media recovery; media recovery session may be in progress<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\n

Action:<\/b>\u00a0Check for and cancel any conflicting recovery session and perform block media recovery on the standby database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10456: cannot open standby database; media recovery session may be in progress<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\n

Action:<\/b>\u00a0Check for and cancel any conflicting recovery session and open the standby database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10457: cannot close standby database due to active media recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\n

Action:<\/b>\u00a0Cancel the media recovery session and close the standby database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10458: standby database requires recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\n

Action:<\/b>\u00a0Perform the necessary recovery and open the standby database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10459: cannot start media recovery on standby database; conflicting state detected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\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><\/p>\n

\n
<\/a> ORA-10460: Perform backward tablescans for consistent read reduction<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10461: Simulate control file corruption during write operation<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10462: enable recovery debug module<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10469: error creating control file backup, no checkpoint<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\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><\/p>\n

\n
<\/a> ORA-10481: Backup data block for data file has an unlogged change<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\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><\/p>\n

\n
<\/a> ORA-10482: Automatic block repair cannot repair an offline or read-only data file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Automatic block repair failed when trying to repair an offline or read-only data file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Bring the data file online in read\/write mode.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10485: Real-Time Query cannot be enabled while applying migration redo.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\n

Action:<\/b>\u00a0Close the standby database in order to recover through migration redo. Reenable the Real-Time Query feature afterwards.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10493: Return empty define buffers on 1422<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10496: Turn off fix for bug 2554178<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10498: Trim blank characters including contol characters<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10501: periodically check selected heap<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10502: CBO disable the fix for bug 2098120<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10503: enable user-specified graduated bind lengths<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10504: CBO disable the fix for bug 2607029<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10505: CBO enable dynamic sampling dump to table<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10506: Disable fix for bug 2588217<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10507: Trace bind equivalence logic<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10508: Enable fix for bug 14772545<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10509: Check kghu subheaps at call boundaries<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10510: turn off SMON check to offline pending offline rollback segment<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10511: turn off SMON check to cleanup undo dictionary<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10512: turn off SMON check to shrink rollback segments<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10515: turn on event to use physical cleanout<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10519: enable ALTER TYPE RESET support<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10520: recreate view only if definition has changed<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10522: turn off wrap source compression<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10523: force recreate package even if definition is unchanged<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10525: Disable automatic object validation for describe<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10526: enables lightweight thread tracing<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Used in ksolt.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set this event only under the supervision of Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10527: enables SGA allocation tracing<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Used for logging events during SGA allocation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set this event only under the supervision of Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10528: enables ksmg tracing<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Used in ksmg module.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set this event only under the supervision of Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10530: lightweight thread spawn failed, error stack:<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A lightweight thread spawn failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the alert or trace files for more information.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10531: lightweight thread unit test failure error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A lightweight thread unit test failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the alert or trace files for more information.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10532: lightweight thread encountered internal error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A lighweight thread encountered an internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the alert or trace files for more information and contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10546: Cannot perform block media recovery; standby database does not have requisite redo.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\n

Action:<\/b>\u00a0Wait until the necessary redo is available and reattempt block media recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10547: Cannot perform block media recovery; standby database is not caught up with primary.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\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><\/p>\n

Action:<\/b>\u00a0Recover the standby up to scn %s and reattempt block media recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10548: Cannot perform block media recovery on a read-only plugged-in datafile.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform block media recovery on a read-only plugged-in datafile.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Convert the plugged-in datafile to read\/write and reattempt block media recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10549: Cannot perform block media recovery using a read-only plugged-in backup datafile.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform block media recovery using a backup of a read-only plugged-in datafile.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reattempt block media recovery using a backup taken after the plugged-in datafile has been converted to read\/write.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10550: signal error during create as select\/create index after n rows<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10551: Internal testing for ORA-1551 error handling<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10553: Incompatible UNTIL CONSISTENT clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0RECOVER UNTIL CONSISTENT required database-level recovery with a backup control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Omit the UNTIL CONSISTENT clause and retry recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10554: Media recovery failed to bring datafile\u00a0string<\/i>\u00a0to a consistent point<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Media recovery couldn’t recover database to a consistent point due to the specified datafile.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Restore a backup of the datafile.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10560: block type ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Report block type for details of another error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See associated error message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10561: block type ‘string<\/i>‘, data object#\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Report block type and data object number for details of another error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See associated error message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10562: Error occurred while applying redo to data block (file#\u00a0string<\/i>, block#\u00a0string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0See other errors on error stack.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Investigate why the error occurred and how important is the data block. Media and standby database recovery usually can continue if user allows recovery to corrupt this data block.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10563: Test recovery had to corrupt data block (file#\u00a0string<\/i>, block#\u00a0string<\/i>) in order to proceed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Test recovery completed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary of the result of the test recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10564: tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Report tablespace name for details of another error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See associated error message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10565: Another test recovery session is active<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There can only be one test recovery session at any time. Another test recovery session is active.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait till the other test recovery session completes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10566: Test recovery has used all the memory it can use<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Test recovery tests redo in memory. It can no longer proceed because it has consumed all the memory it can use.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary result of the test recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10567: Redo is inconsistent with data block (file#\u00a0string<\/i>, block#\u00a0string<\/i>, file offset is\u00a0string<\/i>\u00a0bytes)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There are two possible causes of this error: (1) A write issued by Oracle was lost by the underlying OS or storage system. (2) an Oracle internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Investigate why the error occurred and how important is the data block. Media and standby database recovery usually can continue if user allows recovery to corrupt this data block.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10568: Failed to allocate recovery state object: out of SGA memory<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0out of SGA memory<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Restart the instance. If problem persists, call Oracle support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10570: Test recovery complete<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Test recovery completed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary result of the test recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10571: Test recovery canceled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User canceled test recovery.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary of the result of the test recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10572: Test recovery canceled due to errors<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0See other errors on the error stack.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See other messages on error stack. It is possible that no action is needed. See other messages on error stack for a summary of the result of the test recovery so far.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10573: Test recovery tested redo from change\u00a0string<\/i>\u00a0to\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This message show the range of test recovery have tested.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. See other messages on error stack.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10574: Test recovery did not corrupt any data block<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This message summarizes test recovery result.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. See other messages on error stack.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There were not enough memory to restore recovered datafiles to consistent state<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This error is just a warning: You may not be able to open the database with resetlogs immediately after this error. However, you may continue media\/standby recovery, and that may make the datafiles recovered consistent again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0See alert file or other errors on the stack for a cause of the problem.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This error is just a warning: You may not be able to open the database with resetlogs immediately after this error. However, you may continue media\/standby recovery, and that may make the datafiles recovered consistent again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10577: Can not invoke test recovery for managed standby database recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Test recovery option is used for managed standby database recovery.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either remove the test recovery option or invoke manual test standby database recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10578: Can not allow corruption for managed standby database recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You used the allow corruption option for managed standby database recovery.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either remove the allow corruption option or invoke manual standby database recovery.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10579: Can not modify control file during test recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0To proceed with recovery, test recovery needs to modify the control file. But test recovery is not allowed to modify control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. It can only go so far in the redo stream.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10580: Can not modify datafile header during test recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0To proceed with recovery, test recovery needs to modify a datafile header. But test recovery is not allowed to modify datafile headers.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. It can only go so far in the redo stream.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10581: Can not modify redo log header during test recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0To proceed with recovery, test recovery needs to modify a redo log header. But test recovery is not allowed to modify redo log headers.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. It can only go so far in the redo stream.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10582: The control file is not a backup control file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User requested backup control file test recovery, but the control file is not a backup control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a backup control file, or do not use USING BACKUP CONTROLFILE option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10583: Can not recovery file\u00a0string<\/i>\u00a0renamed as missing during test recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of the files to be recovered is renamed as missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rename the file to the correct file or offline it.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10584: Can not invoke parallel recovery for test recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Both test recovery and parallel recovery are requested.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop either one of the two recovery options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10585: Test recovery can not apply redo that may modify control file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Test recovery has encountered a special redo that may modify control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action is needed. Test recovery has proceeded successfully as far as it could from its starting point.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10586: Test recovery had to corrupt 1 data block in order to proceed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This message summarizes test recovery result: Oracle may have to corrupt one block in order to apply the range of redo tested.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See alert log for details of the problem.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10587: Invalid count for ALLOW n CORRUPTION option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number specified in the ALLOW n CORRUPTION option is too big.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a smaller number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-10588: media recovery file header validation<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-10589: Test recovery had to corrupt\u00a0string<\/i>\u00a0data blocks in order to proceed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This message summarizes test recovery result: Oracle may have to corrupt a number of data blocks as specified in the message in order to apply the range of redo tested.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See alert log for details of the problems.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10260 to ORA-10590 ORA-10260: PGA limit (string\u00a0MB) exceeded – process terminated Cause:\u00a0The Resource Manager SESSION_PGA_LIMIT directive was exceeded because the process used too much program global area (PGA) memory. Action:\u00a0Reduce the complexity of the update or query, or contact your database administrator for more information. ORA-10261:…<\/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":[54],"class_list":["post-2183","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-zd","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2183","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=2183"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2183\/revisions"}],"predecessor-version":[{"id":2184,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2183\/revisions\/2184"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2183"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}