Category Archives: ORA Database Error Messages

ORA-31103: Resource locked in shared mode. Cannot add exclusive lock

oracle

ORA-31103: Resource locked in shared mode. Cannot add exclusive lock
Cause: The resource is locked in shared mode. Cannot add a shared lock
Action: Try locking in shared mode or unlocking the existing lock

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31102: Already locked in exclusive mode. Cannot add lock

oracle

ORA-31102: Already locked in exclusive mode. Cannot add lock
Cause: The resource is already locked in exclusive mode. Cannot add another lock
Action: Unlock the existing lock

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31101: Token “string” not given while locking resource “string”

oracle

ORA-31101: Token "string" not given while locking resource "string"
Cause: Locking attempted on resource when the pricipal already owns a lock given by the token above
Action: Reattempt the lock with the token

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31100: XDB Locking Internal Error

oracle

ORA-31100: XDB Locking Internal Error
Cause: An XDB Locking Internal error has occurred
Action: Contact Oracle Support

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31099: XDB Security Internal Error

oracle

ORA-31099: XDB Security Internal Error
Cause: An XDB Security internal error has occurred
Action: Contact Oracle Support. ////// 31100 - 31110 reserved for WebDAV compliant resource locks

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31097: Hierarchical Index not empty

oracle

ORA-31097: Hierarchical Index not empty
Cause: An attempt was made to rebuild the hierarchical index which is not empty
Action: Delete all rows in the hierarchical index and then rebuild it

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31096: validation failed for schema

oracle

ORA-31096: validation failed for schema
Cause: The XML Schema could not be validated
Action: Make sure that the SQLType and other datatype mapping is valid

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31095: cannot generate string : “string.string” already exists

oracle

ORA-31095: cannot generate string : "string.string" already exists
Cause: The type/table name specified in the XML schema document cannot be generated because it is already being used
Action: Use different names for types/tables or use the NOGEN mode so that schema compiler does not generate new types/tables

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31094: incompatible SQL type “string” for attribute or element “string”

oracle

ORA-31094: incompatible SQL type "string" for attribute or element "string"
Cause: The SQL type information provided in the XML schema is not compatible with the XML datatype for the specified attribute or element
Action: Make sure that the specified SQL types are compatible with the declared XML datatypes

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31093: null or invalid value specified for parameter : string

oracle

ORA-31093: null or invalid value specified for parameter : string
Cause: The argument value passed for the given parameter is null or invalid
Action: Make sure that all the input argument values are valid

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/