Category Archives: Database

ORA-00061: another instance has a different DML_LOCKS setting

ORA-00061: another instance has a different DML_LOCKS setting

ORA-00061: another instance has a different DML_LOCKS setting
Cause: The shared instance being started is using DML locks, and the running instances are not, or vice-versa.
Action: Ensure that all instances’ INIT.ORA files specify the DML_LOCKS parameter as 0 or all as non-zero.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00060: deadlock detected while waiting for resource

ORA-00060: deadlock detected while waiting for resource

ORA-00060: deadlock detected while waiting for resource
Cause: Transactions deadlocked one another while waiting for resources.
Action: Look at the trace file to see the transactions and resources involved. Retry if necessary.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00059: maximum number of DB_FILES exceeded

ORA-00059: maximum number of DB_FILES exceeded

ORA-00059: maximum number of DB_FILES exceeded
Cause: The value of the DB_FILES initialization parameter was exceeded.
Action: Increase the value of the DB_FILES parameter and warm start.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)

ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)

ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)
Cause: DB_BLOCK_SIZE initialization parameter is wrong for the database being mounted. It does not match the value used to create the database.
Action: Fix the value of the DB_BLOCK_SIZE parameter or mount a database that matches the value

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00057: maximum number of temporary table locks exceeded

ORA-00057: maximum number of temporary table locks exceeded

ORA-00057: maximum number of temporary table locks exceeded
Cause: The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.
Action: Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00056: DDL lock on object ‘string.string’ is already held in an incompatible mode

ORA-00056: DDL lock on object ‘string.string’ is already held in an incompatible mode

ORA-00056: DDL lock on object ‘string.string’ is already held in an incompatible mode
Cause: An attempt was made to acquire a DDL lock that is already locked.
Action: This happens if you attempt to drop a table that has parse locks on it.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00055: maximum number of DML locks exceeded

ORA-00055: maximum number of DML locks exceeded

ORA-00055: maximum number of DML locks exceeded
Cause: Ran out of DML lock state objects.
Action: Increase the value of the DML_LOCKS initialization parameter and warm start.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00054: resource busy and acquire with NOWAIT specified
Cause: Resource interested is busy.
Action: Retry if necessary.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00053: maximum number of enqueues exceeded

ORA-00053: maximum number of enqueues exceeded

ORA-00053: maximum number of enqueues exceeded
Cause: Ran out of enqueue state objects.
Action: Increase the value of the ENQUEUES initialization parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00052: maximum number of enqueue resources (string) exceeded

ORA-00052: maximum number of enqueue resources (string) exceeded

ORA-00052: maximum number of enqueue resources (string) exceeded

Cause: Ran out of enqueue resources.

Action: Increase the value of the ENQUEUE_RESOURCES initialization parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/