Wednesday, March 27, 2013

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

ORA-00163: Internal Database Name Length String is Greater than Maximum

Error Code
ORA-00163

Description
Internal database name length string is greater than maximum (string).

Cause
Possible cause of this error is, an internal database name with a too large length field was passed in.

Action
To fix this error, report the problem to your external transaction coordinator vendor.

reference