Monday, January 28, 2013

ORA-00069 cannot acquire lock -- table locks disabled for string

Error Code
ORA-00069

Description
cannot acquire lock -- table locks disabled for string

Cause
Possible cause of this error is, a command was issued that tried to lock the table indicated in the message. Examples of commands that can lock tables are: LOCK TABLE, ALTER TABLE ... ADD ( ), and so on.

Action
To fix this error, use the ALTER TABLE ... ENABLE TABLE LOCK command, and retry the command.

reference

ORA-00068 invalid value string for parameter string, must be between string and string

Error Code
ORA-00068

Description
invalid value string for parameter string, must be between string and string

Cause
Possible cause of this error is, the value for the initialization parameter is invalid.

Action
To fix this error, choose a value as indicated by the message.

reference

ORA-00067 invalid value string for parameter string; must be at least string

Error Code
ORA-00067

Description
invalid value string for parameter string; must be at least string

Cause
Possible cause of this error is, the value for the initialization parameter is invalid.

Action
To fix this error, choose a value as indicated by the message.

reference

ORA-00066 LOG_FILES is string but needs to be string to be compatible

Error Code
ORA-00066

Description
LOG_FILES is string but needs to be string to be compatible

Cause
Possible cause of this error is, the maximum number of log files supported by this instance is not the same as for the other instances. All instances must be able to open all the files any instance can open.

Action
To fix this error, change the value of the LOG_FILES initialization parameter to be compatible.

reference

ORA-00065 initialization of FIXED_DATE failed

Error Code
ORA-00065

Description
initialization of FIXED_DATE failed

Cause
Possible cause of this error is, the FIXED_DATE string was not in date format yyyy-mm-dd:hh24:mi:ss.

Action
To fix this error, make sure the initialization parameter is in the correct date format.

reference