Chapter 12. 12000 ~ 12999

12001: Session has been closed.

CauseThe session was terminated by a system administrator or system timer.
ActionTry to reconnect.

12002: Requested session was not found.

CauseThe required session could not be found.
ActionDouble check the session ID and serial number.

12003: Unable to open a session.

CauseThe maximum number of sessions are already open.
ActionClose the other open sessions, or shut down the server, (WTHR_PROC_CNT, _WTHR_PER_PROC), and restart the server.

12004: Unable to connect: DBMS server is in recovery mode.

CauseUnable to connect to the server since the DBMS server is currently in a recovery process.
ActionWait until the recovery process is completed.

12005: Unable to connect to the DBMS server.

CauseThe listener blocked the current client's IP address from access to the DBMS server.
ActionContact the DBA or the technical support team about the IP filtering policy.

12006: Session is not open for this connection.

CauseA request occurred for a session that was not opened.
ActionOpen the session or log on.

12007: Requested cursor [%1$d] was not found.

CauseThe required cursor has been closed.
ActionIf the request was to close a cursor, the request was fulfilled.

12008: Unable to open new cursor: too many cursors are in use.

CauseThe maximum number of cursors was already open.
ActionClose the other open cursors, or modify the OPEN_CURSORS initialization parameter.

12009: Unable to change isolation level of an active transaction.

CauseThe transaction is in progress.
ActionRetry after committing or rolling back the transaction.

12010: No transaction exists to set a savepoint.

CauseThere is no transaction to set a savepoint.
ActionA transaction is necessary to set a savepoint.

12011: Unable to open the session.

CauseOne of the session slots has an internal problem.
ActionTo use the session slot, reboot the system or contact the technical support team.

12012: Session is already open.

CauseThe session is already ACTIVE or RUNNING.
ActionTo change the session state, use the 'session kill' command.

12013: A session cannot terminate itself.

CauseA session attempted to terminate itself through a 'session kill' command.
ActionDouble check the session ID and serial number.

12014: Transaction control statements are not allowed in XA transactions.

CauseAn attempt was made to use a transaction control statement in XA mode.
ActionTransaction control statements cannot be used in XA mode.

12015: Active autonomous transaction detected and rolled back.

CauseAn autonomous transaction has not been closed.
ActionCommit or roll back within the trigger or in the procedure.

12016: Specified DATE/TIME/TIMESTAMP format is too long: \'%1$s\'.

CauseThe format of DATE, TIME or TIMESTAMP is too long.
ActionShorten the format string.

12017: Temporary table \'%1$s\' is being used by another transaction.

CauseAnother transaction is using the temporary table.
ActionCommit the transaction, and try to access the table again.

12018: Invalid PPID.

CauseThe PPID is invalid.
ActionCheck the protocol version.

12019: Unable to execute batch update: invalid array binding count detected.

CauseInvalid number of bindings.
ActionCheck the protocol version.

12020: Unable to execute SQL statement.

CauseThe SQL statement cannot be executed in the current server mode.
ActionChange the server mode and retry the statement.

12021: Only SYS user can log on in restricted boot mode.

CauseOnly the SYS user can log on in the current boot mode.
ActionLog on as SYS user.

12022: Authentication failed: invalid password.

CauseThe password is invalid.
ActionEnter the correct password.

12023: Unrecognized SQL statement: invalid grammar.

CauseThe SQL statement cannot be parsed.
ActionVerify that the SQL statement is correct and retry.

12024: SQL queries cannot be submitted during batch updates.

CauseQueries are not allowed during a batch update.
ActionDon't use queries during batch updates.

12025: Only procedure-type PSMs are allowed during batch updates.

CauseFunction-type PSMs are not allowed during batch update.
ActionUse only procedure-type PSM during batch update.

12026: Output parameters cannot be used during batch updates.

CauseAn attempt was made to use an output parameter during a batch update.
ActionOutput parameters are not allowed during batch updates.

12027: Database name is too long.

CauseThe DB name is too long.
ActionChoose a shorter name for the DB.

12028: Only DDL statements are allowed in NOMOUNT boot mode.

