Monday, January 28, 2013

ORA-00060 deadlock detected while waiting for resource

Error Code
ORA-00060

Description
deadlock detected while waiting for resource

Cause
Possible cause of this error is, when transactions deadlocked one another while waiting for resources.

Action
To fix this error, look at the trace file to see the transactions and resources involved. Retry if necessary.

reference

ORA-00059 maximum number of DB_FILES exceeded


Error Code
ORA-00059

Description
maximum number of DB_FILES exceeded

Cause
Possible cause of this error is, the value of the DB_FILES initialization parameter was exceeded.

Action
To fix this error, increase the value of the DB_FILES parameter and warm start.


reference

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

Error Code
ORA-00058

Description
DB_BLOCK_SIZE must be string to mount this database (not string)

Cause
Possible cause of this error is, DB_BLOCK_SIZE initialization parameter is wrong for the database being mounted. It does not match the value used to create the database.

Action
To solve this error, fix the value of the DB_BLOCK_SIZE parameter or mount a database that matches the value.


ORA-00057 maximum number of temporary table locks exceeded


Error Code
ORA-00057

Description
maximum number of temporary table locks exceeded

Cause
Possible cause of this error is when 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.


reference

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


Error Code
ORA-00056 

Description
DDL lock on object 'string.string' is already held in an incompatible mode

Cause
A possible cause of this error is that 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.


reference