Wednesday, March 27, 2013

ORA-00202 Control File String

Error Code
ORA-00202

Description
Control file: 'string'.

Cause
Possible cause of this error is, this message reports the name file involved in other messages.

Action
To fix this error, see associated error messages for a description of the problem.

reference

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