Oracle Error Messages: 04/22/12

Sunday, 22 April 2012

ORA-24501: invalid UTF16 string passed in

ORA-24501: invalid UTF16 string passed in

Cause: Non-UTF16 string is passed in while UTF16 string is expected

Action: Check the parameter which is actually a string

ORA-24500: invalid UTF16 mode

ORA-24500: invalid UTF16 mode

Cause: UTF16 mode is allowed only at environment handle creation time.

Action: Remove UTF16 mode for functions other than OCIEnvCreate()

ORA-24460: Native Net Internal Error

ORA-24460: Native Net Internal Error

Cause: Internal error .

Action: This error should not normally occur. If it persists, please contact your customer service representative.

ORA-24450: Cannot pre-process OCI statement

ORA-24450: Cannot pre-process OCI statement

Cause: An error occured during statement pre-processing. E.g., SQL statement has invalid usage of N or Q literals.

Action: Correct the SQL statement.

ORA-24440: OCI Easy Install mode cannot be initialized

ORA-24440: OCI Easy Install mode cannot be initialized

Cause: An internal OCI error has occurred.

Action: Please contact Oracle customer support.

ORA-24439: success with PLSQL compilation warning

ORA-24439: success with PLSQL compilation warning

Cause: A plsql compilation warning occurred.

Action: Return OCI_SUCCESS_WITH_INFO along with the error code.

ORA-24438: Invalid Authentication Handle specified.

ORA-24438: Invalid Authentication Handle specified.

Cause: The statement was prepared using an authentication handle that is different from the one specified in OCIStmtExecute.

Action: none

ORA-24437: OCIStmtExecute called before OCIStmtPrepare2.

ORA-24437: OCIStmtExecute called before OCIStmtPrepare2.

Cause: An attempt was made to execute a statement without first preparing it using OCIStmtPrepare2.

Action: Call OCIStmtPrepare2 before OCIStmtExecute.

ORA-24436: Invalid statement Handle.

ORA-24436: Invalid statement Handle.

Cause: OCIHandleFree called on a statement that was prepared using OCIstmtPrepare2.

Action: Release the statement using OCIStmtRelease.

ORA-24435: Invalid Service Context specified.

ORA-24435: Invalid Service Context specified.

Cause: The statement was prepared using a service context that is different from the one specified in OCIStmtExecute.

Action: Please specify the same service context that the statement was prepared with.

ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.

ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.

Cause: An attempt was made to release a statement without first preparing it using OCIStmtPrepare2.

Action: Call OCIStmtPrepare2 before OCIStmtRelease.

ORA-24433: This statement has already been prepared using OCIStmtPrepare2.

ORA-24433: This statement has already been prepared using OCIStmtPrepare2.

Cause: A statement that was earlier prepared using OCIStmtPrepare2 is now being reprepared using OCIStmtPrepare.

Action: Please use a different statement handle.

ORA-24432: The statement that was returned is not tagged.

ORA-24432: The statement that was returned is not tagged.

Cause: A tagged statement was requested for, but an untagged statement has been returned.

Action: This is a warning. Please modify and tag the statement as desired.

ORA-24431: Statement does not exist in the cache

ORA-24431: Statement does not exist in the cache

Cause: The statement that was requested for does not exist in the statement cache.

Action: Please request for a valid statement.

ORA-24430: Null values for sqltext and key were specified.

ORA-24430: Null values for sqltext and key were specified.

Cause: An attempt was made to call OCIStmtPrepare2 and neither sqltext nor key were specified.

Action: Specify valid values for sqltext or key or both.

ORA-24422: error occurred while trying to destroy the Session Pool

ORA-24422: error occurred while trying to destroy the Session Pool

Cause: An attempt was made to destroy the session pool while some sessions in the pool were busy.

Action: Ensure that no sessions from the pool are being used OR call OCISessionPoolDestroy with mode set to OCI_SPD_FORCE.

ORA-24421: OCISessionRelease cannot be used to release this session.

ORA-24421: OCISessionRelease cannot be used to release this session.

Cause: The session was not retrieved using OCISessionGet, and an attempt has been made to release it using OCISessionRelease.

Action: Release the session using an appropriate call.

