Archive for January, 2005

Oracle Error ORA-00065


01 Jan

Oracle Error :: ORA-00065
initialization of FIXED_DATE failed

Cause
The FIXED_DATE string was not in date format yyyy-mm-dd:hh24:mi:ss.

Action
Make sure the initialization parameter is in the correct date format.

Oracle Error ORA-00064


01 Jan

Oracle Error :: ORA-00064
object is too large to allocate on this O/S (string,string)

Cause
An initialization parameter was set to a value that required allocating more contiguous space than can be allocated on this operating system.

Action
Reduce the value of the initialization parameter.

Oracle Error ORA-00063


01 Jan

Oracle Error :: 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.

Oracle Error ORA-00062


01 Jan

Oracle Error :: 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.

Oracle Error ORA-00061


01 Jan

Oracle Error :: 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.

Oracle Error ORA-00060


01 Jan

Oracle Error :: 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.

Oracle Error ORA-00059


01 Jan

Oracle Error :: 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.

AntoniusSony.Com

It's Good to be an Important person,but it's more Important to be a Good person