Oracle错误代码解析
来源:互联网 发布:网络监控解决方案 编辑:程序博客网 时间:2024/06/01 21:30
15 ORA-24280 to ORA-28674
- ORA-24280: invalid input value for parameterstring
- Cause: The parameter has been provided a negative, out of range, or NULL input value.
- Action: Correct the input value such that it is valid, and is within the range as specified in the documentation.
- ORA-24281: invalid access past the maximum size of LOB parameterstring
- Cause: The value of positional or size parameters exceeds the maximum allowed LOB size of 4 Gigabytes.
- Action: Correct the input values for amount and offset such that their sum is less than or equal to 4 Gigabytes. If error occurs in a read or write loop, check the looping conditions and/or offset increments.
- ORA-24292: no more tables permitted in this sorted hash cluster
- Cause: A sorted hash cluster only supports a maximum of 2 tables
- Action: none
- ORA-24295: max key length (string) for sorted hash cluster exceeded
- Cause: Sorted hash clusters have a maximum key size
- Action: none
- ORA-24300: bad value for mode
- Cause: An undefined mode value was specified.
- Action: Check that the correct mode is selected and that an allowed value for that mode is specified.
- ORA-24301: null host specified in thread-safe logon
- Cause: An HDA was not specified in the logon call while running in a thread safe environment.
- Action: Make sure that HDA is not NULL when calling the logon routine.
- ORA-24302: host connection in use by another thread
- Cause: An attempt was made to use the host connection while it was in use by another thread.
- Action: Wait for another thread to finish before using this connection.
- ORA-24303: call not supported in non-deferred linkage
- Cause: One of the calls that is supported in deferred mode linkage exclusively was invoked when the client was linked non-deferred.
- Action: Use this call in deferred mode of linkage.
- ORA-24304: datatype not allowed for this call
- Cause: Data of this datatype cannot be sent or fetched in pieces.
- Action: Use other bind or define calls for this datatype.
- ORA-24305: bad bind or define context
- Cause: The call was executed on a cursor for which this is invalid.
- Action: Verify that this call is valid for this cursor. For example, Get piece information and set piece information are valid on a cursor if appropriate binds and defines have been done on this cursor.
- ORA-24306: bad buffer for piece
- Cause: A zero length buffer or a null buffer pointer was provided.
- Action: Verify that the buffer pointing to this piece or its length is non-zero. The buffer pointer for the next piece or its length can be zero if it is the last piece to be inserted and there are no more data for the column.
- ORA-24307: invalid length for piece
- Cause: The length of the piece exceeded the maximum possible size.
- Action: Verify that the length of this piece and the cumulative length of all the previous pieces is not more than the desired value supplied by the application.
- ORA-24308: illegal define position
- Cause: Call to modify attributes was done for a non-existent position
- Action: Verify that a define has been done for this position
- ORA-24309: already connected to a server
- Cause: This server handle is already attached to a server.
- Action: Disconnect from the server and then retry the call to establish a connection.
- ORA-24310: length specified for null connect string
- Cause: The connect string is null, but a length was specified for it.
- Action: Set length to zero if connect string is null.
- ORA-24311: memory initialization failed
- Cause: Cannot initialize user memory.
- Action: Contact customer support.
- ORA-24312: illegal parameters specified for allocating user memory
- Cause: An illegal size or null pointer was specified for user memory.
- Action: Specify a legal size and a valid pointer for user memory.
- ORA-24313: user already authenticated
- Cause: A user has already been authenticated on this service handle.
- Action: Terminate the service context before using it for another user.
- ORA-24314: service handle not initialized
- Cause: The server context does not done exist.
- Action: Establish the server context in the service context.
- ORA-24315: illegal attribute type
- Cause: An illegal attribute type was specified for the handle.
- Action: Consult user manual to specify an attribute valid for this handle.
- ORA-24316: illegal handle type
- Cause: An illegal handle type was specified.
- Action: Consult user manual to specify a valid handle type.
- ORA-24317: define handle used in a different position
- Cause: A define was done with an existing handle on a different position.
- Action: Specify the same position as before on a re-define.
- ORA-24318: call not allowed for scalar data types
- Cause: This call is valid only for object types.
- Action: Verify that the data-type for this variable is an object type
- ORA-24319: unable to allocate memory
- Cause: Process was unable to allocate memory to store diagnostics.
- Action: Terminate other processes in order to reclaim needed memory.
- ORA-24320: unable to initialize a mutex
- Cause: An attempt to initialize a mutex failed.
- Action: Contact customer support.
- ORA-24321: inconsistent parameters passed
- Cause: One of the three memory function pointers is null or non-null.
- Action: Verify that either all the memory functions are null or non-null.
- ORA-24322: unable to delete an initialized mutex
- Cause: An attempt to delete an initialized mutex failed.
- Action: Contact customer support.
- ORA-24323: value not allowed
- Cause: A null value or a bogus value was passed in for a mandatory parameter.
- Action: Verify that all mandatory parameters are properly initialized.
- ORA-24324: service handle not initialized
- Cause: An attempt was made to use an improper service context handle.
- Action: Verify that the service context handle has all the parameters initialized prior to this call.
- ORA-24325: this OCI operation is not currently allowed
- Cause: An attempt was made to use a context handle outside its scope.
- Action: Verify that the context handle is set to a service context handle that has been converted to a logon data area for other OCI calls. The logon data area must be converted back to a service context before it can be used.
- ORA-24326: handle passed in is already initialized
- Cause: An attempt was made to pass an initialized handle.
- Action: Verify that the parameter passed in to retrieve a handle does not already point to a handle.
- ORA-24327: need explicit attach before authenticating a user
- Cause: A server context must be initialized before creating a session.
- Action: Create and initialize a server handle.
- ORA-24328: illegal attribute value
- Cause: The attribute value passed in is illegal.
- Action: Consult the users manual and specify a legal attribute value for the handle.
- ORA-24329: invalid character set identifier
- Cause: The character set identifier specifed is invalid
- Action: Specify a valid character set identifier in the OCI call.
- ORA-24330: internal OCI error
- Cause: An internal OCI error has occurred.
- Action: Please contact Oracle customer support.
- ORA-24331: user buffer too small
- Cause: The user buffer to contain the output data is too small.
- Action: Specify a bigger buffer.
- ORA-24332: invalid object type
- Cause: An invalid object type is requested for the describe call.
- Action: Specify a valid object type to the describe call.
- ORA-24333: zero iteration count
- Cause: An iteration count of zero was specified for the statement
- Action: Specify the number of times this statement must be executed
- ORA-24334: no descriptor for this position
- Cause: The application is trying to get a descriptor from a handle for an illegal position.
- Action: Check the position number.
- ORA-24335: cannot support more than 1000 columns
- Cause: The number of columns exceeds the maximum number supported.
- Action: none
- ORA-24336: invalid result set descriptor
- Cause: The result set descriptor should have valid data fetched into it before it can be converted to a statement handle
- Action: Fetch valid data into the descriptor before attempting to convert it into a statement handle
- ORA-24337: statement handle not prepared
- Cause: A statement cannot be executed before making preparing a request.
- Action: Prepare a statement before attempting to execute it.
- ORA-24338: statement handle not executed
- Cause: A fetch or describe was attempted before executing a statement handle.
- Action: Execute a statement and then fetch or describe the data.
- ORA-24339: cannot set server group name after connecting to server
- Cause: An attempt was made to set the server group in a server handle after connecting to the server. However, once the connection is established to a server, the server group name cannot be set anymore.
- Action: Attach to the server after setting the server group name in the server handle.
- ORA-24340: cannot support more than 255 columns
- Cause: The number of columns exceeds maximum supported by the server.
- Action: Limit your operation to 255 columns.
- ORA-24341: bad mode specified
- Cause: OCI_ENV_NO_MUTEX mode was specified for a non-threaded client.
- Action: OCI_ENV_NO_MUTEX may be specified when OCI_THREADED had been specified at process initialization.
- ORA-24342: unable to destroy a mutex
- Cause: An attempt to destroy a mutex failed.
- Action: none
- ORA-24343: user defined callback error
- Cause: The only valid return value for a user defined callback function is OCI_CONTINUE or OCI_ROWCBK_DONE. Any other value will cause this error.
- Action: Please insure that OCI_CONTINUE or OCI_ROWCBK_DONE is returned from the user defined callback function.
- ORA-24344: success with compilation error
- Cause: A sql/plsql compilation error occurred.
- Action: Return OCI_SUCCESS_WITH_INFO along with the error code
- ORA-24345: A Truncation or null fetch error occurred
- Cause: A truncation or a null fetch error"
- Action: Please ensure that the buffer size is long enough to store the returned data.
- ORA-24346: cannot execute without binding variables
- Cause: None of the bind variables in the SQL statement are bound.
- Action: Please bind all the variables before the execute is done.
- ORA-24347: Warning of a NULL column in an aggregate function
- Cause: A null column was processed by an aggregate function
- Action: An OCI_SUCCESS_WITH_INFO is returned.
- ORA-24348: Update or Delete without Where
- Cause: An update or delete was executed without where clause
- Action: An OCI_SUCCESS_WITH_INFO is returned.
- ORA-24350: OCI call not allowed
- Cause: OCI used is not permitted from external procedures.
- Action: Refer to user manual for usage restrictions.
- ORA-24351: invalid date passed into OCI call
- Cause: A bad date was passed into one of the OCI calls.
- Action: Check your date bind values and correct them.
- ORA-24352: invalid COBOL display type passed into OCI call
- Cause: A bad COBOL display type was passed into one of the OCI calls.
- Action: Check your COBOL display type bind values and correct them.
- ORA-24353: user buffer too small to accommodate COBOL display type
- Cause: User supplied buffer for a COBOL display type was too small to accommodate fetched number.
- Action: Increase the allocation for COBOL display type buffer.
- ORA-24354: number fetched too large to fit in COBOL display type buffer.
- Cause: The number fetched was beyond the range that can be displayed.
- Action: Please check the number in the database.
- ORA-24355: attempt to store a negative number in an Unsigned Display type.
- Cause: An attempt was made to convert a negative number into an unsigned display type.
- Action: Please check the number in the database or change the defined datatype.
- ORA-24356: internal error while converting from to COBOL display type.
- Cause: An internal error was encountered during conversion to COBOL display type.
- Action: Contact customer support.
- ORA-24357: internal error while converting from to OCIDate.
- Cause: An internal error was encountered during conversion to OCIDate type.
- Action: Contact customer support.
- ORA-24358: OCIBindObject not invoked for a Object type or Reference
- Cause: OCIBindObject was not invoked resulting in an incomplete bind specification for a Object Type or Reference.
- Action: Please invoke the OCIBindObject call for all Object Types and References.
- ORA-24359: OCIDefineObject not invoked for a Object type or Reference
- Cause: OCIDefineObject was not invoked resulting in an incomplete bind specification for a Object Type or Reference.
- Action: Please invoke the OCIDefineObject call for all Object Types and References.
- ORA-24360: Type Descriptor Object not specified for Object Bind/Define
- Cause: Type Descriptor Object is a mandatory parameter for Object Types Binds and Defines.
- Action: Please invoke the OCIBindObject() or OCIDefineObject() call with a valid Type Descriptor Object.
- ORA-24361: basic bind call not invoked before invoking advanced bind call
- Cause: One of the basic bind calls was not invoked on this bind handle before performing an advanced bind call.
- Action: Please invoke the advanced bind call on this bind handle only after performing a basic bind call.
- ORA-24362: improper use of the character count flag
- Cause: When the character count flag is set, then the maximum size of the buffer in the server should be specified as a non-zero value.
- Action: Please use a non-zero value for the mamimum size of the buffer in the server.
- ORA-24363: measurements in characters illegal here
- Cause: Measurements in characters instead of bytes are illegal if either the server's or client's character set is varying width.
- Action: If either the client's or server's character set is varying width then do not use the OCI_ATTR_CHAR_COUNT attribute for the bind handle. Use OCI_ATTR_MAXDATA_SIZE instead.
- ORA-24364: internal error while padding blanks
- Cause: An internal error has occurred while attempting to blank pad string data. This error should not occur normally.
- Action: Contact customer support.
- ORA-24365: error in character conversion
- Cause: This usually occurs during conversion of a multibyte character data when the source data is abnormally terminated in the middle of a multibyte character.
- Action: Make sure that all multibyte character data is properly terminated.
- ORA-24366: migratable user handle is set in service handle
- Cause: This occurs during user authentication, a migratable user handle has been set in the service handle.
- Action: Service handle must not be set with migratable user handle when it is used to authenticate another user.
- ORA-24367: user handle has not been set in service handle
- Cause: This occurs during authentication of a migratable user. the service handle has not been set with non-migratable user handle.
- Action: Service handle must be set with non-migratable user handle when it is used to authenticate a migratable user.
- ORA-24368: OCI mutex counter non-zero when freeing a handle
- Cause: This is an internal OCI error.
- Action: Contact customer support.
- ORA-24369: required callbacks not registered for one or more bind handles
- Cause: No callbacks have been registered for one or more of the bind handles which are part of the RETURNING clause.
- Action: The bind handles which are to receive data in a DML statememt with a RETURNING clause must have their mode set as DATA_AT_EXEC and callback functions must be registered for these bind handles using OCIBindDynamic.
- ORA-24370: illegal piecewise operation attempted
- Cause: Data of a certain datatype that does not support piecewise operation is being sent or fetched in pieces.
- Action: Always set the piece value to OCI_ONE_PIECE for datatypes that does not support piecewise operation.
- ORA-24371: data would not fit in current prefetch buffer
- Cause: An internal OCI error has occurred.
- Action: Please contact Oracle customer support.
- ORA-24372: invalid object for describe
- Cause: The object to be described is not valid. It either has compilation or authorization errors.
- Action: The object to be described must be valid.
- ORA-24373: invalid length specified for statement
- Cause: The length specified for the statement is either 0 or too large.
- Action: Specify a valid length for the statement.
- ORA-24374: define not done before fetch or execute and fetch
- Cause: The application did not define output variables for data being fetched before issuing a fetch call or invoking a fetch by specifying a non-zero row count in an execute call.
- Action: Issue OCI define calls for the columns to be fetched.
- ORA-24375: Cannot use V6 syntax when talking to a V8 server
- Cause: V6 syntax is no longer supported in V8 server.
- Action: Change syntax to V7 syntax or higher.
- ORA-24376: cannot register/get user callback for non-environment handle
- Cause: A user callback registration or get was attempted on a handle which is not an environment handle.
- Action: Pass the environment handle to register/get user callback.
- ORA-24377: invalid OCI function code
- Cause: An invalid function code was used to register or get user callback"
- Action: Use a valid OCI function code.
- ORA-24378: user callbacks not allowed for this call
- Cause: An attempt was made to register a user callback for an OCI call for which it not allowed to register user callbacks.
- Action: Do not register user callback for this OCI call.
- ORA-24379: invalid user callback type
- Cause: An invalid type of user callback was specified.
- Action: Specify a valid user callback type.
- ORA-24380: invalid mode specification
- Cause: The mode parameter in an OCIU* call is invalid
- Action: Use only valid mode parameter
- ORA-24381: error(s) in array DML
- Cause: One or more rows failed in the DML.
- Action: Refer to the error stack in the error handle.
- ORA-24382: statement handled already executed or described
- Cause: The Statement handle was executed or described successfuly before.
- Action: Perform a OCIStmtPrepare again before OCI_PARSE_ONLY.
- ORA-24383: Overflow segment of an IOT cannot be described
- Cause: The name specified in the OCIDescribeAny call referred to an IOT overflow segment.
- Action: Use OCIDescribeAny to describe only documented objects.
- ORA-24384: Application context size is not initialized
- Cause: The size of the application context must be initialized before populating each context element.
- Action: Issue OCIAttrSet with OCI_ATTR_CTX_SIZE to initialize context size
- ORA-24385: Application context size or index is not valid
- Cause: The size or index of the application context must be non-zero and non-negative.
- Action: Use an appropriate value for the size.
- ORA-24386: statement/server handle is in use when being freed
- Cause: This is an internal OCI error.
- Action: The user should reset in-use flag in statement handle before freeing the handle.
- ORA-24387: Invalid attach driver
- Cause: Trying to attach using the wrong driver
- Action: Relink the application in the right mode
- ORA-24388: Unsupported functionality in fast path mode
- Cause: Feature not supported in fast path mode
- Action: Avoid using the functionality in this mode
- 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.
- 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-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-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-24393: invalid mode for creating connection pool
- Cause: Mode specified in OCIConnectionPoolCreate is invalid.
- Action: Use a valid mode.
- ORA-24394: invalid mode for destroying connection pool
- Cause: Mode specified in OCIConnectionPoolDestroy is invalid.
- Action: Use a valid mode.
- 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-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-24397: error occured while trying to free connections
- Cause: An internal error occured while trying to free connections.
- Action: Contact customer support.
- 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-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-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-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-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-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-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-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-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-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-24408: could not generate unique server group name
- Cause: An internal error occured while generating unique server group name.
- Action: Contact customer support.
- 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-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-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-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-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-24414: Onlynumber 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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-24436: Invalid statement Handle.
- Cause: OCIHandleFree called on a statement that was prepared using OCIstmtPrepare2.
- Action: Release the statement using OCIStmtRelease.
- 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-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-24439: success with PLSQL compilation warning
- Cause: A plsql compilation warning occurred.
- Action: Return OCI_SUCCESS_WITH_INFO along with the error code.
- ORA-24440: OCI Easy Install mode cannot be initialized
- Cause: An internal OCI error has occurred.
- Action: Please contact Oracle customer support.
- 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-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-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-24502: codepoint length overflows
- Cause: Returned buffer has more codepoints than allowed
- Action: Set OCI_MAXCHAR_SIZE large enough to accommodate
- ORA-24503: codepoint length overflows for piecewise operation
- Cause: Accumulated codepoint length exceeds allowed codepoint length
- Action: Set OCI_MAXCHAR_SIZE large enough to accommodate
- ORA-24504: data length larger than expected
- Cause: Incoming data larger than receiving buffer
- Action: Set OCI_MAXDATA/MAXCHAR_SIZE appropriately or remove the setting
- ORA-24505: cannot change character set id on the handle
- Cause: Attempts to change character set id on non-environment handles
- Action: Only try to change character set id on environment handles
- ORA-24506: invalid attempt to change character set id on env handle
- Cause: Attempts to change character set id after other handles have been allocated from the env handle
- Action: Change character set id after creating environment handle but before allocating any handles from it.
- ORA-24507: invalid combination of character set ids
- Cause: Attempts to set one character set id as zero
- Action: Set both charset and ncharset as zero or non-zero in OCIEnvNlsCreate()
- ORA-24508: Buffer is not aligned correctly.
- Cause: Alignment error ocurred in buffer when converting between character sets.
- Action: Align buffer appropriately. For UTF16 buffer, pass a ub2 pointer.
- ORA-24750: incorrect size of attribute
- Cause: Transaction ID attribute size is incorrect.
- Action: Verify that the size parameter is correct.
- ORA-24752: OCI_TRANS_NEW flag must be specified for local transactions
- Cause: Application attempted to start a local transaction without using OCI_TRANS_NEW.
- Action: Use OCI_TRANS_NEW when starting local transactions.
- ORA-24753: local transactions cannot be detached
- Cause: An attempt to detach a local transaction was made.
- Action: Local transactions may only be committed or rolled back.
- ORA-24754: cannot start new transaction with an active transaction
- Cause: An attempt to start a new transaction was made when there was an active transaction.
- Action: Commit, rollback or detach the existing transaction before starting a new transaction.
- ORA-24755: OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
- Cause: These flags are currently not supported.
- Action: none
- ORA-24756: transaction does not exist
- Cause: An invalid transaction identifier or context was used or the transaction has completed.
- Action: Supply a valid identifier if the transaction has not completed and retry the call.
- ORA-24757: duplicate transaction identifier
- Cause: An attempt was made to start a new transaction with an identifier already in use by an existing transaction.
- Action: Verify that the identifier is not in use.
- ORA-24758: not attached to the requested transaction
- Cause: An attempt was made to detach or complete a transaction that is not the current transaction.
- Action: Verify that the transaction context refers to the current transaction.
- ORA-24759: invalid transaction start flags
- Cause: An invalid transaction start flag was passed.
- Action: Verify that one of the following values - OCI_TRANS_NEW, OCI_TRANS_JOIN, OCI_TRANS_RESUME was specified.
- ORA-24760: invalid isolation level flags
- Cause: An invalid isolation level flag was passed.
- Action: Verify that only one of following values - OCI_TRANS_READONLY, OCI_TRANS_READWRITE, OCI_TRANS_SERIALIZABLE is used.
- ORA-24762: server failed due to unspecified error
- Cause: An internal error has occured in the server commit protocol.
- Action: Contact customer support.
- ORA-24763: transaction operation cannot be completed now
- Cause: The commit or rollback cannot be performed now because the session cannot switch to the specified transaction.
- Action: Retry the operation later.
- ORA-24769: cannot forget an active transaction
- Cause: Transaction identifier refers to an active transaction.
- Action: Verify that the identifier of an active transaction was not passed as an argument.
- ORA-24770: cannot forget a prepared transaction
- Cause: Transaction identifier refers to a prepared transaction.
- Action: Verify that the identifier of a prepared transaction was not passed as an argument.
- ORA-24771: cannot detach, prepare or forget a local transaction
- Cause: Service handle contains a local transaction context.
- Action: Verify that the transaction context does not refer to a local transaction.
- ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches
- Cause: Application attempted to start a transaction with a global transaction identifier and a wrong option.
- Action: Verify that all branches of a global transaction are started with either OCI_TRANS_TIGHT or OCI_TRANS_LOOSE option. If the application is correct and uses distributed updates, contact customer support.
- ORA-24773: invalid transaction type flags
- Cause: OCI_TRANS_TIGHT or OCI_TRANS_LOOSE mode was not specified.
- Action: Verify that the right parameters are being used.
- ORA-24774: cannot switch to specified transaction
- Cause: The transaction specified in the call refers to a transaction created by a different user.
- Action: Create transactions with the same authentication so that they can be switched.
- ORA-24775: cannot prepare or commit transaction with non-zero lock value
- Cause: An attempt was made to detach the transaction with a non-zero lock value.
- Action: Detach the transaction with lock value set to zero and then try to prepare or commit the transaction.
- ORA-24776: cannot start a new transaction
- Cause: An attempt was made to start a new transaction when session was already attached to an existing transaction.
- Action: End the current transaction before creating a new transaction.
- ORA-24777: use of non-migratable database link not allowed
- Cause: The transaction, which needs to be migratable between sessions, tried to access a remote database from a non-multi threaded server process.
- Action: Perform the work in the local database or open a connection to the remote database from the client. If multi threaded server option is installed, connect to the Oracle instance through the dispatcher.
- ORA-24778: cannot open connections
- Cause: The migratable transaction tried to access a remote database when the session itself had opened connections to remote database(s).
- Action: Close the connection(s) in the session and then try to access the remote database from the migratable transaction. If the error still occurs, contact Oracle customer support.
- ORA-24779: detach not allowed with open remote cursor
- Cause: The migratable transaction tried to detach from the current session while having an open remote cursor.
- Action: Close any open remote cursor prior to detach.
- ORA-24780: cannot recover a transaction while in an existing transaction
- Cause: An attempt was made to commit or roll back a transaction while in a different transaction, and the transaction for which the action is requested is in a recovery state (this happens if it is idle too long).
- Action: Detach from the current transaction and retry the operation.
- ORA-24781: branches don't belong to the same global transaction
- Cause: The list of xids passed into kpotxmp() don't have the same gtrid
- Action: none
- ORA-24782: Cannot detach from a non-migratable transaction
- Cause: An attempt was made to detach from a non-migrateable transaction.
- Action: Either commit or rollback the transaction.
- ORA-24783: Cannot switch non-migratable transactions
- Cause: An attempt was made to prepare/commit a txn different from current.
- Action: none
- ORA-24784: Transaction exists
- Cause: An attempt was made to start a transaction, while attached to a non-migrateable transaction
- Action: none
- ORA-24785: Cannot resume a non-migratable transaction
- Cause: An attempt was made to resume a non-migrateable transaction.
- Action: none
- ORA-24786: separated transaction has been completed
- Cause: The current transaction has been completed by another process.
- Action: Start a new transaction
- ORA-24787: remote cursors must be closed before a call completes
- Cause: The previous operation did not close all the remote cursors it opened. Since separated transactions are enabled, this is not allowed.
- Action: Close all remote cursors in each call, or start a regular (non-separated) transaction.
- ORA-24788: cannot switch to specified transaction (server type)
- Cause: The transaction specified was created by a shared server and the requestor is a dedicated server, or the transaction was created by a dedicated server and the requestor is a shared server.
- Action: All parts of this application should connect as dedicated or as shared.
- ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags
- Cause: An attempt was made to change the isolation level of an existing transaction.
- Action: No action required
- ORA-24791: invalid transaction start flags
- Cause: An invalid transaction start flag was passed.
- Action: Verify that OCI_TRANS_LOOSE was not passed along with OCI_TRANS_JOIN, OCI_TRANS_RESUME.
- ORA-24801: illegal parameter value in OCI lob function
- Cause: One of the parameter values in the OCI lob function is illegal.
- Action: Check every parameter in the OCI Lob function call to make sure they are correct. Offsets should be greater than or equal to one.
- ORA-24802: user defined lob read callback error
- Cause: The only valid return value for a user defined lob read callback function is OCI_CONTINUE. Any other value will cause this error.
- Action: Verify that OCI_CONTINUE is returned from the user defined lob read callback function.
- ORA-24803: illegal parameter value in lob read function
- Cause: Internal error .
- Action: This error should not normally occur. If it persists, please contact your customer service representative.
- ORA-24804: Lob read/write functions called while another OCI LOB read/write streaming is in progress
- Cause: Internal error.
- Action: Wait for the ongoing LOB streaming call to finish before issuing the next server call, or use OCIBreak() abort the current LOB streaming call.
- ORA-24805: LOB type mismatch
- Cause: When copying or appending LOB locators, both source and desctination LOB locators should be of the same type.
- Action: Pass the same type of LOB locators for copying or appending.
- ORA-24806: LOB form mismatch
- Cause: When reading from or writing into LOBs, the character set form of the user buffer should be same as that of the LOB.
- Action: Make sure that the buffer you are using to read or write has the same form as that of the LOB.
- ORA-24807: LOB form mismatch
- Cause: When copying or appending LOBs, both source and desctination LOB locators should have the same character set form.
- Action: Pass locators of the same character set form for copying or appending LOBs.
- ORA-24808: streaming of lob data is not allowed when using lob buffering
- Cause: Attempted to stream lob data via the polling mode or a callback when lob buffering was enabled for the input lob locator.
- Action: Lob buffering is useful when reading/writing small amounts of lob data so streaming should not be necessary. Rewrite the OCILobRead/OCILobWrite call so that it does not use streaming. If streaming of data is required, lob buffering should not be used. In this case, flush buffers associated with the input lob locator as necessary, disable buffering on the input lob locator and reissue the OCILobRead/OCILobWrite call.
- ORA-24809: amount specified will not fit in the lob buffers
- Cause: LOB buffering is enabled for the input lob locator so buffering will be used. However, the amount of lob data to read or write is larger than what the lob buffers can hold.
- Action: Either disable buffering on the input lob locator and reissue the command or pass a smaller amount.
- ORA-24810: attempting to write more data than indicated
- Cause: While writing into a LOB, more data was supplied than indicated.
- Action: If data is written in pieces, then make sure that you do not provide more data in the pieces (cumulatively), than you indicated.
- ORA-24811: less data provided for writing than indicated
- Cause: While writing into a LOB, less data was provided than indicated.
- Action: If writing data in single pieces, then make sure that the buffer length specified is big enough to accommodate tha data being provided. If data is written in pieces, then make sure that all the data has been provided before specifying OCI_LAST_PIECE.
- ORA-24812: character set conversion to or from UCS2 failed
- Cause: If the database character set is varying-width, the CLOB/NCLOB value is implicitly converted to or from UCS2. This implicit conversion failed.
- Action: Contact Oracle Worldwide Support.
- ORA-24813: cannot send or receive an unsupported LOB
- Cause: An attempt was made to send a LOB across the network, but either the server does not support the LOB sent by the client, or the client does not support the LOB sent by the server. This error usually occurs when the client and server are running different versions of Oracle.
- Action: Use a version of the Oracle that supports the LOB on both the client and the server.
- ORA-24814: operation not allowed for temporary LOBs
- Cause: Temporary LOB locators are not allowed in the operation. For example: OCILobAssign only takes persistent LOB locators as parameters, not temporary LOBs.
- Action: Use OCILobLocatorAssign for temporary LOBs instead. Note that OCILobLocatorAssign can also be used for persistent LOBs, in which case it will behave the same as OCILobAssign.
- ORA-24815: Invalid character set form
- Cause: An invalid character set form was passed into an OCI LOB function. For example, the only valid cs form for OCILobCreateTemporary() is OCI_DEFAULT(0), SQLCS_IMPLICIT(1) or SQLCS_NCHAR(2).
- Action: Specify a valid character set form.
- ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
- Cause: A Bind value of length potentially > 4000 bytes follows binding for LOB or LONG.
- Action: Re-order the binds so that the LONG bind or LOB binds are all at the end of the bind list.
- ORA-24850: failed to startup shared subsystem
- Cause: While attempting to initialize OCI in shared mode, a problem was encountered in starting up the shared subsystem.
- Action: Contact Oracle Customer support.
- ORA-24851: failed to connect to shared subsystem
- Cause: While attempting to initialize OCI in shared mode, a problem was encountered in connecting the process to the shared subsystem.
- Action: Contact Oracle Customer Support.
- ORA-24852: protocol error during statement execution
- Cause: An internal protocol error occurred while receiving describe data from the server during execution of a statement.
- Action: Contact Oracle Customer Support.
- ORA-24853: failed to connect thread to shared subsystem
- Cause: While attempting to initialize OCI in shared mode, a problem was encountered in connecting the thread to the shared subsystem.
- Action: Contact Oracle Customer Support.
- ORA-24900: invalid or unsupported mode paramater passed in call
- Cause: The mode parameter passed into the OCI Client Notification call is incorrect.
- Action: Please correct the mode parameter passed into OCI.
- ORA-24901: handles belonging to different environments passed into an OCI call
- Cause: All handles passed into an OCI call should belong to the same environment. In the call that returned this error, handles belonging to different environments were passed in.
- Action: Please ensure that the handle parameters in the call to come from the same OCI Environment.
- ORA-24902: invalid subscription name or name-length in subscription handle
- Cause: The subscription handle passed into the OCI call does not have a proper name or name-length attribute.
- Action: Please set the name and name-length attributes using the OCIAttrSet() call.
- ORA-24903: invalid namespace attribute passed into OCI call
- Cause: The subscription handle passed into the OCI call does not have a proper namespace attribute.
- Action: Please set the namespace attribute using the OCIAttrSet() call.
- ORA-24904: invalid callback attribute passed into OCI call
- Cause: The subscription handle passed into the OCI call does not have a proper callback attribute.
- Action: Please set the callback attribute using the OCIAttrSet() call.
- ORA-24905: invalid recepient protocol attribute passed into OCI call
- Cause: The subscription handle passed into the OCI call does not have a proper recepient protocol attribute.
- Action: Please set the recepient protocol attribute using the OCIAttrSet() call.
- ORA-24906: invalid recepient attribute passed into OCI call
- Cause: The subscription handle passed into the OCI call does not have a proper recepient attribute.
- Action: Please set the recepient attribute using the OCIAttrSet() call.
- ORA-24907: invalid pair of callback and recepient protocol attributes
- Cause: The subscription handle passed into the OCI call can't have both the callback defined and a recepient protocol other than OCI_SUBSCR_PROTO_OCI at the same time.
- Action: Please set the appropriate callback and recepient protocol attributes using the OCIAttrSet() call.
- ORA-24908: invalid recipient presentation attribute
- Cause: The subscription handle passed into the OCI call does not have a valid recipient presentation attribute.
- Action: Set the recipient presentation attribute using the OCIAttrSet() call
- ORA-24909: call in progress. Current operation cancelled
- Cause: The OCI call was invoked when another call on the connection was in progress.
- Action: Check if the OCI call is supported when the call is in progress under special conditions; for example, if it is being used by a signal handler.
- ORA-24950: unregister failed, registeration not found
- Cause: The registeration that was asked to be unregistered could not be found.
- Action: Please check the callback function name and the subscription name in the unregister call.
- ORA-24960: the attributestring is greater than the maximum allowable length of number
- Cause: The user attempted to pass an attribute that is too long
- Action: Shorten the specified attribute and retry the operation.
- ORA-25000: invalid use of bind variable in trigger WHEN clause
- Cause: A bind variable was used in the when clause of a trigger.
- Action: Remove the bind variable. To access the table columns use (new/old).column_name.
- ORA-25001: cannot create this trigger type on views
- Cause: Only INSTEAD OF triggers can be created on a view.
- Action: Change the trigger type to INSTEAD OF.
- ORA-25002: cannot create INSTEAD OF triggers on tables
- Cause: Only BEFORE or AFTER triggers can be created on a table.
- Action: Change the trigger type to BEFORE or AFTER.
- ORA-25003: cannot change NEW values for this column type in trigger
- Cause: Attempt to change NEW trigger variables of datatype object, REF, nested table, VARRAY or LOB datatype which is not supported.
- Action: Do not change the NEW trigger variables in the trigger body.
- ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers
- Cause: WHEN clause is specified in an INSTEAD OF trigger.
- Action: Remove the WHEN clause when creating an INSTEAD OF trigger.
- ORA-25005: cannot CREATE INSTEAD OF trigger on a read-only view
- Cause: attempt to create an INSTEAD OF trigger on a view created with read-only option. The view cannot be updated using INSTEAD OF triggers.
- Action: Do not create the trigger.
- ORA-25006: cannot specify this column in UPDATE OF clause
- Cause: Attempt to create a trigger on update of a column whose datatype is disallowed in the clause, such as LOB and nested table.
- Action: Remove the UPDATE OF clause.
- ORA-25007: functions or methods not allowed in WHEN clause
- Cause: PLSQL function call or method invocation is not allowed in the WHEN clause when creating a trigger.
- Action: Remove the function call or method invocation from the WHEN clause.
- ORA-25008: no implicit conversion to LOB datatype in instead-of trigger
- Cause: When inserting or updating a view using instead-of trigger, the new value for a LOB view column is of a different datatype.
- Action: Specified a LOB value as the new value for the LOB view column.
- ORA-25009: Nested table clause allowed only for INSTEAD OF triggers
- Cause: Triggers on nested tables can only be created on view columns using INSTEAD OF triggers.
- Action: Use view nested table columns for defining nested table triggers.
- ORA-25010: Invalid nested table column name in nested table clause
- Cause: The column name specified in the nested table clause of an INSTEAD OF trigger does not correspond to a nested table column.
- Action: Specify a nested table column on which the trigger is to be defined.
- ORA-25012: PARENT and NEW values cannot be identical
- Cause: The referencing clause specifies identical values for PARENT and OLD.
- Action: Re-specify either the PARENT or NEW referencing value.
- ORA-25013: OLD and PARENT values cannot be identical
- Cause: The referencing clause specifies identical values for OLD and PARENT.
- Action: Re-specify either the OLD or PARENT referencing value.
- ORA-25014: cannot change the value of a PARENT reference variable
- Cause: Parent values can only be read and not changed.
- Action: Do not attempt to change a Parent variable.
- ORA-25015: cannot perform DML on this nested table view column
- Cause: DML cannot be performed on a nested table view column except through an INSTEAD OF trigger
- Action: Create an INSTEAD OF trigger over the nested table view column and then perform the DML.
- ORA-25016: cannot specify column list for insert into nested table view column
- Cause: A column list cannot be specified for inserts into the nested table view column.
- Action: Specify all the columns for insert into the nested table.
- ORA-25017: cannot reference NEW ROWID for movable rows in before triggers
- Cause: NEW ROWID was referenced in a before row trigger which is defined on an index-organized table, or a partitioned table with enabled movement of rows. The ROWID cannot be computed in a before row update trigger because it depends on the actual values of the row
- Action: Remove references to NEW ROWID from the trigger definition.
- ORA-25018: conflicting triggerstring already exists
- Cause: Conflicting instead of DDL trigger on schema/database already exists.
- Action: Remove the old trigger
- ORA-25019: too much concurreny
- Cause: cannot pin the database/schema because of too much concurrency
- Action: try the operation later
- ORA-25020: renaming system triggers is not allowed
- Cause: renaming system triggers is not allowed
- Action: Drop the trigger, and create a new one for the same
- ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD
- Cause: The TABLESPACE option to ALTER INDEX was used without the REBUILD option.
- Action: Use ALTER INDEX REBUILD TABLESPACE tablespace name.
- ORA-25101: duplicate REBUILD option specification
- Cause: The REBUILD option to ALTER INDEX is specified more than once.
- Action: Specify the option at most once.
- ORA-25102: PARALLEL option can only be used with ALTER INDEX REBUILD
- Cause: The PARALLEL option to ALTER INDEX was used without the REBUILD option.
- Action: Use ALTER INDEX REBUILD.
- ORA-25103: NOPARALLEL option can only be used with ALTER INDEX REBUILD
- Cause: The NOPARALLEL option to ALTER INDEX was used without the REBUILD option.
- Action: Use ALTER INDEX REBUILD.
- ORA-25104: UNRECOVERABLE option can only be used with ALTER INDEX REBUILD
- Cause: The UNRECOVERABLE option to ALTER INDEX was used without the REBUILD option.
- Action: Use ALTER INDEX REBUILD.
- ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD
- Cause: The RECOVERABLE option to ALTER INDEX was used without the REBUILD option.
- Action: Use ALTER INDEX REBUILD.
- ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified
- Cause: PARALLEL was specified more than once, NOPARALLEL was specified more than once, or both PARALLEL and NOPARALLEL were specified in an ALTER INDEX REBUILD statement.
- Action: Remove all but one of the PARALLEL or NOPARALLEL clauses.
- ORA-25107: duplicate TABLESPACE option specification
- Cause: the TABLESPACE was specified more than once in an ALTER INDEX REBUILD statement.
- Action: Remove all but one of the TABLESPACE clauses.
- ORA-25108: standby lock name space exceeds size limit ofstring characters
- Cause: The lock name space for the standby database exceeded the maximum string length.
- Action: Change initialization parameter _STANDBY_LOCK_NAME_SPACE to a character string of less than the specified characters.
- ORA-25109: standby lock name space has illegal character 'string'
- Cause: An invalid lock name space was specified for the standby database. The lock name space for the standby database can only contain A-Z, 0-9, '_', '#', '$', '.' and '@' characters.
- Action: Change initialization parameter _STANDBY_LOCK_NAME_SPACE to a valid character string.
- ORA-25110: NOSORT may not be used with a bitmap index
- Cause: An attempt was made to create a bitmap index using the NOSORT option.
- Action: Remove NOSORT from the CREATE BITMAP INDEX statement.
- ORA-25111: creation of BITMAP cluster indices is not supported
- Cause: An attempt was made to create a cluster index with the BITMAP attribute.
- Action: Remove BITMAP from the CREATE INDEX statement.
- ORA-25112: maximum number of BITMAP index columns is 30
- Cause: Too many columns were specified for the index.
- Action: Create an index on fewer columns.
- ORA-25113: GLOBAL may not be used with a bitmap index
- Cause: An attempt was made to create a bitmap index using the GLOBAL option.
- Action: Remove GLOBAL from the CREATE BITMAP INDEX statement, and/or add a LOCAL partition descriptor if the table is partitioned.
- ORA-25114: invalid file number specified in the DUMP DATAFILE/TEMPFILE command
- Cause: An invalid file number was used in dumping a datafile or tempfile.
- Action: Specify a valid file number.
- ORA-25115: duplicate BLOCK option specification
- Cause: BLOCK (MIN/MAX) was specified more than once in the DUMP DATAFILE/TEMPFILE command.
- Action: Specify only one BLOCK option.
- ORA-25116: invalid block number specified in the DUMP DATAFILE/TEMPFILE command
- Cause: An invalid block number was used in dumping a datafile or tempfile.
- Action: Specify a valid block number.
- ORA-25117: MIN/MAX/Block Number expected
- Cause: A value other than MIN/MAX, or a block number was entered in the DUMP DATAFILE/TEMPFILE command.
- Action: Correct the syntax.
- ORA-25118: invalid DUMP DATAFILE/TEMPFILE option
- Cause: An invalid option was specified for the DUMP DATAFILE/TEMPFILE command.
- Action: Correct the syntax.
- ORA-25119: LOGGING/NOLOGGING option already specified
- Cause: In CREATE TABLESPACE, the LOGGING and/or NOLOGGING options were specified more than once.
- Action: Remove all but one of the logging specifications.
- ORA-25120: MINIMUM EXTENT option already specified
- Cause: In CREATE TABLESPACE, the MINIMUM EXTENT option was specified more than once.
- Action: Remove all but one of the MINIMUM EXTENT specifications.
- ORA-25121: MINIMUM EXTENT value greater than maximum extent size
- Cause: In CREATE/ALTER TABLESPACE, the value specified for the MINIMUM EXTENT option was greater than the maximum extent size.
- Action: Choose a lower value for the MINIMUM EXTENT option.
- ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables
- Cause: An attempt was made to create a global bitmap index on a partioned table.
- Action: create a local bitmap index instead.
- ORA-25123: Too many components specified in the name.
- Cause: Specifying more components to a name than allowed.
- Action: Check the name specified for the operation.
- ORA-25124: Database link name not allowed.
- Cause: Specifying a database link name when it is not permitted.
- Action: Check the name specified for the operation.
- ORA-25125: BUFFER_POOL storage option not allowed
- Cause: The user attempted to specify the BUFFER_POOL storage option. This option may only be specified during CREATE/ALTER TABLE/CLUSTER/INDEX.
- Action: Remove this option and retry the statement.
- ORA-25126: Invalid name specified for BUFFER_POOL
- Cause: The name of the buffer pool specified by the user is invalid. The only valid names are KEEP, RECYCLE and DEFAULT.
- Action: Use a valid name or remove the BUFFER_POOL clause.
- ORA-25127: RELY not allowed in NOT NULL constraint
- Cause: An attempt to set RELY on for NOT NULL constraint.
- Action: only NORELY may be specified for a NOT NULL constraint.
- ORA-25128: No insert/update/delete on table with constraint (string.string) disabled and validated
- Cause: Try to insert/update/delete on table with DISABLE VALIDATE constraint.
- Action: Change the constraint's states.
- ORA-25129: cannot modify constraint (string) - no such constraint
- Cause: the named constraint does not exist for this table.
- Action: Obvious
- ORA-25130: cannot modify primary key - primary key not defined for table
- Cause: Attempted to modify a primary key that is not defined for the table.
- Action: None
- ORA-25131: cannot modify unique(string) - unique key not defined for table
- Cause: attempted to modify a unique key that is not deined for the table.
- Action: None
- ORA-25132: UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION
- Cause: cannot ALTER TABLE EXCHANGE PARTITION when the partition and the table have a disabled and validated unique constraints AND the unique keys in the partion is not mutually exclusive from the rest of the table.
- Action: Change the constraint's status.
- ORA-25133: duplicate SINGLE TABLE option specified
- Cause: The SINGLE TABLE option was specified more than once.
- Action: Specify the SINGLE TABLE option only once.
- ORA-25134: keyword TABLE expected
- Cause: The keyword TABLE is missing from the SINGLE TABLE option.
- Action: Place the keyword TABLE after the keyword SINGLE in the command.
- ORA-25135: cannot use the SINGLE TABLE option
- Cause: The SINGLE TABLE option is only valid for hash clusters.
- Action: Do not specify the SINGLE TABLE option.
- ORA-25136: this cluster can contain only one table
- Cause: An attempt was made to store more than one table in a cluster that was created with the SINGLE TABLE option.
- Action: Do not attempt to store more than one table in the cluster.
- ORA-25137: Data value out of range
- Cause: Value from cast operand is larger than cast target size.
- Action: Increase size of cast target.
- ORA-25138: %s initialization parameter has been made obsolete
- Cause: An obsolete initialization parameter has been specified
- Action: The system will come up, but parameters must be examined
- ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
- Cause: An invalid option appears.
- Action: Specify one of the valid options: TEMPFILE, EXTENT MANAGEMENT LOCAL, UNIFORM
- ORA-25140: %s space policy cannot be specified for thestring extent management
- Cause: An invalid option appears.
- Action: Make sure that for LOCAL extent management UNIFORM or AUTOALLOCATE is specified, and for DICTIONARY extent management UNIFORM or AUTOALLOCATE are not specified
- ORA-25141: invalid EXTENT MANAGEMENT clause
- Cause: An invalid option appears for EXTENT MANAGEMENT clause
- Action: Specify one of the valid options: UNIFORM SIZE, AUTOALLOCATE
- ORA-25142: default storage clause specified twice
- Cause: default storage clause was specified twice for create tablespace
- Action: Specify it once.
- ORA-25143: default storage clause is not compatible with allocation policy
- Cause: default storage clause was specified for a tablespace with AUTOALLOCATE or UNIFORM policy
- Action: Omit the storage clause
- ORA-25144: invalid option for CREATE TABLESPACE with TEMPORARY contents
- Cause: An invalid option appears.
- Action: Specify one of the valid options: EXTENT MANAGEMENT DICTIONARY, USER
- ORA-25145: allocation policy already specified
- Cause: In CREATE TABLESPACE, the allocation policy was specified more than once, for example, AUTOALLOCATE and UNIFORM.
- Action: Remove all but one of the allocation policy specifications.
- ORA-25146: EXTENT MANAGEMENT option already specified
- Cause: In CREATE TABLESPACE, the EXTENT MANAGEMENT option was specified more than once.
- Action: Remove all but one of the EXTENT MANAGEMENT specifications.
- ORA-25147: UNIFORM SIZE value greater than maximum extent size
- Cause: In CREATE/ALTER TABLESPACE, the value specified for the UNIFORM SIZE option was greater than the maximum extent size.
- Action: Choose a lower value for the UNIFORM SIZE option.
- ORA-25148: ONLINE option not permitted
- Cause: An attempt was made to specify ONLINE for ALTER TABLE MOVE on a table that is not index-organized. The ONLINE option is currently supported only for index-organized tables.
- Action: Remove the ONLINE option from the command.
- ORA-25149: Columns of UROWID type may not be indexed
- Cause: An attempt was made to create an index on a column of UROWID type
- Action: Remove the column from the list of indexed columns
- ORA-25150: ALTERING of extent parameters not permitted
- Cause: An attempt was made to alter the extent parameters for a segment in a tablespace with autoallocate or uniform extent allocation policy.
- Action: Remove the appropriate extent parameters from the command.
- ORA-25151: Rollback Segment cannot be created in this tablespace
- Cause: An attempt was made to create a rollback segment in a tablespace with autoallocate extent allocation policy.
- Action: Specify a different tablespace for the rollback segment
- ORA-25152: TEMPFILE cannot be dropped at this time
- Cause: An attempt was made to drop a TEMPFILE being used by online users
- Action: The TEMPFILE has been taken offline. Try again, later.
- ORA-25153: Temporary Tablespace is Empty
- Cause: An attempt was made to use space in a temporary tablespace with no files.
- Action: Add files to the tablespace using ADD TEMPFILE command.
- ORA-25154: column part of USING clause cannot have qualifier
- Cause: Columns that are used for a named-join (either a NATURAL join or a join with a USING clause) cannot have an explicit qualifier.
- Action: Remove the qualifier.
- ORA-25155: column used in NATURAL join cannot have qualifier
- Cause: Columns that are used for a named-join (either a NATURAL join or a join with a USING clause) cannot have an explicit qualifier.
- Action: Remove the qualifier.
- ORA-25156: old style outer join (+) cannot be used with ANSI joins
- Cause: When a query block uses ANSI style joins, the old notation for specifying outer joins (+) cannot be used.
- Action: Use ANSI style for specifying outer joins also.
- ORA-25157: Specified block sizestring is not valid
- Cause: An attempt was made to create a tablespace with a block size which is not supported.
- Action: Specify one of the valid blocksizes i.e the standard blocksize or one of (2k, 4k, 8k, 16k, 32k) subject to the maximum and minimum blocksizes supported by the platform.
- ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
- Cause: RELY is specified for the foreign key contraint, when the associated primary key constraint is NORELY.
- Action: Change the option of the primary key also to RELY.
- ORA-25175: no PRIMARY KEY constraint found
- Cause: A PRIMARY KEY constraint must be defined for a table with this organization
- Action: Define a PRIMARY KEY
- ORA-25176: storage specification not permitted for primary key
- Cause: Storage parameters cannot be defined for a PRIMARY KEY constraint for a table with this organization
- Action: Remove storage specification for primary key
- ORA-25177: UNRECOVERABLE option not permitted
- Cause: The UNRECOVERABLE option may not be specified for a primary key for a table with this organization
- Action: Remove UNRECOVERABLE option for primary key
- ORA-25178: duplicate PCTTHRESHOLD storage option specification
- Cause: The storage option PCTTHRESHOLD is specified more than once.
- Action: Specify storage options at most once.
- ORA-25179: invalid PCTTHRESHOLD storage option value
- Cause: The specified value must be a positive integer.
- Action: Specify an appropriate value.
- ORA-25180: PCTTHRESHOLD only valid for certain table organizations
- Cause: PCTTHRESHOLD can only be specified for tables with certain organizations.
- Action: Remove the PCTTHRESHOLD option.
- ORA-25181: missing ON keyword for NESTED INDEX
- Cause: ON keyword required to specify nested index column nest
- Action: Add ON keyword
- ORA-25182: feature not currently available for index-organized tables
- Cause: An attempt was made to use one or more of the following feature(s) not currently supported for index-organized tables: CREATE TABLE with LOB/BFILE/VARRAY columns, partitioning/PARALLEL/CREATE TABLE AS SELECT options, ALTER TABLE with ADD/MODIFY column options, CREATE INDEX
- Action: Do not use the disallowed feature(s) in this release.
- ORA-25183: index-organized table top index segment is in a different tablespace
- Cause: An attempt was made to drop a tablespace which contains an index only table's overflow segment but not the top index segment"
- Action: find index-organized tables which span the tablespace being dropped and some other tablespace(s). Drop these tables.
- ORA-25184: column name expected
- Cause: A column name is not present where required by the CREATE TABLE for specifying last column to be included in the index segment of the index-organized table
- Action: Specify a column name where required by the syntax.
- ORA-25185: index column other than last can not be specified for INCLUDE clause
- Cause: An index column name other than the last is specified as including column
- Action: Specify either a column name which is not part of index-organized table primary key index , or the last key column of the primary key for the INCLUDING clause.
- ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW
- Cause: INCLUDING clause of a CREATE TABLE is an valid option only for index-organized tables with OVERFLOW clause (at creation time) or if an OVERFLOW segment already exists (at ALTER time).
- Action: Specify OVERFLOW clause for the index-organized table : For ALTER, perform ADD OVERFLOW first.
- ORA-25187: specified exceptions table form incorrect
- Cause: The specified table does not have the proper field definitions.
- Action: Specify the correct table to use.
- ORA-25189: illegal ALTER TABLE option for an index-organized table
- Cause: During ALTER of a index-organized table, the user attempted to enter one or more of the following options: TABLESPACE, ALLOCATE/DEALLOCATE EXTENT, PCTFREE/PCTUSED for IOT top index segment
- Action: Remove the illegal option(s).
- ORA-25190: an index-organized table maintenance operation may not be combined with other operations
- Cause: ALTER TABLE statement attempted to combine an index-organized table maintenance operation (e.g. changing physical attributes) with some other operation (e.g. ADD constraint) which is illegal
- Action: Ensure that a index-organized table maintenance operation is the sole operation specified in ALTER TABLE statement;
- ORA-25191: cannot reference overflow table of an index-organized table
- Cause: An attempt to directly access the overflow table of an index-organized table
- Action: Issue the statement against the parent index-organized table containing the specified overflow table.
- ORA-25192: invalid option for an index-organized table
- Cause: An attempt to specify one or more of the following options for an index-organized table: [NO]CACHE, NO LOGGING, CLUSTER
- Action: Remove the illegal option(s)
- ORA-25193: cannot use COMPRESS option for a single column key
- Cause: An attempt to use COMPRESS option on single column key
- Action: Remove the COMPRESS option.
- ORA-25194: invalid COMPRESS prefix length value
- Cause: The specified value must be a positive integer less than the number of key columns
- Action: Specify an appropriate value.
- ORA-25195: invalid option for index on an index-organized table
- Cause: An attempt to specify one or more of the following options for index on an IOT: BITMAP, REVERSE, PCTUSED
- Action: none
- ORA-25196: keyword MOVE in ALTER TABLE MOVE must immediately follow <table name>
- Cause: MOVE specified after one/more other ALTER options
- Action: Remove the illegal option(s)
- ORA-25197: an overflow segment already exists for the indexed-organized table
- Cause: An attempt was made to ADD OVERFLOW segment on an index-organized table that already has an overflow segment
- Action: none
- ORA-25198: only range, list, and hash partitioning are supported for index-organized table
- Cause: System, or Composite partitioning schemes are not supported yet
- Action: Select a different partitioning scheme
- ORA-25199: partitioning key of a index-organized table must be a subset of the primary key
- Cause: An attempt to specify a partitioning key which is not a prefix of the primary key of the index-organized table
- Action: Select a different partitioning key
- ORA-25200: invalid valuestring, QUEUE_NAME should be [SCHEMA.]NAME
- Cause: A NULL parameter was specified for QUEUE_NAME.
- Action: Specify a non-NULL queue name.
- ORA-25201: invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE
- Cause: An invalid value specified for parameter VISIBILITY.
- Action: Specify either ON_COMMIT or IMMEDIATE.
- ORA-25202: invalid value NULL,string should be non-NULL
- Cause: A NULL value was specified for the parameter.
- Action: Specify a non-NULL value.
- ORA-25203: invalid valuestring, DELAY should be non-negative
- Cause: A negative value or NULL was specified for DELAY.
- Action: Specify a non negative integer for DELAY.
- ORA-25204: invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
- Cause: An invalid SEQUENCE_DEVIATION was specified.
- Action: Specify either the option 'BEFORE' or 'TOP'.
- ORA-25205: the QUEUEstring.string does not exist
- Cause: The specified queue does not exist.
- Action: Create the queue first before specifying it for enqueue or dequeue.
- ORA-25206: enqueue failed, enqueue to exception queuestring.string not permitted
- Cause: An attempt was made to enqueue to an exception queue.
- Action: Try enqueueing to another queue.
- ORA-25207: enqueue failed, queuestring.string is disabled from enqueueing
- Cause: The queue has been stopped to prevent any further enqueueing.
- Action: Enable the queue first by using an administrative operation.
- ORA-25208: RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE
- Cause: A relative message identifier should be specified if sequence deviation is specified as BEFORE.
- Action: Either specify an existing relative message identifier or don't specify sequence deviation as BEFORE.
- ORA-25209: invalid valuestring, EXPIRATION should be non-negative or NEVER
- Cause: The expiration is less than zero or NULL.
- Action: Specify a valid value for expire_after which should be greater than or equal to zero or NEVER.
- ORA-25210: invalid value for RELATIVE_MSGID, no message in queue with that msgid
- Cause: No message inm the queue with the msgid equal to the specified RELATIVE_MSGID.
- Action: Try again with a valid RELATIVE_MSGID.
- ORA-25211: invalid DELAY specified when using sequence deviation
- Cause: The DELAY specified in the enqueue is greater than the delay of the message with the given relative message id.
- Action: Set the DELAY to be less than or equal to the delay of the message with the given relative message id. If the TOP option is used the delay must be less than or equal to the delay of all the messages in the queue.
- ORA-25212: invalid PRIORITY specified when using sequence deviation
- Cause: The PRIORITY specified in the enqueue is less than the priority of the message with the given relative message id.
- Action: Set the PRIORITY to be less than the delay of the message with the given relative message id. If the TOP option is used the prioirty must be greater than or equal to the priority of all the messages in the queue.
- ORA-25213: message with specified RELATIVE_MSGID has been dequeued
- Cause: The message specified by the RELATIVE_MSGID field in the sequence deviation BEFORE option has been dequeued.
- Action: none
- ORA-25214: cannot specify delay or expiration for enqueue to exception queue
- Cause: A message was enqueued to the exception queue with either delay or expiration specified.
- Action: Enqueue a message without delay or expiration.
- ORA-25215: user_data type and queue type do not match
- Cause: A user tries to enqueue an object to a queue that was created for objects of different type.
- Action: Try enqueue again with an object of the right type.
- ORA-25216: invalid recipient, either NAME or ADDRESS must be specified
- Cause: Both attributes, NAME and ADDRESS, were specified null for one of the recipients in the recipient list.
- Action: Specify a non-null NAME or ADDRESS for the recipient.
- ORA-25217: enqueue failed, visibility must be IMMEDIATE for queuestring.string
- Cause: An attempt was made to enqueue to a non-persistent queue without setting visibility to IMMEDIATE.
- Action: Set visibility to IMMEDIATE.
- ORA-25218: enqueue failed, delay must be zero for queuestring.string
- Cause: An attempt was made to enqueue to a non-persistent queue with delay greater than zero seconds.
- Action: Set delay to zero.
- ORA-25219: enqueue failed, sequence deviation not allowed for queuestring.string
- Cause: An attempt was made to enqueue to a non-persistent queue with sequence deviation specified.
- Action: Do not specify sequence deviation.
- ORA-25220: enqueue failed, signature not specified for a non-repudiable queue
- Cause: An attempt was made to enqueue to a non-repudiable queue without specifying the signature
- Action: Give the signature
- ORA-25221: enqueue failed, signature specified queue not supporting non-repudiation
- Cause: An attempt was made to enqueue to a queue specifying the signature for a queue not supporting non-repudiation
- Action: Remove the signature
- ORA-25222: enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
- Cause: An attempt was made to enqueue to a queue without giving the complete sender information (name) for a queue supporting non-repudiation
- Action: Provide the sender information
- ORA-25223: user_data type used is not supported
- Cause: An attempt was made to enqueue data into a non persistent queue that is of a type other than the supported raw or object type.
- Action: Enqueue the message again with data of raw or object type.
- ORA-25224: sender name must be specified for enqueue into secure queues
- Cause: An attempt was made to enqueue into a secure queue without specifying a sender name.
- Action: Enqueue the message with sender name specified.
- ORA-25225: invalid valuestring, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
- Cause: An invalid parameter has been specified for DEQUEUE_MODE.
- Action: Specify either REMOVE, BROWSE or LOCKED.
- ORA-25226: dequeue failed, queuestring.string is not enabled for dequeue
- Cause: The queue has not been enabled for dequeue.
- Action: Enable the queue using START_QUEUE.
- ORA-25228: timeout or end-of-fetch during message dequeue fromstring.string
- Cause: User-specified dequeue wait time has passed or the end of the queue has been reached but no message has been retrieved.
- Action: Try dequeue again with the appropriate WAIT_TIME or the FIRST_MESSAGE option.
- ORA-25229: error on transformation of messagestring string
- Cause: There was an error when transforming a message at enqueue, dequeue or propagation time.
- Action: Correct the transformation function.
- ORA-25230: invalid valuestring, WAIT should be non-negative
- Cause: A negative value has been specified for WAIT.
- Action: specify a non negative value or FOREVER.
- ORA-25231: cannot dequeue because CONSUMER_NAME not specified
- Cause: A user tried to dequeue from a queue that has been created for multiple consumers but a CONSUMER_NAME was not been specified in the dequeue options.
- Action: Specify the CONSUMER_NAME in the dequeue options.
- ORA-25232: duplicate recipients specified for message
- Cause: An enqueue was performed with duplicate queue agents in the recipients parameter.
- Action: Remove the duplicate queue agent and retry the call.
- ORA-25233: invalid parameter specified for NAVIGATION
- Cause: An invalid parameter has been specified for NAVIGATION.
- Action: Choose one of FIRST_MESSAGE, NEXT_MESSAGE or NEXT_TRANSACTION. Use FIRST_MESSAGE for dequeuing the first message that satisifies the criterion, NEXT_MESSAGE for dequeuing the next message that satisifies the criterion and NEXT_TRANSACTION for moving to a set of messages enqueued by another transaction.
- ORA-25234: NEXT_TRANSACTION navigation option invalid for queue tablestring.string
- Cause: The NEXT_TRANSACTION navigation option was used in a dequeue from a queue in a queue table that was not created for transactional grouping.
- Action: Specify either FIRST_MESSAGE or NEXT_MESSAGE as the navigation option. If you want to dequeue messages using transactional grouping create the queue in a queue table that has transactional grouping enabled.
- ORA-25235: fetched all messages in current transaction
- Cause: The NEXT_TRANSACTION navigation option was used in a dequeue when there were no more messages that belong to the same transaction.
- Action: Use the NEXT_TRANSACTION navigation option to move to the next also use the FIRST_MESSAGE option to start from the head of the queue again.
- ORA-25236: buffer too small for user data
- Cause: The variable or buffer used for the out parameter payload is too small for the user data dequeued.
- Action: Increase the size of the buffer or the size of the variable. Maximum size allowed is 32K.
- ORA-25237: navigation option used out of sequence
- Cause: The NEXT_MESSAGE or NEXT_TRANSACTION option was specified after dequeuing all the messages.
- Action: Reset the dequeuing position using the FIRST_MESSAGE naviagtion option and then specify the NEXT_MESSAGE or NEXT_TRANSACTION option.
- ORA-25238: too many recipients specified for message destinationstring
- Cause: An ENQUEUE was performed with more than 32 recipients for the given destination (address).
- Action: Reduce the number of recipients to 32 or less, and retry the call.
- ORA-25239: message ID not supplied when dequeuing from exception queuestring.string
- Cause: An attempt was made to dequeue from a release 8.0-compatible exception queue without including a message ID in the dequeue options.
- Action: Check the application to ensure that the queue name has been specified correctly. If the queue name is correct supply a message ID when dequeuing from a release 8.0-compatible exception queue. Otherwise, upgrade the queue_table containing the queue to release 8.1-compatible using the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure.
- ORA-25240: message ID and dequeue condition/correlation ID specified in dequeue options
- Cause: An attempt was made to dequeue by including both a message ID and a dequeue condition/correlation ID in the dequeue options. In the dequeue options, you are permitted to specify either message ID or dequeue condition/correlation ID, or neither.
- Action: To dequeue a message, specify a message ID or a dequeue condition/correlation ID in the dequeue options, but do not specify both. If you want to dequeue in the queue's sort order, then do not specify either the message ID or dequeue condition/correlation ID in the dequeue options.
- ORA-25241: cannot change correlation ID fromstring to string without FIRST_MESSAGE option
- Cause: An attempt was made to change the correlation ID while using the NEXT_MESSAGE or NEXT_TRANSACTION option for dequeuing.
- Action: To use a correlation ID that is different from the previous dequeue call, reset the dequeuing position by using the FIRST_MESSAGE navigation option.
- ORA-25242: cannot change subscriber name fromstring to string without FIRST_MESSAGE option
- Cause: An attempt was made to change the subscriber name while using the NEXT_MESSAGE or NEXT_TRANSACTION option for dequeuing.
- Action: To use a subscriber name that is different from the previous dequeue call, reset the dequeuing position by using the FIRST_MESSAGE navigation option.
- ORA-25243: CONSUMER_NAME cannot be specified when dequeuing from exception queuestring.string
- Cause: An attempt was made to dequeue from an exception queue by specifying the CONSUMER_NAME in the dequeue options. CONSUMER_NAME can only be specified when dequeuing from a normal queue created for multiple consumers.
- Action: Specify only the message id in the dequeue options to dequeue a message from an exception queue.
- ORA-25244: dequeue index key not found, QUEUEstring, rowid string
- Cause: An internal error was encountered. There may be an inconsistency in the queue table index.
- Action: Contact your Oracle customer support representative. You may need to provide the trace file and information about reproducing the error.
- ORA-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue
- Cause: The agent name for the agent in the LISTEN call was specified when the agent address was a single-consumer queue or an exception queue.
- Action: Do not specify the agent name.
- ORA-25246: listen failed, the addressstring is an 8.0 style exception queue
- Cause: An 8.0 style exception queue was specified in the agent-list for the LISTEN call.
- Action: Specify a normal 8.0 style queue or an 8.1 style queue in the agent-list.
- ORA-25247: %s is not a recipient of specified message
- Cause: The consumer name specified in the dequeue options is not a recipient of the message specified by the message id.
- Action: Ensure that the agent specified by the consumer name is a recipient of the message specified by the message id.
- ORA-25248: duplicate agent specified in the agent list
- Cause: An agent was specified more than once in the agent list of the LISTEN call.
- Action: Remove the duplicate agent specification(s), and retry the call.
- ORA-25249: dequeue failed, dequeue not allowed for queuestring.string
- Cause: An attempt was made to dequeue from a non-persistent queue.
- Action: Dequeue from a different queue.
- ORA-25250: Cannot specify a remote recipient for the message
- Cause: A recipient for the message enqueued to a non-persistent queue had a non-local address.
- Action: Do not specify the address field or specify the queue which is the target of the enqueue
- ORA-25251: exceeded maximum number of recipients for message
- Cause: An attempt was made to issue an ENQUEUE call that exceeded the the maximum number (1024) of recipients per message.
- Action: Reduce the number of recipients to 1024 or less, and retry the call.
- ORA-25252: listen failed, the addressstring is a non-persistent queue
- Cause: A non-persistent queue was specified as an address for an agent in the LISTEN call.
- Action: Specify a normal queue as address for the agent, and retry the the LISTEN call.
- ORA-25253: listen failed, queuestring.string is not enabled for dequeue
- Cause: An attempt was made to specify a queue that is not enabled for dequeue in a LISTEN call.
- Action: Enable the queue for dequeue using START_QUEUE, and retry the LISTEN call.
- ORA-25254: time-out in LISTEN while waiting for a message
- Cause: The specified wait time has elapsed and there were no messages for any of the agents in the agent-list.
- Action: Try the LISTEN call with an appropriate time-out.
- ORA-25255: incorrect subscription stringstring
- Cause: An incorrect subscription string was specified with OCIRegister.
- Action: Specify a subscription string using the [CONSUMER:]SCHEMA.QUEUE form.
- ORA-25256: consumer cannot be specified with a single-consumer queue or an exception queue
- Cause: An attempt was made to specify a consumer in the subscription string when registering for notification on a single-consumer queue or an exception queue.
- Action: Do not specify the consumer in the subscription string.
- ORA-25257: consumer must be specified with a multi-consumer queue
- Cause: An attempt was made to register on a multi-consumer queue without specifying a consumer in the subscription string.
- Action: Specify a consumer in the subscription string.
- ORA-25258: cannot register for notifications on an 8.0 style exception queue
- Cause: An attempt was made to specify an 8.0 style exception queue in the subscription string of OCIRegister.
- Action: Specify a normal queue or a non-persistent queue.
- ORA-25259: cannot specify protocol for agent
- Cause: The user specified the protocol attribute for an agent in the agent list.
- Action: Do not specify the protocol attribute of the agent object type.
- ORA-25261: JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation
- Cause: AQ Propagator encountered a setting for JOB_QUEUE_PROCESSES that is insufficient for AQ propagation.
- Action: Set the number of JOB_QUEUE_PROCESSES to at least 2 for AQ propagation.
- ORA-25262: agent name cannot be NULL if address is a multi-consumer queue
- Cause: The name for the agent in the LISTEN call was not specified when the agent address was a multi-consumer queue.
- Action: Specify a non-NULL name for the agent.
- ORA-25263: no message in queuestring.string with message ID string
- Cause: An attempt was made to dequeue a message with a specific message ID, but no such message exists in the queue.
- Action: Try dequeue again with a valid message ID.
- ORA-25264: cant get signature for this queue
- Cause: An attempt was made to dequeue the signature from this queue, which is not reciever non-repidiable.
- Action: Try dequeue again without the get signature option
- ORA-25265: specified signature for a queue which does not support reciever non-repudiation
- Cause: An attempt was made to dequeue the message from a queue which does not support reciever non-repudiation, but the signature was specified for verification
- Action: Try dequeue again without the signature
- ORA-25266: didnt try to dequeue by message id. with the signature
- Cause: The signature was specified for a queue, but the dequeue was not done by message id.
- Action: Try dequeue again by message id.
- ORA-25267: didnt specify the signature for a reciever non-repudiable queue
- Cause: The signature was not specified for a reciever non-repudiable queue
- Action: Try dequeue again along with the signature
- ORA-25268: didnt dequeue in browse mode with get signature option
- Cause: The dequeue was not performed in browse mode with get signature option
- Action: Try dequeue again in browse mode
- ORA-25269: cant specify sognature with get signature option
- Cause: The signature is not required for the dequeue with get signature option
- Action: Try dequeue again without the signature in dequeue options
- ORA-25270: sender info does not match with the actual sender of the message
- Cause: The sender info. and the message id. do not match
- Action: Try dequeue again without the signature in dequeue options
- ORA-25271: queue table not found for the given queue
- Cause: The queue table does not exist for the given queue
- Action: Provide the right queue name
- ORA-25272: Signature does not exist for the given reciever and message id.
- Cause: Signature does not exist for the given reciever and message id.
- Action: Check the message id. and the reciever's information
- ORA-25276: table specified is not a queue table
- Cause: An invalid queue table name is specified.
- Action: Check the dictionary views to see if the table is a queue table.
- ORA-25277: cannot grant or revoke object privilege on release 8.0 compatible queues
- Cause: An attempt was made to grant or revoke object privilege on release 8.0 style queues.
- Action: Convert the release 8.0 compatible queue table to release 8.1 compatible using DBMS_AQADM.MIGRATE_QUEUE_TABLE before granting or revoking object privilege.
- ORA-25278: grantee name cannot be NULL
- Cause: An attempt was made to specify NULL for the grantee parameter.
- Action: Specify a valid grantee parameter.
- ORA-25279: dequeue as select not supported before 8.2
- Cause: Dequeue as select not supported before 8.2.
- Action: Dont use select condition while dequeuing
- ORA-25280: complete sender information not provided to non-repudiate sender
- Cause: complete sender information not provided to non-repudiate sender
- Action: Provide the complete sender information
- ORA-25281: complete reciever information not provided to non-repudiate reciever
- Cause: complete reciever information not provided to non-repudiate reciever
- Action: Provide the complete reciever information
- ORA-25282: message id. not provided for non-repudiation
- Cause: message id. was not provided
- Action: Provide the message id.
- ORA-25283: either agent's name or address needed for non-repudiation
- Cause: neither agent's name nor address provided for non-repudiation"
- Action: Provide the agent info.
- ORA-25284: Invalid valuestring for string
- Cause: An Invalid value or NULL was specified for the parameter.
- Action: Check the documentation for valid values.
- ORA-25285: Invalid valuestring for array_mode
- Cause: An Invalid value or NULL was specified for the array_mode.
- Action: Check the documentation for valid values.
- ORA-25286: Invalid number of elements in the message properties array
- Cause: Number of elements in the message properties array do not match the number of elements in the payload array.
- Action: Create a message property array with one element (that applies for all the elements in the payload array) or create a message property array with the same number of elements as there are in the payload array.
- ORA-25287: Invalid valuestring, string should be non-negative
- Cause: An Invalid value or NULL was specified for the parameter.
- Action: Specify a non negative integer.
- ORA-25288: AQ HTTP propagation encountered error, status-codenumber, string
- Cause: AQ propagation's HTTP request to the propagation servlet at the specified address encountered an error
- Action: Specify a valid address in the connect string of the propagation destination dblink, the dblink user has the correct permissions, check if the AQ propagation servlet was properly installed.
- ORA-25289: Buffer Already Exists
- Cause: Buffer already exists for the specified queue.
- Action: None
- ORA-25290: Cannot complete operation on queuestring with existing messages
- Cause: Queue already has messages. Cannot complete operation
- Action: Truncate the queue before adding/dropping a buffer
- ORA-25291: Buffer does not exist for the specified queue
- Cause: Buffer does not exist for the specified queue
- Action: Operation on the buffer cannot be performed. create the buffer
- ORA-25292: Cannot add buffer on the specified queue
- Cause: Buffer cannot be added on Specified Queue
- Action: Can only add buffers to 8.1 style non-exception multi-consumer queues, which do not have priority, non_repudiation, message_grouping, max_retries and retention.
- ORA-25293: Remote Recipient Subsribers and buffered operations not possible for Queuestring
- Cause: Specified Queue has remote recipient subscribers
- Action: Cannot add buffers/add buffered subscribers to queues with remote recipient subscribers
- ORA-25294: Queuestring has a buffer
- Cause: Specified Queue has a buffer
- Action: Drop the buffer first
- ORA-25295: Subscriber is not allowed to dequeue buffered messages
- Cause: Subscriber is only allowed to dequeue persistent messages
- Action: Drop the subscriber and re-create it
- ORA-25296: Queue Tablestring has a buffered queue string
- Cause: Cannot downgrade the queue table because it has a buffered queue
- Action: Drop the buffer or the buffered queue
- ORA-25297: The message options only make sense for buffered messages
- Cause: The message options only make sense for buffered messages
- Action: Check the enqueue/dequeue options
- ORA-25298: The memory threshold for a queue cannot be negative
- Cause: The memory threshold for a queue cannot be negative
- Action: Correct the memory threshold
- ORA-25299: Cannot add buffered subscriber for a non-buffered queue
- Cause: Cannot add buffered subscriber for a non-buffered queue
- Action: Either add buffer to the queue, or make the subscriber non-buffered
- ORA-25300: Cannot drop buffer for queue with buffered subscribers
- Cause: Cannot drop buffer for queue with buffered subscribers
- Action: Either drop buffered subscribers or forcibly drop the buffer
- ORA-25301: cannot specify recipient list during enqueue
- Cause: Recipient list for buffered queue not supported
- Action: Dont specify recipient list for buffered enqueues
- ORA-25302: Operation not possible for non-buffered queuestring
- Cause: Last enqd/ackd message is only supported for buffered queues
- Action: The operation is not supported.
- ORA-25303: Buffered operation allowed only on the owner instance
- Cause: Operation was not performed on the owner instance.
- Action: Perform operation on the owner instance.
- ORA-25304: Queue Table has primary/secondary instance affinity. Cannot add buffer
- Cause: Cannot add buffer if primary/secondary instance is specified.
- Action: Add buffer after removing instance affinities.
- ORA-25305: enqueue failed, expiration must be zero for queuestring.string
- Cause: An attempt was made to enqueue to a non-persistent or buffered queue with expiration greater than zero seconds.
- Action: Set expiration to zero.
- ORA-25306: Queue tablestring has buffered queues. Cannot alter
- Cause: Cannot change instance affinities if there are buffered queues on this queue table.
- Action: Perform Alter after dropping all buffered queues.
- ORA-25307: Enqueue rate too high. Enable flow control
- Cause: Subscribers cannot keep pace with the enqueue rate.
- Action: Try enqueue after sleeping for some time.
- ORA-25321: enqueue failed, user property specified but queuestring.string is not an 8.1 style queue
- Cause: user properties can only be specified when enqueueing into 8.1 style queues.
- Action: Specify an 8.1 style queue or pass user property as NULL.
- ORA-25326: Arraystring operation failed for message at index string
- Cause: Array operation fails for the message at specified index. Look at the remainder of the error stack to see what the problem was.
- Action: Fix cause of error and retry array operation.
- ORA-25327: Array size is invalid
- Cause: Array size must be a positive, non-zero integer.
- Action: Use corrected array size and retry array operation.
- ORA-25328: %s argument sizestring is smaller than array size
- Cause: The size of the argument is smaller than the given array size.
- Action: Lower array size or use a larger sized input argument.
- ORA-25329: AQ array operations not allowed on 8.0 queues
- Cause: An array enqueue/dequeue was attempted on an 8.0 queue.
- Action: Use single enqueue/dequeue with this queue.
- ORA-25330: PL/SQL associative arrays may not be used with AQ array operations
- Cause: A PL/SQL associative array was provided for the payload parameter in an enqueue/dequeue array operation.
- Action: Use VARRAY or NESTED TABLE types with AQ array operations.
- ORA-25350: maximum number of concurrent transaction branches exceeded
- Cause: the limit on the number of concurrent transaction branches has been reached
- Action: Increase the INIT.ORA parameter 'transactions' and restart the system.
- ORA-25351: transaction is currently in use
- Cause: The transaction is currently used by a different session.
- Action: Do not switch to a transaction attached to some other session.
- ORA-25352: no current transaction
- Cause: The user session is not attached to any transaction.
- Action: Do not attempt to detach when there is no current transaction.
- ORA-25353: branch marked for deletion
- Cause: The branch specified cannot be killed immediately because another session is using the branch, but it has been marked for kill. This means it will be deleted as soon as possible after the current uninterruptable operation is completed.
- Action: No action is required for the branch to be deleted.
- ORA-25400: must replay fetch
- Cause: A failure occured since the last fetch on this statement. Failover was able to bring the statement to its original state to allow continued fetches.
- Action: This is an internally used error message and should not be seen by the user.
- ORA-25401: can not continue fetches
- Cause: A failure occured since the last fetch on this statement. Failover was unable to bring the statement to its original state to allow continued fetches.
- Action: Reexecute the statement and start fetching from the beginning
- ORA-25402: transaction must roll back
- Cause: A failure occured while a transaction was active on this connection.
- Action: The client must roll back.
- ORA-25403: could not reconnect
- Cause: The connection to the database has been lost, and attempts to reconnect have failed.
- Action: Manually reconnect.
- ORA-25404: lost instance
- Cause: The primary instance has died.
- Action: This is an internally used error message and should not be seen by the user.
- ORA-25405: transaction status unknown
- Cause: A failure occured while a transaction was attempting to commit. Failover could not automatically determine instance status.
- Action: The user must determine the transaction's status manually.
- ORA-25406: could not generate a connect address
- Cause: Failover was unable to generate an address for a backup instance.
- Action: Contact Oracle customer support.
- ORA-25407: connection terminated
- Cause: The connection was lost while doing a fetch.
- Action: This is an internally used error message and should not be seen by the user.
- ORA-25408: can not safely replay call
- Cause: The connection was lost while doing this call. It may not be safe to replay it after failover.
- Action: Check to see if the results of the call have taken place, and then replay it if desired.
- ORA-25409: failover happened during the network operation,cannot continue
- Cause: The connection was lost when fetching a LOB column.
- Action: Failover happened when fetching LOB data directly or indirectly. Please replay the top level statement.
- ORA-25425: connection lost during rollback
- Cause: The connection was lost while issuing a rollback and the application failed over.
- Action: The connection was lost and failover happened during rollback. If the transaction is not externally coordinated, then Oracle implicitly rolled back, so no action is required. Otherwise examine pending_trans$ to determine if "rollback force" is required.
- ORA-25426: remote instance does not support shared dblinks
- Cause: A shared dblink is being used to connect to a remote instance that does not support this feature because it is an older version.
- Action: Use a normal dblink if you need to connect to this instance.
- ORA-25436: invalid table alias:string
- Cause: An attempt to evaluate was made, which failed because one of the table values specified had an invalid alias.
- Action: Check the valid table aliases in the evaluation context, and try again with a valid alias.
- ORA-25437: duplicate table value for table alias:string
- Cause: An attempt to evaluate was made, which failed because some of the table values specified had the same table alias.
- Action: Check the table values specified, and try again with only one value per table.
- ORA-25438: invalid variable name:string
- Cause: An attempt to evaluate was made, which failed because one of the variable values specified had an invalid name.
- Action: Check the valid variable names in the evaluation context, and try again with a valid name.
- ORA-25439: duplicate variable value for variable:string
- Cause: An attempt to evaluate was made, which failed because some of the variable values specified had the same variable name.
- Action: Check the variable names specified, and try again with only one value per variable.
- ORA-25440: invalid table alias:string
- Cause: An attempt to evaluate was made, which failed because one of the column values specified had an invalid table alias.
- Action: Check the valid table aliases in the evaluation context, and try again with a valid name.
- ORA-25441: duplicate column value for table alias:string
- Cause: An attempt to evaluate was made, which failed because one of the column values supplied a value for a table alias, which already had a table value supplied.
- Action: Check the table and column values specified, and try again with either a table value or column values for each table alias.
- ORA-25442: too many column values for table alias:string
- Cause: An attempt to evaluate was made, which failed because too many column values were supplied for the specified table alias.
- Action: Check the column values specified, and try again with the right number of column values.
- ORA-25443: duplicate column value for table alias:string, column number: string
- Cause: An attempt to evaluate was made, which failed because duplicate column values were supplied for the specified table alias and column number.
- Action: Check the column values specified, and try again with only one column value for each table alias, and column number.
- ORA-25444: invalid ROWID:string for table alias: string
- Cause: An attempt to evaluate was made, which failed because an invalid ROWID was supplied for the specified table alias.
- Action: Check the column values specified, and try again with only one column value for each table alias, and column number.
- ORA-25445: invalid column number:string for table alias: string
- Cause: An attempt to evaluate was made, which failed because an invalid column number was supplied for the specified table alias as a part of a column value.
- Action: Check the column values specified, and try again with a valid column number.
- ORA-25446: duplicate column value for table alias:string, column: string
- Cause: An attempt to evaluate was made, which failed because duplicate column values were supplied for the specified table alias and column name.
- Action: Check the column values specified, and try again with only one column value for each table alias, and column name.
- ORA-25447: encountered errors during evaluation of rulestring.string
- Cause: An attempt to evaluate was made, which failed during the evaluation of the specified rule.
- Action: Check the rule and the values passed to evaluate, and try again with valid values.
- ORA-25448: rulestring.string has errors
- Cause: An attempt to load the specified rule failed due to errors in the rule.
- Action: Check the rule and retry the operation.
- ORA-25449: invalid variable name:string
- Cause: An attempt to evaluate was made, which failed because one of the attribute values specified had an invalid variable name.
- Action: Check the valid variable names in the evaluation context, and try again with a valid name.
- ORA-25450: errorstring during evaluation of rule set string.string
- Cause: The specified error occurred during evaluation of the rule set.
- Action: Check the error and take appropriate action.
- ORA-25451: too many attribute values for variable:string
- Cause: An attempt to evaluate was made, which failed because too many attribute values were supplied for the specified variable.
- Action: Check the attribute values specified, and try again with the right number of attribute values.
- ORA-25452: duplicate attribute value for variable:string, attribute: string
- Cause: An attempt to evaluate was made, which failed because duplicate attribute values were supplied for the specified variable and attribute name.
- Action: Check the attribute values specified, and try again with only one attribute value for each variable, and attribute name.
- ORA-25453: invalid iterator:string
- Cause: An attempt to get rule hits or to close an iterator was made, which failed because an invalid iterator was passed in.
- Action: Check the iterator, and try again with a valid iterator.
- ORA-25454: error during evaluation of rule set:string.string for iterator: string
- Cause: An attempt to get rule hits for an iterator was made, which failed because of an error in evaluation of the specified rule set.
- Action: Check the validity of the rule set and try again.
- ORA-25455: evaluation error for rule set:string.string, evaluation context: string.string
- Cause: An attempt to evaluate the specified rule set using the evaluation context specified failed due to some errors.
- Action: Check additional errors signalled to determine the problem.
- ORA-25456: rule set was modified or evaluation terminated for iterator:string
- Cause: An attempt to get rule hits was made, which failed because the underlying rule set was modified after the iterator was returned.
- Action: Try again after re-evaluating the rule set.
- ORA-25457: evaluation functionstring returns failure
- Cause: The specified evaluation function returned a failure during evaluation, causing evaluation to terminate.
- Action: Check arguments to evaluate and retry.
- ORA-25461: rule set not specified
- Cause: An attempt to evaluate was made, which failed because the ruleset name specified was null.
- Action: Check the rule set name, and try again with a valid name.
- ORA-25462: evaluation context not specified
- Cause: An attempt to evaluate was made, which failed because the evaluation context specified was null.
- Action: Check the evaluation context name, and try again with a valid name.
- ORA-25463: table alias not specified
- Cause: An attempt to evaluate was made, which failed because one of the table values specified had a NULL alias name.
- Action: Check the list of table values, and try again with a valid alias name.
- ORA-25464: ROWID not specified for table alias:string
- Cause: An attempt to evaluate was made, which failed because the table value for the specified table alias had a NULL ROWID.
- Action: Check the list of table values, and try again with a valid ROWID.
- ORA-25465: variable name not specified
- Cause: An attempt to evaluate was made, which failed because one of the variable values specified had a NULL variable name.
- Action: Check the list of variable values, and try again with a valid variable name.
- ORA-25466: data not specified for variable name:string
- Cause: An attempt to evaluate was made, which failed because the variable value for the specified variable name had NULL data.
- Action: Check the list of variable values, and try again with valid data.
- ORA-25467: table alias not specified
- Cause: An attempt to evaluate was made, which failed because one of the column values specified had a NULL alias name.
- Action: Check the list of column values, and try again with a valid alias name.
- ORA-25468: column name not specified for alias:string
- Cause: An attempt to evaluate was made, which failed because one of the column values for the specified alias name had a NULL column name.
- Action: Check the list of column values, and try again with a valid column name.
- ORA-25469: data not specified for alias:string column name: string
- Cause: An attempt to evaluate was made, which failed because the column value for the specified alias and column name had NULL data.
- Action: Check the list of column values, and try again with valid data.
- ORA-25470: duplicate attribute value for variable:string
- Cause: An attempt to evaluate was made, which failed because one of the attribute values supplied a value for a variable, which already had a variable value supplied.
- Action: Check the variable and attribute values specified, and try again with either a variable value or attribute values for each variable.
- ORA-25471: attribute name not specified for variable:string
- Cause: An attempt to evaluate was made, which failed because one of the attribute values for the specified variable had a NULL attribute name.
- Action: Check the list of attribute values, and try again with a valid attribute name.
- ORA-25472: maximum open iterators exceeded
- Cause: The open rule hit iterators in the session exceeded 2 * OPEN_CURSORS.
- Action: Close some rule hit iterators.
- ORA-25473: cannot storestring in rule action context
- Cause: The user attempted to put unsupported data types, such as LOBs and evolved ADTs, into the rule action context.
- Action: Use only supported data types in rule action context.
- ORA-25500: database is not open
- Cause: Database must be open to perform ALTER SYSTEM QUIESCE RESTRICTED command.
- Action: Open the database and retry this command.
- ORA-25501: ALTER SYSTEM QUIESCE RESTRICTED command failed
- Cause: Database resource manager failed to change plan.
- Action: Look at the alert logs to see detailed description of the error.
- ORA-25502: concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running
- Cause: There is a concurrent ALTER SYSTEM QUIESCE RESTRICTED or ALTER SYSTEM UNQUIESCE command running in the system.
- Action: Contact the database administrator who is responsible for the concurrent command.
- ORA-25503: cannot open database because the database is being quiesced
- Cause: Database cannot be opened because the system is being or has been quiesced.
- Action: Open the database after the system has been quiesced.
- ORA-25504: the system is already in quiesced state
- Cause: Cannot quiesce the system because the system is already quiesced.
- Action: none
- ORA-25505: the system is not in quiesced state
- Cause: Cannot unquiesce the system because the system is not in quiesced state.
- Action: none
- ORA-25506: resource manager has not been continuously on in some instances
- Cause: Cannot quiesce the system because resource manager has not been continuously on since startup in this or some other instances.
- Action: none
- ORA-25507: resource manager has not been continuously on
- Cause: Cannot quiesce the system because resource manager has not been continuously on since startup.
- Action: none
- ORA-25508: database is not mounted
- Cause: Database must be mounted to perform ALTER SYSTEM UNQUIESCE command.
- Action: Mount the database and retry this command.
- ORA-25509: operation on "string"."string".string not allowed
- Cause: A column has been added to a replicated table, but replication support processing has not completed.
- Action: Wait until replication support processing has completed before updating the column
- ORA-25526: bad format of _DB_MTTR_SIM_TARGET:string
- Cause: One value in _DB_MTTR_SIM_TARGET is not a valid MTTR.
- Action: Alter the value of _DB_MTTR_SIM_TARGET.
- ORA-25527: bad format of _DB_MTTR_SIM_TARGET
- Cause: One value in _DB_MTTR_SIM_TARGET is empty.
- Action: Set the value of _DB_MTTR_SIM_TARGET properly.
- ORA-25528: too many candidate MTTRs are specified in _DB_MTTR_SIM_TARGET
- Cause: Too many candidate MTTRs are specified in _DB_MTTR_SIM_TARGET.
- Action: Alter the value of _DB_MTTR_SIM_TARGET.
- ORA-25530: FAST_START_MTTR_TARGET is not specified
- Cause: An attempt to start MTTR advisory was made, which failed because FAST_START_MTTR_TARGET was not specified.
- Action: Set FAST_START_MTTR_TARGET.
- ORA-25531: MTTR specified is too small:string
- Cause: The current FAST_START_MTTR_TARGET setting or a candidate MTTR setting is too small for MTTR advisory.
- Action: Set a larger FAST_START_MTTR_TARGET or candidate MTTR.
- ORA-25532: MTTR specified is too large:string
- Cause: The current FAST_START_MTTR_TARGET setting or a candidate MTTR setting is too large for MTTR advisory.
- Action: Set a smaller FAST_START_MTTR_TARGET or candidate MTTR.
- ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
- Cause: An attempt to start MTTR advisory was made, which failed because either FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL was specified.
- Action: Set FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL to 0.
- ORA-25534: _MEAN_TIME_TO_CLUSTER_AVAILABILITY is specified
- Cause: An attempt to start MTTR advisory was made, which failed because _MEAN_TIME_TO_CLUSTER_AVAILABILITY was specified.
- Action: No action required.
- ORA-25950: missing where clause in join index specification
- Cause: An attempt to create a join index was made, which failed because no valid where clause was found.
- Action: Ensure that a where clause with valid join conditions is specified in the create index statement.
- ORA-25951: join index where clause cannot contain OR condition
- Cause: An attempt to create a join index was made, which failed because there was an OR branch in the where clause.
- Action: Reformulate the where clause without using ORs.
- ORA-25952: join index must only contain inner equi-joins
- Cause: An attempt to create a join index was made, which failed because it included a predicate which wasn't an equi-inner join.
- Action: Remove the inappropriate predicate.
- ORA-25953: join index cannot be a functional index
- Cause: An attempt to create a join index was made, which failed because a functional index was requested or necessary (such as is the case for indexing columns using timezone).
- Action: Remove any functional indexing columns.
- ORA-25954: missing primary key or unique constraint on dimension
- Cause: An attempt to create a join index was made, which failed because one or more dimensions did not have an appropriate constraint matching the join conditions.
- Action: Ensure that the where clause is correct (contains all of the constraint columns) and that an enforced constraint is on each dimension table.
- ORA-25955: all tables must be joined in the where clause
- Cause: An attempt to create a join index was made, which failed because one of the tables in the from clause did not appear in the where clause.
- Action: Ensure that the where clause contains all from clause tables.
- ORA-25956: join index cannot be created on tables owned by SYS
- Cause: An attempt to create a join index was made, which failed because one of the tables was owned by SYS.
- Action: Ensure that no join index related table is owned by SYS.
- ORA-25957: join index where clause cannot contain cycles
- Cause: An attempt to create a join index was made, which failed because the where clause contains a cycle.
- Action: Ensure that the where clause is in the form of a star or snowflake schema.
- ORA-25958: join index where clause predicate may only contain column references
- Cause: An attempt to create a join index was made, which failed because a predicate in the where clause contained something other than a simple column.
- Action: Ensure that the where clause only contains columns.
- ORA-25959: join index must be of the bitmap type
- Cause: An attempt to create a join index was made, which failed because no bitmap keyword was used.
- Action: Make the index a bitmap index.
- ORA-25960: join index cannot be based on a temporary table
- Cause: An attempt to create a join index was made, which failed because one of the tables was temporary.
- Action: Ensure no underlying tables are temporary.
- ORA-25961: join index prevents dml cascade constraint operation
- Cause: An attempt to execute dml resulted in the need to perform dml on another table because of a cascade constraint. The join index only allows one of its underlying tables to me modified at a time.
- Action: Drop the join index or remove the constraint.
- ORA-25962: join index prevents multitable insert or merge
- Cause: An attempt to execute an merge or multitable insert on a table that was used to create a bitmap join index was made. Merge and multitable inserts are not supported on tables that were used to create a bitmap join index.
- Action: Drop the join index.
- ORA-25963: join index must be created on tables
- Cause: An attempt to create a join index was made, which failed because the from clause contains non table object.
- Action: Ensure that the from clause only contains tables.
- ORA-25964: column type incompatible with join column type
- Cause: The datatype of the join column is incompatible with the datatype of the joined column.
- Action: Select a compatible datatype for the join column.
- ORA-25965: fact table must be included in the from clause
- Cause: An attempt to create a join index was made, which failed because the from clause does not contain the fact table.
- Action: Ensure that the from clause contains the fact table.
- ORA-25966: join index cannot be based on an index organized table
- Cause: An attempt to create a join index was made, which failed because one of the tables was an index organized table.
- Action: Ensure no underlying tables are index organized.
- ORA-26000: partition load specified but tablestring is not partitioned
- Cause: The Loader control file contains a PARTITION clause but the table being loaded is not partitioned.
- Action: Remove the partition specification from the SQL*Loader control file and retry the load.
- ORA-26001: Indexstring specified in SORTED INDEXES does not exist on table string
- Cause: A nonexistent index was specified in the SORTED INDEXES clause.
- Action: Do not specify as a SORTED INDEX.
- ORA-26002: Tablestring has index defined upon it.
- Cause: Parallel load was specified into a table which has index defined upon it.
- Action: Drop index(es) defined upon table, or don't use parallel load, or use SKIP_INDEX_MAINTENANCE option.
- ORA-26003: parallel load not supported for index-organized tablestring.
- Cause: Parallel load is not supported for index-organized tables.
- Action: load the index-organized table without the PARALLEL option.
- ORA-26004: Tables loaded through the direct path may not be clustered
- Cause: User attempted to load a clustered table via the direct path.
- Action: Use the conventional path.
- ORA-26005: Invalid handle for direct path load
- Cause: In direct path load, the handle passed in does not match the type listed.
- Action: Verify the handle and type are correct.
- ORA-26006: Incorrect bind variable in columnstring's sql expression - string
- Cause: In direct path load, the bind variables listed in the sql expression do not match the input argument column names.
- Action: Verify all the input arguments are listed in the expression as bind variables, and all the bind variables are listed as input arguments to the expression. Or verify that there were no errors in executing the OCI statements when getting the bind variable list.
- ORA-26007: invalid value for SETID or OID column
- Cause: The value passed in a Direct Path API stream for a column containing a SETID or OID has an invalid value. SETIDs and Object IDs must be either 16 bytes of RAW data or 32 bytes of hexidecimal characters.
- Action: Regenerate the Direct Path API stream with a valid value for the SETID column.
- ORA-26010: Columnstring in table string is NOT NULL and is not being loaded
- Cause: A column which is NOT NULL in the database is not being loaded and will cause every row to be rejected.
- Action: Load the column by specifying the NOT NULL column in the INTO TABLE clause in the SQL*Loader control file.
- ORA-26011: Cannot load typestring into column string in table string
- Cause: A column can only store data of type declared for that column. And a substitutable column can only store data of valid subtypes of the supertype declared for that column.
- Action: Check that the type or subtype specified is valid for that column.
- ORA-26012: No data found while executing sql statementstring for column string - check input for: string
- Cause: Executing sql statement against the data dictionary tables returned "ORA-01403: no data found".
- Action: No data retrieved when selecting against the data dictionary tables most likely means that there's an error in user input. Check that the input listed is correct.
- ORA-26013: List allocated may not be big enough
- Cause: There seems to be a discrepancy between the size for a list or buffer allocated by direct path api and the size needed.
- Action: Contact Oracle Customer Support.
- ORA-26015: Array columnstring in table string is not supported by direct path
- Cause: User attempted to load an array column via the direct path.
- Action: Use the conventional path.
- ORA-26017: global indexes not allowed for direct path load of table partitionstring
- Cause: Global indexes are defined on a table when direct path loading a single partition of the table.
- Action: none
- ORA-26018: Columnstring in table string does not exist
- Cause: Column specified in the loader control file does not exist.
- Action: Make sure the column exists and that you have privileges on it. Correct the loader control file if it is wrong.
- ORA-26019: Columnstring in table string of type string not supported by direct path
- Cause: The Specified column of SQL column type %s is not supported by the direct path loader.
- Action: If the column is NULLable, remove it from the control file description. Then it will be loaded as a NULL.
- ORA-26020: indexstring.string loaded successfully with string keys
- Cause: Non-partitioned index information put to loader log file.
- Action: None. Information only.
- ORA-26021: indexstring.string partition string loaded successfully withstring keys
- Cause: Partitioned index information put to loader log file.
- Action: None. Information only.
- ORA-26022: indexstring.string was made unusable due to:
- Cause: A Non-partitioned index was made index unusable due to the error displayed below this error.
- Action: Depending on the error, either rebuild the index, or drop and re-create it.
- ORA-26023: indexstring.string partition string was made unusable due to:
- Cause: A partition of a partitioned index was made index unusable due to error displayed below this error.
- Action: Depending on the error, either rebuild the index partition, or drop and re-create the entire index.
- ORA-26024: SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable
- Cause: User requested SKIP_UNUSABLE_INDEXES option, and the index segment
* was in unusable state prior to the beginning of the load.
- Action: Informational only. User will need to either rebuild the index
* or index partition, or re-create the index.
- ORA-26025: SKIP_INDEX_MAINTENANCE option requested
- Cause: User requested that index maintenance be skipped on a direct path load.
- Action: The listed index was put into Index Unusable state due to the user requesting that index maintenance be skipped. Either rebuild the index or index partitions, or drop and re-create the index.
- ORA-26026: unique indexstring.string initially in unusable state
- Cause: A unique index is in IU state (a unique index cannot have
* index maintenance skipped via SKIP_UNUSABLE_INDEXES).
- Action: Either rebuild the index or index partition, or use
* SKIP_INDEX_MAINTENANCE if the client is SQL*Loader.
- ORA-26027: unique indexstring.string partition string initially in unusable state
- Cause: A partition of a unique index is in IU state (a unique index
* cannot have index maintenance skipped via SKIP_UNUSABLE_INDEXES).
- Action: Either rebuild the index or index partition, or use
* SKIP_INDEX_MAINTENANCE if the client is SQL*Loader.
- ORA-26028: indexstring.string initially in unusable state
- Cause: An index is in IU state prior to the beginning of a direct
* path load, it cannot be maintained by the loader.
- Action: Either rebuild the index, re-create the index, or use either
* SKIP_UNUSABLE_INDEXES or SKIP_INDEX_MAINTENANCE (Sql*Loader only).
- ORA-26029: indexstring.string partition string initially in unusable state
- Cause: A partition of an index is in IU state prior to the beginning
* of a direct path load, it cannot be maintained by the loader.
- Action: Either rebuild index partition, re-create the index, or use either
* SKIP_UNUSABLE_INDEXES or SKIP_INDEX_MAINTENANCE (Sql*Loader only).
- ORA-26030: indexstring.string had string partitions made unusable due to:
- Cause: A logical index error occurred on a partitioned index which
* affected one or more index partitions, which are listed below
* this message.
- Action: The affected index partitions will have to be re-built, or, the
* entire index dropped and re-created.
- ORA-26031: index maintenance error, the load cannot continue
- Cause: A index errror occurred during the index maintenance phase of
* a direct path load. The load cannot continue. See error message
* below this message.
- Action: See action for the error message which follows this one.
- ORA-26032: indexstring.string loading aborted after string keys
- Cause: An index error occurred during direct-load of an index-organized table.
* Loading had to be aborted. No rows were loaded.
- Action: Check the key just following the number of keys mentioned above.
* This key caused the index problem mentioned in an earlier message. *
- ORA-26033: Direct path operation not supported on table with encrypted colum
- Cause: A direct path operation was attempted on a table with an encrypted
* column.
- Action: Use conventional path load on tables with encrypted columns. *
- ORA-26034: Columnstring does not exist in stream
- Cause: Column specified in the column list does not exist in the stream.
- Action: Make sure the column exists or remove it from the list.
- ORA-26036: subpartition load specified but tablestring is not subpartitioned
- Cause: The Loader control file contains a PARTITION clause but the table being loaded is not subpartitioned.
- Action: Remove the subpartition specification from the SQL*Loader control file and retry the load.
- ORA-26040: Data block was loaded using the NOLOGGING option
- Cause: Trying to access data in block that was loaded without
* redo generation using the NOLOGGING/UNRECOVERABLE option
- Action: Drop the object containing the block.
- ORA-26041: DATETIME/INTERVAL datatype conversion error
- Cause: The column could not be converted from DATETIME
* datatype to internal DATETIME/CHARACTER datatype.
- Action: Contact Oracle Customer Support.
- ORA-26045: REF columnstring expects string arguments; found string.
- Cause: The number of arguments for the REF column is incorrect.
- Action: Specify the correct number of input arguments for REFs.
1. Unscoped system-generated REFs can have exactly 1 or 2 input arguments. a) It has exactly 1 input argument (one for the OID value) if a fixed table name was specified through OCI_DIRPATH_EXPR_REF_TBLNAME. b) It has exactly 2 input arguments (one for the table name and one for the OID value) if a fixed table name was not specified through OCI_DIRPATH_EXPR_REF_TBLNAME.
2. Scoped system-generated REFs can have 1 or 2 input arguments. Because a table name argument is not needed for a scoped ref, only 1 argument (OID value) is expected. But if the table name argument is given, it's still accepted.
3. Scoped primary-key REFs with N columns in its primary-key OID can have N or N+1 input arguments. Because a table name argument is not needed for a scoped ref, only N arguments (making up the OID value) is expected. But if the table name argument is given, it's still accepted.
- ORA-26046: REF columnstring expects scoped table name string; user passed in string.
- Cause: The scoped table name passed in by the user does not match the name in the schema.
- Action: Specify the correct table name for the scoped REF column.
- ORA-26048: Scoped REF column has wrong table name.
- Cause: The scoped table name passed in by the user does not match the name in the schema.
- Action: Specify the correct table name for the scoped REF column.
- ORA-26049: Unscoped REF column has non-existent table name.
- Cause: The table name passed in by the user does not exist in the schema.
- Action: Specify a valid table name for the unscoped REF column.
- ORA-26050: Direct path load of domain index is not supported for this column type.
- Cause: Direct path can not load a domain index of that column type.
- Action: Drop the index and try again or load using conventional path.
- ORA-26051: internal error parsing packed decimal format string
- Cause: A packed decimal field with a non-zero scale factor is mapped to a character column. In order to perform the datatype conversion, a numeric format string must be created based on the input field's precision and scale specifications. Direct path loader encountered an error in creating this format string.
- Action: Examine the packed decimal field's precision and scale specifications and make sure that they contain valid values.
- ORA-26052: Unsupported typenumber for SQL expression on column string.
- Cause: The direct path api does not support a SQL expression on a column of that type.
- Action: Make sure the types are correct.
- ORA-26053: Row was not loaded due to conversion error.
- Cause: The current row was not loaded due to a conversion error.
- Action: Continue with the load anyways. 260xx - 260xx Direct Path API
- ORA-26054: Direct Path Context prepared for a different mode than operation requested.
- Cause: The user prepared the direct path context for one operation (Load, Unload, Convert), but then tried to perform a different operation.
- Action: Make sure the direct path context mode and operation matches.
- ORA-26055: Invalid buffer specified for direct path unload
- Cause: The user specified a zero length or null buffer to be used for the Direct Path Unload operation.
- Action: Specify a valid buffer and length.
- ORA-26056: Can not unload from a view through the direct path.
- Cause: User attempted to unload from a view via the direct path.
- Action: Unload from a normal table.
- ORA-26057: Conversion is not necessary for this direct path stream.
- Cause: User attempted to convert a direct path stream that does not require conversion.
- Action: Load the stream without conversion it.
- ORA-26058: unexpected error fetching metadata for columnstring in table string
- Cause: The direct path API encountered an unexpected error while retrieving metadata for a column.
- Action: Contact Oracle support.
- ORA-26059: Data is too large for columnstring
- Cause: The direct path API encountered a column that can not be loaded because the input data is too large for a column.
- Action: Make the target column larger.
- ORA-26060: Can not convert type identifier for columnstring
- Cause: The direct path API encountered a type identifier for a column that can not be loaded because a mapping can not be found for the input value.
- Action: Verify the input data.
- ORA-26061: Concurrent direct unloads is not allowed.
- Cause: User attempted a direct unload when another is still in progress.
- Action: Complete the current direct unload before starting another.
- ORA-26062: Can not continue from previous errors.
- Cause: User attempted to continue a direct path load after receiving an error which indicates the load can not continue.
- Action: Address the original error that was returned.
- ORA-26063: Can not flashback to specified SCN value - Wrap:string Base: string.
- Cause: User specified an SCN which occurs before the last time the table definition was modified.
- Action: Specify a more recent SCN.
- ORA-26064: Invalid SCN specified - Wrap:string Base: string.
- Cause: User specified an invalid SCN.
- Action: Specify a valid SCN.
- ORA-26076: cannot set or reset value after direct path structure is allocated
- Cause: Client attempted to set or reset the number of rows in a direct path
* structure after it has already been allocated and initialized.
* Attributes used is one of the following:
* - OCI_ATTR_NUM_ROWS: to set # of rows in a direct path column array
* - OCI_ATTR_DIRPATH_DCACHE_SIZE: to set size of a date cache
* (default is 0)
* - OCI_ATTR_DIRPATH_DCACHE_DISABLE: to set whether date cache will be
* disabled on overflow (default is FALSE)
- Action: Set the following attributes before:
* - OCI_ATTR_NUM_ROWS: before calling OCIHandleAlloc for column array
* - OCI_ATTR_DIRPATH_DCACHE_SIZE: before calling OCIDirPathPrepare
* - OCI_ATTR_DIRPATH_DCACHE_DISABLE: before calling OCIDirPathPrepare
- ORA-26077: direct path column array is not initialized
- Cause: Client attempted to allocate a column array for a direct path
* function context before allocating a column array for the
* table-level direct path context.
- Action: Allocate the table-level direct path context's column array
* via OCIHandleAlloc before allocating column arrays for
* direct path function contexts.
- ORA-26078: file "string" is not part of database being loaded
- Cause: A parallel load file was specified which is not part
* of the database.
- Action: Check filename and pathname for correctness.
- ORA-26079: file "string" is not part of tablestring.string
- Cause: A parallel load file was specified which is not in the
* tablespace of the table being loaded.
- Action: Check to make sure that the specified parallel load file
* is in the tablespace of the table being loaded.
- ORA-26080: file "string" is not part of tablestring.string partition string
- Cause: A parallel load file was specified which is not in the
* tablespace of the table (partition, subpartition) being loaded.
* When a partitioned table is being loaded, the file must be
* in the tablespace of every partition or subpartition
* (i.e. each (sub)partition must be in the same tablespace).
- Action: Specify a different parallel load file, or no file at all.
- ORA-26082: load of overlapping segments on tablestring.string is not allowed
- Cause: Client application is attempting to do multiple direct path load
* operations on the same table, but the segments overlap.
- Action: Check the partition names (subname attribute of the direct path
* context) being loaded. Make sure you are not loading a table,
* and a partition of the same table. Make sure you are not
* loading a partition, and a sub-partition within the same
* partition.
- ORA-26083: unsupported direct path stream versionstring
- Cause: The stream version requested is not supported by the server.
- Action: Check to make sure that the VERSION attribute of the direct
* stream is not being set to an invalid value.
- ORA-26084: direct path context already finished
- Cause: An OCIDirPathLoadStream operation was attempted after
* OCIDirPathFinish was called. Once a direct path operaton
* has been finished, no more data can be loaded.
- Action: Check program logic to make sure OCIDirPathLoadStream is
* not called after OCIDirPathFinish.
- ORA-26085: direct path operation must start its own transaction
- Cause: A direct path operation is being attempted within a transaction
* that has already been started.
- Action: Commit the transaction and Prepare the direct path operation again.
- ORA-26086: direct path does not support triggers
- Cause: A direct path operation is being attempted on a table which
* has enabled triggers.
- Action: Disable the triggers on the table and try again.
- ORA-26088: scalar column "string" must be specified prior to LOB columns
- Cause: All scalar columns (i.e. non-LOB and non-LONG columns) must be
* specified by the client of the direct path API prior to
* specifying any LOB columns.
- Action: Specify all scalar columns prior to specifying any LOB columns.
- ORA-26089: LONG column "string" must be specified last
- Cause: A client of the direct path API specified a LONG column to be
* loaded, but the LONG column was not the last column to be
* specified.
- Action: Specify the LONG column last.
- ORA-26090: row is in partial state
- Cause: A direct path operation is being finished or a data save request
* has been made, but the table for which the request is being made
* on has a row in partial state. The row must be completed before
* the segment high water marks can be moved.
- Action: Either complete the row, or abort the direct path operation.
- ORA-26091: requested direct path operation not supported
- Cause: A direct path operation was requested that is not supported
- Action: Do not use that operation. Currently, UNLOAD is not supported.
- ORA-26092: only LONG or LOB types can be partial
- Cause: A column which is not a LONG or LOB had the
* OCI_DIRPATH_COL_PARTIAL flag associated with it.
* Only LONG or LOB type columns can be loaded in pieces.
- Action: Do not use the OCI_DIRPATH_COL_PARTIAL flag for the column.
- ORA-26093: input data column size (number) exceeds the maximum input size (number)
- Cause: The user attempted to specify a column size (%d) that exceeded
* the maximum allowable input size (%d)."
- Action: Make sure the input column metadata matches the column definition.
- ORA-26094: stream format error: input column overflow
- Cause: An input stream contained data for more input columns
* than specified by the client of the direct path API.
- Action: Make sure that the stream being loaded is for the
* correct table. Check initialization sequence.
- ORA-26095: unprocessed stream data exists
- Cause: Either a OCIDirPathLoadStream call was made which provided
* more stream data prior to the server being able to fully
* process the stream data that it already has, or a
* OCIDirPathFinish call was made when the server had
* unprocessed stream data.
- Action: Most likely an application mis-use of the direct path API.
* Make sure that the stream is not being reset inadvertently
* prior to any previous stream data being processed, or, that
* OCIDirPathFinish is not being called prematurely (i.e. stream
* pushed, error encountered and LoadStream not called to process
* the remainder of the stream before Finish is called.)
- ORA-26096: transfer size too small for row data (number bytes required)
- Cause: Either the transfer buffer size specified, or the default
* transfer buffer size (if you did not specify a size), is
* too small to contain a single row of the converted row data.
- Action: Set the transfer buffer size attribute of the direct path
* context to be larger.
- ORA-26097: unsupported conversion for columnstring (from type number to type number)
- Cause: The direct path api does not support the required conversion.
- Action: Make sure the types are correct. *
- ORA-26098: direct path context is not prepared
- Cause: A direct path api function was called with a direct path
* context which has not been prepared.
- Action: Make sure all necessary attributes in the direct path
* context have been set, and the context is prepared via
* OCIDirPathPrepare.
- ORA-26099: direct path context is already prepared
- Cause: OCIDirPathPrepare was called with a context that has already
* been prepared.
- Action: Free the direct path context, set necessary attributes, and
* call OCIDirPathPrepare.
- ORA-26101: tablespace # in file header isstring rather than string for file string
- Cause: The tablespace number in the file header is inconsistent with that in the control file.
- Action: Check if the control file has been migrated correctly. Retry with the correct control file and data file.
- ORA-26102: relative file # in file header isstring rather than string for file string
- Cause: The relative file number in the file header is inconsistent with that in the control file.
- Action: Check if the control file has been migrated correctly. Retry with the correct control file and data file.
- ORA-26103: V6 or V7 data file used to create control file
- Cause: The file header of the referenced file is in V6 or V7 format.
- Action: Either remove the file from the create control file command, or somehow migrate the file header to V8 format.
- ORA-26500: error on caching "string"."string"
- Cause: Attempt to cache the replication information which is unavailable in the catalog for the object.
- Action: Use dbms_reputil.sync_up_rep to validate the replication catalog, or use dbms_reputil.make_internal_pkg to validate internal package.
- ORA-26501: RepAPI operation failure
- Cause: An external RepAPI operation failed.
- Action: consult detail error message.
- ORA-26502: error resignal
- Cause: An internal service failed and signalled an error"
- Action: consult detail error message.
- ORA-26503: internal RepAPI operation failure on objectstring.string
- Cause: An unexpected internal RepAPI failure was detected
- Action: Contact Oracle support.
- ORA-26504: operation not implemented
- Cause: The caller requested a RepAPI operation that was not implemented
- Action: Do not issue this call.
- ORA-26505: unexpected internal null
- Cause: An internal buffer control structure was NULL
- Action: Verify that sufficient memory resources are available to RepAPI.
- ORA-26506: null global context
- Cause: An internal buffer control structure was NULL
- Action: Verify that sufficient memory resources are available to RepAPI.
- ORA-26507: null master connection
- Cause: The master connection handle was or became invalid.
- Action: Verify that the master connection is valid.
- ORA-26508: null materialized view connection
- Cause: The client connection handle was or became invalid.
- Action: Verify that the client connection is valid.
- ORA-26509: null materialized view control structure
- Cause: An internal materialized view control structure could not be obtained.
- Action: Check that the owner and users provided are correct.
- ORA-26510: materialized view name: 'string' is greater than max. allowed length ofstring bytes
- Cause: The specified materialized view name was too long.
- Action: Shorten the materialized view name.
- ORA-26511: master table 'string.string' not found
- Cause: A RepAPI operation was attempted against a non-existent or invalid master table
- Action: Verify that the master table object exists.
- ORA-26512: error pushing transaction to def$error
- Cause: An unexpected error occurred while sending an def$error rpc to the master site
- Action: Verify that the DBMS_DEFER package is valid and executable by the RepAPI client. Contact the local or master site administrator, if necessary.
- ORA-26513: push error: master proc.string$RP.string failed for trans:string seq:string
- Cause: A conflict/error occurred at the master site while executing a $RP.rep_insert(), rep_update(), or rep_delete() function which was not handled by conflict resolution logic at the master.
- Action: Notify master site system adminstrator or DBA.
- ORA-26514: object 'string.string' not found
- Cause: The specified object was expected but not found.
- Action: Verify that the specified object exists and is valid.
- ORA-26515: no master log available for 'string.string'
- Cause: The specified master log was not found or available for the named table.
- Action: Create the master log at the master site or correct any problems that may exist with the log.
- ORA-26516: no push transaction acknowledgement
- Cause: RepAPI was unable to confirm that the last pushed transaction was successfully commited by the master site.
- Action: Verify that the communications link between the local site and the master site is still valid. If the transaction has not been committed at the master, repush the transaction.
- ORA-26517: materialized view control entry for 'string.string' was not found
- Cause: The specified materialized view catalog control reocrd was not found.
- Action: Verify that the local materialized view catalog is valid and that the local materialized view is properly defined.
- ORA-26518: push queue synchronization error detected
- Cause: Client tried to repush a transaction has already been committed at the master site. A common cause of this problem is an error at the local site in initializing or updating the local site transaction sequence mechanism.
- Action: Verify that transaction data that RepAPI was attempting to repushed to the master site exists at the master table and is valid and consistent with the local site. If this error occurs, redundantly identified transactions are ignored and then purged from the local updatable materialized view logs. Check that the local site is correctly assigning new transactionIDs and is not accidently generating non-unique values.
- ORA-26519: no memory available to allocate
- Cause: There was no memory left for the RepAPI process. This error may occur when RepAPI is trying to allocate a new table buffer area.
- Action: Shutdown one or more local applications to attempt to free heap memory and retry the RepAPI operation.
- ORA-26520: internal memory failure
- Cause: An internal memory error was detected.
- Action: Check if other errors have occurred or determine if any local application may have corrupted the memory subsystem.
- ORA-26521: rpc initialization error
- Cause: An error occurred during the initialization of a PL/SQL rpc.
- Action: Verify that the procudure to be invoked exists and is valid at the master site and is executable by the RepAPI user.
- ORA-26522: rpc execution error
- Cause: An error occurred during the execution of a PL/SQL rpc.
- Action: Check the error messages from the remote procedure and fix any remote site problems that may be preventing the execution of the invoked rpc.
- ORA-26523: rpc termination error
- Cause: An error occurred during the termination of a PL/SQL rpc. This is usually caused by master site being unable to close an opened cursor or if RepAPI cannot deallocate internal memory.
- Action: Fix any server side problems first, determine if the RepAPI memory subsystem has been corrupted.
- ORA-26524: nls subsystem initialization failure for product=string, facility=string
- Cause: The NLS product/facility error message file could not be located or properly initialized.
- Action: Check that the error message directory and file(s) have been properly installed.
- ORA-26525: session connection attempt failed forstring (@string)
- Cause: A connection could not be established to the specified database using the provided connection string.
- Action: Check that the user, password, connect string, names services, network, and any remote site listener process are properly installed and working.
- ORA-26526: materialized view sql ddl parse/expansion failed forstring.string
- Cause: The client sql materialized view definition query could not be properly parsed by the master Oracle site.
- Action: Check that materialized view ddl sql is compatible with the currently connected version of Oracle and does not violate any of the RepAPI sql limitations or restrictions.
- ORA-26527: local store callback init phase failed for 'string.string'
- Cause: The client callback failed during its INIT phase for the named object.
- Action: Verify that the objects referenced by the client callback exist and are valid. Refer to the vendor-specific callback error code reference to diagnose the local problem. Record all error state and notify Oracle support.
- ORA-26528: local store callback proc phase failed for 'string.string'
- Cause: The client callback failed during its PROC phase for the named object.
- Action: Refer to the vendor-specific callback error code reference to diagnose the local problem. Record all error state and notify Oracle support.
- ORA-26529: local store callback term phase failed for 'string.string'
- Cause: The client callback failed during its TERM phase for the named object.
- Action: Refer to the vendor-specific callback error code reference to diagnose the local problem. Record all error state and notify Oracle support.
- ORA-26530: unable to build materialized view refresh control list
- Cause: The materialized view control list could not be constructed. This is generally the result of an error while accessing the local materialized view catalog.
- Action: Verify that the named materialized view(s) are properly defined and valid.
- ORA-26532: replication parallel push simulated site failure
- Cause: A parallel push executed with event 26531 enabled raises this error to simulation failure of network or destination site.
- Action: Do not enable the event for normal operation.
- ORA-26534: collision: tranIDnumber ignored and purged
- Cause: A transaction that was pushed had a transaction ID that collided with a transaction that was previously pushed and committed at the master site.
- Action: See the action section for E_QUEUESYNC (26518).
- ORA-26535: %ud byte row cache insufficient for table with rowsize=number
- Cause: A transaction that was pushed had a transaction ID that collided with a transaction that was previously pushed and committed at the master site.
- Action: Increase the RepAPI row buffer size or reduce the width of the replicated tables.
- ORA-26536: refresh was aborted because of conflicts caused by deferred transactions
- Cause: There are outstanding conflicts logged in the DEFERROR table at the materialized view's master site.
- Action: Resolve the conflicts in the master DEFERROR table and refresh again after the table is empty. Alternatively, refresh with REFRESH_AFTER_ERRORS, even if there are conflicts in the master's DEFERROR table. Proceeding despite conflicts can result in an updatable materialized view's changes appearing to be temporarily lost, until a refresh succeeds after the conflicts are resolved.
- ORA-26563: renaming this table is not allowed
- Cause: Attempt to rename a replicated table, an updatable materialized view table or the master table of a materialized view for which a materialized view log has beencreated.
- Action: If desired, unregister the replicated table with dbms_repcat.drop_master_repobject, or use the recommended procedure to rename the master table of a materialized view.
- ORA-26564: %s argument is not of specified type
- Cause: User passed type of the given argument number doesn't match with the type of the argument in the stored arguments.
- Action: Invoke correct type procedure (i.e. get_XXX_arg)
- ORA-26565: Call to <type>_arg made before calling dbms_defer.call
- Cause: User invoked <type>_arg procedure before starting a deferred call
- Action: Invoke various procedures in the correct order.
- ORA-26566: Couldn't open connect tostring
- Cause: Failed to open connection using given dblink
- Action: Make sure that the dblink is valid and remote m/c is up.
- ORA-26571: %s.string.string: number of arguments (string) does not match replication catalog
- Cause: number of arguments does not match replication catalog
- Action: examine total number of arguments for the rpc call
- ORA-26572: %s.string.string: argumentstring does not match replication catalog
- Cause: the (rpc) call is corrupted
- Action: examine total number of arguments and each argument for the rpc call
- ORA-26575: remote database does not support replication parallel propagation
- Cause: The remote database has a version lower than Oracle 8.0 and hence does not understand replication parallel propagation.
- Action: Use serial propagation or upgrade the remote database to Oracle 8.0 or above.
- ORA-26576: cannot acquire SR enqueue
- Cause: An attempt to acquire the SR enqueue in exclusive mode failed.
- Action: none
- ORA-26577: PRESERVE TABLE can not be used when dropping old style materialized viewstring.string
- Cause: The materialized view consists of a view and a container table.
- Action: Drop the materialized view without PRESERVE TABLE option.
- ORA-26650: %s background processstring might not be started successfully
- Cause: An error occurred during creation of a capture or apply background process.
- Action: Please review V$Capture and V$Apply_coordinator views for the status of these processes. Please also check the trace file for more information.
- ORA-26660: Invalid action context value forstring
- Cause: The value specified in the action context is invalid for use in STREAMS.
- Action: Check that the type and value are correct.
- ORA-26662: unable to process STREAMS Data Dictonary information for object
- Cause: The database is unable to process STREAMS Data Dictionary for this object.
- Action: Check that the compatibility for the database supports the object, and check the trace file for information about the object.
- ORA-26663: error queue for apply processstring must be empty
- Cause: The error queue for this apply process contains error entries.
- Action: Execute or delete errors in the error queue.
- ORA-26664: cannot create STREAMS processstring
- Cause: An attempt was made to create a STREAMS process when another was being created concurrently.
- Action: Wait for the creation of the other STREAMS process to finish before attempting to create the STREAMS process.
- ORA-26665: STREAMS processstring already exists
- Cause: An attempt was made to create a STREAMS process that already exists.
- Action: Either specify another STREAMS process or remove the existing STREAMS process.
- ORA-26666: cannot alter STREAMS processstring
- Cause: An attempt was made to alter a STREAMS process that is currently running.
- Action: Stop the STREAMS process and reissue the command.
- ORA-26667: invalid STREAMS parameterstring
- Cause: An attempt was made to specify an invalid parameter.
- Action: Check the documentation for valid parameters.
- ORA-26668: STREAMS processstring exists
- Cause: An attempt to remove the component failed because it is associated with the STREAMS process.
- Action: Either remove the process manually or specify the "cascade" option in dbms_streams_adm.remove_queue.
- ORA-26669: parameterstring inconsistent with parameter string
- Cause: An attempt was made to specify a subprogram parameter value that is inconsistent with another parameter value.
- Action: Check the documentation for valid parameter values.
- ORA-26670: STREAMS option requires COMPATIBLE parameter to bestring or higher
- Cause: Streams requires compatibility to be 9.2.0 or higher.
- Action: Shut down and restart with an appropriate compatibility setting.
- ORA-26671: maximum number of STREAMS processes exceeded
- Cause: Cannot create additional STREAMS processes since the maximum number of STREAMS processes has been reached.
- Action: Remove existing STREAMS processes and retry the operation.
- ORA-26672: timeout occurred while stopping STREAMS processstring
- Cause: Timeout occurred while waiting for a STREAMS process to shut down.
- Action: Retry the operation. If the error persists, try stopping the process with the FORCE option, or contact Oracle Support Services.
- ORA-26675: cannot create Streams capture processstring
- Cause: Streams capture process could not be created because one or more parameters contain invalid value.
- Action: Refer to trace file for more details.
- ORA-26677: Streams downstream capture processstring cannot proceed
- Cause: Database global name has been set to a value which is same as the source database name of the downstream capture process.
- Action: Change database global name to a value other than the source database name for the downstream capture.
- ORA-26678: Streams capture process must be created first
- Cause: Must create Streams capture process before attempting this operation.
- Action: Create a Streams capture process, then retry the operation.
- ORA-26679: operation not allowed on LOB or LONG columns in LCR
- Cause: Certain operations on LOB/LONG columns of the LCR through rule-based transformations, DML handlers, or error handlers were not allowed.
- Action: Do not perform restricted operations on LOB or LONG columns in LCRs. See the documentation for operations that are restricted on LOB/LONG columns in LCRs.
- ORA-26680: object type not supported
- Cause: The specified object type is not supported.
- Action: Retry with a supported object type.
- ORA-26681: command type not supported
- Cause: The specified command type is not supported.
- Action: Retry with a supported command type.
- ORA-26682: invalid value for publication_on
- Cause: The publication_on parameter should be either 'Y' or 'N'
- Action: Retry with a proper value for publication_on.
- ORA-26683: invalid value for value_type
- Cause: The value_type parameter should be either 'OLD' or 'NEW'
- Action: Retry with proper value_type.
- ORA-26684: invalid value for value_type
- Cause: The value_type parameter should be one of 'OLD', 'NEW' or '*'
- Action: Retry with proper value_type.
- ORA-26685: cannot apply transactions from multiple sources
- Cause: Transactions from multiple sources were sent to the same apply process.
- Action: Create multiple apply processes and create appropriate rules so that transactions from only one source reach an apply process.
- ORA-26686: cannot capture from specified SCN
- Cause: An attempt was made to specify an invalid SCN.
- Action: Retry with a valid SCN.
- ORA-26687: no instantiation SCN provided for "string"."string" in source database "string"
- Cause: Object SCN was not set. If the object is a table, then both fields will be filled, for example "SCOTT"."EMP". If the object is a schema, only one field will be set, for example "SCOTT"."". And if the object is the entire database, no fields will be set, for example ""."".
- Action: Set the SCN by calling DBMS_APPLY_ADM.SET_%_INSTANTIATION_SCN
- ORA-26688: missing key in LCR
- Cause: Metadata mismatch, or not enough information in the user generated LCR.
- Action: Alter the database object, or provide all defined keys in the LCR.
- ORA-26689: column datatype mismatch in LCR
- Cause: The datatypes of columns in the LCR are not the same as the datatypes in the database object.
- Action: Alter the database object.
- ORA-26690: datatype not supported at non-Oracle system
- Cause: One of the columns of the LCR being applied was of a datatype not supported by either the target non-Oracle system or by the Oracle transparent gateway through which the apply is being done.
- Action: Do not apply data of this type. If possible, filter out columns containing such datatypes before applying.
- ORA-26691: operation not supported at non-Oracle system
- Cause: The apply process attempted an operation that is either not supported by the non-Oracle system or by the Oracle transparent gateway through which the apply is being done. Some kinds of DML (like procedure and function calls) and all DDL will cause this error to be raised.
- Action: Do not attempt to apply such LCRs to non-Oracle systems. If possible, filter out such LCRs before applying.
- ORA-26692: invalid valuestring, string should be in string format
- Cause: The parameter specified was not in the correct format.
- Action: Specify the parameter value in the correct format.
- ORA-26693: STREAMSstring process dropped successfully, but error occurred while dropping rule setstring
- Cause: An attempt to drop an unused rule set failed after dropping the STREAMS proccess successfully.
- Action: Check existence of rule set and manually drop if necessary.
- ORA-26694: error while enqueueing into queuestring.string
- Cause: An error occurred while enqueueing a message.
- Action: If the situation described in the next error on the stack can be corrected, do so.
- ORA-26695: error on call tostring: return code string
- Cause: A locking related call failed.
- Action: Try the call again after fixing the condition indicated by the return code.
- ORA-26696: no streams data dictionary for object with numberstring and version number string from source database string
- Cause: An attempt to access the database object failed because the data dictionary for the object was either never populated or it was purged.
- Action: Make sure the streams data dictionary is created by calling DBMS_CAPTURE_ADM.PREPARE_%_INSTANTIATION.
- ORA-26698: %s did not have astring rule set
- Cause: The STREAMS client does not have a rule set of the indicated type.
- Action: Verify that the Streams client has a rule set of the specified type, and retry the operation.
- ORA-26699: STREAMS message consumerstring already exists
- Cause: An attempt was made to create a STREAMS message consumer that already exists.
- Action: Either specify another STREAMS message consumer or remove the existing STREAMS message consumer.
- ORA-26701: STREAMS processstring does not exist
- Cause: An attempt was made to access a STREAMS process which does not exist.
- Action: Check with the relevant security views for the correct name of the object.
- ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded
- Cause: An attempt was made to downgrade a capture process after it has upgraded the Streams data dictionary.
- Action: Drop the capture process before attempting the downgrade.
- ORA-26706: cannot downgrade capture process
- Cause: An attempt was made to downgrade a capture process that has a higher version than the downgrade release version.
- Action: Drop the capture process after capture has finished consuming all the redo logs before attempting the downgrade.
- ORA-26708: remote DDL not supported by STREAMS : dblinkstring
- Cause: The apply process attempted to apply a DDL LCR via a dblink. This is not supported.
- Action: Do not attempt to apply DDL LCRs via a dblink. If possible, filter out DDL LCRs before applying.
- ORA-26710: incompatible version marker encountered during Capture
- Cause: Capture process cannot mine redo from a version higher than the current software release version.
- Action: Drop and recreate the capture process.
- ORA-26711: remote table does not contain a primary key constraint
- Cause: The master table for remote apply does not constain a primary key constraint or the primary key constraint has been disabled.
- Action: Create a primary key constraint on the master table or enable the existing constraint.
- ORA-26712: remote object is "string"."string"\@"string"
- Cause: See the preceding error message to identify the cause. This message names the remote object, usually a table or view, for which an error occurred when Streams tried to access it for remote apply.
- Action: See the preceding error message.
- ORA-26713: remote object does not exist or is inaccessible
- Cause: Streams replication could not access the named table or view at a remote database to apply changes.
- Action: Confirm that the given remote table or view exists and is accessible through the given database link. When using a Heterogeneous Services database link to access a non-Oracle system, it may be necessary to check administration details for network connections at the non-Oracle system.
- ORA-26714: User error encountered while applying
- Cause: An error was encountered while applying.
- Action: Query the dba_apply_error view to determine the error and take the appropriate action.
- ORA-26715: time limit reached
- Cause: The specified time limit was reached for the STREAMS process.
- Action: Restart the STREAMS process, increasing the TIME_LIMIT parameter if necessary.
- ORA-26716: message limit reached
- Cause: The specified message limit was reached for the Capture process.
- Action: Restart the Capture process, increasing the MESSAGE_LIMIT parameter if necessary.
- ORA-26717: SCN limit reached
- Cause: The specified SCN limit was reached for the STREAMS process.
- Action: Change the MAXIMUM_SCN parameter, then restart the STREAMS process.
- ORA-26718: transaction limit reached
- Cause: The specified transaction limit was reached for the Apply process.
- Action: Restart the Apply process, increasing the TRANSACTION_LIMIT parameter if necessary.
- ORA-26721: enqueue of the LCR not allowed
- Cause: An apply process attempted to enqueue an LCR with a LONG column. This is not supported.
- Action: Modify rules or unset the enqueue destination to prevent LCRs with LONG columns from being enqueued by the apply process.
- ORA-26723: user "string" requires the role "string"
- Cause: The user was not granted the specified role required to proceed.
- Action: Grant the specified role to the user.
- ORA-26724: only SYS is allowed to set the Capture or Apply user to SYS.
- Cause: The Capture or Apply user was specified as SYS by a user other than SYS.
- Action: Set SYS as the Capture or Apply user while logged in as SYS.
- ORA-26725: cannot downgrade apply handlers
- Cause: An attempt was made to downgrade apply handlers that are not associated with a local database object, or the apply handlers are associated with a specific apply process.
- Action: Drop the associated apply handlers before attempting the downgrade.
- ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
- Cause: sbtinit returned an error, additional information indicates error
- Action: verify that vendor's storage subsystem product is operating correctly
- ORA-27001: unsupported device type
- Cause: the specified device type is supported on this platform
- Action: check V$BACKUP_DEVICE for supported device types
- ORA-27002: function called with invalid device structure
- Cause: internal error, aditional information indicates which function encountered error
- Action: check for trace file and contact Oracle Support
- ORA-27003: cannot open file on device allocated with NOIO option
- Cause: internal error, a file is being created/retrieved on a device allocated with NOIO option, additional information indicates which function encountered error
- Action: check for trace file and contact Oracle Support
- ORA-27004: invalid blocksize specified
- Cause: internal error, blocksize specified is incorrect for the device on which file is being created, aditional information indicates blocksize specified, and the function that encountered the error
- Action: check for trace file and contact Oracle Support
- ORA-27005: cannot open file for async I/O on device not supporting async
- Cause: internal error, a file is being opened for async I/O on a device that does not support async I/O, additional information indicates which function encountered error
- Action: check for trace file and contact Oracle Support
- ORA-27006: sbtremove returned error
- Cause: additional information indicates error returned by sbtremove, and the function that encountered the error
- Action: verify that vendor's storage subsystem product is operating correctly
- ORA-27007: failed to open file
- Cause: sbtopen returned error, additional information indicates error returned from sbtopen, and the function that encountered the error
- Action: verify that vendor's storage subsystem product is operating correctly
- ORA-27008: function called with invalid file structure
- Cause: internal error, aditional information indicates which function encountered error
- Action: check for trace file and contact Oracle Support
- ORA-27009: skgfwrt: cannot write to file opened for read
- Cause: internal error
- Action: check for trace file and contact Oracle Support
- ORA-27010: skgfwrt: write to file failed
- Cause: sbtwrite returned error, additional information indicates error returned from sbtwrite
- Action: verify that vendor's storage subsystem product is operating correctly
- ORA-27011: skgfrd: cannot read from file opened for write
- Cause: internal error
- Action: check for trace file and contact Oracle Support
- ORA-27012: skgfrd: read from file failed
- Cause: sbtread returned error, additional information indicates error returned from sbtread
- Action: verify that vendor's storage subsystem product is operating correctly
- ORA-27013: skgfqdel: cannot delete an open file
- Cause: internal error
- Action: check for trace file and contact Oracle Support
- ORA-27014: skgfqpini: translation error while expanding SS_UDMPDIR
- Cause: Failure of sltln in skgfqpini
- Action: Check additional return error for more information.
- ORA-27015: skgfcls: failed to close the file
- Cause: sbtclose returned error, additional information indicates error returned from sbtclose
- Action: verify that vendor's storage subsystem product is operating correctly
- ORA-27016: skgfcls: sbtinfo returned error
- Cause: additional information indicates error returned from sbtinfo
- Action: verify that vendor's storage subsystem product is operating correctly
- ORA-27017: skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)
- Cause: media handle string length exceeds SSTMXQMH
- Action: verify that vendor's storage subsystem product is operating correctly, and that the platform limit (SSTMXQMH) is atleast 64 (the limit specified for sbtinfo). additional information indicates the media handle string length returned by sbtinfo, and the limit (SSTMXQMH)
- ORA-27018: BLKSIZE is not a multiple of the minimum physical block size
- Cause: User-specified BLKSIZE (blocking factor) is not a multiple of the minimum block size that is permitted on this platform.
- Action: Two ADDITIONAL INFORMATION messages are displayed which show the blocking factor provided by the user and the minimum physical block size. Specify a BLKSIZE that is an integral multiple of the minimum block size.
- ORA-27019: tape filename length exceeds limit (SBTOPMXF)
- Cause: length of tape filename provided to sequential I/O OSD functions is too long
- Action: additional information indicates in which function this error is encountered, the length of filename provided, and the limit on filename
- ORA-27020: named devices not supported
- Cause: the platform or the specified device type does not support named devices
- Action: do not specify device name or use a device type that supports named devices. Use V$BACKUP_DEVICE view to see what device types and names (if any) are available.
- ORA-27021: sequential file handle must be specified
- Cause: The filename which will be passed to sbtopen was not specified.
- Action: Specify a filename and continue. If this is a backup set being created via Recovery Manager, use the 'format' option to specify the backup piece handle name.
- ORA-27022: skgfqsbi: could not allocate memory for media manager
- Cause: Oracle could not allocate memory required by the media management software which is linked with Oracle to provide backup/restore services.
- Action: Increase the amount of memory available to the Oracle process and retry the backup/restore.
- ORA-27023: skgfqsbi: media manager protocol error
- Cause: The media management software which is linked with Oracle to provide backup/restore services did not provide its function pointer structure to Oracle.
- Action: This is an internal error in the media management product. Contact the media management vendor.
- ORA-27024: skgfqsbi: sbtinit2 returned error
- Cause: sbtinit2 returned an error. This happens during a backup or restore operation.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27025: skgfqsbi: invalid media manager context area size
- Cause: The media management software requested a context area size which is greater than the maximum allowable size.
- Action: This is an internal error in the media management product. Contact the media management vendor.
- ORA-27026: skgfrls: sbtend returned error
- Cause: sbtend returned an error. This happens during a backup or restore operation.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27027: sbtremove2 returned error
- Cause: sbtremove2 returned an error. This happens when deleting a backup file.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27028: skgfqcre: sbtbackup returned error
- Cause: sbtbackup returned an error. This happens when creating a backup file during a backup operation.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27029: skgfrtrv: sbtrestore returned error
- Cause: sbtrestore returned an error. This happens when retrieving a backup file during a restore operation.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27030: skgfwrt: sbtwrite2 returned error
- Cause: sbtwrite2 returned an error. This happens while writing a backup file during a backup operation.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27031: mirror resilvering functions not supported
- Cause: internal error
- Action: check for trace file and contact Oracle Support
- ORA-27032: failed to obtain file size limit
- Cause: getrlimit system call returned an error
- Action: check errno
- ORA-27033: failed to obtain file size limit
- Cause: ulimit system call returned an error
- Action: check errno
- ORA-27034: maximum length of ORACLE_SID exceeded
- Cause: too many characters in the ORACLE_SID string
- Action: rename the ORACLE_SID to a string of up to the maximum number of characters specified for your system
- ORA-27035: logical block size is invalid
- Cause: logical block size for oracle files must be a multiple of the physical block size, and less than the maximum
- Action: block size specified is returned as additional information, check init.ora parameters, additional information also indicates which function encountered the error
- ORA-27036: translation error, unable to expand file name
- Cause: additional information indicates sltln/slnrm error, and also indicates which function encountered the error
- Action: check additional information
- ORA-27037: unable to obtain file status
- Cause: stat system call returned an error, additional information indicates which function encountered the error
- Action: check errno
- ORA-27038: created file already exists
- Cause: trying to create a database file, but file by that name already exists
- Action: verify that name is correct, specify reuse if necessary
- ORA-27039: create file failed, file size limit reached
- Cause: an attempt was made to create a file that exceeds the process's file size limit, additional information indicates which function encountered the error
- Action: raise the file size limit
- ORA-27040: file create error, unable to create file
- Cause: create system call returned an error, unable to create file
- Action: verify filename, and permissions
- ORA-27041: unable to open file
- Cause: open system call returned an error, additional information indicates which function encountered the error
- Action: check errno
- ORA-27042: not enough space on raw partition to fullfill request
- Cause: internal error, file too large for raw partition, additional information indicates which function encountered the error
- Action: check for trace file and contact Oracle Support
- ORA-27043: unable to seek to beginning of file
- Cause: seek system call failed, additional information indicates which function encountered the error
- Action: check errno
- ORA-27044: unable to write the header block of file
- Cause: write system call failed, additional information indicates which function encountered the error
- Action: check errno
- ORA-27045: unable to close the file
- Cause: close system call failed, additional information indicates which function encountered the error
- Action: check errno
- ORA-27046: file size is not a multiple of logical block size
- Cause: file size as indicated by stat is not correct, additional information indicates which function encountered the error
- Action: verify that the file has not been overwritten or truncated
- ORA-27047: unable to read the header block of file
- Cause: read system call failed, additional information indicates which function encountered the error
- Action: check errno
- ORA-27048: skgfifi: file header information is invalid
- Cause: possibly trying to use a non-database file as a database file
- Action: verify that file is a database file
- ORA-27049: unable to seek to and read the last block
- Cause: an attempt was made to seek to and read the last block in file, additional information indicates which function encountered error
- Action: check errno
- ORA-27050: function called with invalid FIB/IOV structure
- Cause: internal error, aditional information indicates which function encountered error
- Action: check for trace file and contact Oracle Support
- ORA-27052: unable to flush file data
- Cause: fsync system call returned error, additional information indicates which function encountered the error
- Action: check errno
- ORA-27053: blocksize in file header not a multiple of logical block size
- Cause: the logical block size is invalid, additional information indicates the logical block size and the blocksize in the file header
- Action: use a different logical block size, or do not reuse file
- ORA-27056: could not delete file
- Cause: unlink system call returned error
- Action: check errno
- ORA-27057: cannot perform async I/O to file
- Cause: internal error, query is being asked about async vector I/O when the file does not support async I/O
- Action: check for trace file and contact Oracle Support
- ORA-27058: file I/O question parameter is invalid
- Cause: internal error, invalid query is being asked
- Action: check for trace file and contact Oracle Support
- ORA-27059: could not reduce file size
- Cause: ftruncate system call returned error
- Action: check errno
- ORA-27060: could not set close-on-exec bit on file
- Cause: fcntl system call returned error
- Action: check errno
- ORA-27061: waiting for async I/Os failed
- Cause: aiowait function returned error
- Action: check errno
- ORA-27062: could not find pending async I/Os
- Cause: There should have been some async I/Os in the system but a blocking aiowait indicates that there are no more I/Os. It could be either because of an Oracle bug or the vendor OS bug or due to a NFS server not responding
- Action: check Oracle trace file, OS message files and contact Oracle Support
- ORA-27063: number of bytes read/written is incorrect
- Cause: the number of bytes read/written as returned by aiowait does not match the original number, additional information indicates both these numbers
- Action: check errno
- ORA-27064: cannot perform async I/O to file
- Cause: internal error, asked to perform async I/O when IOV indicates that it cannot be performed on the file
- Action: check for trace file and contact Oracle Support
- ORA-27065: cannot perform async vector I/O to file
- Cause: internal error, asked to perform async vector I/O when it cannot be performed on the file
- Action: check for trace file and contact Oracle Support
- ORA-27066: number of buffers in vector I/O exceeds maximum
- Cause: internal error, number of buffers in vector I/O exceeds maximum allowed by the OSD, additional information indicates both these numbers
- Action: check for trace file and contact Oracle Support
- ORA-27067: size of I/O buffer is invalid
- Cause: internal error, buffer size is either 0, or greater than SSTIOMAX or not a multiple of logical block size, additional information indicates where in function the error was encountered and the buffer size
- Action: check for trace file and contact Oracle Support
- ORA-27068: I/O buffer is not aligned properly
- Cause: internal error, buffer is not aligned to SSIOALIGN boundary, additional information indicates where in function the error was encountered and the buffer pointer
- Action: check for trace file and contact Oracle Support
- ORA-27069: attempt to do I/O beyond the range of the file
- Cause: internal error, the range of blocks being read or written is outside the range of the file, additional information indicates the starting block number, number of blocks in I/O, and the last valid block in the file
- Action: check for trace file and contact Oracle Support
- ORA-27070: async read/write failed
- Cause: aioread/aiowrite system call returned error, additional information indicates starting block number of I/O
- Action: check errno
- ORA-27071: unable to seek to desired position in file
- Cause: lseek system call returned error, additional information indicates block number in file to which seek was attempted
- Action: check errno
- ORA-27072: File I/O error
- Cause: read/write/readv/writev system call returned error, additional information indicates starting block number of I/O
- Action: check errno
- ORA-27073: Trying to close a file which has async I/Os pending to be dequeued
- Cause: internal error, the file is being closed but not all async I/Os to the file have been dequeued, additional information indicates number of I/Os pending on the file
- Action: check for trace file and contact Oracle Support
- ORA-27074: unable to determine limit for open files
- Cause: The getrlimit() system call returned an error.
- Action: Check errno.
- ORA-27075: SSTMOFRC constant too large
- Cause: internal error
- Action: check for trace file and contact Oracle Support
- ORA-27076: unable to set limit for open files
- Cause: The setrlimit() system call returned an error.
- Action: Check errno.
- ORA-27077: too many files open
- Cause: internal error, the number of files opened through skgfofi has reached the limit
- Action: Check for trace file and contact Oracle Support.
- ORA-27078: unable to determine limit for open files
- Cause: The getrlimit() system call returned an error.
- Action: Check errno.
- ORA-27080: too many files open
- Cause: The number of files opened has reached the system limit.
- Action: Check the error, and set system configuration values.
- ORA-27081: unable to close the file
- Cause: The close() system call failed.
- Action: Check errno.
- ORA-27083: waiting for async I/Os failed
- Cause: The aio_waitn() library call returned an error.
- Action: Check errno.
- ORA-27084: unable to get/set file status flags
- Cause: The fcntl() system call with F_GETFL/F_SETFL flag returned an error.
- Action: Check errno.
- ORA-27086: unable to lock file - already in use
- Cause: the file is locked by another process, indicating that it is currently in use by a database instance.
- Action: determine which database instance legitimately owns this file.
- ORA-27087: unable to get share lock - file not readable
- Cause: share lock request was made on a file not open for read access.
- Action: file must be open read-only or read-write to get a share lock.
- ORA-27088: unable to get file status
- Cause: file not open or file descriptor is invalid.
- Action: none
- ORA-27089: unable to release advisory lock
- Cause: release of file lock failed
- Action: see errno
- ORA-27091: unable to queue I/O
- Cause: read/write/readv/writev system call returned error, additional information indicates starting block number of I/O
- Action: check errno
- ORA-27092: size of file exceeds file size limit of the process
- Cause: an attempt was made to open a file that exceeds the process's file size limit (ulimit), additional information shows the current limit (logical blocks) and the size of the file (logical blocks)
- Action: increase the processes file size limit (ulimit) and retry
- ORA-27093: could not delete directory
- Cause: rmdir system call returned error
- Action: check errno
- ORA-27094: raw volume cannot be used
- Cause: A raw device with VTOC information was provided as a database file.
- Action: Make sure the disk partition that is provided to Oracle does not start at sector 0
- ORA-27100: shared memory realm already exists
- Cause: Tried to start duplicate instances, or tried to restart an instance that had not been properly shutdown
- Action: Use a different instance name, or cleanup the failed instance's SGA
- ORA-27101: shared memory realm does not exist
- Cause: Unable to locate shared memory realm
- Action: Verify that the realm is accessible
- ORA-27102: out of memory
- Cause: Out of memory
- Action: Consult the trace file for details
- ORA-27103: internal error
- Cause: internal error
- Action: contact Oracle support
- ORA-27120: unable to removed shared memory segment
- Cause: shmctl() call failed
- Action: check permissions on segment, contact Oracle support
- ORA-27121: unable to determine size of shared memory segment
- Cause: shmctl() call failed
- Action: check permissions on segment, contact Oracle support
- ORA-27122: unable to protect memory
- Cause: mprotect() call failed
- Action: contact Oracle support
- ORA-27123: unable to attach to shared memory segment
- Cause: shmat() call failed
- Action: check permissions on segment, contact Oracle support
- ORA-27124: unable to detach from shared memory segment
- Cause: shmdt() call failed
- Action: contact Oracle support
- ORA-27125: unable to create shared memory segment
- Cause: shmget() call failed
- Action: contact Oracle support
- ORA-27126: unable to lock shared memory segment in core
- Cause: insufficient privileges to lock shared memory segment in core
- Action: make sure process is running with necessary privileges.
- ORA-27127: unable to unlock shared memory segment
- Cause: insufficient privileges to unlock shared memory segment
- Action: make sure process is running with necessary privileges.
- ORA-27128: unable to determine pagesize
- Cause: sysconf() call failed
- Action: contact Oracle support
- ORA-27140: attach to post/wait facility failed
- Cause: The program attempted to initialize the post/wait facility, but the facility could not be attached.
- Action: Check for additional errors and contact Oracle Support.
- ORA-27141: invalid process ID
- Cause: process operation attempted using invalid process ID
- Action: contact Oracle Support
- ORA-27142: could not create new process
- Cause: OS system call
- Action: check errno and if possible increase the number of processes
- ORA-27143: OS system call failure
- Cause: OS system call failed
- Action: check errno and contact Oracle support
- ORA-27144: attempt to kill process failed
- Cause: OS system call error
- Action: check errno and contact Oracle Support
- ORA-27145: insufficient resources for requested number of processes
- Cause: OS system call error
- Action: check errno and contact Oracle Support
- ORA-27146: post/wait initialization failed
- Cause: OS system call failed
- Action: check errno and contact Oracle Support
- ORA-27147: post/wait reset failed
- Cause: OS system call failed
- Action: check errno and contact Oracle Support
- ORA-27148: spawn wait error
- Cause: OS system call failed
- Action: check errno and contact Oracle Support
- ORA-27149: assignment out of range
- Cause: internal error, requested conversion too large for type
- Action: contact Oracle Support
- ORA-27150: attempt to notify process of pending oradebug call failed
- Cause: OS system call
- Action: check errno contact Oracle Support
- ORA-27151: buffer not large enough to hold process ID string
- Cause: internal error
- Action: contact Oracle Support
- ORA-27152: attempt to post process failed
- Cause: OS system call failed
- Action: check errno and contact Oracle Support
- ORA-27153: wait operation failed
- Cause: OS system called failed
- Action: check errno contact Oracle Support
- ORA-27154: post/wait create failed
- Cause: internal error, multiple post/wait creates attempted simultaneously
- Action: check errno and contact Oracle Support
- ORA-27155: could not execute file
- Cause: OS system call failed
- Action: check errno and contact Oracle Support
- ORA-27156: request for process information failed
- Cause: internal error
- Action: contact Oracle Support
- ORA-27157: OS post/wait facility removed
- Cause: the post/wait facility for which the calling process is awaiting
- Action: check errno and contact Oracle Support
- ORA-27158: process control failure
- Cause: Oracle was unable to set the specified process control.
- Action: Consult the Oracle Administrator's Guide.
- ORA-27159: failure setting process scheduling priority
- Cause: Oracle was unable to set the scheduling priority desired.
- Action: Consult the Oracle Administrator's Guide.
- ORA-27160: process requested to perform operation
- Cause: The current process was requested to perform an operation by another process.
- Action: This is used internally; no action is required.
- ORA-27190: skgfrd: sbtread2 returned error
- Cause: sbtread returned an error. This happens while reading a backup file during a restore operation.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27191: sbtinfo2 returned error
- Cause: sbtinfo2 returned an error. This happens while retrieving backup file information from the media manager's catalog.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
- Cause: sbtclose2 returned an error. This happens while closing a backup file during a backup or restore operation.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27193: sbtinfo2 did not return volume label
- Cause: sbtinfo2 did not return the volume label information for the backup file that was just created.
- Action: This is an internal error in the media management product. Contact the media management vendor.
- ORA-27194: skgfdvcmd: sbtcommand returned error
- Cause: sbtcommand returned an error. This happens when an rman SEND command is issued.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27195: proxy copy not supported
- Cause: An attempt was made to do a proxy backup or restore, but the media management software installed with Oracle does not support proxy copy.
- Action: Re-run the backup in non-proxy mode, or contact the media management vendor if the software is supposed to support proxy copy.
- ORA-27196: skgfpbk: sbtpcbackup returned error
- Cause: sbtpcbackup returned an error. This happens when a proxy backup is begun.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27197: skgfprs: sbtpcrestore returned error
- Cause: sbtpcrestore returned an error. This happens when a proxy restore is begun.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27198: skgfpvl: sbtpcvalidate returned error
- Cause: sbtpcvalidate returned an error. This happens during a proxy backup or restore.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27199: skgfpst: sbtpcstatus returned error
- Cause: sbtpcstatus returned an error. This happens during a proxy backup or restore.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27200: skgfpgo: sbtpcstart returned error
- Cause: sbtpcstart returned an error. This happens during a proxy backup or restore.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27201: skgfpcm: sbtpccommit returned error
- Cause: sbtpccommit returned an error. This happens during a proxy backup or restore.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27202: skgfpen: sbtpcend returned error
- Cause: sbtpcend returned an error. This happens during a proxy backup or restore.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27203: skgfpqb: sbtpcquerybackup returned error
- Cause: sbtpcquerybackup returned an error. This happens during a proxy backup.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27204: skgfpqr: sbtpcqueryrestore returned error
- Cause: sbtpcqueryrestore returned an error. This happens during a proxy restore.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27205: skgfpcn: sbtpccancel returned error
- Cause: sbtpccancel returned an error. This happens during a proxy restore.
- Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.
- ORA-27206: requested file not found in media management catalog
- Cause: A backup file used in a recovery manager catalog maintenance command was not found in the media management catalog.
- Action: Retry the command with a different file.
- ORA-27207: syntax error in device PARMS - parentheses mismatch or missing
- Cause: User-supplied PARMS value has incorrect syntax.
- Action: Retry the command with correct syntax: ENV=(..) BLKSIZE=nnnn
- ORA-27208: syntax error in device PARMS - environment variable value missing
- Cause: User-supplied PARMS value has incorrect syntax.
- Action: Retry the command with correct syntax: ENV=(var1=val1,var2=val2,..)
- ORA-27209: syntax error in device PARMS - unknown keyword or missing =
- Cause: User-supplied PARMS value has incorrect syntax. The server expected to find ENV or BLKSIZE, but found an unknown keyword.
- Action: Retry the command with correct syntax: ENV=(..) BLKSIZE=nnnn
- ORA-27210: syntax error in device PARMS
- Cause: User-supplied PARMS value has incorrect syntax.
- Action: Retry the command with correct syntax: ENV=(..) BLKSIZE=nnnn
- ORA-27211: Failed to load Media Management Library
- Cause: User-supplied SBT_LIBRARY or libobk.so could not be loaded. Call to dlopen for media library returned error. See Additional information for error code.
- Action: Retry the command with proper media library. Or re-install Media management module for Oracle.
- ORA-27212: some entrypoints in Media Management Library are missing
- Cause: media library does not have one of the following entrypoints : sbtinfo, sbtread, sbtwrite, sbtremove, sbtopen, sbtclose, sbtinit
- Action: Retry the command with proper media library.
- ORA-27213: failed to unload Media Management Library
- Cause: dlclose for media library returned error. See Additional Additional information for error code.
- Action: contact Oracle Support.
- ORA-27214: skgfrsfe: file search failed
- Cause: The FindNextFile function returned unxpected error.
- Action: Check errors on the error stack for an explanation why the search for files could not be successfully executed.
- ORA-27215: skgfgsmcs: sbtinfo2 returned unknown file
- Cause: During an sbtinfo2() call, the media management software returned information about an unknown backup file.
- Action: Contact the media management vendor.
- ORA-27216: skgfgsmcs: sbtinfo2 returned a malformed response
- Cause: The media management software returned a malformed response during an sbtinfo2() call.
- Action: Contact the media management vendor.
- ORA-27230: OS system call failure
- Cause: OS system call failed
- Action: check errno and contact Oracle support
- ORA-27250: OS system call failure
- Cause: OS system call failed
- Action: check errno and contact Oracle support
- ORA-27300: OS system dependent operation:string failed with status:string
- Cause: OS system call error
- Action: contact Oracle Support
- ORA-27301: OS failure message:string
- Cause: OS system call error
- Action: contact Oracle Support
- ORA-27302: failure occurred at:string
- Cause: OS system call error
- Action: contact Oracle Support
- ORA-27303: additional information:string
- Cause: OS system call error
- Action: contact Oracle Support
- ORA-27365: job has been notified to stop, but failed to do so immediately
- Cause: The job specified in the stop_job command cannot be stopped immediately(because it is rolling back or blocked on a network operation), but it has been notified to stop. This means it will be stopped as soon as possible after its current uninterruptable operation is done.
- Action: No action is required for the job to be stopped, but calling stop_job with force (if you have the privilege) may cause the job to be stopped sooner.
- ORA-27366: job "string.string" is not running
- Cause: An attempt was made to stop a job that was not running.
- Action: Verify the status of the job. If the job is running but this message is still being returned, contact Oracle support.
- ORA-27367: program "string.string" associated with this job is disabled
- Cause: An attempt was made to run a job whose program has been disabled.
- Action: Reenable the program before running the job.
- ORA-27369: job of type EXECUTABLE failed with exit code:string
- Cause: A problem was encountered while running a job of type EXECUTABLE. The cause of the actual problem is identified by the exit code.
- Action: Correct the cause of the exit code and reschedule the job.
- ORA-27370: job slave failed to launch a job of type EXECUTABLE
- Cause: The scheduler ran into an error when the job slave tried to start a job of type EXECUTABLE. The rest of the error stack will provide more detailed information on what the exact problem was.
- Action: Correct the problem specified in the error stack and reschedule the job.
- ORA-27371: jobs of type EXECUTABLE are not supported on this platform
- Cause: The user tried to create a job or program of type EXECUTABLE on a platform where such jobs are not supported.
- Action: Switch to a different platform or create a different type of job or program.
- ORA-27372: length of action and arguments exceeds platform limitstring
- Cause: The total length of the job or program action and the arguments exceeds the platform limit specified.
- Action: Reduce the total length by specifying fewer and/or shorter arguments
- ORA-27411: An empty string is not a valid repeat interval.
- Cause: An empty string '' was provided as a repeat interval for a window or a schedule.
- Action: Specify a valid repeat interval, e.g., 'FREQ=DAILY;BYHOUR=8;BYMINUTE=0;BYSECOND=0' for a job that executes daily at 8am.
- ORA-27412: repeat interval contains invalid keyword:string
- Cause: The calendar string for the repeat interval of a job, schedule, or window contained an unsupported keyword.
- Action: Correct the repeat interval such that it no longer contains the invalid keyword.
- ORA-27413: repeat interval is too long
- Cause: The repeat interval consisted of a calendar string larger than the maximum size allowed.
- Action: Use a shorter calendar string for the repeat interval.
- ORA-27414: Invalid BY value type
- Cause: The type of BY value was not allowed for the frequency specified
- Action: Ommit BY values of this type or alter the frequency
- ORA-27415: repeat interval must start with the FREQ= clause
- Cause: The specified calendar string for the repeat interval did not start with the frequency clause.
- Action: Create a repeat interval that starts with a frequency clause, e.g. 'FREQ=YEARLY;BYMONTH=FEB'
- ORA-27416: BYDAY= clause in repeat interval contains an invalid weekday
- Cause: The BYDAY clause of the repeat interval contained a value that doesn't properly represent a weekday.
- Action: Use the correct three letter abbreviations for weekdays, e.g. MON for Monday and FRI for Friday.
- ORA-27417: BYWEEKNO clause is only supported when FREQ=YEARLY
- Cause: A repeat interval calendar string contained a BYWEEKNO clause with a frequency other than yearly.
- Action: Remove the BYWEEKNO clause or change the frequency to yearly.
- ORA-27418: syntax error in repeat interval
- Cause: The repeat interval could not be recognized as a valid syntax.
- Action: Specify a valid repeat interval.
- ORA-27419: unable to determine valid execution date from repeat interval
- Cause: The specified repeat interval contained conflicting clauses that made it impossible to ever find a matching date, e.g., 'FREQ=YEARLY;BYMONTH=FEB;BYMONTHDAY=31'. Alternatively, the scheduler reached its maximum number of attempts to try to find a valid execution date. This occurs when theoretically there is a valid execution date far in the future, but the scheduler took too many attempts to determine this date.
- Action: Remove the conflicting clauses, or simplify the repeat interval so that it is easier to determine the next execution date.
- ORA-27451: %s cannot be NULL
- Cause: An attempt was made to set a NOT NULL scheduler attribute to NULL.
- Action: Reissue the command using a non-NULL value for the specified attribute.
- ORA-27452: %s is an invalid name for a database object.
- Cause: An invalid name was used to identify a database object.
- Action: Reissue the command using a valid name.
- ORA-27453: %s is an invalid job or program argument name.
- Cause: An invalid job or program argument name was specified.
- Action: Reissue the command using a valid name for this argument.
- ORA-27454: argument name and position cannot be NULL
- Cause: The name or position of a program or job argument was defined as NULL.
- Action: Reissue the command providing either a valid argument name or valid argument position.
- ORA-27455: Only "SYS" is a valid schema for astring.
- Cause: A non-SYS schema was specified for an object that must be in the SYS schema.
- Action: Reissue the command, leaving out the schema name or using the schema name of SYS.
- ORA-27456: not all arguments of program "string.string" have been defined
- Cause: The number_of_arguments attribute of the named program did not match the actual number of arguments that have been defined.
- Action: Define as many arguments as the number of arguments, or change the number of arguments.
- ORA-27457: argumentstring of job "string.string" has no value
- Cause: No value was provided for the job argument with the specified position.
- Action: Provide a value for the job argument using any of the set_job_xxxx_value() routines. Or, when using a named program, specify a default value for the corresponding argument of the program.
- ORA-27458: A program of type PLSQL_BLOCK cannot have any arguments.
- Cause: An attempt was made to create or enable a program of type PLSQL_BLOCK with arguments. This is not allowed.
- Action: Change the number of arguments to zero, or change the type of the program.
- ORA-27459: A program of type EXECUTABLE must have character-only arguments.
- Cause: A program of type EXECUTABLE was created or enabled with one or more arguments of non-character datatypes.
- Action: Change the arguments to be of character-only datatypes.
- ORA-27460: cannot execute disabled job "string.string"
- Cause: An attempt was made to run a job that is disabled.
- Action: Enable the job and then reschedule the job.
- ORA-27461: The value for attributestring is too large.
- Cause: The value that was provided for the specified attribute was too large.
- Action: Reissue the command using a smaller or shorter value.
- ORA-27463: invalid program typestring
- Cause: An invalid program type was specified.
- Action: Reissue the command using a valid program type.
- ORA-27464: invalid schedule typestring
- Cause: An invalid schedule type was specified.
- Action: Reissue the command using a valid schedule type.
- ORA-27465: invalid valuestring for attribute string
- Cause: An invalid value was provided for the specified attribute.
- Action: Reissue the command using a valid value for this attribute.
- ORA-27467: invalid datatype forstring value
- Cause: The value provided for the named scheduler attribute was of an invalid datatype.
- Action: Reissue the command using a value of the correct datatype.
- ORA-27468: "string.string" is locked by another process
- Cause: An attempt was made to read or modify the state of the named scheduler object when another process was also updating the same object and held the lock.
- Action: Retry the operation. Scheduler locks are held for a very short duration. If the error persists, contact Oracle Support.
- ORA-27469: %s is not a validstring attribute
- Cause: A non-existant attribute was specified.
- Action: Reissue the command using a valid attribute for that specific scheduler object.
- ORA-27470: failed to re-enable "string.string" after making requested change
- Cause: A change was made to an enabled scheduler object that caused it to become disabled.
- Action: Alter the object so that it becomes valid and then enable it.
- ORA-27471: window "string.string" is already closed
- Cause: An attempt was made to close a window that was not open.
- Action: No action required.
- ORA-27472: invalid metadata attributestring
- Cause: An invalid metadata attribute was specified.
- Action: Reissue the command using a valid metadata attribute.
- ORA-27473: argumentstring does not exist
- Cause: An argument which was specified does not exist.
- Action: Reissue the command using an argument name defined by the program or using a valid argument position.
- ORA-27474: cannot give both an argument name and an argument position
- Cause: An argument was specified using both a name and a position.
- Action: Reissue the command using either the argument name or the argument position but not both.
- ORA-27475: "string.string" must be astring
- Cause: An object of the wrong type was specified. For example, a table could have been passed to the drop_job() procedure.
- Action: Reissue a different command applicable to this object type or reissue the same command using an object of the valid type.
- ORA-27476: "string.string" does not exist
- Cause: A database object was specified that does not exist.
- Action: Reissue the command using an object that exists or create a new object and then reissue this command.
- ORA-27477: "string.string" already exists
- Cause: An attempt was made to create an object with a name that has already been used by another object in the same schema.
- Action: Reissue the command using a different name or schema.
- ORA-27478: job "string.string" is running
- Cause: An attempt was made to drop a job that is currently running.
- Action: Stop the job and then reissue the command, or reissue the command specifying the force option to stop the job first.
- ORA-27479: Cannotstring "string.string" because other objects depend on it
- Cause: An attempt was made to drop or disable a scheduler object that has jobs associated with it without specifying the force option.
- Action: Alter the associated jobs so they do not point to the scheduler object being dropped or disabled and then reissue the command. Alternatively reissue the command specifying the force option. If the force option is specified and a scheduler object is being dropped, all associated jobs will be disabled.
- ORA-27480: window "string" is currently open
- Cause: An attempt was made to drop a window that is currently open, or to manually open a window while another window is already open.
- Action: Close the window that is open and then reissue the command, or reissue the command while setting the force option to TRUE.
- ORA-27481: "string.string" has an invalid schedule
- Cause: An attempt was made to enable a job or window that has an invalid schedule.
- Action: Alter the schedule of the job or window so that it is valid and then reissue the enable command.
- ORA-27483: "string.string" has an invalid END_DATE
- Cause: An attempt was made to enable a job or window that has an invalid end_date. Either the end_date is before the start_date or the end_date is in the past.
- Action: Alter the job or window so that the end date becomes valid (possibly null) and then reissue the command.
- ORA-27484: Argument names are not supported for jobs without a program.
- Cause: An attempt was made to set or reset a job argument by using the name of the argument. Identifying job arguments by their name is only supported in combination with jobs that are based on programs. Jobs that are not using a program cannot have named arguments.
- Action: Use argument position instead of name and then issue the command again.
- ORA-27485: argumentstring already exists at a different position
- Cause: An attempt was made to create or replace an argument with a name that is already used by an argument at a different position.
- Action: Use a different name for the argument or drop or alter the argument which already exists with this name and then reissue the command.
- ORA-27486: insufficient privileges
- Cause: An attempt was made to perform a scheduler operation without the required privileges.
- Action: Ask a sufficiently privileged user to perform the requested operation, or grant the required privileges to the proper user(s).
- ORA-27487: invalid object privilege for astring
- Cause: The granted object privilege is not valid for the specified scheduler object.
- Action: Check the scheduler documentation to verify which object privileges can be granted on which scheduler objects.
- ORA-27488: unable to setstring because string was/were already set
- Cause: An attempt was made to set an object's attribute even though one or more conflicting attributes of the same object had already been set.
- Action: Set the other conflicting attributes to NULL and then reissue the command.
- ORA-27489: unable to process job "string.string" from job class "string"
- Cause: An error was encountered while processing the named job from the specified job class.
- Action: Resolve the error for this job and then reissue the command. See the next error message on the stack to find out what the error for the job is.
- ORA-27490: cannot open disabled window "string.string"
- Cause: The user tried to open a disabled window.
- Action: Enable the window and then try to open it again.
- ORA-27491: repeat_interval and start_date cannot both be NULL
- Cause: An attempt was made to set both repeat_interval and start_date to equal NULL for a Scheduler window or schedule.
- Action: If either repeat_interval or start_date is set to equal NULL, the other should be set to a non-NULL value.
- ORA-27500: inter-instance IPC error
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the extra information and contact Oracle Support Services.
- ORA-27501: IPC error creating a port
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27502: IPC error deleting OSD context
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27503: IPC error attempting to cancel request
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27504: IPC error creating OSD context
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27505: IPC error destroying a port
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27506: IPC error connecting to a port
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27507: IPC error disconnecting from a port
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27508: IPC error sending a message
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27509: IPC error receiving a message
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27510: IPC error waiting for a request to complete
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27542: Failed to unprepare a buffer prepared for remote update
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27543: Failed to cancel outstanding IPC request
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27544: Failed to map memory region for export
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27545: Fail to prepare buffer for remote update
- Cause: This is an operating system/cluster interconnect error.
- Action: Check the value of errno and contact Oracle Support Services.
- ORA-27546: Oracle compiled against IPC interface versionstring.string found version string.string
- Cause: A misconfiguration or installation error occurred.
- Action: Install the IPC library for this release of Oracle.
- ORA-27547: Unable to query IPC OSD attributestring
- Cause: This is an operating system-dependent IPC error.
- Action: Contact Oracle support Services.
- ORA-27548: Unable to unprepare IPC buffer
- Cause: This is an operating system-dependent IPC error.
- Action: Contact Oracle support Services.
- ORA-28000: the account is locked
- Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
- Action: Wait for PASSWORD_LOCK_TIME or contact DBA
- ORA-28001: the password has expired
- Cause: The user's account has expired and the password needs to be changed
- Action: change the password or contact the DBA
- ORA-28002: the password will expire withinstring days
- Cause: The user's account is about to about to expire and the password needs to be changed
- Action: change the password or contact the DBA
- ORA-28003: password verification for the specified password failed
- Cause: The new password did not meet the necessary complexity specifications and the password_verify_function failed
- Action: Enter a different password. Contact the DBA to know the rules for choosing the new password
- ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTIONstring
- Cause: The password verification function does not have the required number and type of input/output arguments and/or the return argument
- Action: Check the manual to find out the format of the password verification function
- ORA-28005: invalid logon flags
- Cause: The flags are not properly set or conflicting flags are set in making calls
- Action: Call the function with appropriate flags set.
- ORA-28006: conflicting values for parametersstring and string
- Cause: The parameters PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX cannot both be set. One parameter should be unlimited while other is set
- Action: Set one value to UNLIMITED explicitly
- ORA-28007: the password cannot be reused
- Cause: The password cannot be reused for the specified number of days or for the specified nunmber of password changes
- Action: Try the password that you have not used for the specified number of days or the specified number of password changes Refer to the password parameters in the CREATE PROFILE statement
- ORA-28008: invalid old password
- Cause: old password supplied is wrong; Hence user cannot be authenticated using old password
- Action: Supply the correct old password for authentication
- ORA-28009: connection to sys should be as sysdba or sysoper
- Cause: connect sys/<password> is no longer a valid syntax
- Action: Try connect sys/<password> as sysdba or connect sys/<password> as sysoper
- ORA-28010: cannot expire external or global accounts
- Cause: If a user account is created as IDENTIFIED EXTERNALLY, or IDENTIFIED GLOBALLY, this account cannot be expired
- Action: Try to expire the password of the user that has database password
- ORA-28011: the account will expire soon; change your password now
- Cause: The user's account is marked for expir; the expiry period is unlimited.
- Action: Change the password or contact the DBA.
- ORA-28012: Manual commit not allowed here
- Cause: An attempt was made to commit a non-autonomous transaction from within a change password trigger or password verification routine
- Action: Remove the COMMIT from the password trigger or password verification routine
- ORA-28020: IDENTIFIED GLOBALLY already specified
- Cause: The IDENTIFIED GLOBALLY clause was specified twice.
- Action: Use only one IDENTIFIED GLOBALLY clause.
- ORA-28021: cannot grant global roles
- Cause: A role granted was IDENTIFIED GLOBALLY. Global roles can only be granted via a central authority for the domain.
- Action: Use ALTER ROLE to change the type of role (from IDENTIFIED GLOBALLY to other, such as IDENTIFIED BY password), or allocate it to a global user via the central authority.
- ORA-28022: cannot grant external roles to global user or role
- Cause: A role granted was IDENTIFIED EXTERNALLY. External roles cannot be granted to global users or global roles.
- Action: Use ALTER ROLE to change the type of the role being granted (from IDENTIFIED EXTERNALLY to other, such as IDENTIFIED BY password), or use ALTER ROLE or ALTER USER to change the type of the user or role that is the grantee.
- ORA-28023: must revoke grants of this role to other user(s) first
- Cause: The role altered to IDENTIFIED GLOBALLY was granted to one or more other users and/or roles. Global roles cannot be granted to any user or role.
- Action: Use REVOKE to revoke the role from other users or roles first.
- ORA-28024: must revoke grants of external roles to this role/user
- Cause: The user or role altered to IDENTIFIED GLOBALLY has external roles directly granted - these must be revoked, since external roles cannot be granted to global users or roles.
- Action: Use REVOKE to revoke the external roles from the user or role to be ALTERed.
- ORA-28025: missing or null external name
- Cause: The IDENTIFIED EXTERNALLY AS or IDENTIFIED GLOBALLY AS clause was specified with a valid external name.
- Action: Provide a valid external name.
- ORA-28026: user with same external name already exists
- Cause: The external name specified for the user being created or altered already exists for another user.
- Action: External names must be unique among users. Specify another.
- ORA-28027: privileged database links may be used by global users
- Cause: Only users IDENTIFIED GLOBALLY may use a privileged database link.
- Action: Either change the user to a global user or try to use a different database link.
- ORA-28028: could not authenticate remote server
- Cause: During the course of opening a privileged database link, the remote server was not securely identified using the network security service. Additional errors should follow.
- Action: Consult the network security service documentation on how to properly configure the remote server.
- ORA-28029: could not authorize remote server for userstring
- Cause: During the course of opening a privileged database link, the remote server was found to lack the necessary authorizations to connect as the current global user. This may be because the server was not authorized by the network security service. Or it may be because the local server is restricting access by the remote server using the DBMS_SECURITY_DOMAINS_ADMIN package.
- Action: Grant the remote server the proper authorization to connect as the given global user, and check that the local server is not restricting access.
- ORA-28030: Server encountered problems accessing LDAP directory service
- Cause: Unable to access LDAP directory service
- Action: Please contact your system administrator
- ORA-28031: maximum ofstring enabled roles exceeded
- Cause: The user attempted to enable too many roles.
- Action: Enable fewer roles.
- ORA-28035: Cannot Get Session Key for Authentication
- Cause: Client and server cannot negotiate shared secret during logon
- Action: User should not see this error. Please contact your system administrator
- ORA-28037: Cannot Get Session Key for RACF Authentication
- Cause: Client and server cannot negotiate shared secret during logon
- Action: User should not see this error. Please contact your system administrator
- ORA-28038: disallow O2LOGON
- Cause: turn off O2LOGON
- Action: none
- ORA-28039: cannot validate Kerberos service ticket
- Cause: The Kerberos service ticket provided was invalid or expired
- Action: Provide a valid, unexpired service ticket.
- ORA-28040: No matching authentication protocol
- Cause: No acceptible authentication protocol for both client and server
- Action: Administrator should set SQLNET_ALLOWED_LOGON_VERSION parameter on both client and servers to values that matches the minimum version supported in the system.
- ORA-28041: Authentication protocol internal error
- Cause: Authentication protocol failed with an internal error
- Action: none
- ORA-28042: Server authentication failed
- Cause: Server failed to authenticate itself to the client
- Action: Confirm that the server is a valid database server.
- ORA-28043: invalid bind credentials for DB-OID connection
- Cause: The Database password stored in the wallet did not match the one in OID .
- Action: Use DBCA to reset the database password so that it is the same in database wallet and in OID.
- ORA-28044: unsupported directory type
- Cause: The database tried to work with a directory which is not OID.
- Action: Enterprise User Security works only with Oracle Internet Directory. Update the ldap.ora file to reflect an appropriate OID.
- ORA-28045: SSL authentication between database and OID failed
- Cause: Server failed to authenticate itself to the Directory.
- Action: Make sure the sqlnet.ora used is pointing to the wallet with the right certificate.
- ORA-28046: Password change for SYS disallowed
- Cause: REMOTE_LOGIN_PASSWORDFILE is set to SHARED, prohibiting SYS password changes.
- Action: Change setting of REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE or NONE.
- ORA-28047: database is not a member of any enterprise domain in OID
- Cause: An enterprise user login was attempted on a database that is not a member of any enterprise domain in OID.
- Action: An administrator should put the database into an enterprise domain in OID, and then the user should reconnect.
- ORA-28100: policy function schemastring is invalid
- Cause: The schema was dropped after the policy associated with the function had been added to the object.
- Action: Drop the policy and re-create it with a policy function owned by a valid user. Or re-create the user and the policy function under the new user.
- ORA-28101: policy already exists
- Cause: A policy with the same name for the same object already exists.
- Action: Check if the policy has already been added or use a different policy name.
- ORA-28102: policy does not exist
- Cause: Try to drop/enable/refresh a non-existent policy.
- Action: Correct the policy name argument.
- ORA-28103: adding a policy to an object owned by SYS is not allowed
- Cause: Try to add a policy to a table or a view owned by SYS.
- Action: You can not perform this operation.
- ORA-28104: input value forstring is not valid
- Cause: Input value for the argument is not valid
- Action: specify a valid argument value.
- ORA-28105: cannot create security relevant column policy in an object view
- Cause: Security relevant column argument is not null in policy creation for an object view
- Action: none
- ORA-28106: input value for argument #string is not valid
- Cause: Input values for the argument is missing or invalid.
- Action: Correct the input values.
- ORA-28107: policy was disabled
- Cause: Try to flush a disabled policy.
- Action: If the policy is supposed to be enforced, it must be enabled.
- ORA-28108: circular security policies detected
- Cause: Policies for the same object reference each other.
- Action: Drop the policies
- ORA-28109: the number of related policies has exceeded the limit of 16
- Cause: Too many policies are involved in the same objects.
- Action: Drop one or more policies. Or combine a few of them into one.
- ORA-28110: policy function or packagestring.string has error
- Cause: The policy function may have been dropped, or is no longer valid.
- Action: Check the status of the function and correct the problem. Or re-create the policy with a valid function.
- ORA-28111: insufficient privilege to evaluate policy predicate
- Cause: Predicate has a subquery which contains objects that the owner of policy function does not have privilege to access.
- Action: Grant appropriate privileges to the policy function owner.
- ORA-28112: failed to execute policy function
- Cause: The policy function has one or more error during execution.
- Action: Check the trace file and correct the errors.
- ORA-28113: policy predicate has error
- Cause: Policy function generates invalid predicate.
- Action: Review the trace file for detailed error information.
- ORA-28115: policy with check option violation
- Cause: Policy predicate was evaluated to FALSE with the updated values.
- Action: none
- ORA-28116: insufficient privileges to do direct path access
- Cause: Users with insufficient privileges attempting to do direct path access of tables with fine grain access control policies.
- Action: Ask the database administrator to do the operation. Note that users can work with security administrator to temporarily drop/disable the policies at time of export, import, or load, but this has security implication, and thus access of the database must be controlled carefully.
- ORA-28117: integrity constraint violated - parent record not found
- Cause: try to update/insert a child record with new foreign key values, but the corresponding parent row is not visible because of fine-grained security in the parent.
- Action: make sure that the updated foreign key values must also visible in the parent
- ORA-28118: policy group already exists
- Cause: try to create a policy group that already exists
- Action: none
- ORA-28119: policy group does not exist
- Cause: try to drop a policy group that does not exist
- Action: none
- ORA-28120: driving context already exists
- Cause: try to create a driving context that already exists
- Action: none
- ORA-28121: driving context does not exist
- Cause: try to drop a driving context that does not exist
- Action: none
- ORA-28132: Merge into syntax does not support security policies.
- Cause: Merge into syntax currently does not support a security policy on the destination table.
- Action: use the insert / update DML stmts on the table that has a security policy defined on it.
- ORA-28134: object cannot have fine-grained access control policy
- Cause: Only tables, views, or synonyms of tables or views may have VPD policies
- Action: none
- ORA-28137: Invalid FGA audit Handler
- Cause: An invalid audit handler was specified.
- Action: Specify a valid audit handler.
- ORA-28138: Error in Policy Predicate
- Cause: An invalid policy predicate was specified.
- Action: Please specify a valide policy Predicate for the FGA policy
- ORA-28139: Maximum allowed Fine Grain Audit Policies Exceeded
- Cause: A maximum of 256 policies can be enabled on an object
- Action: Drop or disable an existing policy before creating more
- ORA-28140: Invalid column specified
- Cause: Column name specified during policy creation is invalid
- Action: Please specify a valid column name. Object columns are not supported
- ORA-28150: proxy not authorized to connect as client
- Cause: A proxy user attempted to connect as a client, but the proxy was not authorized to act on behalf of the client.
- Action: Grant the proxy user permission to perform actions on behalf of the client by using the ALTER USER ... GRANT CONNECT command.
- ORA-28151: more than one user name specified for command
- Cause: More than one user name was specified for an ALTER USER command.
- Action: Try the command again with only one user name.
- ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
- Cause: A proxy user attempted to specify an initial role for a client, but the client does not possess the role.
- Action: Change the proxy user so that it does not specify the role or grant the role to the client.
- ORA-28153: Invalid client initial role specified: 'string'
- Cause: A role specified by a proxy user as an initial role to be activated upon connecting on behalf of a client is invalid.
- Action: Connect again as the client specifying a valid role.
- ORA-28154: Proxy user may not act as client 'string'
- Cause: A proxy user may not assume the identity of a privileged user in order to limit the privileges that a proxy may possess.
- Action: Execute the statement again specify a client other than a privileged user.
- ORA-28155: user 'string' specified as a proxy is actually a role
- Cause: A user specified in an AUDIT <operation> BY <proxy> ON BEHALF OF <client> is actually a role.
- Action: Execute the statement again with a valid proxy user.
- ORA-28156: Proxy user 'string' not authorized to set role 'string' for client 'string'
- Cause: A proxy user has not been granted the right to use a role on behalf of a client.
- Action: Execute the command ALTER USER <client> GRANT CONNECT THROUGH PROXY <proxy> to grant the needed role.
- ORA-28157: Proxy user 'string' forbidden to set role 'string' for client 'string'
- Cause: A proxy user was forbidden to use a role on behalf of a client through the command ALTER USER <client> GRANT CONNECT THROUGH <proxy> WITH ALL ROLES EXCEPT <role>
- Action: Execute the command ALTER USER <client> GRANT CONNECT THROUGH PROXY <proxy> to grant the needed role.
- ORA-28163: GRANT already specified
- Cause: The GRANT clause was specified twice.
- Action: Use only one GRANT clause.
- ORA-28164: REVOKE already specified
- Cause: The REVOKE clause was specified twice.
- Action: Use only one REVOKE clause.
- ORA-28165: proxy 'string' may not specify password-protected role 'string' for client 'string'
- Cause: A proxy user attempted to activate a role on behalf of a client which has a password associated with it. Since the proxy does not have a password, this activation cannot be allowed.
- Action: Attempt to activate a different role or change the role administratively so that there is no password.
- ORA-28166: duplicate rolename in list
- Cause: The name of a role was specified more than once in a list.
- Action: Repeat the command specifying the role once.
- ORA-28168: attempted to grant password-protected role
- Cause: An ALTER USER ... GRANT CONNECT command was attempted specifying a role that is protected by a password as a role which the proxy may execute on behalf of a client.
- Action: Either specify a role that does not have a password or alter the role so that a password is not required.
- ORA-28169: unsupported certificate type
- Cause: The type of certificate from which the server is to extract the credentials of the client is not supported.
- Action: Specify a supported type.
- ORA-28170: unsupported certificate version
- Cause: The version of the certificate from which the server is to extract the credentials of the client is not supported.
- Action: Specify a supported version.
- ORA-28171: unsupported Kerberos version
- Cause: the version the Kerberos ticket which the server is to use to validate the identity of the client is not supported.
- Action: Specify a supported version.
- ORA-28172: distinguished name not provided by proxy
- Cause: A client user is to be identified using a distinguished name, but none was provided by the proxy user.
- Action: Provide a distinguished name.
- ORA-28173: certificate not provided by proxy
- Cause: A client user is to be identified using a certificate but none was provided by the proxy user.
- Action: Provide a certificate.
- ORA-28174: Kerberos ticket not provided by proxy
- Cause: A client user is to be authenticated using a Kerberos ticket but none was provided by the proxy user.
- Action: Provide a Kerberos ticket.
- ORA-28175: incorrect certificate type
- Cause: the type of certificate provided by the proxy user to identify a client user does not match the type that is required.
- Action: Provide a certificate of the correct type.
- ORA-28176: incorrect certificate version
- Cause: the version of certificate provided by the proxy user to identify a client user does not match the version that is required.
- Action: Provide a certificate of the correct version.
- ORA-28177: incorrect Kerberos ticket version
- Cause: the version of Kerberos ticket provided by the proxy user to authenticate a client user does not match the version that is required.
- Action: Provide a Kerberos ticket of the correct version.
- ORA-28178: password not provided by proxy
- Cause: A client user is to be authenticated using a database password but none was provided by the proxy user.
- Action: Provide a password.
- ORA-28179: client user name not provided by proxy
- Cause: No user name was provided by the proxy user for the client user.
- Action: Either specify a client database user name, a distinguished name or an X.509 certificate.
- ORA-28180: multiple authentication methods provided by proxy
- Cause: More than one authentication method was specified by the proxy user for the client user.
- Action: Specify only one of the following: a client database user name, a distinguished name or an X.509 certificate.
- ORA-28181: proxy 'string' failed to enable one or more of the specified initial roles for client 'string'
- Cause: Attempt to enable specified initial roles after logon resulted in failure.
- Action: Check that the initial roles are valid, granted to client, and not password protected.
- ORA-28182: cannot acquire Kerberos service ticket for client
- Cause: An attempt to use a Kerberos forwardable ticket granting ticket to obtain a Kerberos service ticket failed.
- Action: Check that the Kerberos forwardable ticket granting ticket belongs to the client, is valid, and that the key distribution center is available.
- ORA-28183: proper authentication not provided by proxy
- Cause: A client user must be authenticated but no authentication credentials were provided by the proxy user.
- Action: Provide some form of authentication credentials.
- ORA-28200: IDENTIFIED USING already specified
- Cause: The IDENTIFIED USING clause was specified twice.
- Action: Use only one IDENTIFIED USING clause.
- ORA-28201: Not enough privileges to enable application role 'string'
- Cause: An attempt to enable application role outside the scope of the designated package
- Action: Enable the role directly or indirectly using the designated package
- ORA-28221: REPLACE not specified
- Cause: User is changing password but password verification function is turned on and the original password is not specified and the user does not have the alter user system privilege.
- Action: Supply the original password.
- ORA-28231: no data passed to obfuscation toolkit
- Cause: A NULL value was passed to a function or procedure.
- Action: Make sure that the data passed is not empty.
- ORA-28232: invalid input length for obfuscation toolkit
- Cause: Length of data submitted for encryption or decryption is not a multiple of 8 bytes.
- Action: Make sure that the length of the data to be encrypted or decrypted is a multiple of 8 bytes.
- ORA-28233: double encryption not supported
- Cause: The obfuscation toolkit does not support the encryption of already-encrypted data.
- Action: Do not attempt to encrypt already-encrypted data.
- ORA-28234: key length too short
- Cause: The key specified is too short for the algorithm. DES requires a key of at least 8 bytes. Triple DES requires a key of least 16 bytes in two-key mode and 24 bytes in three-key mode.
- Action: Specify a longer key.
- ORA-28235: algorithm not available
- Cause: The encryption algorithm desired is not available.
- Action: Run the installer to install the needed algorithm in Oracle Advanced Security.
- ORA-28236: invalid Triple DES mode
- Cause: An unknown value was specified for the mode in which triple DES encryption is to run.
- Action: Specify a valid value. See the package declaration for a list of valid values.
- ORA-28237: seed length too short
- Cause: The seed specified for the key generation routine must be at least 80 characters.
- Action: Specify a longer seed.
- ORA-28238: no seed provided
- Cause: A NULL value was passed in as the seed to be used in generating a key.
- Action: Provide a non-NULL value for the seed.
- ORA-28239: no key provided
- Cause: A NULL value was passed in as a encryption or decryption key.
- Action: Provide a non-NULL value for the key.
- ORA-28261: CURRENT_USER can not be used in PLSQL Definer's Right procedure.
- Cause: An attempt to retrieve CURRENT_USER using SYS_CONTEXT PLSQL interface.
- Action: Use a SQL statement to query CURRENT_USER inside a DR procedure.
- ORA-28262: global_context_pool_size has invalid value.
- Cause: Parameter global_context_pool_size has a value less than the minimum required value (10K).
- Action: Please specify a value for the init.ora parameter global_context_pool_size which is atleast 10k.
- ORA-28263: Insufficient memory in global context pool
- Cause: Allocations for the global context heap exceeded the value set in init.ora.
- Action: Increase the value of global_context_pool_size parameter in init.ora or clear usused global context.
- ORA-28264: Client identifier is too long
- Cause: The length of the client identifier is longer than 64
- Action: Set a client identifier whose length is less than 64.
- ORA-28265: NameSpace beginning with 'sys_' is not allowed
- Cause: Namespace beginning with 'sys_' is not allowed.
- Action: Use a namespace that does not begin with 'sys_'.
- ORA-28267: Invalid name for NameSpace
- Cause: Context NameSpace conflicts with reserved key words.
- Action: Use a NameSpace that does not use reserved key words.
- ORA-28270: Malformed user nickname for password authenticated global user.
- Cause: An attempt to login as password-auuthenticated global user with a malformed user nickname.
- Action: Make sure the nickname is valid and re-login.
- ORA-28271: No permission to read user entry in LDAP directory service.
- Cause: ORACLE server does not have read permission on user nickname's X.500 user entry.
- Action: Make sure ORACLE server is using right SSL credentials to connect to LDAP directory services. Make sure permissions for LDAP user entries are right.
- ORA-28272: Domain policy restricts password based GLOBAL user authentication.
- Cause: Domain policy does not allow password-authenticated GLOBAL users.
- Action: Make sure ORACLE server is using right SSL credentials to connect to LDAP directory services. Make sure orclDBAuthTypes attributes within Oracle enterprise domain object is either set to PWD or ALL.
- ORA-28273: No mapping for user nickname to LDAP distinguished name exists.
- Cause: ORACLE server cannot map the given user nickname to LDAP distinguished name.
- Action: Make sure user entries in LDAP are correctly provisioned with correct user nickname attribute values.
- ORA-28274: No ORACLE password attribute corresponding to user nickname exists.
- Cause: LDAP user entry corresponding to user nickname does not have a ORACLE password attribute or the attribute is not initialized.
- Action: Make sure user entries in LDAP are correctly provisioned with correct ORACLE password attribute values.
- ORA-28275: Multiple mappings for user nickname to LDAP distinguished name exist.
- Cause: The given user nickname maps to more than one LDAP distinguished name.
- Action: Make sure user nickname is unique within the enterprise.
- ORA-28276: Invalid ORACLE password attribute.
- Cause: The ORACLE password attribute of a user entry has an invalid format.
- Action: Make sure ORACLE password attribute value is RFC-2307 compliant.
- ORA-28277: LDAP search, while authenticating global user with passwords, failed.
- Cause: The LDAP search for finding the appropriate user entry and ORACLE password failed.
- Action: Make sure LDAP directory service is up and running.
- ORA-28278: No domain policy registered for password based GLOBAL users.
- Cause: No policy about password authenticated GLOBAL users has been registered.
- Action: Add attribute orclDBAuthTypes to the database server's Enterprise domain.
- ORA-28279: Error reading ldap_directory_access init parameter.
- Cause: ldap_directory_access parameter is not specified corrrectly.
- Action: Make sure spfile.ora has ldap_directory_access set correctly. Possible correct values are PASSWORD, SSL and NONE.
- ORA-28280: Multiple entries for ORACLE database password exist.
- Cause: The ORACLE password attribute of a user entry has multiple entries of ORACLE database password.
- Action: Make sure ORACLE password attribute has one entry for ORACLE Database password.
- ORA-28290: Multiple entries found for the same Kerberos Principal Name
- Cause: Multiple user entries has been configured with the same krbPrincipalName
- Action: Modify enterprise user's entry to assign its Kerberos principal name Make sure the user entries in LDAP are provisioned correctly.
- ORA-28291: No Kerberos Principal Value found.
- Cause: Oracle server fails to get value of krbPrincipalName attribute
- Action: Make sure user entries are correctly provisioned with correct Kerberos principal value
- ORA-28292: No Domain Policy registered for Kerberos based authentication
- Cause: The enterprise domain entry is not configured for Kerberos based global authentication.
- Action: Modify orclDBAuthType of the database server's enterprise domain entry and assign it "ALL" or "KRB5"
- ORA-28293: No matched Kerberos Principal found in any user entry
- Cause: Oracle server fails to find the principal in the user search base
- Action: Make sure the user search base is correct. Use ESM to configure the enterprise user its Kerberos principal name
- ORA-28300: No permission to read user entry in LDAP directory service.
- Cause: ORACLE server does not have read permission on user entries.
- Action: Make sure ORACLE server is using right credentials to connect to LDAP directory services. Make sure permissions for LDAP user entries are configured correctly.
- ORA-28301: Domain Policy hasn't been registered for SSL authentication.
- Cause: An attempt was made to authenticate with SSL, but the database enterprise domain was not configured for SSL authentication.
- Action: Modify orclDBAuthType of the server's enterprise domain entry and assign it "ALL" or "SSL".
- ORA-28302: User does not exist in the LDAP directory service.
- Cause: An attempt was made to authenticate with SSL using the user's certificate, but there was no user entry in the LDAP server that matched the user's Distinguished Name.
- Action: Add an user entry whose DN matches the user's PKI DN in the LDAP directory.
- ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
- Cause: The cause is explained in the forwarded message.
- Action: See the non-Oracle system's documentation of the forwarded message.
- ORA-28501: communication error on heterogeneous database link
- Cause: An unexpected communication failure occurred on a heterogeneous database link to a non-Oracle system. The message above will be followed by a second message generated by the connected non-Oracle system.
- Action: See the documentation for the non-Oracle system for an explanation of the second error message.
- ORA-28502: internal communication error on heterogeneous database link
- Cause: A communication error internal to ORACLE's heterogeneous services has occurred.
- Action: Contact Oracle customer support.
- ORA-28503: bind value cannot be translated into SQL text for non-Oracle system
- Cause: A SQL statement used bind variables on a Heterogenous Services database link to a non-Oracle system, but the non-Oracle system does not support bind variables.
- Action: Change your SQL statement so that it does not use bind variables.
- ORA-28504: ROWID not found in ROWID cache for heterogeneous database link
- Cause: The ROWID cache for Heterogeneous Services held no entry that corresponds to the specified ROWID. The ROWID entry may have been overwritten in the ROWID cache.
- Action: Enlarge the Heterogeneous Services ROWID cache size by increasing the value of the Heterogenous Services initialization parameter HS_ROWID_CACHE_SIZE.
- ORA-28505: cannot get non-Oracle system capabilities fromstring
- Cause: ORACLE was unable to retrieve capability information for the non-Oracle system connected through a heterogeneous database link. This capability information should be stored in data dictionary tables viewable with the HS_CLASS_CAPS or HS_INST_CAPS data dictionary views.
- Action: Contact the DBA to check the server data dictionary table named in the error message. If table contents are incorrect, the DBA should restore all data dictionary content for this FDS_CLASS_NAME and/or FDS_INST_NAME. It usually is sufficient to delete all current data dictionary content for this class and/or instance and initiate a new connection to let the connected agent upload new data dictionary content to the server.
- ORA-28506: parse error in data dictionary translation forstring stored in string
- Cause: A reference to an ORACLE data dictionary table or view name on a heterogeneous database link to a non-Oracle system could not be translated. The ORACLE data dictionary tables shown with view HS_CLASS_DD contain invalid SQL for the data dictionary translation.
- Action: Contact customer support of the agent vendor.
- ORA-28507: error in data dictionary viewstring
- Cause: The initialization parameter table for the Heterogeneous Services was not available, or its structure (number of columns or column types) was incorrect.
- Action: Verify correct installation of the following Heterogeneous Services' initialization parameter views: HS_CLASS_INIT and HS_INST_INIT. If these views are not available, make sure you ran the script CATHS.SQL in the $ORACLE_HOME/rdbms/admin directory.
- ORA-28508: invalid valuestring for Heterogeneous Services initialization parameter string
- Cause: The specified Heterogeneous Services initialization parameter had an invalid value when attempting to connect to a non-Oracle system.
- Action: Check the Heterogeneous Services and agent documentation to determine acceptable values
- ORA-28509: unable to establish a connection to non-Oracle system
- Cause: Initialization of a database link to a non-Oracle system failed to connect to the Heterogeneous Services agent process for this non-Oracle system.
- Action: Check the Net8 service name definition in the following places: -- the USING clause of the CREATE DATABASE LINK statement -- the TNSNAMES.ORA file -- the Oracle Names Server The following are possible reasons for name mismatches: -- The USING clause in the CREATE DATABASE LINK statement has to match the service name defined in the TNSNAMES.ORA file or in the Oracle Names Server. -- The protocol-specific information in the service name definition must match the protocol-specific definition of the responding listener. -- The SID=<name> in the service name definition (in the TNSNAMES.ORA file or in Oracle Names Server) must match the value in the LISTENER.ORA file for the responding listener.
- ORA-28510: heterogeneous database link initialization failed
- Cause: Initialization of a heterogeneous database link to a non-Oracle system failed due to an error identified by the agent for this non-Oracle system.
- Action: Make sure the non-Oracle system is up and running and that all of the environment and initialization values for the agent are set correctly.
- ORA-28511: lost RPC connection to heterogeneous remote agent using SID=string
- Cause: A fatal error occurred in one of the following places: -- the connection between the ORACLE server and the agent -- the heterogeneous services remote agent itself -- the connection to the non-Oracle system This error occurred after communication had been established successfully.
- Action: Check for network problems and remote host crashes. The problem is probably in the agent software. If so, contact a customer support representative of the agent vendor.
- ORA-28512: cannot get data dictionary translations fromstring
- Cause: ORACLE was unable to retrieve data dictionary translation information for the non-Oracle system connected through a heterogeneous database link. This data dictionary translation information should be stored in data dictionary tables viewable with the HS_CLASS_DD or HS_INST_DD data dictionary views.
- Action: Ask your DBA to check the server data dictionary table named in the error message. If table contents are incorrect, the DBA should restore all data dictionary content for this FDS_CLASS_NAME and/or FDS_INST_NAME. It usually is sufficient to delete all current data dictionary content for this class and/or instance and initiate a new connection to let the connected agent upload new data dictionary content to the server.
- ORA-28513: internal error in heterogeneous remote agent
- Cause: An internal error has occurred in the Oracle remote agent supporting a heterogeneous database link.
- Action: Make a note of how the error was produced and contact the customer support representative of the agent vendor.
- ORA-28514: heterogeneous database link initialization could not convert system date
- Cause: The system date was not retrievable.
- Action: Verify that the ORACLE server's host machine and operating system are operational. This error should not occur unless low level system functions are failing.
- ORA-28515: cannot get external object definitions fromstring
- Cause: ORACLE was unable to retrieve definitions of distributed external procedures or remote libraries registered for the non-Oracle system instance, probably because the underlying data dictionary table does not exist or is malformed.
- Action: Verify that the ORACLE server's Heterogeneous Services data dictionary was installed correctly. If the Heterogeneous Services data dictionary is not installed, execute the CATHS.SQL script in the $ORACLE_HOME/rdbms/admin directory.
- ORA-28518: data dictionary translation has illegal translation type
- Cause: A data dictionary translation definition, either in the ORACLE server data dictionary or in data dictionary content uploaded from a Heterogeneous Services agent, specified an illegal translation type code. Legal values are 'T' or 't' for 'translate', 'M' or 'm' for 'mimic'. Information on the exact data dictionary translation causing the error is written to a trace (*.TRC) file for the ORACLE instance and to the ORACLE instance's alert log. This error occurs when a Heterogeneous Services agent uploads data dictionary content to an ORACLE server on the first connection from the server to the agent.
- Action: Contact the customer support of the agent vendor.
- ORA-28519: no heterogeneous data dictionary translations available
- Cause: The ORACLE server's data dictionary did not define data dictionary translations for the connected non-Oracle system, and automatic self-registration (data dictionary upload) was disabled.
- Action: Ask a DBA to resolve this problem. The easiest solution is to enable automatic self-registration by setting the ORACLE server's HS_AUTO_REGISTER initialization parameter to TRUE. An alternative is to load the Heterogeneous Services data dictionary with information specific for the non-Oracle system by executing a SQL script supplied by the agent vendor. If the script is run and the error persists, contact the customer support representative of the agent vendor.
- ORA-28520: error initializing heterogeneous data dictionary translations
- Cause: ORACLE was unable to retrieve data dictionary translations for the non-Oracle system instance, probably because the underlying data dictionary table does not exist or is formed incorrectly.
- Action: Verify that the ORACLE server's Heterogeneous Services data dictionary was installed correctly. If the Heterogeneous Services data dictionary is not installed, execute the CATHS.SQL script in the $ORACLE_HOME/rdbms/admin directory. If the connected agent, identified by FDS_CLASS_NAME, requires a custom installation script for the ORACLE server, verify that the script has been run. If both scripts were executed and the error persists, contact the customer support representative of the agent vendor.
- ORA-28521: no heterogeneous capability information available
- Cause: The ORACLE server's data dictionary did not contain capability definitions for the connected non-Oracle system, and automatic self-registration (data dictionary upload) was disabled.
- Action: Ask a DBA to resolve this problem. The easiest resolution is to enable automatic self-registration by setting the ORACLE server's HS_AUTO_REGISTER initialization parameter to TRUE. An alternative is to load the Heterogeneous Services data dictionary with information specific for the non-Oracle system by executing a SQL script supplied by the agent vendor. If the script is run and the error persists, contact the customer support representative of the agent vendor.
- ORA-28522: error initializing heterogeneous capabilities
- Cause: ORACLE was unable to retrieve capability definitions for the non-Oracle system instance, probably because the underlying data dictionary table does not exist or is formed incorrectly.
- Action: Verify that the ORACLE server's Heterogeneous Services data dictionary was installed correctly. If the Heterogeneous Services data dictionary is not installed, execute the CATHS.SQL script in the $ORACLE_HOME/rdbms/admin directory. If the connected agent, identified by FDS_CLASS_NAME, requires a custom installation script for the ORACLE server, verify that the script has been run. If both scripts were executed and the error persists, contact the customer support representative of the agent vendor.
- ORA-28523: ORACLE and heterogeneous agent are incompatible versions
- Cause: An operation on a database link attempted to connect to a non-Oracle system, but the ORACLE instance and the agent process for the non-Oracle system are incompatible.
- Action: Ask your DBA to confirm configuration of both the ORACLE instance and the agent. Additional information on the version incompatibility is logged in trace (*.TRC) files, the ORACLE instance and the agent, and in the ORACLE instance's alert log. Check the documentation for your agent to find out which releases of the Oracle Server are supported.
- ORA-28525: unable to create Heterogeneous Services error message text
- Cause: Incorrect arguments were passed into the error message creation routine.
- Action: Contact Oracle customer support.
- ORA-28526: invalid describe information returned to Heterogeneous Services
- Cause: The Heterogeneous Services received invalid describe information for a select list, bind list, or stored procedure from the Heterogeneous Services agent. This indicates a problem with the Heterogeneous Services' non-Oracle system agent.
- Action: Contact customer support of the agent vendor.
- ORA-28527: Heterogeneous Services datatype mapping error
- Cause: Either an Oracle datatype could not be mapped to a non-Oracle datatype, or a non-Oracle datatype could not be mapped to an Oracle datatype. These mappings are defined as capability definitions in the ORACLE server's data dictionary.
- Action: Verify that the ORACLE server's data dictionary has been initialized with correct capability definitions for the connected FDS_CLASS_NAME and FDS_INST_NAME. If table contents are incorrect, a DBA should restore all data dictionary content for this FDS_CLASS_NAME and/or FDS_INST_NAME. It usually is sufficient to delete all current data dictionary content for this class and/or instance and initiate a new connection to let the connected agent upload new data dictionary content to the server. If the error persists contact the customer support representative of the agent vendor.
- ORA-28528: Heterogeneous Services datatype conversion error
- Cause: Either an Oracle datatype could not be converted to a non-Oracle datatype, or a non-Oracle datatype could not be converted to an Oracle datatype. The following are possible reasons for for the conversion failure: -- overflow problems (in the case of numbers) -- length limitations (in the case of character strings) -- invalid values passed into the conversion routines
- Action: Contact customer support of the agent vendor. If the problem is due to size discrepancies between Oracle and the non-Oracle system, it may not be possible to convert the value.
- ORA-28529: invalid or missing parameter in Net8 service name definition
- Cause: There was an invalid or missing Heterogeneous Services parameter in the Net8 service name definition stored in either the TNSNAMES.ORA file or in the Oracle Names Server.
- Action: Ask your DBA to make sure the information in the Net8 service definition is correct and complete. The correct information that should be included in the Net8 service definition can be found in the agent's documentation.
- ORA-28530: Heterogeneous Services initialization error in NLS language ID
- Cause: Heterogeneous Services was unable to initialize an NLS language ID. Both the ORACLE server and the Heterogeneous Services agent for the connected non-Oracle system must have language IDs.
- Action: Contact Oracle customer support.
- ORA-28533: Heterogeneous Services coercion handling error
- Cause: The Heterogeneous Services encountered an error in coercion handling. The HS can, if the agent vendor so chooses, perform extra processing on SQL statements that contain implicit coercions or that contain coercion functions such as TO_CHAR, TO_NUMBER or TO_DATE. This functionality is controlled by coercion-related capabilities. HS logic reports this error when it encounters an error in one of these capability definitions.
- Action: The capability table settings are controlled by the agent vendor and can be modified by the DBA. Contact your DBA and agent vendor and get the correct set of capabilities installed.
- ORA-28534: Heterogeneous Services preprocessing error
- Cause: One of the things that the Heterogeneous Services can do is to preprocess parts of SQL statements that contain implicit coercions or calls to explicit coercion functions like TO_CHAR TO_NUMBER or TO_DATE. For example, it could convert a call to TO_DATE to a bind variable, pre-evaluate the TO_DATE function call and pass the resulting value to the non-Oracle system as the bind value. This behavior is controlled by some coercion related capabilities. If the capabilities are set incorrectly, the HS could encounter errors when it attempts to do the preprocessing. If it does then this error will be signaled.
- Action: The capability table settings are controlled by the agent vendor and can be modified by the DBA. Contact your DBA and agent vendor and get the correct set of capabilities installed.
- ORA-28535: invalid Heterogeneous Services context
- Cause: A Heterogeneous Services agent's driver module called an HS service routine with an invalid HS context value. This probably is a logic error in the driver.
- Action: Contact Oracle customer support or your agent vendor.
- ORA-28536: error in processing Heterogeneous Services initialization parameters
- Cause: An error described by a subsequent error message prevented successful processing of Heterogeneous Services initialization parameters from the ORACLE server data dictionary.
- Action: Check server data dictionary views HS_CLASS_INIT, HS_INST_INIT, and HS_ALL_INITS. Look for conditions which could produce the error identified in the error message immediately following this one.
- ORA-28537: no more result sets
- Cause: This error code is used internally within Oracle Transparent Gateway and Heterogeneous Services code and should not be reported to a client program.
- Action: Contact Oracle customer support.
- ORA-28538: result set not found
- Cause: The client program tried fetching from a result set that is not open anymore. Many gateways will, on execution of a stored procedure, automatically close all result sets that were returned by any previously executed stored procedure.
- Action: Check the documentation for the gateway that you are using and see if it will automatically close currently open result sets each time a stored procedure is executed. Then check if your client program is doing anything that violates this rule. If it is, fix your program. If it is not then contact Oracle customer support.
- ORA-28539: gateway does not support result sets
- Cause: The client program tried executing a stored procedure that returns one or more result sets through a gateway that does not have result set support.
- Action: Check the documentation for the gateway that you are using and see if it supports result sets returned from stored procedures. If it does not, then the only way of accessing such stored procedures is to upgrade to a version of the gateway that does support result sets (if such a version exists). If the gateway does have result set support and you are still seeing this error then contact Oracle customer support.
- ORA-28540: internal result set error
- Cause: A protocol error internal to Heterogeneous Services or Transparent Gateway code has occurred.
- Action: Contact Oracle customer support.
- ORA-28541: Error in HS init file on linenumber.
- Cause: A syntax error occurred in the gateway initialization file.
- Action: Check gateway init file to correct the syntax error. For further information, check the error message in the gateway trace file.
- ORA-28542: Error in reading HS init file
- Cause: Reading the gateway init file generated an error.
- Action: Check the gateway initialization file name to see that the gateway initialization file acctually exists. Check the ifile parameter to see that it points to the correct location.
- ORA-28543: Error initializing apply connection to non-Oracle system
- Cause: Attempt to initialize connection to non-Oracle for heterogeneous replication failed.
- Action: Check if the listener used to connect to the gateway is up and is correctly configured. Make sure that the database link used has been configured correctly and, if a tnsnames alias has been used in the database link definition, make sure that the configuration of the entry in tnsnames.ora has been done correctly.
- ORA-28544: connect to agent failed, probable Net8 administration error
- Cause: Net8 reported a failure to make a RSLV connection or a protocol mode error when the Oracle server attempted to establish communication with a Heterogeneous Services agent or an external procedure agent. This usually is due to an administration error in setting up Net8 service definitions in TNSNAMES.ORA or LISTENER.ORA: A basic network connection is opened, but it connects to a program which does not use the appropriate protocol. This often is a sign that the connection goes to the wrong program.
- Action: Check Net8 administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the connection from the ORACLE server uses the correct service name or SID. -- Check LISTENER.ORA on the agent's host machine to assure that the service name or SID refers to the correct agent executable in its (PROGRAM=...) clause. -- Confirm in TNSNAMES.ORA or the equivalent service definition that sevice 'extproc_connection_data' does NOT contain (HS=), or that the service definition used by a Heterogeneous Services database link DOES contain (HS=).
- ORA-28545: error diagnosed by Net8 when connecting to an agent
- Cause: An attempt to call an external procedure or to issue SQL to a non-Oracle system on a Heterogeneous Services database link failed at connection initialization. The error diagnosed by Net8 NCR software is reported separately.
- Action: Refer to the Net8 NCRO error message. If this isn't clear, check connection administrative setup in tnsnames.ora and listener.ora for the service associated with the Heterogeneous Services database link being used, or with 'extproc_connection_data' for an external procedure call.
- ORA-28546: connection initialization failed, probable Net8 admin error
- Cause: A failure occurred during initialization of a network connection from the Oracle server to a second process: The connection was completed but a disconnect occurred while trying to perform protocol-specific initialization, usually due to use of different network protocols by opposite sides of the connection. This usually is caused by incorrect Net8 administrative setup for database links or external procedure calls. The most frequent specific causes are: -- Database link setup for an Oracle-to-Oracle connection instead connects to a Heterogeneous Services agent or an external procedure agent. -- Database link setup for a Heterogeneous Services connection instead connects directly to an Oracle server. -- The extproc_connection_data definition in tnsnames.ora connects to an Oracle instance instead of an external procedure agent. -- Connect data for a Heterogeneous Services database link, usually defined in tnsnames.ora, does not specify (HS=). -- Connect data for an Oracle-to-Oracle database link, usually defined in tnsnames.ora, specifies (HS=).
- Action: Check Net8 administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the connection from the ORACLE server uses the correct service name or SID. -- Check LISTENER.ORA on the connection end point's host machine to assure that this service name or SID connects to the correct program. -- Confirm in TNSNAMES.ORA or the equivalent service definition that service 'extproc_connection_data' does NOT contain (HS=), or that the service definition used by a Heterogeneous Services database link DOES contain (HS=).
- ORA-28547: connection to server failed, probable Net8 admin error
- Cause: A failure occurred during initialization of a network connection from a client process to the Oracle server: The connection was completed but a disconnect occurred while trying to perform protocol-specific initialization, usually due to use of different network protocols by opposite sides of the connection. This usually is caused by incorrect Net8 administrative setup for database links or external procedure calls. The most frequent specific causes are: -- The connection uses a connect string which refers to a Heterogeneous Services agent instead of an Oracle server. -- The connection uses a connect string which includes an (HS=) specification.
- Action: Check Net8 administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the client connection to the ORACLE server uses the correct service name or SID. -- Check LISTENER.ORA on the connection end point's host machine to assure that this service name or SID refers to the correct server. -- Confirm in TNSNAMES.ORA or the equivalent service definition that the connect string does NOT contain (HS=).
- ORA-28550: pass-through SQL: cursor not found
- Cause: A value passed to a pass-through SQL function or procedure call as a cursor does not identify a currently open cursor.
- Action: Use a cursor number returned by the pass-through SQL OPEN_CURSOR call.
- ORA-28551: pass-through SQL: SQL parse error
- Cause: A non-Oracle system rejected text supplied as a pass-through SQL statement.
- Action: Ensure that the SQL supplied to the pass-through SQL PARSE call is legal for the non-Oracle system.
- ORA-28552: pass-through SQL: call flow error
- Cause: A pass-through SQL function was called in an invalid order.
- Action: Correct program flow by changing the order of API calls to match the flow described in the manual.
- ORA-28553: pass-through SQL: invalid bind-variable position
- Cause: A pass-through SQL function referring to the position of a bind variable in the currently-parsed SQL statement supplied an invalid bind-variable position. Valid values are 1 through n, where n is the number of bind-variable place-holders in the SQL text.
- Action: Verify that the bind-variable position parameter is in the correct range to represent a place-holder in the SQL text. Confirm that the SQL text uses the correct syntax for a bind-variable place-holder, as required by the non-Oracle system.
- ORA-28554: pass-through SQL: out of cursors
- Cause: The maximum number of open cursors has been exceeded.
- Action: Close open cursors by using the pass-through SQL CLOSE_CURSOR function.
- ORA-28555: pass-through SQL: required parameter missing or NULL
- Cause: An attempt was made to pass a NULL value to a non-NULL parameter.
- Action: Use a non-NULL value for the parameter.
- ORA-28556: authorization insufficient to access table
- Cause: A query attempted to access a table in the non-Oracle system that is either privileged or has privileged columns.
- Action: Contact the DBA for the non-Oracle system. The DBA can grant permission to access the privileged table or columns.
- ORA-28557: unknownstring for database link to non-Oracle system
- Cause: When attempting to connect to a non-Oracle system through a Heterogeneous Services database link, the agent supporting this non-Oracle system failed to return FDS_CLASS_NAME and/or FDS_INST_NAME. ORACLE requires these names to configure the heterogeneous database link.
- Action: Contact the DBA to check setup of the connection and the Heterogeneous Services agent.
- ORA-28558: HS_FDS_CONNECT_STRING undefined for non-Oracle system
- Cause: A database link to a non-Oracle system had no HS_FDS_CONNECT_STRING initialization parameter in the ORACLE server's data dictionary for Heterogeneous Services. Without this parameter, the connection could not be completed.
- Action: Contact your DBA to verify correct setup of an HS_FDS_CONNECT_STRING entry in the ORACLE Heterogeneous Services data dictionary.
- ORA-28559: FDS_CLASS_NAME isstring, FDS_INST_NAME is string
- Cause: An associated error was reported in another message, and this message supplies supplementary information to assist diagnosis of that error. FDS_CLASS_NAME and FDS_INST_NAME are used to access information in tables and views of the ORACLE data dictionary that direct operation of Heterogeneous Services on a database link to a non-Oracle data store.
- Action: Use the FDS_CLASS_NAME and FDS_INST_NAME values to check ORACLE data dictionary contents when necessary to diagnose the cause of the associated error.
- ORA-28560: error in configuration of agent process
- Cause: An ORACLE server invoked a function not supported by the connected agent (Heterogeneous Services or external procedures). The most probable cause is incorrect Net8 setup, resulting in use of the wrong agent executable.
- Action: Check Net8 administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the connection from the ORACLE server uses the correct SID. -- Check LISTENER.ORA on the agent's host machine to assure that this SID refers to the correct agent executable in its (PROGRAM=...) clause.
- ORA-28561: unable to set date format on non-Oracle system
- Cause: Initialization of a Heterogeneous Services connection to set the date format to be used on the connected non-Oracle system.
- Action: If the Oracle data dictionary supplies a value for the HS_NLS_DATE_FORMAT parameter, confirm that this value is formatted correctly by the rules of the non-Oracle system. Also check for additional information in log and trace files generated by the Heterogeneous Services agent.
- ORA-28575: unable to open RPC connection to external procedure agent
- Cause: Initialization of a network connection to the extproc agent did not succeed. This problem can be caused by network problems, incorrect listener configuration, or incorrect transfer code.
- Action: Check listener configuration in LISTENER.ORA and TNSNAMES.ORA, or check Oracle Names Server.
- ORA-28576: lost RPC connection to external procedure agent
- Cause: of this error is abnormal termination of the invoked "C" routine. If this is not the case, check for network problems. Correct the problem if you find it. If all components appear to be normal but the problem persists, the problem could be an internal logic error in the RPC transfer code. Contact your customer support representative.
- Action: First check the 3GL code you are invoking; the most likely
- ORA-28577: argumentstring of external procedure string has unsupported datatype string
- Cause: While transferring external procedure arguments to the agent, an unsupported datatype was detected.
- Action: Check your documentation for the supported datatypes of external procedure arguments.
- ORA-28578: protocol error during callback from an external procedure
- Cause: An internal protocol error occurred while trying to execute a callback to the Oracle server from the user's 3GL routine.
- Action: Contact Oracle customer support.
- ORA-28579: network error during callback from external procedure agent
- Cause: An internal network error occurred while trying to execute a callback to the Oracle server from the user's 3GL routine.
- Action: Contact Oracle customer support.
- ORA-28580: recursive external procedures are not supported
- Cause: A callback from within a user's 3GL routine resulted in the invocation of another external procedure.
- Action: Make sure that the SQL code executed in a callback does not directly call another external procedure, or indirectly results in another external procedure, such as triggers calling external procedures, PL/SQL procedures calling external procedures, etc.
- ORA-28581: protocol error while executing recursive external procedure
- Cause: An internal protocol error occurred while trying to execute an external procedure resulting from a callback in another external procedure.
- Action: Contact Oracle customer support.
- ORA-28582: a direct connection to this agent is not allowed
- Cause: A user or a tool tried to establish a direct connection to either an external procedure agent or a Heterogeneous Services agent, for example: "SVRMGR> CONNECT SCOTT/TIGER@NETWORK_ALIAS". This type of connection is not allowed.
- Action: When executing the CONNECT statement, make sure your database link or network alias is not pointing to a Heterogeneous Option agent or an external procedure agent.
- ORA-28583: remote references are not permitted during agent callbacks
- Cause: A Heterogeous Services agent issued a callback to the Oracle server which attemted to to access a remote system. This is not supported.
- Action: Make sure that SQL code issued by Heterogeneous Services agents does not reference a database link.
- ORA-28584: heterogeneous apply internal error
- Cause: The apply slave process encountered an error while trying to apply changes through a gateway to a non-Oracle system.
- Action: Make sure that the apply database link is correctly configured and that the gateway listener and the non-Oracle system are correctly set up and are up and running. If everything is configured correctly and the problem still occurs, contact Oracle customer support. errors 28590 - 28599 are reserved for the HS agent control utility
- ORA-28590: agent control utility: illegal or badly formed command
- Cause: The user has issued an unrecognized or syntactically incorrect command.
- Action: Refer to documentation and correct the syntax of the command.
- ORA-28591: agent control utility: unable to access parameter file
- Cause: The agent control utility was unable to access its parameter file. This could be because it could not find its admin directory or because permissions on directory were not correctly set.
- Action: The agent control utility puts its parameter file in either the directory pointed to by the environment variable AGTCTL_ADMIN or in the directory pointed to by the environment variable TNS_ADMIN. Make sure that at least one of these environment variables is set and that it points to a directory that the agent has access to.
- ORA-28592: agent control utility: agent SID not set
- Cause: The agent needs to know the value of the AGENT_SID parameter before it can process any commands. If it does not have a value for AGENT_SID then all commands will fail.
- Action: Issue the command SET AGENT_SID <value> and then retry the command that failed.
- ORA-28593: agent control utility: command terminated with error
- Cause: An error occurred during the processing of the command. There could be several causes. A SET or an UNSET command could have been issued after the agent was started. This is illegal. The user may have attempted to start two agents with the same SID value or the user could have attempted to shutdown an agent that is no longer running.
- Action: If the user wishes to issue a SET or an UNSET command, he should make sure the agent is shutdown first by issuing the SHUTDOWN command.
- ORA-28594: agent control utility: invalid parameter name
- Cause: The user tried to set or unset an invalid agent parameter.
- Action: Refer to documentation and correct the parameter name.
- ORA-28595: Extproc agent : Invalid DLL Path
- Cause: The path of DLL supplied for the extproc execution is invalid.
- Action: Check if the DLL path is set properly using the EXTPROC_DLLS environment variable. errors 28600 - 28620 are reserved for bitmap indexes
- ORA-28601: invalid [no]MINIMIZE option
- Cause: user didn't type this alter table <table_name> MINIMIZE RECORDS_PER_BLOCK or alter table <table_name> NOMINIMIZE RECORDS_PER_BLOCK
- Action: reenter correct sql command
- ORA-28602: statement not permitted on tables containing bitmap indexes
- Cause: table has bitmap indexes and user is minimizing or nominimizing records_per_block
- Action: drop all bitmap indexes before changing records_per_block
- ORA-28603: statement not permitted on empty tables
- Cause: table is empty and statement does not work on empty tables
- Action: try statement after loading your data
- ORA-28604: table too fragmented to build bitmap index (string,string,string)
- Cause: The table has one or more blocks that exceed the maximum number of rows expected when creating a bitmap index. This is probably due to deleted rows. The values in the message are: (data block address, slot number found, maximum slot allowed)
- Action: Defragment the table or block(s). Use the values in the message to determine the FIRST block affected. (There may be others).
- ORA-28605: bitmap indexes cannot be reversed
- Cause: user tried to create reverse bitmap index
- Action: don't do this; it is not supported
- ORA-28606: block too fragmented to build bitmap index (string,string)
- Cause: The block(s) exceed the maximum number of rows expected when creating a bitmap index. This is probably due to maximum slot allowed set too low. The values in the message are: (slot number found, maximum slot allowed)
- Action: alter system flush shared_pool; update tab$ set spare1 = 8192 where obj# = (select obj# from obj$ where NAME=<table_name> AND owner# = <table_owner>; commit;
- ORA-28611: bitmap index is corrupted - see trace file for diagnostics
- Cause: Validate Index detected bitmap corruption in its argument index
- Action: Drop this bitmap index and create a new one.
- ORA-28650: Primary index on an IOT cannot be rebuilt
- Cause: An attempt is made to issue alter index rebuild on IOT-TOP
- Action: Use Alter table MOVE to reorganize the table(IOT)
- ORA-28651: Primary index on IOTs can not be marked unusable
- Cause: An attempt is made to mark IOT-TOP unusable thru ALTER INDEX
- Action: Remove the option UNUSABLE
- ORA-28652: overflow segment attributes cannot be specified
- Cause: During ALTER MOVE ONLINE of a index-organized table, the user attempted to enter one or more of the following options: OVERFLOW, PCTTHRESHOLD,INCLUDING.
- Action: Remove the illegal option(s).
- ORA-28653: tables must both be index-organized
- Cause: Attempt to exchange a non IOT table/partition with a partition/table respectively
- Action: Ensure that non-partitioned and partitioned tables are both index-organized.
- ORA-28654: table and partition not overflow compatible
- Cause: If one of the tables (partitioned/non-partitioned) has overflow data segment and the other one doesn't.
- Action: Ensure that non-partitioned and partitioned tables both have overflow data segment or neither one does.
- ORA-28655: Alter table add overflow syntax error
- Cause: Syntax error
- Action: Check the syntax.
- ORA-28656: incomplete attribute specification
- Cause: The attribute specification is not done for all partitions"
- Action: Specify the storage attributes either for ALL partitions or NONE
- ORA-28658: This operation is supported only for Index-Organized tables
- Cause: Attempt to perform some IOT specific operation on a non-IOT
- Action: don't do this. This is not supported
- ORA-28659: COMPRESS must be specified at object level first
- Cause: Attempt to specify COMPRESS at partition level without first specifying at the table level
- Action: Specify COMPRESS at table level. Use ALTER TABLE xxx MODIFY DEFAULT ATTRIBUTES COMPRESS ...
- ORA-28660: Partitioned Index-Organized table may not be MOVEd as a whole
- Cause: Attempt to MOVE partitioned IOT as a whole
- Action: don't do this. This is not supported
- ORA-28661: Object already has COMPRESS clause specified
- Cause: Attempt to specify compress for iot/index which already has a compression clause.
- Action: This is a 'create time only' attribute
- ORA-28662: IOT index and overflow segments must share the same LOGGING attribute
- Cause: Attempt to specify LOGGING for one segment and NOLOGGING for the other segment.
- Action: don't do that
- ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
- Cause: Attempt to specify LOGGING for a Alter Table Add Overflow.
- Action: don't do that
- ORA-28664: a partitioned table may not be coalesced as a whole
- Cause: User attempted to coalesce a partitioned IOT using ALTER TABLE COALESCE statement, which is illegal
- Action: Coalesce the table a partition at a time (using ALTER TABLE MODIFY PARTITION COALESCE)
- ORA-28665: table and partition must have same compression attribute
- Cause: User attempted to EXCHANGE a compression enabled partition with a compression disabled table or vice versa OR the # of columns compressed is different for table and partition
- Action: Make sure the compression attributes match If they don't, fix it using ALTER TABLE MOVE [PARTITION] COMPRESS
- ORA-28666: option not allowed for an index on UROWID column(s)
- Cause: User attempted to build a REVERSE or COMPRESSED or GLOBAL partitioned index on UROWID column(s)
- Action: Build the index without these options
- ORA-28667: USING INDEX option not allowed for the primary key of an IOT
- Cause: User attempted to define storage attributes for the primary key index of an Index-Organized table with USING INDEX clause. All the storage attribute defined for the (IOT)table applies to the primary key index and a separate USING INDEX clause is not required.
- Action: Remove the USING INDEX clause and specify all attributes directly for the table
- ORA-28668: cannot reference mapping table of an index-organized table
- Cause: An attempt to directly access the mapping table of an index-organized table
- Action: Issue the statement against the parent index-organized table containing the specified mapping table.
- ORA-28669: bitmap index can not be created on an IOT with no mapping table
- Cause: User attempted to create a bitmap index on an index-organized table without a mapping table.
- Action: Enable bitmap indexes on the Index-organized table by creating a mapping table using 'ALTER TABLE .. MOVE MAPPING TABLE'.
- ORA-28670: mapping table cannot be dropped due to an existing bitmap index
- Cause: User attempted to drop the mapping table with NOMAPPING option when the IOT has one or more bitmap indexed.
- Action: Drop the bitmap index(es) before dropping the mapping table.
- ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole
- Cause: User attempted to UPDATE BLOCK REFERENCES on a partitioned index using ALTER INDEX UPDATE BLOCK REFERENCES statement, which is illegal.
- Action: Issue a partition level operation with ALTER INDEX .. PARTITION .. UPDATE BLOCK REFERENCES
- ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index
- Cause: User attempted to UPDATE BLOCK REFERENCES on a global partitioned or non-partitioned index. This feature is not supported for non-partitioned or global partitioned index on a partitioned IOT and a global partitioned index on a non-partitioned IOT.
- Action: Use online index [partition] rebuild to fix the block references
- ORA-28673: Merge operation not allowed on an index-organized table
- Cause: User attempted merge operation on an index-organized table. Merge is not supported on a IOT .
- Action: Use updates and inserts on index-organized table .
- ORA-28674: cannot reference transient index-organized table
- Cause: An attempt was made to directly access a transient table created created on behalf of a index-organized table partition maintenance operation.
- Action: Issue the statement against the associated permanent index-organized table.
- Oracle错误代码解析
- oracle错误代码
- oracle错误代码
- Oracle错误代码
- oracle错误代码
- Oracle错误代码
- oracle错误代码
- oracle错误代码
- oracle错误代码
- oracle错误代码
- oracle错误代码
- 邮件服务器错误代码解析
- PCSC 错误代码解析
- http错误代码大全解析
- 数据库错误代码解析
- http错误代码解析
- Oracle常见错误代码
- oracle 错误代码 显示
- 常用Maven插件介绍(上)
- android 视频采集
- 常用Maven插件介绍(下)
- 请教一个sizeof在模版函数内无法正常获取大小的问题。
- C++ 虚函数表解析
- Oracle错误代码解析
- 在Ubuntu上安装JDK
- sql case when 用法(转)
- git 基本环境设定
- android源码解析 ---- camera 照相机 摄像机
- Eval截取字符串
- 正确卸载瑞星
- hdu 2544 最短路<java>
- mono for android中TTS的使用