All posts by mpbod

ORA-00063: maximum number of log files exceeded string

ORA-00063: maximum number of log files exceeded string

ORA-00063: maximum number of log files exceeded string
Cause: The number of log files specificied exceeded the maximum number of log files supported in this release.
Action: Re-create the control file with the highest number of log files no greater than the maximum supported in this release.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0

ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0

ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0
Cause: The instance was started with DML_LOCKS = 0, and the statement being executed needs a full-table lock (S, X, or SSX).
Action: Restart the instance with DML_LOCKS not equal to zero, and reexecute the statement

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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/