No. 12000 ~ 12999
12001: Session has been closed.
Cause The session was terminated by a system administrator or system timer.
Action Try to reconnect.
12002: Requested session was not found.
Cause The required session could not be found.
Action Double check the session ID and serial number.
12003: Unable to open a session.
Cause The maximum number of sessions are already open.
Action Close the other open sessions, or shut down the server, increase the maximum number of sessions, and restart the server.
12004: Unable to connect: DBMS server is in recovery mode.
Cause Unable to connect to the server since the DBMS server is currently in a recovery process.
Action Wait until the recovery process is completed.
12005: Unable to connect to the DBMS server.
Cause The listener blocked the current client's IP address from access to the DBMS server.
Action Contact the DBA or the technical support team about the IP filtering policy.
12006: Session is not open for this connection.
Cause A request occurred for a session that was not opened.
Action Open the session or log on.
12007: Requested cursor [%1$d] was not found.
Cause The required cursor has been closed.
Action If the request was to close a cursor, the request was fulfilled.
12008: Unable to open new cursor: too many cursors are in use.
Cause The maximum number of cursors was already open.
Action Close the other open cursors, or modify the OPEN_CURSORS initialization parameter.
12009: Unable to change isolation level of an active transaction.
Cause The transaction is in progress.
Action Retry after committing or rolling back the transaction.
12010: No transaction exists to set a savepoint.
Cause There is no transaction to set a savepoint.
Action A transaction is necessary to set a savepoint.
12011: Unable to open the session.
Cause One of the session slots has an internal problem.
Action To use the session slot, reboot the system or contact the technical support team.
12012: Session is already open.
Cause The session is already ACTIVE or RUNNING.
Action To change the session state, use the 'session kill' command.
12013: A session cannot terminate itself.
Cause A session attempted to terminate itself through a 'session kill' command.
Action Double check the session ID and serial number.
12014: Transaction control statements are not allowed in XA transactions.
Cause An attempt was made to use a transaction control statement in XA mode.
Action Transaction control statements cannot be used in XA mode.
12015: Active autonomous transaction detected and rolled back.
Cause An autonomous transaction has not been closed.
Action Commit or roll back within the trigger or in the procedure.
12016: Specified DATE/TIME/TIMESTAMP format is too long: \'%1$s\'.
Cause The format of DATE, TIME or TIMESTAMP is too long.
Action Shorten the format string.
12017: Temporary table \'%1$s\' is being used by another transac tion.
Cause Another transaction is using the temporary table.
Action Commit the transaction, and try to access the table again.
12018: Invalid PPID.
Cause The PPID is invalid.
Action Check the protocol version.
12019: Unable to execute batch update: invalid array binding count detected.
Cause Invalid number of bindings.
Action Check the protocol version.
12020: Unable to execute SQL statement.
Cause The SQL statement cannot be executed in the current server mode.
Action Change the server mode and retry the statement.
12021: Only SYS user can log on in restricted boot mode.
Cause Only the SYS user can log on in the current boot mode.
Action Log on as SYS user.
12022: Authentication failed: invalid password.
Cause The password is invalid.
Action Enter the correct password.
12023: Unrecognized SQL statement: invalid grammar.
Cause The SQL statement cannot be parsed.
Action Verify that the SQL statement is correct and retry.
12024: SQL queries cannot be submitted during batch updates.
Cause Queries are not allowed during a batch update.
Action Don't use queries during batch updates.
12025: Only procedure-type PSMs are allowed during batch up dates.
Cause Function-type PSMs are not allowed during batch update.
Action Use only procedure-type PSM during batch update.
12026: Output parameters cannot be used during batch updates.
Cause An attempt was made to use an output parameter during a batch update.
Action Output parameters are not allowed during batch updates.
12027: Database name is too long.
Cause The DB name is too long.
Action Choose a shorter name for the DB.
12028: Only DDL statements are allowed in NOMOUNT boot mode.
Cause Only DDL statements are allowed in the NOMOUNT mode.
Action Check the boot mode and the SQL statement.
12029: Unable to execute the prepared statement: invalid number of parameters.
Cause The number of parameters specified does not match the number required by the physical plan.
Action Check the protocol version.
12030: Unable to handle unexpected incoming message type %1$d.
Cause An unexpected protocol was received.
Action Check that the protocol is from a valid context.
12031: Invalid cursor state.
Cause The cursor state is invalid because the DDL statement was executed during fetch.
Action Check the object at which the cursor was pointed.
12032: Deadlock detected.
Cause Deadlock detected.
Action Retry the transaction.
12033: Lock acquisition failed in NOWAIT mode.
Cause Lock acquisition failed in NOWAIT mode.
Action Wait a moment and try again.
12034: Lock acquisition timed out in WAIT mode.
Cause Lock acquisition failed after the maximum wait time expired (lock timeout).
Action Wait a moment and try again.
12035: Internal error %1$d occurred.
Cause An internal error occurred.
Action Contact the technical support team.
12039: Server instance is shutting down.
Cause The server instance is shutting down the system.
Action The server instance is shutting down the system.
12040: Statement canceled.
Cause The SQL statement was canceled during execution.
Action Execute the SQL statement again.
12041: Local COMMIT/ROLLBACK/SAVEPOINT is not allowed in XA transactions.
Cause Local COMMIT, ROLLBACK or SAVEPOINT was specified in an XA transaction.
Action Local COMMIT, ROLLBACK or SAVEPOINT cannot be executed in an XA transaction.
12042: Authentication timed out.
Cause User authentication failed after the maximum wait time expired.
Action The connection request might have come from an invalid client; if not, increase the timeout value.
12043: DBLink information was not found.
Cause No DBLink information could be found.
Action Check the DBLink name and permissions.
12044: Unable to connect to remote database.
Cause Cannot access the remote DB.
Action Check the DBLink host information.
12048: Unknown service requested.
Cause The request is for an unknown service.
Action Verify the request is from a valid context.
12049: Return clauses cannot be used during batch updates.
Cause A return clause cannot be used during batch updates.
Action Remove the return clause.
12050: Connection error. Connect to a different server.
Cause The server may be in standby or not yet open.
Action Access a different server.
12051: Unable to change server mode (%1$s).
Cause The server mode cannot be changed.
Action Check the cause of failure and try again.
12052: Cannot commit with DBLink.
Cause Two-phase commit with database link has failed.
Action Check the target DB server and restart transaction.
12054: In-doubt transactions.
Cause The transactions are in an in-doubt state.
Action Check the status of the remote DB and resolve the in-doubt state.
12055: Transaction rolled back. Some remote DBs may be in doubt.
Cause There is a possibility that a remote DB is in an in-doubt state after the transaction was rolled back.
Action Check the status of the remote DB.
12056: Database link is in use.
Cause A transaction is using the database link.
Action Try again after the transaction is completed.
12057: Database link is not open.
Cause The database link is not connected.
Action Check the database link name.
12058: Remote connection was lost. Transaction rollback required.
Cause The connection to the remote server was severed, so the current transaction must be rolled back.
Action Roll back the current transaction.
12059: Remote statement failed due to (ec=%1$d): \n%2$s.
Cause An error occurred with the remote server.
Action Resolve the problem by referring to the remote server, and then try again.
12060: DBMS server is experiencing heavy load: connect to another instance.
Cause Unable to connect to DBMS server; the server is under heavy load.
Action Try to connect to another instance, or tweak load balancing settings.
12064: Unable to alter the session PDML state within a transaction.
Cause PDML cannot be enabled or disabled in the middle of a transaction.
Action Commit or roll back the active transaction.
12066: Unable to read or modify an object after modifying it with PDML.
Cause An attempt was made to read or modify a table which was already modified with PDML in the current transaction.
Action This command cannot be executed.
12067: Unable to modify an object with PDML after modifying it.
Cause An attempt was made to modify a table that has already been modified with PDML in the current transaction.
Action This command cannot be executed.
12068: Wallet is already open.
Cause The wallet is already open.
Action Proceed to the step following the opening of the wallet.
12069: Failed to open wallet.
Cause Failed to open wallet.
Action Check 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).
Cause An error occurred in the target database system.
Action Check the message received from the target database system.
12071: Unable to allocate a block transaction entry for parallel ex ecution.
Cause The block does not have an enough space to store transaction entries, or the DOP (Degree of Parallelism) is too large.
Action Decrease DOP, or increase PCTFREE of the segment.
12072: Unable to allocate a slave session.
Cause Unable to allocate a slave session for parallel processing.
Action Increase the maximum number of server sessions, or wait until there is an available session.
12073: Wallet is not open.
Cause Wallet is not yet open.
Action Try again after opening the wallet.
12074: Unable to begin a global transaction.
Cause The target database system cannot start a global transaction.
Action Check the state of the target database system and gateway.
12075: Workload repository table does not exist.
Cause There is no workload repository table.
Action Try again after opening the wallet.
12076: Retry the attempted action.
Cause The SQL need to be run again because the materialized view freshness has been corrupted.
Action Try 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.
Action Contact the technical support team.
12078: Rollback request from the remote DB for the global trans action.
Cause The remote DB requested to roll back the global transaction.
Action Internal message.
12079: The requested DB_NAME does not match with the server DB_NAME.
Cause The DB_NAME specified in the client does not match the DB_NAME in the server.
Action Check the DB_NAME in the server and try to connect again.
12080: Unable to generate SSL ctx.
Cause Unable to create the SSL ctx structure.
Action Check the server status and try again.
12081: Failed to load the SSL user certificate file.
Cause Failed to load the server certificate.
Action Check the path of the server certificate file.
12082: Failed to load the SSL private file.
Cause Failed to load the private key.
Action Check the path of the private key file.
12083: Unmatched SSL public key.
Cause The certificate and the private key do not match.
Action Check the certificate and the private key.
12084: Failed to generate the SSL structure.
Cause Failed to generate the SSL structure from the SSL ctx.
Action Check the server status and try again.
12085: Failed to accept from client ssl connection.
Cause Failed to connect to the client.
Action Check the client status and the server status.
12086: Incoming SQL is empty.
Cause The requested SQL is empty.
Action Check the SQL statement and try again.
12087: Failed to open the wallet.
Cause The wallet is not yet closed.
Action Check if the wallet is completely closed and retry the statement.
12088: The table for the performance monitoring function does not exist.
Cause The table for the performance monitoring function does not exist or user does not have admin authority.
Action Get admin authority or create the table again with the system.sh.
12089: The specified snapshot between '%1$s' and '%2$s' does not exist.
Cause Among the saved snapshots, the snapshot between '%1$s' and '%2$s' does not exist.
Action Check if the snapshot exists and try again.
12090: Unable to open the report file '%1$s'.
Cause Failed to create the file '%1$s' in order to generate the report file.
Action Ensure files can be created and try again.
12091: The performance monitoring function is deactivated.
Cause Unable to execute the function due to the deactivated performance monitoring function.
Action Set the performance monitoring on.
12092: Binding a deferred parameter is not allowed in an anony mous block.
Cause Binding a deferred parameter in an anonymous block has not yet been implemented.
Action Bind a non-deferred parameter.
12093: Invalid protocol message is arrived.
Cause There is a problem in the slave server or the session.
Action Check the status of the slave server or the session.
12094: The remote session is closed.
Cause The remote session is closed.
Action Do not send a message to the remote session.
12096: Unable to modify the size of TCP send buffer.
Cause The TCP send buffer size was not modified.
Action Contact the technical support team.
12097: Unable to modify the size of TCP send buffer.
Cause The TCP send buffer size was not modified.
Action Contact the technical support team.
12098: There are too many open cursors using the same physical plan object or data dictionary object.
Cause This error occurs if clients leave cursors open for an extended amount of time.
Action Contact the technical support team.
12099: Read message timeout.
Cause Reading message from the client failed after the maximum wait time expired. Server closed connection to client.
Action Check the status of the client.
12100: Active session timed out.
Cause Active session timed out after the maximum wait time expired.
Action Increase the active session timeout value.
12101: Can't fill the shared pool with dummy chunks. The reserve size is invalid.
Cause The reserve size is negative or larger than the maximum chunk size limit of the shared pool.
Action Check the reserve size.
12102: Can't fill the shared pool with dummy chunks. Reserve size is too big.
Cause The available shared pool size is smaller than the reserve size.
Action Check the reserve size.
12103: Can't fill the shared pool with dummy chunks. A Fill or Sweep operation is in progress by another session.
Cause A Fill or Sweep operation is in progress by another session.
Action Retry 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.
Cause A Fill or Sweep operation is in progress by another session.
Action Wait a while and retry the command.
12105: The mode 2 batch update failed.
Cause The mode 2 batch update failed for the bound data.
Action Check the bound data.
12106: SQL Plan History table does not exist.
Cause One or more SQL Plan History tables do not exist.
Action Create the tables.
12107: Parameter value is out of range.
Cause One or more SQL Plan History parameter values are out of range.
Action Check the parameter values first.
12108: Fatal error occured during loading initialization parameter.
Cause Initialization pramteter is invalid.
Action Check the inititalization parameter first.
12109: Appropriate node not found.
Cause No node found in given condition.
Action Check the horde group mapping.
12110: Session has been clean.
Cause The session was cleaned by a system administrator
Action Check the target session is clean
12111: Unable to read or modify an object after modifying it with DPL/DPI.
Cause An attempt was made to read or modify a table which was already modified with DPL/DPI in the current transaction.
Action This command cannot be executed.
12112: The database trigger '%1$s' contains an error.
Cause An existing database trigger may be invalid or has generated an error during execution.
Action Check the trigger.
12113: The policy function or package %1$s.%2$s contains an er ror.
Cause The policy function cannot be executed because it is invalid or has an error.
Action Recheck the function definition.
12114: The RLS policy cannot be attached to this object.
Cause RLS policy can only be attached to tables, views, and synonyms.
Action Check the object.
12115: The performance monitoring function is not started.
Cause The performance monitoring function is being started.
Action Wait a moment and try again.
12116: Encryption not supported.
Cause This version does not support encryption.
Action Try another version of the product.
12117: The ASH function is deactivated.
Cause Unable to execute the function due to the deactivated ASH function.
Action Set the ACTIVE_SESSION_HISTORY to 'Y'
12119: User argument error for Benchmark execution.
Cause Check the argument values specified in the DDL.
Action Change the argument values and try again.
12120: Transaction rolled back.
Cause Transaction rolled back.
Action Check constraints.
12121: The given set of wlock id and tid is invalid.
Cause No wlock is found using the given wlock id and tid.
Action Check the wlock id and tid.
12122: Only SYSADM user can log on in restricted boot mode.
Cause Only the SYSADM user can log on in the current boot mode.
Action Log on as SYSADM user.
12123: An attempt to begin sysdump has failed.
Cause An attempt to stop processes for sysdump has failed.
Action Wait a moment and try again.
12124: Invalid error code - %1$u.
Cause The specified error code was not found.
Action Check the error code.
12125: Database link is read-only.
Cause The database link is read-only, so the DML is not allowed.
Action Check the configuration of the database link, and remake the database link as normal mode if needed.
12126: Database link client API error - %1$s
Cause An error occured while using the client API via database link.
Action Check the error message for the client API.
12127: Invalid PPID.
Cause The PPID is invalid.
Action Check the protocol version.
12128: Statement canceled by DDL.
Cause The SQL statement was canceled by DDL execution.
Action Execute the SQL statement again.
12129: Failed to decompress batch update messages.
Cause Failed to decompress batch update messages.
Action Check the client library.
12130: Unable to connect to remote database(link_name=%1$s).
Cause Cannot access the remote DB.
Action Check the DBLink host information.
12131: External TDE package is not open.
Cause External TDE package is not yet open.
Action Try again after opening the external TDE package.
12132: External TDE package is already opened.
Cause Function can not be used simultaneously.
Action Remove parameter in tip file.
12134: Database link is not allowed in distributed transaction.
Cause Database link is not allowed in distributed transaction.
Action Retry after distributed transaction is over.
12135: Commit/Rollback force is allowed for prepared transaction only.
Cause Commit/Rollback force is allowed for prepared transaction only.
Action Prepare dblink transaction or rollback.
12136: The address of initialization parameter is NULL.
Cause The address of initialization parameter is NULL.
Action The address of initialization parameter is NULL.
12137: The requested SERVICE_NAME does not match with the server SERVICE_NAME.
Cause The SERVICE_NAME specified in the client does not match the SERVICE_NAME in the server.
Action Check the SERVICE_NAME in the server and try to connect again.
12138: The requested ILOG_NAME does not match with the server ILOG_NAME.
Cause The ILOG_NAME specified in the client does not match the ILOG_NAME in the server.
Action Check the ILOG_NAME in the server and try to connect again.
12139: The requested ILOG_TAG does not match with the server ILOG_TAG.
Cause The ILOG_NAME specified in the client does not match the ILOG_TAG in the server.
Action Check the ILOG_TAG in the server and try to connect again.
12140: The requested GENERATE_KEY is not working properly.
Cause The requested GENERATE_KEY is not working properly.
Action The requested GENERATE_KEY is not working properly.
12141: The requested GET_KEY is not working.
Cause The requested GET_KEY is not working.
Action The requested GET_KEY is not working.
12142: The requested GET_KEY or GENERATE_KEY is not working.
Cause The requested GET_KEY or GENERATE_KEY is not working.
Action The requested GET_KEY or GENERATE_KEY is not working.
12143: The requested GET_KEY or GENERATE_KEY is not working.
Cause The requested GET_KEY or GENERATE_KEY is not working.
Action The requested GET_KEY or GENERATE_KEY is not working.
12144: AD authentication has failed.
Cause AD authentication has failed.
Action Check service ticket(expiration), keytab file path and AD initialization paramters.
12145: The DBLink query must be rerun.
Cause The DBLink query needs to be rerun because the column metas of the remote table have been changed.
Action Rerun the DBLink query.
12146: TTE key migration is failed.
Cause TTE key migration is failed in the middle of modifying a datafile headerblock.
Action Need to restore tte keys using a backup file.
12147: TTE key restoration is failed.
Cause TTE key restoration is failed in the middle of modifying a datafile headerblock.
Action Retry restore using a backup file.
12148: Failed to change wallet password.
Cause Failed to change wallet password.
Action Check status of the wallet file and check syslog for details.
12149: Failed to open service file.
Cause Failed to open service file.
Action Check the path of the service file.
12150: Failed to parse service file.
Cause Failed to parse service file.
Action Check service file dsn format.
12151: Remote connection is blocked by DBMS server.
Cause DBMS server only allows local connection now.
Action Try connecting with localhost.
12152: A pointer variable in the PP structure points to an invalid memory space.
Cause The memory space preoccupied by the PP is dirty, or an invalid memory address is refer enced when creating the PP.
Action Contact technical support team. If the PP exists in the PP cache, hard parse the PP to temporarily resolve this issue.
12153: Service is not supported.
Cause This version does not support service.
Action Try another version of the product.
12154: Service file is not opened.
Cause Client failed to connect with service name because service file is not opened.
Action Check the format/path of the service file and try reboot
12156: A fatal error at RMGR session has found by the system administrator.
Cause Session was to be terminated but hasn't due to being RMGR worker.
Action If RMGR not working properly, please contact the technical support team.
12157: Failed to load the SSL user certificate file from active stor age. (%1$s)
Cause Failed to load the server certificate.
Action Check the path of the server certificate file.
12158: Failed to load the SSL private file from active storage. (%1$s)
Cause Failed to load the private key.
Action Check the path of the private key file.
12159: The wallet is in the process of being opened or closed.
Cause The wallet is already being opened or closed in the same session.
Action Retry after the wallet is completely opened or closed.
12160: Unable to open a session.
Cause The maximum number of sessions are already open.
Action Close the other open sessions, or shut down the server, increase the maximum number of sessions, and restart the server.
Last updated