ORA-24420: OCISessionRelease must be used to release this session.

ORA-24420: OCISessionRelease must be used to release this session.

Cause: The session was retrieved using OCISessionGet, and an attempt has been made to release it using a call other than OCISessionRelease.

Action: Call OCISessionRelease.

ORA-24419: Proxy sessions are not supported in this mode.

ORA-24419: Proxy sessions are not supported in this mode.

Cause: A proxy session was requested for from a Session Pool which does not support proxy sessions.

Action: Do not specify mode OCI_CRED_PROXY.

ORA-24418: Cannot open further sessions.

ORA-24418: Cannot open further sessions.

Cause: Sufficient number of sessions are not present in the pool to execute the call. No new sessions can be opened as the sessMax parameter supplied in OCISessionPoolCreate has been reached.

Action: Call OCISessionPoolCreate in OCI_SPOOL_REINITIALIZE mode and increase the value of the sessMax parameter.

ORA-24417: Session pool size has exceeded the maximum limit

ORA-24417: Session pool size has exceeded the maximum limit

Cause: The number of sessions has exceeded the maximum size of the Session Pool.

Action: This is a warning. You can tune the session pool with appropriate minimum and maximum parameters.

ORA-24416: Invalid session Poolname was specified.

ORA-24416: Invalid session Poolname was specified.

Cause: An attempt was made to use a Session Pool that does not exist.

Action: Create a Session Pool before using it.

ORA-24415: Missing or null username.

ORA-24415: Missing or null username.

Cause: Username and password must be specified when pool is created in this mode.

Action: Specify a valid username and password.

ORA-24414: Only number sessions could be started.

ORA-24414: Only number sessions could be started.

Cause: The number of sessions specified by the minSess parameter of OCISessionPoolCreate could not be started, possibly because the value supplied was larger than that supported by the server.

Action: This is a warning. Check the maximum number of sessions allowed on the server.

ORA-24413: Invalid number of sessions specified

ORA-24413: Invalid number of sessions specified

Cause: An invalid combination of minimum, maximum and increment number of sessions was specified in the OCISessionPoolCreate call.

Action: Specify a valid combination of parameters.

ORA-24412: Cannot reinitialize non-existent pool

ORA-24412: Cannot reinitialize non-existent pool

Cause: OCISessionPoolCreate was not called in OCI_DEFAULT mode for this pool handle.

Action: Create a session pool prior to reinitializing it.

ORA-24411: Session pool already exists.

ORA-24411: Session pool already exists.

Cause: A session pool has already been created for the specified pool handle.

Action: 1) Specify a different pool handle to create a new session pool. 2) If you wish to modify the pool parameters, call OCISessionPoolCreate in OCI_SPOOL_ REINITIALIZE mode.

ORA-24410: scrollable cursor max size exceeded

ORA-24410: scrollable cursor max size exceeded

Cause: Result set size exceeded the max limits.

Action: Check the documentation for allowable maximum result set size for scrollable cursors. Re-execute with a smaller expected result set size or make the cursor non-scrollable.

ORA-24409: client cannot understand the object

ORA-24409: client cannot understand the object

Cause: The client cannot process all the new features in the object.

Action: Upgrade the client so that features like inheritance and SQLJ objects can be used.

ORA-24408: could not generate unique server group name

ORA-24408: could not generate unique server group name

Cause: An internal error occured while generating unique server group name.

Action: Contact customer support.

ORA-24407: connection pool already exists

ORA-24407: connection pool already exists

Cause: A connection pool has already been created for the specified pool name.

Action: Specify a different pool name to create a new connection pool.

ORA-24406: API mode switch is disallowed when a call is in progress.

ORA-24406: API mode switch is disallowed when a call is in progress.

Cause: A mode switch from OCI8 to OCI7 was attempted in a callback.

Action: The user should perform the API mode switch either prior to initiating the top call or after the main call is done.

ORA-24405: error occured while trying to create connections in the pool

ORA-24405: error occured while trying to create connections in the pool

Cause: An internal error occured while creating connections in the pool.

Action: Contact customer support.

ORA-24404: connection pool does not exist

ORA-24404: connection pool does not exist

Cause: An attempt was made to use the connection pool before creating it.

