Sunday, 8 January 2012

ORA-00705: inconsistent state during start up; shut down the instance, then restart it

ORA-00705: inconsistent state during start up; shut down the instance, then restart it

Cause: A previous attempt to start an instance was terminated.

Action: Shut down the instance completely, then restart it.

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

Cause: Failure in processing bootstrap data - see accompanying error.

Action: Contact your customer support representative.

ORA-00703: maximum number of row cache instance locks exceeded

ORA-00703: maximum number of row cache instance locks exceeded

Cause: There are not enough row cache enqueues.

Action: Increase the row cache enqueue parameter and warm start the system.

ORA-00702: bootstrap verison string inconsistent with version string

ORA-00702: bootstrap verison string inconsistent with version string

Cause: The reading version of the boostrap is incompatible with the current bootstrap version.

Action: Restore a version of the software that is compatible with this bootstrap version.

ORA-00701: object necessary for warmstarting database cannot be altered

ORA-00701: object necessary for warmstarting database cannot be altered

Cause: Attempt to alter or drop a database object (table, cluster, or index) which are needed for warmstarting the database.

Action: None.

ORA-00610: Internal error code

ORA-00610: Internal error code

Cause: Oracle process started too late

Action: This error should never be seen by the customer. Contact Oraclce Support

ORA-00609: could not attach to incoming connection

ORA-00609: could not attach to incoming connection

Cause: Oracle process could not answer incoming connection

Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.

