Oracle8
Error Messages Release 8.0 A54625_01 |
|
This section lists the messages generated by the Oracle Server.
If you are using Trusted Oracle, see the Trusted Oracle documentation for information about error messages in that environment.
Cause: An operation has completed normally, having met no exceptions.
Cause: An update or insert statement attempted to insert a duplicate key.
Action: Either remove the unique restriction or do not insert the key.
Cause: The current session was requested to set a trace event by another session.
Action: This is used internally; no action required.
Cause: An operation requested a resource that was unavailable. The maximum number of sessions is specified by the initialization parameter SESSIONS. When this maximum is reached, no more requests are processed.
Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the SESSIONS parameter in the initialization parameter file, and restart Oracle.
Cause: All licenses are in use.
Action: Call customer support before increasing the number of session licenses.
Cause: An operation requested a resource that was unavailable. The maximum number of processes is specified by the initialization parameter PROCESSES. When this maximum is reached, no more requests are processed.
Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the PROCESSES parameter in the initialization parameter file, and restart Oracle.
Cause: The user session is currently being used by someone else.
Action: Do not execute calls in a user session concurrently.
Cause: Either the session specified does not exist, or the caller does not have the privilege to access it.
Action: Specify a valid session ID. This requires ownership of the session id or the CHANGE_USER privilege.
Cause: An attempt was made to detach the current session, which contains references to the process' private memory.
Action: A session may contain references to process memory (PGA) if it has an open network connection, a very large context area, or operating system privileges. To allow the detach, it may be necessary to close the session's database link or cursors. Detaching a session with operating system privileges is always disallowed.
Cause: An attempt was made to log in more than once from different processes after Oracle had been started in single-process mode.
Action: When Oracle is running in single-process mode, out of the previous process before trying to log in from another one.
Cause: An allocation failed because Oracle ran out of memory.
Action: Restart Oracle with a larger SGA heap.
Cause: The session ID string specified in the ALTER SYSTEM KILL SESSION command was invalid, or no string was specified.
Action: Retry the command with a valid session ID.
Cause: An attempt was made to kill the current session with the ALTER SYSTEM KILL SESSION command.
Action: If it is necessary to kill the current session, do so from another session.
Cause: A privileged user killed the session and it is no longer logged in to the database.
Action: Contact the database administrator. The administrator may be attempting to perform an operation that requires users to be logged out. When the database administrator announces that the database is available, log in and resume work.
Cause: The session ID specified in an ALTER SYSTEM KILL SESSION command was not a user session. For example, the session may be recursively started.
Action: Retry the command with a valid session ID.
Cause: The user session ID no longer exists, probably because the session was logged out.
Action: Use a valid session ID.
Cause: The session specified in the ALTER SYSTEM KILL SESSION command cannot be killed immediately because the session is involved in a non-interruptible operation. For example, rolling back a transaction or being blocked by a network operation. The session has been marked to be killed as soon as possible after the current operation is done.
Action: No action required. The session will be killed when the operation is completed. Further executions of the ALTER SYSTEM KILL SESSION command may cause the session to be killed sooner.
Cause: The session migration password specified in a session creation call was invalid (probably too long).
Action: Retry with a valid password, less than 30 characters.
Cause: An attempt was made to detach or clone the current session, and it has an empty migration password. This is not allowed.
Action: Create the session with a non-empty migration password.
Cause: An attempt was made to ROLLBACK from a PL/SQL object (procedure, function, package) in a session where COMMIT and ROLLBACK are disabled by an ALTER SESSION DISABLE COMMIT IN PROCEDURE statement.
Action: Enable COMMITs from PL/SQL in this session or do not attempt a COMMIT or ROLLBACK when disabled.
Cause: Specified value for LICENSE_MAX_USERS is less than current number of users.
Action: Check the license limit and drop extra users or purchase more licenses.
Cause: An attempt was made to go more than the specified number of recursive SQL levels was made.
Action: Remove the recursive SQL, possibly a recursive trigger.
Cause: Could not obtain the operating system resources necessary for an Oracle enqueue. This most often occurs when the user resource quota on the operating system is too low.
Action: Look up the operating system error in the operating system-specific Oracle documentation and perform the needed action.
Cause: This message is usually caused by an instance that has terminated abnormally.
Action: Restart any non-recovered instances.
Cause: An operation requested a resource that was unavailable. The maximum number of enqueue resources is specified by the initialization parameter ENQUEUE_RESOURCES. When this maximum is reached, no more requests are processed.
Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the ENQUEUE_RESOURCES parameter in the initialization parameter file, and restart Oracle.
Cause: An operation requested a resource that was unavailable and the enqueue list for the resource had reached its maximum length. If a request is made for a resource that is unavailable, the request is enqueued to wait for the resource. The number of requests that may be queued for a given resource is specified by the initialization parameter ENQUEUE_RESOURCES. When this maximum is reached, no more requests may be added to the enqueue list.
Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the ENQUEUE_RESOURCES parameter in the initialization parameter file, and restart Oracle.
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
Action: Try the command after a few minutes or enter the command without the NOWAIT keyword.
Cause: An operation requested a resource that was unavailable. The maximum number of DML locks is specified by the DML_LOCKS parameter in the initialization parameter file. When this maximum is reached, no more requests are processed.
Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the DML_LOCKS parameter in the initialization parameter file, and restart Oracle.
Cause: The attempted lock is incompatible with the DDL lock already held on the object. This usually occurs when attempting to drop a table that has parse locks.
Action: Before attempting to drop a table, check that it has no parse locks. Wait a few minutes before retrying the operation.
Cause: The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.
Action: Increase the TEMPORARY_TABLE_LOCKS parameter and restart Oracle.
Cause: The DB_BLOCK_SIZE parameter value in the initialization parameter file used to start a database does not match the value used when that database was created. Potential reasons for this mismatch are
Action: For one of the above causes, either
Cause: An unavailable resource was requested. The maximum number of datafiles is specified by the DB_FILES parameter in the initialization parameter file. When this maximum is reached, no more requests are processed.
Action: Try again when the resource is freed. If this message occurs often, Oracle must be shut down and restarted after increasing the DB_FILES parameter in the initialization parameter file. If the DB_FILES parameter cannot be changed because it is already set to the MAXDATAFILES parameter value, set at database creation, you must create a new control file.
Cause: Your session and another session are waiting for a resource locked by the other. This condition is known as a deadlock. To resolve the deadlock, one or more statements were rolled back for the other session to continue work.
Action: Either
Cause: The shared instance being started is using DML locks and the running instances are not, or vice versa.
Action: Either
Cause: The instance was started with the initialization parameter DML_LOCKS set to zero, but the statement being executed needs a full-table lock (S, X, or SRX).
Action: Set DML_LOCKS to a non-zero value, restart the instance, and re-enter the statement.
Cause: The value of the LOG_FILES initialization parameter was exceeded.
Action: Increase the value of LOG_FILES and warm start Oracle. The value needs to be as large as the highest number log that currently exists rather than just the count of the logs that exist. If this parameter cannot be increased because it would exceed the MAXLOGFILES set at database creation, you must create a new control file first.
Cause: The initialization parameter DB_BLOCK_SIZE is set to a value that calls for more contiguous space than can be allocated on the operating system being used.
Action: Reduce the value of DB_BLOCK_SIZE so that the requested contiguous space is within the capacity of the operating system.
Cause: An attempt was made to enter a fixed date string that was not in the proper format.
Action: Enter the date string using the format YYYY-MM-DD:HH24:MI:SS.
Cause: The maximum number of redo log files supported by this instance is not the same as for the other instances. All instances must be able to open all the files any instance can open.
Action: Check that the LOG_FILES initialization parameter is the same for all instances.
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message. Change the value of the LOG_FILES parameter to be compatible.
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message. Change the value of the LOG_FILES parameter to be compatible.
Cause: A command was issued that tried to lock the table indicated in the message. Examples of commands that can lock tables are LOCK TABLE, ALTER TABLE ... ADD (...), and so on.
Action: Use the ALTER TABLE ... ENABLE TABLE LOCK command, and retry the command.
Cause: An invalid debugger command was specified.
Action: Type HELP to see the list of available commands.
Cause: An invalid process number was specified.
Action: Specify a valid process number.
Cause: An invalid process was specified.
Action: Specify a valid process.
Cause: An incorrect number of arguments was specified.
Action: Specify the correct number of arguments. Type HELP to see the list of commands and their syntax.
Cause: No debug process has been specified.
Action: Specify a valid process.
Cause: The specified process was not logged on to the current instance.
Action: Specify a valid process.
Cause: An attempt was made to invoke a dump which doesn't exist.
Action: Type DUMPLIST to see the list of available dumps.
Cause: An attempt was made to invoke an invalid dump.
Cause: An attempt was made to dump a variable by name on a system which does not support this feature.
Cause: An attempt was made to dump a variable which doesn't exist.
Action: Use a valid variable name.
Cause: An attempt was made to dump an invalid global area.
Action: Use level 1 for the PGA, 2 for the SGA, and 3 for the UGA. Use extra + level to dump global area as well as extra bytes for every pointer; extra must be a multiple of 4.
Cause: An attempt was made to read/write an invalid memory address range.
Action: Try another address or length.
Cause: An invalid length was specified for the POKE command.
Action: Use a valid length (either 1, 2, 4, or possibly 8).
Cause: Even though there may be SGA corruptions, the SGA was mapped.
Action: Use the DUMPSGA command to dump the SGA.
Cause: An attempt was made to dump an invalid global area.
Action: Specify either PGA, SGA, or UGA.
Cause: An invalid attempt was made to dump the current call heap.
Action: Wait until the process starts a call.
Cause: An invalid attempt was made to dump the user call heap.
Action: Wait until the process starts a call.
Cause: You tried to use an Oracle SQL feature that is not compliant with the SQL92 standard.
Action: Do not use the feature or use the ALTER SESSION SET FLAGGER command to set the appropriate level of SQL92 compliance.
Cause: The resource needed by the transaction was busy. The PDML transaction could not acquire the resource within the specified amount of time. This indicates potential deadlock involving this PDML transaction and other transactions currently running in the system.
Action: Increase the value of the PARALLEL_TRANSACTION_RESOURCE_TIMEOUT parameter, then retry the operation.
Cause: An application made reference to unknown or inaccessible data.
Action: Handle this condition within the application or make appropriate modifications to the application code. Note: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead of ORA-00100.
This section lists message generated by the multi-threaded server.
Cause: The syntax for the MTS_DISPATCHERS parameter is incorrect.
Action: Enter the MTS_DISPATCHERS parameter into the initialization parameter file with the correct syntax and then shut down and restart the instance.
Cause: The network specified in MTS_DISPATCHERS initialization parameter does not have the functionality required by the dispatchers.
Action: Refer to your Oracle operating system-specific documentation for network protocols supported by the dispatchers.
Cause: The network specified in Net8 CONNECT string is reserved for use by the dispatchers.
Action: Specify other network protocols in the CONNECT string.
Cause: This message occurs when a client locks a resource and the maximum number of shared servers are taken by other clients who are requesting a locked resource. The original client is unable to get a shared server and cannot release the lock on the resource.
Action: The system automatically starts up new servers to break the deadlock until the number of servers reaches the value specified in MTS_MAX_SERVERS. If this problem occurs frequently, ensure more shared servers will be available at the next restart of the instance by increasing the value of the initialization parameter MTS_SERVERS or MTS_MAX_SERVERS.
Cause: The ALTER SYSTEM SET MTS_DISPATCHERS command was used to alter a set of dispatchers for a network protocol that is not specified in the initialization parameter file.
Action: Do either of the following:
Cause: An attempt was made to start up or shut down an instance while connected to a shared server process via a dispatcher.
Action: Reconnect to the database using a dedicated server.
Cause: Usually caused by the fact that the network listener process has not been started.
Action: Check for the following:
Cause: The network protocol used by the dispatcher does not support asynchronous operations.
Action: Contact customer support.
Cause: An attempt was made to start more shared server processes than the number allowed by the initialization parameter MTS_MAX_SERVERS. The actual number of shared servers started is specified in the message.
Action: If more shared server processes are required, increase the initialization parameter MTS_MAX_SERVERS and restart the instance.
Cause: An attempt was made to start up more dispatchers than the maximum number specified by the initialization parameter MTS_MAX_DISPATCHERS.
Action: If more dispatchers are required, increase MTS_MAX_DISPATCHERS, restart the instance, and add dispatchers using the ALTER SYSTEM MTS_DISPATCHERS command.
Cause: A protocol name specified in the MTS_DISPATCHERS initialization parameter is too long.
Action: Use a valid protocol name for the MTS_DISPATCHERS initialization parameter.
Cause: There is no value for the MTS_SERVICE initialization parameter, nor for the DB_NAME parameter.
Action: Add an MTS_SERVICE or DB_NAME definition to the initialization parameter file. By default, MTS_SERVICE is the value of DB_NAME unless MTS_SERVICE is explicitly specified.
Cause: A connection request was refused by a dispatcher because the dispatcher cannot support any more connections.
Action: Connect to a different dispatcher or use a dedicated server.
Cause: The service name specified in the MTS_SERVICE initialization parameter is too long.
Action: Use a shorter name for the MTS_SERVICE value (maximum is 255 characters).
Cause: The value of the MTS_SERVERS parameter is incorrect.
Action: The MTS_SERVERS parameter must be from 0 to MTS_MAX_SERVERS.
Cause: The value of the MTS_DISPATCHERS parameter is incorrect.
Action: The sum of all MTS_DISPATCHERS values must be from 0 to MTS_MAX_DISPATCHERS.
Cause: The syntax for the MTS_LISTENER_ADDRESS is incorrect.
Action: Refer to the Oracle8 Server Administrator's Guide for the correct syntax.
Cause: Either the dispatching mechanism is not enabled or the Oracle executable image is not installed with the dispatching mechanism.
Action: Refer to the Oracle8 Server Administrator's Guide and your Oracle operating system-specific documentation for procedures for starting and configuring the dispatcher processes.
Cause: A definition for MTS_SERVERS was specified in the INIT.ORA file, but no definition for MTS_DISPATCHERS was specified. If no value is specified for MTS_DISPATCHERS, shared servers will not be used.
Action: Add a definition for MTS_DISPATCHERS in the INIT.ORA file. If you do not intend to use shared servers, remove the MTS_SERVERS definition.
Cause: Oracle could not initialize Net8 Version 2.
Action: See accompanying messages.
Cause: Too many idle servers were waiting on the common queue.
Action: This is used internally, no action required.
Cause: A definition for MTS_DISPATCHERS was specified in the INIT.ORA file, but MTS_MAX_SERVERS was specified as zero.
Action: Specify MTS_MAX_SERVERS to be greater than zero.
Cause: Attempted to start a new transaction with an ID already in use by an existing transaction.
Action: Check that your application uses a valid transaction ID.
Cause: The specified transaction ID does not correspond to an existing valid transaction.
Action: Check that your application uses a valid transaction ID.
Cause: The current session is not the same as the session that was passed into a UPIXADO() call.
Action: Check that your application is coded correctly.
Cause: The XA library could not access thread-specific pointers.
Action: Contact customer support.
Cause: The transaction monitor returned TMJOIN on an AX_REG call but the transaction was locally suspended.
Action: Contact the transaction monitor customer support.
Cause: The application tried to perform some work on an Oracle 7.3 server outside of a global transaction.
Action: Check if the application is connected to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3.
This section lists messages generated during distributed transactions. See also "02040-02099: Distributed Transactions Messages" on page 2¬222.
Cause: An external global transaction ID with a too large length field was passed in.
Action: Report the problem to your external transaction coordinator vendor.
Cause: An external transaction branch ID with a length either too large or 0 was passed in.
Action: Report the problem to your external transaction coordinator vendor.
Cause: An external database name with too large a length field was passed in.
Action: Report the problem to your external transaction coordinator vendor.
Cause: An internal database name with a too large length field was passed in.
Action: Report the problem to your external transaction coordinator vendor.
Cause: The control file cannot be created, usually because of insufficient disk storage or filename conflicts.
Action: Check that there is sufficient disk space and no conflicts in filenames and try to create the control file again.
Cause: The control file was created by a different version of Oracle.
Action: Either
Cause: This message reports the name of the file involved in other messages.
Action: See the associated messages for a description of the problem.
Cause: The mount ID in the control file is not the same as the mount ID in the control file used by the first instance to mount this database. The control files are for the same database but are not the same files. The most likely cause is that one instance is using a backup of the control file. If you want to use a backed up control file, you can recover using the USING BACKUP CONTROLFILE option.
Action: Check that all instances are using the correct version of the control file.
Cause: A disk read-failure occurred while attempting to read the specified control file. The block location of the failure is given.
Action: Check that the disk is online. If it is not, bring it online and shut down and restart Oracle. If the disk is online, then look for operating system reasons for Oracle's inability to read the disk or control file. Refer to the Oracle8 Server Administrator's Guide for information about recovering from the loss of a control file. See also your operating system-specific Oracle documentation.
Cause: The system could not find a control file of the specified name and size.
Action: Either
Cause: A disk write-failure occurred while attempting to write to the specified control file. The block location of the failure is given.
Action: Check that the disk is online. If it is not, bring it online and shut down and restart Oracle. If the disk is online, then look for operating system reasons for Oracle's inability to write to the disk or control file. See the Oracle8 Server Administrator's Guide for information on recovering from the loss of a control file. See also your operating system-specific Oracle documentation.
Cause: The database ID in the control file is not the same as the database ID in the control file used by the first instance to mount this database. The most likely cause is either that one of the mounts used the wrong control file or there are two databases with the same name.
Action: Check that the control file is for the correct database and not an old version. When using multiplexed control files, that is, more than one control file is referenced in the initialization parameter file, remove the control filename listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file using a new filename in the initialization parameter file.
Cause: An attempt was made to use more control files than Oracle supports. The limit is given in the message.
Action: Shut down Oracle, reduce the number of control filenames specified in the CONTROL_FILES parameter in the initialization parameter file, and restart Oracle. Delete unused files.
Cause: A block size larger than that allowed by the operating system was specified.
Action: Reduce the block size to the amount specified in the message and try again.
Cause: The system was unable to open a control file.
Action: Check that the control file exists, that the storage device is online, and that the file is not locked by some other program and try again. Also, check to see that the operating system limit on the number of open files per process has not been exceeded.
When using multiplexed control files, that is, more than one control file is referenced in the initialization parameter file, remove the parameter from the initialization parameter file referencing the control filename indicated in the message and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file using a new filename in the initialization parameter file.
Cause: The specified control file is from another database.
Action: Locate and specify the correct control file for this database, then retry the operation. When using multiplexed control files, that is, more than one control file is referenced in the initialization parameter file, remove the control filename listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file, create another copy of the control file, and include the new filename in the initialization parameter file.
Cause: The specified block size is too small. Additional space is needed for system overhead.
Action: Specify a larger block size and retry the operation.
Cause: To reuse a control file, it must be the same size as the previous one used.
Action: In the CREATE DATABASE statement, do not specify REUSE.
Cause: An inconsistent set of control files, datafiles, and redo log files was used.
Action: Use a consistent set of control files, datafiles, and redo log files. That is, all the files must be for the same database and from the same time period.
Cause: No control file was specified, or the control file specified does not exist.
Action: Specify at least one valid control file and retry the operation.
Cause: Controlfiles created by release 8.0.2 were missing some records. These records are automatically added by resizing the contolfile when attempting to run a later release. The resize failed.
Action: Look in the alert log for the reason that the resize failed. If it can be fixed by giving the controlfile more space then do so. Otherwise, use the CREATE CONTROLFILE script dumped to the trace file to create a new controlfile.
Cause: The physical block size of the operating system is inconsistent with the block size of the control file.
Action: The system will not operate with invalid control files. Either restore a valid control file or recreate the database. When using multiplexed control files, that is, more than one control file is referenced in the initialization parameter file, remove the control filename listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file with a new filename in the initialization parameter file.
Cause: The physical block size, stored in the control file header, was different in physical block size returned by the O/S. This usually indicates that the control file was corrupted.
Action: Restore a good copy of the control file. For more information about control files and recovery, see the index entries on "control files," "control files, backing up," "control files, recovery and" in Oracle8 Server Concepts.
Cause: The CREATE DATABASE statement specified a combination of initialization parameters that results in the control file exceeding the internal maximum size.
Action: You must recreate the database. In the CREATE DATABASE statement, use a value less than the maximum permissible value for clauses such as MAXDATAFILES and MAXLOGFILES as described in the Oracle8 Server Administrator's Guide.
Cause: The specified control file has a different mount ID than the other control files that are being mounted. This means that the first instance to mount the database did not use this control file.
Action: Find and use the correct control file.
Cause: An error occurred when writing to one or more of the control files.
Action: See accompanying messages.
Cause: Attempted to use client process connected to dispatcher. This is not allowed for queries to control file fixed tables due to the memory requirements.
Action: Connect directly to the instance, then execute the query.
Cause: An Oracle7 to Oracle8 convert file contains invalid data or was created with an different version of the migration utility. This error can also be caused by incorrect ORACLE_HOME environment variable when "ALTER DATABASE CONVERT" command is issued.
Action: Use a correct version of the convert file or regenerate it with the migration utility. Make sure that the migration utility is the same version as the Oracle8 RDBMS executable and that the ORACLE_HOME environment variable is properly set.
Cause: The file specified in the initialization parameter file is not a control file.
Action: Edit the initialization parameter file and specify the correct control filename.
Cause: The expected size of the control file as stored in its header was different than the actual operating system file size of the control file. This usually indicates that the control file was corrupted.
Action: Restore a good copy of the control file. For more information about control files and recovery, see the index entries on "control files," "control files, backing up," "control files, recovery and" in Oracle8 Server Concepts.
Cause: The attempted operation cannot be executed at this time because this process has an alternate controlfile open for fixed table access.
Action: Retry the operation after calling cfileUseCurrent.
Cause: A block header corruption or checksum error was detected on reading the controlfile.
Action: Use the CREATE CONTROLFILE or RECOVER DATABASE USING BACKUP CONTROLFILE command.
Cause: The specified file name, which was supplied as a parameter to cfileSetSnapshotName or cfileUseCopy, exceeds the maximum file name length for this operating system.
Action: Retry the operation with a shorter file name.
Cause: The attempted operation cannot be executed at this time because this process currently holds the snapshot controlfile enqueue.
Action: Retry the operation after calling cfileUseCurrent to release the snapshot controlfile enqueue.
Cause: The attempted operation cannot be executed at this time because another process currently holds the snapshot controlfile enqueue.
Action: Retry the operation after the concurrent operation that is holding the snapshot controlfile enqueue terminates.
Cause: During an invocation of cfileMakeAndUseSnapshot or cfileUseSnapshot it was detected that no filename for the snapshot controlfile had previously been specified.
Action: First specify a name for the snapshot controlfile by calling cfileSetSnapshotName.
Cause: The snapshot controlfile was found to be nonexistent, corrupt, or unreadable during an invocation of cfileUseSnapshot.
Action: Call cfileMakeAndUseSnapshot again (or for the first time).
Cause: The specified copy controlfile was found to be corrupt or unreadable during an invocation of cfileUseCopy.
Action: Before retrying cfileUseCopy, use the ALTER DATABASE BACKUP CONTROLFILE command, specifying the same filename as specified to cfileUseCopy.
Cause: A snapshot or copy controlfile of the specified name could not be found or opened during an invocation of cfileUseSnapshot, cfileMakeAndUseSnapshot, or cfileUseCopy.
Action: Recreate the snapshot or copy controlfile using cfileMakeAndUseSnapshot or ALTER DATABASE BACKUP CONTROLFILE, respectively.
Cause: Concurrent controlfile update activity caused a query on a controlfile fixed table to read inconsistent information.
Cause: An attempt was made to invoke cfileSetSnapshotName, cfileMakeAndUseSnapshot, or cfileUseSnapshot when the currently mounted controlfile is a backup controlfile.
Action: Mount a current controlfile and retry the operation.
Cause: An attempt to invoke cfileMakeAndUseSnapshot with a currently mounted controlfile that was newly created with CREATE CONTROLFILE was made.
Action: Mount a current controlfile and retry the operation.
Cause: The filename supplied as a parameter to the ALTER DATABASE BACKUP CONTROLFILE command or to cfileSetSnapshotName matches the name of a file that is currently part of the database.
Action: Retry the operation with a different filename.
This section lists the messages generated when archiving or recovery of the database is in progress.
Cause: An attempt was made to stop automatic archiving, but the archiver process was not running.
Cause: The destination pointed by the LOG_ARCHIVE_DUPLEX_DEST initialization parameter is the same as the destination pointed by LOG_ARCHIVE_DEST.
Action: Specify a different destination for either LOG_ARCHIVE_DUPLEX_DEST or LOG_ARCHIVE_DEST.
Cause: The specified redo log was not used since it was introduced to the database. It is also possible that the instance died during a log switch, and the log was left empty.
Action: Empty logs do not need to be archived. Do not attempt to archive the redo log file.
Cause: The specified archive string is too long. The limit is given in the message.
Action: Use a shorter string, making sure not to exceed the given limit and try again.
Cause: The specified archive log location is invalid in the archive command or the LOG_ARCHIVE_DEST initialization parameter.
Action: Specify a valid location name.
Cause: An error occurred during archiving.
Action: Check the accompanying message stack for more detailed information. If the online log is corrupted then the log can be cleared using the UNARCHIVED option. This will make any existing backups useless for recovery to any time after the log was created, but does allow redo to be generated.
Cause: An error occurred while translating the archive control string.
Action: Check the accompanying message stack for more detailed information.
Cause: The ARCH process received an error while trying to archive a redo log file. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is that the destination device is out of space to store the redo log file.
Action: Check the archiver trace file for a detailed description of the problem. Also, verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.
Cause: An attempt was made to archive a redo log file manually without specifying the sequence number, group number, or filename while the database was in NOARCHIVELOG mode.
Action: The name, group number, or thread and sequence number of redo log files must be specified to archive redo log files manually while the database is in NOARCHIVELOG mode.
Cause: An attempt was made to archive the current log of an open thread. This is not allowed because the redo log file may still be in use for generation of redo entries.
Action: Force a log switch in the instance where the thread is open. If no instances are open, open the database so instance recovery can recover the thread.
Cause: The log sequence number specified in the ARCHIVE statement does not match any of the online logs for the specified thread. This can result from any of the following situations:
Action: Check the ARCHIVE statement; then specify a valid log sequence number.
Cause: Either the log is being archived by another process or an administrative command is executing and modifying the log. Clearing, adding a member, dropping a member, renaming a member, and dropping the log are operations that modify a log.
Action: Wait for the current operation to complete and try again.
Cause: The log cannot be cleared or manually archived because it is the current log of a closed thread, and it is not possible to switch logs so another log is current. All other logs for the thread need to be archived or cleared and cannot be reused.
Action: Archive another log in the same thread first or complete the clearing. See attached errors for the reason the switch cannot be completed.
Cause: An attempt was made to archive the unarchived logs in this thread manually, but no logs need archiving.
Cause: An attempt was made to perform media recovery on files that do not need any type of recovery.
Action: Do not attempt to perform media recovery on the selected files. Check to see that the filenames were entered properly. If not, retry the command with the proper filenames.
Cause: The database either crashed or was shut down with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the datafiles.
Action: Open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE options.
Cause: During media recovery, the name of an archived redo log file was requested, but no name was entered.
Action: Mount the correct redo log file and enter its name when it is requested.
Cause: During media recovery, the name of an archived redo log file was entered, but no name was requested.
Action: Continue media recovery, but do not enter a new log name.
Cause: The given redo log file does not exist.
Action: Check the spelling and capitalization of the filename and retry the command.
Cause: The given redo log file is not part of the given thread.
Action: Check that the thread of the redo log file matches the thread on the command line. If not, use a redo log file from the appropriate thread. Retry the command after correcting the error.
Cause: An error was encountered when either creating or opening the destination file for archiving.
Action: Check that the archive destination is valid and that there is sufficient space on the destination device.
Cause: An attempt was made to archive the unarchived redo log files manually, but there are no files that need to be archived.
Cause: An I/O error occurred while archiving a redo log file.
Action: Check that the output device is still available and correct any device errors that may have occurred. Also, make certain that sufficient space for archiving is available on the output device.
Cause: A media recovery session encountered a table that was loaded by the direct loader without logging any redo information. Some or all of the blocks in this table are now marked as corrupt.
Action: The table must be dropped or truncated so that the corrupted blocks can be reused. If a more recent backup of the file is available, try to recover this file to eliminate this error.
Cause: An illegal option was specified for a recovery command.
Action: Correct the syntax and retry the command.
Cause: An attempt was made to start a second media recovery operation in the same session.
Action: Complete or cancel the first media recovery session or start another session to perform media recovery.
Cause: The CHANGE keyword was specified on the command line, but no change number was given.
Action: Retry the command using a valid change number after the CHANGE keyword.
Cause: Only CANCEL, CHANGE and TIME can be used with the UNTIL keyword.
Cause: The specified redo log file is no longer needed for the current recovery.
Action: No action required. The archived redo log file may be removed from its current location to conserve disk space, if needed. However, the redo log file may still be required for another recovery session in the future.
Cause: The requested log is required to proceed with recovery.
Action: Please specify the requested log in the command or cancel recovery.
Cause: This message helps to locate the redo log file with the specified change number requested by other messages.
Action: Use the information provided in this message to specify the required archived redo log files for other errors.
Cause: An attempt was made to use a dispatcher process for media recovery. Memory requirements disallow this recovery method.
Action: Connect to the instance via a dedicated server process to perform media recovery.
Cause: The given UPI call is no longer supported.
Action: Use the ALTER DATABASE RECOVER command for all recovery actions.
Cause: An error during recovery was determined to be fatal enough to end the current recovery session.
Action: More specific messages will accompany this message. Refer to the other messages for the appropriate action.
Cause: An error during recovery was determined to be minor enough to allow the current recovery session to continue.
Action: More specific messages will accompany this message. Refer to other messages for the appropriate action.
Cause: UNTIL TIME was not followed by a string constant for the time.
Action: Enter the time enclosed in single quotation marks.
Cause: None of the members of a redo log file group are available, or the available members do not contain complete data.
Action: If a member is temporarily off line, attempt to make it available. Check that the correct filenames are being used, especially if the redo log file is being accessed from a remote location.
Cause: The given change number does not appear in any of the online redo logs for the given thread.
Action: Check the statement to make certain a valid change number is given. Perhaps try to use the NEXT option for archiving logs.
Cause: During media recovery, redo information from a new log is not required but the continuation command is necessary to do a checkpoint and report errors.
Action: Type ALTER DATABASE RECOVER CONTINUE and recovery will resume.
Cause: This message reports the next redo log filename that is needed, according to the initialization parameters LOG_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT. This message assumes that LOG_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT are the same now as when the required redo log file was archived.
Action: Consider using this filename for the next log needed for recovery.
Cause: While attempting to archive to a redo log file, the server encountered an unexpected operating system error.
Action: Correct the operating system error given in the messages and retry the operation. See also your operating system-specific Oracle documentation.
Cause: A recovery command was specified incorrectly. The PARALLEL option must be followed by a numeric argument that specifies the degree of parallelism.
Action: Re-enter the command with a numeric argument specifying the degree of parallelism desired.
Cause: A parallel recovery was requested when the parallel recovery option is not installed.
Action: Delete the PARALLEL clause from the RECOVER command. Also, delete the RECOVERY_PARALLELISM parameter in the initialization file.
Cause: The redo log and control file are out of sync because a non-current control file was specified when the instance was started.
Action: Retry the Recover command using the current control file or retry the Recover command using the USING BACKUP CONTROL FILE clause.
Cause: An invalid format specifier was found in the LOG_ARCHIVE_FORMAT initialization parameter. The only characters permitted following the % symbol are s, S, t, and T.
Action: Correct the initialization file and re-start the instance.
Cause: An invalid file number was specified.
Action: Specify a correct datafile number and retry the operation.
This section lists messages generated when the Redo Log Files are accessed.
Cause: The specified block size of the redo log file is greater than the maximum block size for the operating system.
Action: Create the redo log on a device with a smaller block size.
Cause: The creation of the redo log file failed.
Action: Check that there is enough storage space on the device, that the name of the file is valid, and that the device is online; then try again. Also, it is possible REUSE was specified on the command line and a file of the incorrect size exists. Either do not specify REUSE or use a file of the correct size.
Cause: The maximum number of redo log files has been exceeded. There is a limit, set at database creation, on the number of redo log files (typically 16).
Action: Use the CREATE CONTROLFILE command with a larger value for MAXLOGFILES.
Cause: An instance tried to start by using a value of the initialization parameter INSTANCE_NUMBER that is already in use.
Action: Specify another value for INSTANCE_NUMBER in the initialization parameter file or wait for recovery to finish for that instance number. Then restart the instance.
Cause: The database ID in the redo log file does not match the database ID in the control file. This redo log file is not from the current database.
Action: Specify the correct redo log file, then retry the operation.
Cause: Starting this instance would exceed the maximum number of instances allowed for this database. This message occurs only when attempting to start another instance in Parallel Server mode.
Action: It is not possible to start more than the given number of instances. The maximum is the lower of the operating system-specific maximum or the MAXINSTANCES option specified in the CREATE DATABASE statement. See also your operating system-specific Oracle documentation.
Cause: The initialization parameter INSTANCE_NUMBER specified a number that was out of range.
Action: Change INSTANCE_NUMBER to a valid range and restart the instance. The minimum value is one and the maximum value is the lower of the operating system-specific maximum or the MAXINSTANCES option specified in the CREATE DATABASE statement. See also your operating system-specific Oracle documentation.
Cause: The system cannot access a required archived redo log file.
Action: Check that the off line log exists, the storage device is online, and the archived file is in the correct location. Then attempt to continue recovery or restart the recovery session.
Cause: The system cannot access the archived redo log because it belongs to another database.
Action: Specify the correct redo log file, then retry the operation.
Cause: The archived log is out of sequence, probably because it is corrupted or the wrong redo log filename was specified during recovery.
Action: Specify the correct redo log file; then retry the operation.
Cause: An error occurred when attempting to read the file header from the archived redo log file.
Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
Cause: This message reports the filename for details of another message.
Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
Cause: The online log cannot be opened. The file may not be in the expected location.
Action: Specify the correct redo log file or make log available, if necessary. Also, see the following messages, if any.
Cause: The online log is out of sequence, probably because it is corrupted or an old version.
Action: For more information on recovery procedures, see the Oracle8 Server Administrator's Guide.
Cause: The online redo log file is corrupted or is an old version.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: The online redo log file is corrupted or is an old version.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: This is not an archived redo log file.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: The file size indicated in the control file did not match the file size contained in the redo log file.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: An online redo log file has log reset data that is different from the log reset data listed in the control file. The redo log file is probably an incorrectly restored backup.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: The system is unable to read the redo log file header because the file is not available or the file is corrupted.
Action: Specify the correct redo log file, then retry the operation.
Cause: The system cannot write to the redo log file.
Action: Restore access to the redo log file; then retry the operation.
Cause: An online redo log file appears to be an incorrectly restored backup, according to a check of the redo log file header.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: An attempt to open a thread failed because it is necessary to switch to another online log, but all the other online redo logs need to be archived before they can be used.
Action: Archive the online redo logs for the thread, then retry the operation.
Cause: The translated name for a redo log file is too long.
Action: Respecify a redo log filename that produces a shorter filename on translation.
Cause: The archived redo log file is corrupted, or it belongs to another thread. This redo log file cannot be used.
Action: Find and use the correct archived redo log file, then retry the operation.
Cause: The archived redo log file supplied for recovery was generated after the redo log file that is needed. Cannot use the log for applying redo information at this time.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: A redo log file has shrunk in size. This is usually caused by a computer operator's mistake or an operating system error.
Action: Restore the redo log file from backup. If the database was shut down cleanly, no further action should be required. Otherwise, manual recovery may be necessary.
Cause: The archived redo log file supplied for recovery was generated before the log that is needed. Cannot use the log for applying redo information at this time.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: The archived redo log file supplied for recovery is not the correct log. An earlier redo log file is needed.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: The archived redo log file supplied for recovery is not the correct log. A later redo log file is needed.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: The log was created under an older, incompatible version of Oracle, or an attempt was made to use the wrong log.
Action: Specify the correct redo log file or recover the database with the old software. Then shut down and restart Oracle with the new software.
Cause: The log occupies less space than is allocated to it. This may result from a shutdown abort while the archiver was writing it.
Action: Get a complete version of the file, either the online version or one that was successfully archived, and use that for recovery.
Cause: An error occurred while reading the redo log file. Other messages will accompany this message and will give the name of the file.
Action: Restore access to the file or get another copy of the file.
Cause: This message reports the filename involved with other errors.
Action: See the associated messages for a description of the problem.
Cause: This message reports the filename involved with other messages.
Action: Correct the underlying problems mentioned in the other messages.
Cause: The redo log file size specified in the CREATE DATABASE statement is too small.
Action: Increase the redo log file size and re-enter the statement.
Cause: The system could not add a redo log file because it could not find an existing file or a size for creating the file.
Action: Specify a size for the redo log file, then retry the operation.
Cause: The control file change sequence number in the redo log file is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly causing this error to happen by reopening the database may cause the error to stop happening without correcting the problem. Every attempt to open the database advances the control file change sequence number.
Action: Use the correct control file or perform recovery using a backup of the control file.
Cause: The archived log being applied is not the correct log. The log being applied is possibly a copy of a log or was an online log being prepared to be used as the current log.
Action: Restore the correct redo log file.
|
Copyright © 1997 Oracle Corporation. All Rights Reserved. |
|