Tuesday, 31 January 2012

ORA-04027: self-deadlock during automatic validation for object string.string

ORA-04027: self-deadlock during automatic validation for object string.string

Cause: An attempt was made to validate an invalidated object but it failed because of a self-deadlock.

Action: , e.g. compile the invalidated object separately.

ORA-04022: nowait requested, but had to wait to lock dictionary object

ORA-04022: nowait requested, but had to wait to lock dictionary object

Cause: Had to wait to lock a library object during a nowait request.

Action: Retry the operation later.

ORA-04021: timeout occurred while waiting to lock object stringstringstringstringstring

ORA-04021: timeout occurred while waiting to lock object stringstringstringstringstring

Cause: While waiting to lock a library object, a timeout is occurred.

Action: Retry the operation later.

ORA-04020: deadlock detected while trying to lock object stringstringstringstringstring

ORA-04020: deadlock detected while trying to lock object stringstringstringstringstring

Cause: While trying to lock a library object, a deadlock is detected.

Action: Retry the operation later.

ORA-04017: invalid value string (length = string) for parameter max_dump_file_size

ORA-04017: invalid value string (length = string) for parameter max_dump_file_size

Cause: neither did the string supplied for max_dump_file_size parameter match the UNLIMITED string value nor did it represent a base 10 integer.

Action: reassign a proper value to this parameter.

ORA-04016: sequence string no longer exists

ORA-04016: sequence string no longer exists

Cause: sequence was dropped while processing its next value.

Action: re-create the sequence

ORA-04015: ascending sequences that CYCLE must specify MAXVALUE

ORA-04015: ascending sequences that CYCLE must specify MAXVALUE

Cause: sequences that cycle must have their wrap-wrap specified

Action: re-create the sequence, specifying its wrap-value