ORA-00203 Using the Wrong Control Files

Error Code
ORA-00203

Description
Using the wrong control files.

Cause
Possible cause of this error is ,the mount ID in the control file is not the same as the mount ID in the control file used by the first instance to mount this database. The control files are for the same database but they are not the same files. Most likely one instance is using a backup control file.

Action
To fix this issue, check that the correct control files were specified.

reference

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

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