CauseOnly DDL statements are allowed in the NOMOUNT mode.
ActionCheck the boot mode and the SQL statement.

12029: Unable to execute the prepared statement: invalid number of parameters.

CauseThe number of parameters specified does not match the number required by the physical plan.
ActionCheck the protocol version.

12030: Unable to handle unexpected incoming message type %1$d.

CauseAn unexpected protocol was received.
ActionCheck that the protocol is from a valid context.

12031: Invalid cursor state.

CauseThe cursor state is invalid because the DDL statement was executed during fetch.
ActionCheck the object at which the cursor was pointed.

12032: Deadlock detected.

CauseDeadlock detected.
ActionRetry the transaction.

12033: Lock acquisition failed in NOWAIT mode.

CauseLock acquisition failed in NOWAIT mode.
ActionWait a moment and try again.

12034: Lock acquisition timed out in WAIT mode.

CauseLock acquisition failed after the maximum wait time expired (lock timeout).
ActionWait a moment and try again.

12035: Internal error %1$d occurred.

CauseAn internal error occurred.
ActionContact the technical support team.

12039: Server instance is shutting down.

CauseThe server instance is shutting down the system.
ActionThe server instance is shutting down the system.

12040: Statement canceled.

CauseThe SQL statement was canceled during execution.
ActionExecute the SQL statement again.

12041: Local COMMIT/ROLLBACK/SAVEPOINT is not allowed in XA transactions.

CauseLocal COMMIT, ROLLBACK or SAVEPOINT was specified in an XA transaction.
ActionLocal COMMIT, ROLLBACK or SAVEPOINT cannot be executed in an XA transaction.

12042: Authentication timed out.

CauseUser authentication failed after the maximum wait time expired.
ActionThe connection request might have come from an invalid client; if not, increase the timeout value.

12043: DBLink information was not found.

CauseNo DBLink information could be found.
ActionCheck the DBLink name and permissions.

12044: Unable to connect to remote database.

CauseCannot access the remote DB.
ActionCheck the DBLink host information.

12048: Unknown service requested.

CauseThe request is for an unknown service.
ActionVerify the request is from a valid context.

12049: Return clauses cannot be used during batch updates.

CauseA return clause cannot be used during batch updates.
ActionRemove the return clause.

12050: Connection error. Connect to a different server.

CauseThe server may be in standby or not yet open.
ActionAccess a different server.

12051: Unable to change server mode (%1$s).

CauseThe server mode cannot be changed.
ActionCheck the cause of failure and try again.

12052: Cannot commit with DBLink.

CauseTwo-phase commit with database link has failed.
ActionCheck the target DB server and restart transaction.

12054: In-doubt transactions.

CauseThe transactions are in an in-doubt state.
ActionCheck the status of the remote DB and resolve the in-doubt state.

12055: Transaction rolled back. Some remote DBs may be in doubt.

CauseThere is a possibility that a remote DB is in an in-doubt state after the transaction was rolled back.
ActionCheck the status of the remote DB.

12056: Database link is in use.

CauseA transaction is using the database link.
ActionTry again after the transaction is completed.

12057: Database link is not open.

CauseThe database link is not connected.
ActionCheck the database link name.

12058: Remote connection was lost. Transaction rollback required.

CauseThe connection to the remote server was severed, so the current transaction must be rolled back.
ActionRoll back the current transaction.

12059: Remote statement failed due to (ec=%1$d): \n%2$s.

CauseAn error occurred with the remote server.
ActionResolve the problem by referring to the remote server, and then try again.

12060: DBMS server is experiencing heavy load: connect to another instance.

CauseUnable to connect to DBMS server; the server is under heavy load.
ActionTry to connect to another instance, or tweak load balancing settings.

12064: Unable to alter the session PDML state within a transaction.

CausePDML cannot be enabled or disabled in the middle of a transaction.
ActionCommit or roll back the active transaction.

12066: Unable to read or modify an object after modifying it with PDML.

CauseAn attempt was made to read or modify a table which was already modified with PDML in the current transaction.
ActionThis command cannot be executed.

12067: Unable to modify an object with PDML after modifying it.

CauseAn attempt was made to modify a table that has already been modified with PDML in the current transaction.
ActionThis command cannot be executed.

