{"id":2050,"date":"2016-08-06T11:13:03","date_gmt":"2016-08-06T08:13:03","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2050"},"modified":"2016-12-12T09:23:32","modified_gmt":"2016-12-12T06:23:32","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-00500-to-ora-00900","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-00500-to-ora-00900\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00500 to ORA-00900"},"content":{"rendered":"

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

\n
ORA-00500: Listener registration process terminated with an error.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The listener registration process died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00501: CLMN process terminated with error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The cleanup process died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00502: PMAN process terminated with error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The manager process died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00503: CL** process terminated with error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A cleanup slave died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00504: Service monitor background process terminated with error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The service monitor background process died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0PMON will restart the background process shortly.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00505: GEN1 process terminated with error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The generic background processing process 1 died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00510: not a valid MGA heap index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given Managed Global Area (MGA) index was not of the heap type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-00511: Cluster flash cache background process terminated with error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The cluster flash cache process died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00566: cannot request processor group – NUMA not enabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Cannot start process in a requested processor group when the NUMA feature is disabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Start the process without requesting a NUMA processor group.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-00567: Requested processor group\u00a0string<\/i>\u00a0is too large (maximum\u00a0string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The process could not be started in the requested processor group.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Start the process in another processor group.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00568: Maximum number of interrupt handlers exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User specified too many ^c handlers<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove some old handlers.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00569: Failed to acquire global enqueue.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A prior error occurred on one of the instances in the cluster. Typically errors are caused by shared pool resource contention.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check for and resolve prior errors on all instances in the cluster. If there is shared pool resource contention, increase the SHARED_POOL_SIZE, DML_LOCKS, PROCESSES, TRANSACTIONS, CLUSTER_DATABASE_INSTANCES and PARALLEL_MAX_SERVERS initialization parameters.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00574: osndnt: $CANCEL failure (break)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00575: osndnt: $QIO failure (send out-of-band break)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00576: in-band break protocol error<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00577: out-of-band break protocol error<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00578: reset protocol error<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00579: osndnt: server received malformed connection request<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00580: protocol versions do not match<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00581: osndnt: cannot allocate context area<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00582: osndnt: cannot deallocate context area<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00583: osndnt: $TRNLOG failure<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00584: cannot close connection<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00585: host name has incorrect form<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00586: osndnt: LIB$ASN_WTH_MBX failure<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00587: cannot connect to remote host<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00588: message from host was too short<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00589: message from host had incorrect data length<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00590: message from host had incorrect message type<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00591: incorrect number of bytes written<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00592: osndnt: $QIO failure (mailbox queue)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00593: osndnt: $DASSGN failure (network device)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00594: osndnt: $DASSGN failure (mailbox)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00595: osndnt: $QIO failure (receive)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00596: osndnt: $QIO failure (send)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00597: osndnt: $QIO failure (mailbox requeue)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00598: osndnt: $QIO failure (mailbox read)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00600: internal error code, arguments: [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. The first argument is the internal message number. This argument and the database version number are critical in identifying the root cause and the potential impact to your system.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Visit My Oracle Support to access the ORA-00600 Lookup tool (reference Note 600.1) for more information regarding the specific ORA-00600 error encountered. An Incident has been created for this error in the Automatic Diagnostic Repository (ADR). When logging a service request, use the Incident Packaging Service (IPS) from the Support Workbench or the ADR Command Interpreter (ADRCI) to automatically package the relevant trace information (reference My Oracle Support Note 411.1). The following information should also be gathered to help determine the root cause: – changes leading up to the error – events or unusual circumstances leading up to the error – operations attempted prior to the error – conditions of the operating system and databases at the time of the error Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00601: cleanup lock conflict<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The process monitor (PMON) database process ran into a lock conflict while trying to recover the processes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is an internal issue. No action required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00602: internal programming exception: [PC:string<\/i>] [ADDR:string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An address violation was encountered.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Report the issue as a bug.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00603: ORACLE server session terminated by fatal error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An Oracle server session was in an unrecoverable state.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Log in to Oracle again so a new server session will be created automatically. Examine the session trace file for more information.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00604: error occurred at recursive SQL level\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00606: Internal error code<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A call to deferred upi functions was made in non deferred mode<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Report as a bug.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00607: Internal error occurred while making a change to a data block<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error or memory exception occurred while Oracle was applying redo to a data block.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0call Oracle Support<\/span><\/span><\/p>\n

\n
<\/a> ORA-00608: testing error [string<\/i>] [string<\/i>] [string<\/i>] [string<\/i>] [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Internal error reserved for testing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0call Oracle Support<\/span><\/span><\/p>\n

\n
<\/a> ORA-00609: could not attach to incoming connection<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Oracle process could not answer incoming connection<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00614: quarantine limit has been reached<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A quarantine limit was reached and the instance was aborted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Restart the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00700: soft internal error, arguments: [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Internal inconsistency that will not crash a process<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Report as a bug – the first argument is the internal error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00701: object necessary for warmstarting database cannot be altered<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempt to alter or drop a database object (table, cluster, or index) which are needed for warmstarting the database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-00702: bootstrap verison ‘string<\/i>‘ inconsistent with version ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The reading version of the boostrap is incompatible with the current bootstrap version.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Restore a version of the software that is compatible with this bootstrap version.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00703: maximum number of row cache instance locks exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There are not enough row cache enqueues.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase the row cache enqueue parameter and warm start the system.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00704: bootstrap process failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failure in processing bootstrap data – see accompanying error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00705: inconsistent state during start up; shut down the instance, then restart it<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A previous attempt to start an instance was terminated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shut down the instance completely, then restart it.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00706: error changing format of file ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to change the block0 format of the specified file failed because the file is read-only or offline.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make the file read-write or bring the file online and set the BLK0_FMTCHG event.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00710: new tablespace name is the same as the old tablespace name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to rename a tablespace failed because the new name is the same as the old name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00711: new tablespace name is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to rename a tablespace failed because the new name is invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose a valid new name and retry the command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00712: cannot rename system tablespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to rename the system tablespace failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00720: ALTER DATABASE RESET COMPATIBILITY command has been de-supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER DATABASE RESET COMPATIBILITY command has been de-supported since Oracle 10i.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00721: changes by release\u00a0string<\/i>\u00a0cannot be used by release\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to import a tablespace failed because the tablespace contains changes that require a newer software release or that violate the compatibility parameters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a version of the software that can understand the changes or relax the compatibility requirements in the initialization parameter file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00722: Feature “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Reporting name of the feature for details of another error.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-00723: Initialization parameter COMPATIBLE must be explicitly set<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Oracle detected that the initialization parameter COMPATIBLE was not explicitly specified, and the compatibility of the database is lower than the default value of the COMPATIBLE parameter. In order to use the new compatible setting, the intialization parameter must be explicitly set by the user.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Explicitly set the value of COMPATIBLE parameter either in PFILE or SPFILE, whichever is used.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00724: ALTER DATABASE CONVERT command has been de-supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ALTER DATABASE CONVERT command has been de-supported since Oracle 10i.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00725: Desupported ALTER DATABASE SET STANDBY clause specified:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A deprecated ALTER DATABASE SET STANDBY was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00740: datafile size of (string<\/i>) blocks exceeds maximum file size<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user specified datafile size exceeded maximum file size.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Please check REFERENCE for maximum size. Reduce the size and retry.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00741: logfile size of (string<\/i>) blocks exceeds maximum logfile size<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user specified logfile size exceeded maximum logfile size.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Please check REFERENCE for maximum size. Reduce the size and retry.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00742: Log read detects lost write in thread\u00a0string<\/i>\u00a0sequence\u00a0string<\/i>\u00a0block\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either a write issued by Oracle was lost by the underlying operating system or storage system or an Oracle internal error occurred.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The trace file shows the lost write location. Dump the problematic log file to see whether it is a real lost write. Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00750: database has been previously mounted and dismounted<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The instance has already mounted and dismounted the database, which is only allowed once in its lifetime.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shut down the database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00751: could not obtain resilvering status for file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while obtaining the mirror resilvering status of a file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to other error messages shown for additional details of the problem.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00752: recovery detected a lost write of a data block<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A data block write to storage was lost during normal database operation on the primary database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shutdown the primary database and activate the physical standby database to failover. Call Oracle Support Services. See the Data Guard documentation for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00753: recovery detected a lost write of a data block<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A data block write to storage was lost during normal redo database operation on the standby database or during recovery on a primary database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Close the database and try the RECOVER MANAGED STANDBY DATABASE (on the standby database) or RECOVER DATABASE … FORCE START AT (on the primary database) statement starting at the SCN of the bad block that was printed already. See the Administrator’s Guide for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00754: recovery detected a data block with invalid SCN<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error caused a data block mismatch with a log record.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If running on a primary database in recovery mode, you may perform a point-in-time recovery to an earlier time. Otherwise, call Oracle Support Services. See the Administrator’s Guide for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00756: recovery detected a lost write of a data block<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A data block write to storage was lost during normal redo database operation on the standby database or during recovery on a primary database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Close the database and try the RECOVER MANAGED STANDBY DATABASE (on the standby database) or RECOVER DATABASE … FORCE START AT (on the primary database) statement starting at the SCN of the bad block that was printed already. See the Administrator’s Guide for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00758: recovery detected a block with inconsistent flag values set<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error occurred.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If running on a primary database in recovery mode, you may perform a point-in-time recovery to an earlier time. Otherwise, call Oracle Support Services. See the Administrator’s Guide for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00759: session suspension timed out during switchover or failover<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The standby database was going through a role transition and the new primary database was not reopened in the configured timeout duration after switchover.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Open the new primary database and try to connect again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00760: could not remove lost write tracking from data file – check log<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while trying to remove lost write tracking.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the system log for ERROR: or WARNING: for further information.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00761: could not suspend lost write tracking for data file – check log<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while trying to suspend lost write tracking.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the system log for ERROR: or WARNING: for further information.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00762: could not change lost write protection – out of memory<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Memory allocation failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that enough memory including stack memory is available<\/span><\/span><\/p>\n

\n
<\/a> ORA-00763: could not add lost write tracking to data file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while trying to add lost write tracking; could not lookup target data file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This may be an internal error if the target data file exists.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00764: The current transaction started on standby database and attempted to make an update after role transition.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The session, which started a transaction on the standby database and stayed alive after a role transition, attempted to do an update.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The client should catch the exception and retry the transaction.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00816: error message translation failed<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00820: Specified value of sga_max_size is too small, needs to be at least\u00a0string<\/i>M<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value of sga_max_size is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set sga_max_size to the recommended value or reduce the values of any SGA component size parameters you have specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00821: Specified value of sga_target\u00a0string<\/i>M is too small, needs to be at least\u00a0string<\/i>M<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value of sga_target is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set sga_target to the recommended value or reduce the values of any SGA component size parameters you have specified.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00822: MMAN process terminated with error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Memory Management process died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start instance<\/span><\/span><\/p>\n

\n
<\/a> ORA-00823: Specified value of sga_target greater than sga_max_size<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value of sga_target is greater than sga_max_size.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase sga_max_size to match up with sga_target or decrease sga_target to match up with sga_maxsize.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Could not set SGA_TARGET or MEMORY_TARGET due to current parameter settings.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the other error messages for additional information.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SGA_TARGET or MEMORY_TARGET set with DB_BLOCK_BUFFERS set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not set SGA_TARGET, MEMORY_TARGET or use new cache parameters, and do not use DB_BLOCK_BUFFERS which is an old cache parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00826: cannot set SGA_TARGET or MEMORY_TARGET for an ASM instance<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SGA_TARGET or MEMORY_TARGET set for an ASM instance.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not set SGA_TARGET or MEMORY_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00827: could not shrink sga_target to specified value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to shrink the SGA to the specified value but did not succeed because the SGA components could not be shrunk as they were already at their minimum sizes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not set sga_target to a value below the current value without first shrinking the individual SGA components.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Unable to set shared_pool_reserved_size to specified value if SGA_TARGET set, either because the specified value is too small, or because it is too large for the current internal size of shared pool. More details can be found in the alert log.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If possible, do not set shared_pool_reserved_size without setting shared_pool_size if SGA_TARGET set. Examine the alert log for information about current internal size of shared pool, and valid range of values for shared_pool_reserved_size.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to set statistics_level to BASIC with auto-tune SGA enabled which cannot be done because auto-tune SGA cannot work with statistics_level set to BASIC.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Disable auto-tune SGA and try setting the statistics_level to BASIC again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00832: no streams pool created and cannot automatically create one<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A database feature which needs STREAMS SGA was being used, however, the streams_pool_size parameter was not defined and the value of db_cache_size was too small to permit an automatic transfer of SGA to the streams pool from the buffer cache.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Please set the parameter streams_pool_size or set SGA_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value of MEMORY_TARGET was greater than MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set MEMORY_TARGET less than or equal to MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least\u00a0string<\/i>M<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value of MEMORY_TARGET was less than the sum of the specified values for SGA_TARGET and PGA_AGGREGATE_TARGET.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set MEMORY_TARGET to at least the recommended value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00839: SGA_TARGET cannot be modified to the specified value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value of SGA_TARGET was not compatible with current settings of PGA_AGGREGATE_TARGET and MEMORY_TARGET\/MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set SGA_TARGET to be no more than the difference of MEMORY_TARGET\/MEMORY_MAX_TARGET and PGA_AGGREGATE_TARGET. Also ensure that the current PGA memory used for non-auto workareas is low.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00840: PGA_AGGREGATE_TARGET cannot be modified to the specified value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value of PGA_AGGREGATE_TARGET was not compatible with current settings of SGA_TARGET and MEMORY_TARGET\/MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set PGA_AGGREGATE_TARGET to be no more than the difference of MEMORY_TARGET\/MEMORY_MAX_TARGET and SGA_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00841: MEMORY_TARGET not supported on this system<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0MEMORY_TARGET parameter was not supported on this system as shmfs was disabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to documentation for a list of supported systems.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00842: DB_BLOCK_BUFFERS cannot be set with SGA_TARGET or MEMORY_TARGET<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0DB_BLOCK_BUFFERS was incompatible with SGA_TARGET and MEMORY_TARGET.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the incompatible parameter setting.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The parameter was larger than MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the other error messages for additional information about the parameter. Set the parameter to a lower value than MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00844: Parameter not taking MEMORY_TARGET into account<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The parameter was larger than MEMORY_TARGET.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the other error messages for additional information about the parameter. Set the parameter to a lower value than MEMORY_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00845: MEMORY_TARGET not supported on this system<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The MEMORY_TARGET parameter was not supported on this operating system or \/dev\/shm was not sized correctly on Linux.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to documentation for a list of supported operating systems. Or, size \/dev\/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00846: could not shrink MEMORY_TARGET to specified value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to shrink MEMORY_TARGET to the specified value but did not succeed because the PGA and SGA components could not be shrunk.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not set MEMORY_TARGET to a value below the current value without first shrinking the individual memory components.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00847: MEMORY_TARGET\/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0MEMORY_TARGET\/MEMORY_MAX_TARGET was set to a non-zero value and LOCK_SGA was also set<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not set MEMORY_TARGET or MEMORY_MAX_TARGET if LOCK_SGA is set to TRUE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0STATISTICS_LEVEL of BASIC was incompatible with SGA_TARGET and MEMORY_TARGET.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the incompatible parameter setting. Set STATISTICS_LEVEL to TYPICAL or ALL to use SGA_TARGET or MEMORY_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00849: SGA_TARGET\u00a0string<\/i>\u00a0cannot be set to more than MEMORY_MAX_TARGET\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SGA_TARGET value was more than MEMORY_MAX_TARGET value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set SGA_TARGET to be less than MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00850: PGA_AGGREGATE_TARGET\u00a0string<\/i>\u00a0cannot be set to more than MEMORY_MAX_TARGET\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0PGA_AGGREGATE_TARGET value was more than MEMORY_MAX_TARGET value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set PGA_AGGREGATE_TARGET to be less than MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00851: SGA_MAX_SIZE\u00a0string<\/i>\u00a0cannot be set to more than MEMORY_TARGET\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SGA_MAX_SIZE value was more than MEMORY_TARGET value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set SGA_MAX_SIZE to be less than MEMORY_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00852: Rolling migration monitor process terminated.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ASM rolling migration monitor process died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00853: SGA_MAX_SIZE\u00a0string<\/i>\u00a0cannot be set to more than MEMORY_MAX_TARGET\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SGA_MAX_SIZE value was more than MEMORY_MAX_TARGET value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set SGA_MAX_SIZE to be less than MEMORY_MAX_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00854: ASM IOServer Instance Fence monitor process terminated.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ASM IOServer Fence monitor process died.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Warm start the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00855: PGA_AGGREGATE_TARGET cannot be set because of insufficient physical memory.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0PGA_AGGREGATE_TARGET value was too high for the current system global area (SGA) size and amount of physical memory available.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the SGA size or increase the physical memory size.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00856: PGA_AGGREGATE_TARGET cannot be set higher 50 percent of PGA_AGGREGATE_LIMIT.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0PGA_AGGREGATE_TARGET value was greater than 50 percent the current value of PGA_AGGREGATE_LIMIT.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase PGA_AGGREGATE_LIMIT or use a lower PGA_AGGREGATE_TARGET.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00865: cannot perform the current operation on the same session<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The current operation could not be performed on the same session.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-00866: invalid or non-existent SQL ID<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SQL ID specified was invalid or did not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with a valid SQL ID.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00867: invalid instance ID<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The instance ID specified was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with a valid instance ID.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00875: failed to\u00a0string<\/i>\u00a0the dedicated connection broker<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The dedicated connection broker could not be enabled or disabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the process trace file for the reason for failure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00876: invalid CONNECTION_BROKERS specification #string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The syntax for the nth CONNECTION_BROKERS specification was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See the additional errors that were reported. Refer to the Oracle Database Reference manual for the correct syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00877: TYPE=string<\/i>\u00a0appears in multiple CONNECTION_BROKERS specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Multiple CONNECTION_BROKER specifications contained the same TYPE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only one specification for each TYPE.<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00500 to ORA-00900 ORA-00500: Listener registration process terminated with an error. Cause:\u00a0The listener registration process died. Action:\u00a0Warm start the instance. ORA-00501: CLMN process terminated with error Cause:\u00a0The cleanup process died. Action:\u00a0Warm start the instance. ORA-00502: PMAN process terminated with error Cause:\u00a0The manager process died. Action:\u00a0Warm start…<\/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":true,"_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-2050","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-x4","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2050","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=2050"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2050\/revisions"}],"predecessor-version":[{"id":2110,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2050\/revisions\/2110"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2050"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}