Action: Create the connection pool.

ORA-24403: error occured while trying to destroy the connection pool

ORA-24403: error occured while trying to destroy the connection pool

Cause: Some connections in the pool were busy when an attempt to destroy the connection pool was made.

Action: Ensure no connections from the pool are being used.

ORA-24402: error occured while creating connections in the pool

ORA-24402: error occured while creating connections in the pool

Cause: The username and password specified in OCIConnectionPoolCreate might be invalid.

Action: Specify a valid username and password.

ORA-24401: cannot open further connections

ORA-24401: cannot open further connections

Cause: Sufficient number of connections are not present in the pool to execute the call. No new connections can be opened as the connMax parameter supplied in OCIConnectionPoolCreate has been reached.

Action: Call OCIConnectionPoolCreate in OCI_CPOOL_REINITIALIZE mode and increase the value of the connMax parameter.

ORA-24400: error occured while creating connections in the pool

ORA-24400: error occured while creating connections in the pool

Cause: The database link specified in OCIConnectionPoolCreate might be an invalid one.

Action: Specify a valid database link.

ORA-24399: invalid number of connections specified

ORA-24399: invalid number of connections specified

Cause: An invalid combination of minimum, maximum and increment number of connections was specified in the OCIConnectionPoolCreate call.

Action: Specify a valid combination of parameters.

ORA-24398: connection pool already exists

ORA-24398: connection pool already exists

Cause: A connection pool has already been created for the specified pool handle.

Action: 1) Specify a different pool handle to create a new connection pool. 2) If you wish to modify the pool parameters, call OCIConnectionPoolCreate in OCI_ CPOOL_REINITIALIZE mode.

ORA-24397: error occured while trying to free connections

ORA-24397: error occured while trying to free connections

Cause: An internal error occured while trying to free connections.

Action: Contact customer support.

ORA-24396: invalid attribute set in server handle

ORA-24396: invalid attribute set in server handle

Cause: Attribute OCI_ATTR_NONBLOCKING_MODE has been set on the server handle and attached in OCI_POOL mode. Connection pooling does not support non blocking mode.

Action: Do not set the OCI_ATTR_NONBLOCKING_MODE attribute on the server handle while attaching in OCI_POOL mode.

ORA-24395: cannot reinitialize non-existent pool

ORA-24395: cannot reinitialize non-existent pool

Cause: OCIConnectionPoolCreate was not called in OCI_DEFAULT mode for this pool handle.

Action: Create a connection pool prior to reinitializing it.

ORA-24394: invalid mode for destroying connection pool

ORA-24394: invalid mode for destroying connection pool

Cause: Mode specified in OCIConnectionPoolDestroy is invalid.

Action: Use a valid mode.

ORA-24393: invalid mode for creating connection pool

ORA-24393: invalid mode for creating connection pool

Cause: Mode specified in OCIConnectionPoolCreate is invalid.

Action: Use a valid mode.

ORA-24392: no connection pool to associate server handle

ORA-24392: no connection pool to associate server handle

Cause: OCIServerAttach called in OCI_POOL mode but no connection pool found to associate the server handle.

Action: 1) Verify that OCIConnectionPoolCreate is called before calling OCIServerAttach. 2) Verify that the database link specified in OCIServerAttach matches with that of the connection pool database link.

ORA-24391: invalid fetch operation

ORA-24391: invalid fetch operation

Cause: Scrollable cursor operation requested with non-scrollable cursor.

Action: Check if the statement was executed in the scrollable mode. Else the only acceptable orientation is OCI_FETCH_NEXT that ignores the scroll offset parameter.

ORA-24390: Unsupported scrollable cursor operation

ORA-24390: Unsupported scrollable cursor operation

Cause: The scrollable cursor execute or fetch has failed.

Action: Check the documentation for supported types, and other restrictions while using scrollable cursors.

ORA-24389: Invalid scrollable fetch parameters

ORA-24389: Invalid scrollable fetch parameters

Cause: All the requested rows in this fetch could not be received.

Action: Check the fetch orientation, scroll offset, OCI_ATTR_CURRENT_ POSITION and number of rows in OCIStmtFetch2 call. If required, change some of above parameters and fetch again.