12068: Wallet is already open.

CauseThe wallet is already open.
ActionProceed to the step following the opening of the wallet.

12069: Failed to open wallet.

CauseFailed to open wallet.
ActionCheck the password, or request the security administrator to create a new wallet.

12070: Target DB returned this message: %1$s (target DB error code = %2$d).

CauseAn error occurred in the target database system.
ActionCheck the message received from the target database system.

12071: Unable to allocate a block transaction entry for parallel execution.

CauseThe block does not have an enough space to store transaction entries, or the DOP (Degree of Parallelism) is too large.
ActionDecrease DOP, or increase PCTFREE of the segment.

12072: Unable to allocate a slave session.

CauseUnable to allocate a slave session for parallel processing.
ActionIncrease the maximum number of server sessions, or wait until there is an available session.

12073: Wallet is not open.

CauseWallet is not yet open.
ActionTry again after opening the wallet.

12074: Unable to begin a global transaction.

CauseThe target database system cannot start a global transaction.
ActionCheck the state of the target database system and gateway.

12075: Workload repository table does not exist.

CauseThere is no workload repository table.
ActionTry again after opening the wallet.

12076: Retry the attempted action.

CauseThe SQL need to be run again because the materialized view freshness has been corrupted.
ActionTry again.

12077: Commit request from the remote DB to commit the global transaction.

Cause(Internal Error) The remote DB requested to commit the global transaction.
ActionContact the technical support team.

12078: Rollback request from the remote DB for the global transaction.

CauseThe remote DB requested to roll back the global transaction.
ActionInternal message.

12079: The requested DB_NAME does not match with the server DB_NAME.

CauseThe DB_NAME specified in the client does not match the DB_NAME in the server.
ActionCheck the DB_NAME in the server and try to connect again.

12080: Unable to generate SSL ctx.

CauseUnable to create the SSL ctx structure.
ActionCheck the server status and try again.

12081: Failed to load the SSL user certificate file.

CauseFailed to load the server certificate.
ActionCheck the path of the server certificate file.

12082: Failed to load the SSL private file.

CauseFailed to load the private key.
ActionCheck the path of the private key file.

12083: Unmatched SSL public key.

CauseThe certificate and the private key do not match.
ActionCheck the certificate and the private key.

12084: Failed to generate the SSL structure.

CauseFailed to generate the SSL structure from the SSL ctx.
ActionCheck the server status and try again.

12085: Failed to accept from client ssl connection.

CauseFailed to connect to the client.
ActionCheck the client status and the server status.

12086: Incoming SQL is empty.

CauseThe requested SQL is empty.
ActionCheck the SQL statement and try again.

12087: Failed to open the wallet.

CauseThe wallet is not yet closed.
ActionCheck if the wallet is completely closed and retry the statement.

12088: The table for the performance monitoring function does not exist.

CauseThe table for the performance monitoring function does not exist or user does not have admin authority.
ActionGet admin authority or create the table again with the system.sh.

12089: The specified snapshot between '%1$s' and '%2$s' does not exist.

CauseAmong the saved snapshots, the snapshot between '%1$s' and '%2$s' does not exist.
ActionCheck if the snapshot exists and try again.

12090: Unable to open the report file '%1$s'.

CauseFailed to create the file '%1$s' in order to generate the report file.
ActionEnsure files can be created and try again.

12091: The performance monitoring function is deactivated.

CauseUnable to execute the function due to the deactivated performance monitoring function.
ActionSet the performance monitoring on.

12092: Binding a deferred parameter is not allowed in an anonymous block.

CauseBinding a deferred parameter in an anonymous block has not yet been implemented.
ActionBind a non-deferred parameter.

12093: Invalid protocol message is arrived.

CauseThere is a problem in the slave server or the session.
ActionCheck the status of the slave server or the session.

12094: The remote session is closed.

CauseThe remote session is closed.
ActionDo not send a message to the remote session.

12096: Unable to modify the size of TCP send buffer.

CauseThe TCP send buffer size was not modified.
ActionContact the technical support team.

12097: Unable to modify the size of TCP send buffer.

CauseThe TCP send buffer size was not modified.
ActionContact the technical support team.