ORA-00608: testing error (string( (string( (string( (string( (string(

ORA-00608: testing error (string( (string( (string( (string( (string(

Cause: Internal error reserved for testing.

Action: call Oracle Support

ORA-00607: Internal error occurred while making a change to a data block

ORA-00607: Internal error occurred while making a change to a data block

Cause: An internal error or memory exception occurred while Oracle was applying redo to a data block.

Action: call Oracle Support

ORA-00606: Internal error code

ORA-00606: Internal error code

Cause: A call to deferred upi functions was made in non deferred mode

Action: Report as a bug.

ORA-00604: error occurred at recursive SQL level string

ORA-00604: error occurred at recursive SQL level string

Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).

Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.

ORA-00603: ORACLE server session terminated by fatal error

ORA-00603: ORACLE server session terminated by fatal error

Cause: An ORACLE server session is in an unrecoverable state.

Action: Login to ORACLE again so a new server session will be created

ORA-00602: internal programming exception

ORA-00602: internal programming exception

Cause: Internal programming exception

Action: Report as bug

ORA-00601: cleanup lock conflict

ORA-00601: cleanup lock conflict

Cause: PMON process runs into lock conflict trying to recovery processes

Action: This is trapped internally, no action necessary

ORA-00600: internal error code, arguments: (string(, (string(, (string(, (string(, (string(, (string(, (string(, (string(

ORA-00600: internal error code, arguments: (string(, (string(, (string(, (string(, (string(, (string(, (string(, (string(

Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition.

Action: Report as a bug - the first argument is the internal error number

ORA-00569: Failed to acquire global enqueue.

ORA-00569: Failed to acquire global enqueue.

Cause: A prior error occurred on one of the instances in the cluster. Typically errors are caused by shared pool resource contention.

Action: Check 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.

ORA-00568: Maximum number of interrupt handlers exceeded

ORA-00568: Maximum number of interrupt handlers exceeded

Cause: User specified too many ^c handlers

Action: Remove some old handlers.

ORA-00567: Requested processor group string is too large (maximum string)

ORA-00567: Requested processor group string is too large (maximum string)

Cause: The process could not be started in the requested processor group.

Action: Start the process in another processor group.

ORA-00566: cannot request processor group - NUMA not enabled

ORA-00566: cannot request processor group - NUMA not enabled

Cause: Cannot start process in a requested processor group when the NUMA feature is disabled.

Action: Start the process without requesting a NUMA processor group.

ORA-00490: PSP process terminated with error

ORA-00490: PSP process terminated with error

Cause: The process spawner died

Action: Warm start instance

ORA-00489: ARB* process terminated with error

ORA-00489: ARB* process terminated with error

Cause: An ASM rebalance worker process died.

Action: Wait for process to restart.

ORA-00488: RBAL process terminated with error

ORA-00488: RBAL process terminated with error

Cause: The ASM rebalance coordinator process died.

Action: Warm start instance.

ORA-00487: CTWR process terminated with error

ORA-00487: CTWR process terminated with error

Cause: The change tracking process died

Action: Warm start instance

ORA-00486: ASMB process terminated with error

ORA-00486: ASMB process terminated with error

Cause: An ASM background process died.

Action: Warm start instance. Also check that ASM Instance is running.

ORA-00485: DIAG process terminated with error string

ORA-00485: DIAG process terminated with error string

Cause: A global diagnostic process died

Action: Wait for process to restart

ORA-00484: LMS* process terminated with error

ORA-00484: LMS* process terminated with error

Cause: A global cache service process died

Action: Warm start instance

ORA-00483: During shutdown a process abnormally terminated

ORA-00483: During shutdown a process abnormally terminated

Cause: One of the background processes did not exit normally at or near the time of shutdown.

Action: Use shutdown abort.

ORA-00482: LMD* process terminated with error

ORA-00482: LMD* process terminated with error

Cause: A global enqueue service daemon process died

Action: Warm start instance

ORA-00481: LMON process terminated with error

ORA-00481: LMON process terminated with error

Cause: The global enqueue service monitor process died

Action: Warm start instance

ORA-00480: LCK* process terminated with error

ORA-00480: LCK* process terminated with error

Cause: A system lock process died

Action: Warm start instance

ORA-00479: RVWR process terminated with error string

ORA-00479: RVWR process terminated with error string

Cause: The RVWR process died

Action: Warm start instance

ORA-00478: SMON process terminated due to error string

ORA-00478: SMON process terminated due to error string

Cause: SMON was unable to service the requests due to error in cleanup of resources

Action: Warm start instance

ORA-00477: SNP* process terminated with error

ORA-00477: SNP* process terminated with error

Cause: A materialized view refresh process died

Action: PMON will restart SNP process shortly. If SNP process does not get started, contact Oracle support.

ORA-00476: RECO process terminated with error

ORA-00476: RECO process terminated with error

Cause: The distributed transaction (two-phase commit) recovery process died.

Action: Warm start instance

ORA-00475: TRWR process terminated with error

ORA-00475: TRWR process terminated with error

Cause: The system tracing process died

Action: Warm start instance

ORA-00474: SMON process terminated with error

ORA-00474: SMON process terminated with error

Cause: The system cleanup process died

Action: Warm start instance

ORA-00473: ARCH process terminated with error

ORA-00473: ARCH process terminated with error

Cause: The archive process died

Action: Warm start instance

ORA-00472: PMON process terminated with error

ORA-00472: PMON process terminated with error

Cause: The process cleanup process died

Action: Warm start instance

ORA-00471: DBWR process terminated with error

ORA-00471: DBWR process terminated with error

Cause: The database writer process died

Action: Warm start instance

ORA-00470: LGWR process terminated with error

ORA-00470: LGWR process terminated with error

Cause: The log writer process died

Action: Warm start instance

ORA-00469: CKPT process terminated with error

ORA-00469: CKPT process terminated with error

Cause: The checkpoint process died

Action: Warm start instance

ORA-00453: backgroud process string is dead

ORA-00453: backgroud process string is dead

Cause: The background process that was being messaged was dead or its incarnation was invalid.

Action: Restart the background process.

ORA-00452: foreground process unexpectedly terminated with error string

ORA-00452: foreground process unexpectedly terminated with error string

Cause: The foreground process for the new connection did not start.

Action: Reconnect to Oracle.

ORA-00451: foreground process died unexpectedly

ORA-00451: foreground process died unexpectedly

Cause: The foreground process for the new connection did not start.

Action: Reconnect to Oracle.

ORA-00450: background process string did not start

ORA-00450: background process string did not start

Cause: The specified process did not start.

Action: Consult the error code, and the trace file for the process.

ORA-00449: background process string unexpectedly terminated with error string

ORA-00449: background process string unexpectedly terminated with error string

Cause: A foreground process needing service from a background process has discovered the process died.

Action: Consult the error code, and the trace file for the process.

ORA-00448: normal completion of background process

ORA-00448: normal completion of background process

Cause: One of the background processes completed normally (i.e. exited). The background process thinks that somebody asked it to exit.

Action: Warm start the system.

ORA-00447: fatal error in background process

ORA-00447: fatal error in background process

Cause: One of the background processes died unexpectedly.

Action: Warm start the system.

ORA-00446: background process started when not expected

ORA-00446: background process started when not expected

Cause: The background process specified started up AFTER the RDBMS was already running.

Action: If nobody at your site started the process, then this is an internal error.

ORA-00445: background process string did not start after string seconds

ORA-00445: background process string did not start after string seconds

Cause: The specified process did not start after the specified time.

Action: Ensure that the background did not die and leave a trace file.

ORA-00444: background process string failed while starting

ORA-00444: background process string failed while starting

Cause: Usually due to a bad (or non-existent) background process image.

Action: Get a good background process image.

ORA-00443: background process string did not start

ORA-00443: background process string did not start

Cause: The specified process did not start.

Action: Ensure that the executable image is in the correct place with the correct protections, and that there is enough memory.

ORA-00439: feature not enabled: string

ORA-00439: feature not enabled: string

Cause: The specified feature is not enabled.

Action: Do not attempt to use this feature.

ORA-00438: %s Option not installed

ORA-00438: %s Option not installed

Cause: The specified option is not installed.

Action: Purchase and install the option.

ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance

ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance

Cause: ORACLE feature is not licensed.

Action: Contact ORACLE for assistance.

ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT

ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT

Cause: This is due to migrating from an older release of Oracle with tablespaces created using AUTO SEGMENT SPACE MANAGEMENT. To open the database, the COMPATIBLE parameter needs to be set to the specified value.

Action: Shutdown and startup with the specified compatibility setting.

ORA-00408: parameter string is set to TRUE

ORA-00408: parameter string is set to TRUE

Cause: Reporting the parameter that resulted in the compatibility error.

Action: Shutdown and startup with a higher compatibility setting.

ORA-00407: rolling upgrade from release string.string to string.string is not allowed

ORA-00407: rolling upgrade from release string.string to string.string is not allowed

Cause: Another instance executing software at a different point release already has the database mounted.

Action: Shutdown all instances then startup with the new software.

ORA-00406: COMPATIBLE parameter needs to be string or greater

ORA-00406: COMPATIBLE parameter needs to be string or greater

Cause: The COMPATIBLE initialization parameter is not high enough to allow the operation. Allowing the command would make the database incompatible with the release specified by the current COMPATIBLE parameter.

Action: Shutdown and startup with a higher compatibility setting.

ORA-00405: compatibility type string

ORA-00405: compatibility type string

Cause: Reporting a type associated with another error.

Action: See accompanying error