Wednesday, March 27, 2013

ORA-00201 Control File Version String Incompatible with ORACLE Version String

Error Code
ORA-00201

Description
Control file version string incompatible with ORACLE version string.

Cause
Possible cause of this error is, the control file was created by incompatible software.

Action
To fix this error, either restart with a compatible software release or use CREATE CONTROLFILE to create a new control file that is compatible with this release.

reference

ORA-00200 Control File could not be Created

Error Code
ORA-00200

Description
Control file could not be created.

Cause
Possible cause of this error is, it was not possible to create the control file.

Action
To fix this issue, check that there is sufficient disk space and no conflicts in filenames and try to create the control file again.

reference

Monday, March 25, 2013

ORA-00166 Remote or Local Nesting Level is too Deep

Error Code
ORA-00166

Description
Remote/local nesting level is too deep.

Cause:
Possible cause of this error is, too many remote table operations required a reverse trip back to the local site, for example to execute a local function on a remote table.

Action
To fix this error, rearrange the query or co-locate the functions with the tables.

reference

ORA-00165 Migratable Distributed Autonomous Transaction with Remote Operation is not Allowed

Error Code
ORA-00165

Description
Migratable distributed autonomous transaction with remote operation is not allowed.

Cause
Possible cause of this error is, a request was made by the application to start a migratable distributed autonomous transaction with remote operation.

Action
none

reference

ORA-00164 Distributed Autonomous Transaction Disallowed within Migratable Distributed Transaction

Error Code
ORA-00164

Description
Distributed autonomous transaction disallowed within migratable distributed transaction

Cause
Possible cause of this error is, a request was made by the application to start a distributed autonomous transaction when the application was in a migratable distributed transaction.

Action
To fix this error, roll back or commit the current distributed transaction first.

reference