12098: There are too many open cursors using the same physical plan object or data dictionary object.

CauseThis error occurs if clients leave cursors open for an extended amount of time.
ActionContact the technical support team.

12099: Read message timeout.

CauseReading message from the client failed after the maximum wait time expired. Server closed connection to client.
ActionCheck the status of the client.

12100: Active session timed out.

CauseActive session timed out after the maximum wait time expired.
ActionIncrease the active session timeout value.

12101: Can't fill the shared pool with dummy chunks. The reserve size is invalid.

CauseThe reserve size is negative or larger than the maximum chunk size limit of the shared pool.
ActionCheck the reserve size.

12102: Can't fill the shared pool with dummy chunks. Reserve size is too big.

CauseThe available shared pool size is smaller than the reserve size.
ActionCheck the reserve size.

12103: Can't fill the shared pool with dummy chunks. A Fill or Sweep operation is in progress by another session.

CauseA Fill or Sweep operation is in progress by another session.
ActionRetry after the other session has ended.

12104: Can't sweep off the dummy chunks in the shared pool. A Fill or Sweep operation is in progress by another session.

CauseA Fill or Sweep operation is in progress by another session.
ActionWait a while and retry the command.

12105: The mode 2 batch update failed.

CauseThe mode 2 batch update failed for the bound data.
ActionCheck the bound data.

12106: SQL Plan History table does not exist.

CauseOne or more SQL Plan History tables do not exist.
ActionCreate the tables.

12107: Parameter value is out of range.

CauseOne or more SQL Plan History parameter values are out of range.
ActionCheck the parameter values first.

12108: Fatal error occured during loading initialization parameter.

CauseInitialization pramteter is invalid.
ActionCheck the inititalization parameter first.

12109: Appropriate node not found.

CauseNo node found in given condition.
ActionCheck the horde group mapping.

12110: Session has been clean.

CauseThe session was cleaned by a system administrator
ActionCheck the target session is clean

12111: Unable to read or modify an object after modifying it with DPL/DPI.

CauseAn attempt was made to read or modify a table which was already modified with DPL/DPI in the current transaction.
ActionThis command cannot be executed.

12112: The database trigger '%1$s' contains an error.

CauseAn existing database trigger may be invalid or has generated an error during execution.
ActionCheck the trigger.

12113: The policy function or package %1$s.%2$s contains an error.

CauseThe policy function cannot be executed because it is invalid or has an error.
ActionRecheck the function definition.

12114: The RLS policy cannot be attached to this object.

CauseRLS policy can only be attached to tables, views, and synonyms.
ActionCheck the object.

12115: The performance monitoring function is not started.

CauseThe performance monitoring function is being started.
ActionWait a moment and try again.

12116: Encryption not supported.

CauseThis version does not support encryption.
ActionTry another version of the product.

12117: The ASH function is deactivated.

CauseUnable to execute the function due to the deactivated ASH function.
ActionSet the ACTIVE_SESSION_HISTORY to 'Y'

12119: User argument error for Benchmark execution.

CauseCheck the argument values specified in the DDL.
ActionChange the argument values and try again.

12120: Transaction rolled back.

CauseTransaction rolled back.
ActionCheck constraints.

12121: The given set of wlock id and tid is invalid.

CauseNo wlock is found using the given wlock id and tid.
ActionCheck the wlock id and tid.

12122: Only SYSADM user can log on in restricted boot mode.

CauseOnly the SYSADM user can log on in the current boot mode.
ActionLog on as SYSADM user.

12123: An attempt to begin sysdump has failed.

CauseAn attempt to stop processes for sysdump has failed.
ActionWait a moment and try again.

12124: Invalid error code - %1$u.

CauseThe specified error code was not found.
ActionCheck the error code.

12125: Database link is read-only.

CauseThe database link is read-only, so the DML is not allowed.
ActionCheck the configuration of the database link, and remake the database link as normal mode if needed.

12126: Database link client API error - %1$s

CauseAn error occured while using the client API via database link.
ActionCheck the error message for the client API.

12127: Invalid PPID.

CauseThe PPID is invalid.
ActionCheck the protocol version.