All posts by mpbod

ORA-00207: control files are not for the same database

ORA-00207: control files are not for the same database

ORA-00207: control files are not for the same database
Cause: The database ID in the control file is not the same as the database ID in the control file used by the first instance to mount this database. Most likely one of the mounts used the wrong control file or there are two databases with the same name.
Action: Check that the control file is for the correct database and is not an old version.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00206: error in writing (block string, # blocks string) of control file

ORA-00206: error in writing (block string, # blocks string) of control file

ORA-00206: error in writing (block string, # blocks string) of control file
Cause: A disk I/O failure was detected on writing the control file.
Action: Check if the disk is online, if it is not, bring it online and try a warm start again. If it is online, then you need to recover the disk.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00205: error in identifying control file, check alert log for more info

ORA-00205: error in identifying control file, check alert log for more info

ORA-00205: error in identifying control file, check alert log for more info
Cause: The system could not find a control file of the specified name and size.
Action: Check that ALL control files are online and that they are the same files that the system created at cold start time.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00204: error in reading (block string, # blocks string) of control file

ORA-00204: error in reading (block string, # blocks string) of control file

ORA-00204: error in reading (block string, # blocks string) of control file
Cause: A disk I/O failure was detected on reading the control file.
Action: Check if the disk is online, if it is not, bring it online and try a warm start again. If it is online, then you need to recover the disk.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00203: using the wrong control files

ORA-00203: using the wrong control files

ORA-00203: using the wrong control files
Cause: 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: Check that the correct control files were specified.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00202: control file: ‘string’

ORA-00202: control file: ‘string’

ORA-00202: control file: ‘string’
Cause: This message reports the name file involved in other messages.
Action: See associated error messages for a description of the problem.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00201: control file version string incompatible with ORACLE version string

ORA-00201: control file version string incompatible with ORACLE version string

ORA-00201: control file version string incompatible with ORACLE version string
Cause: The control file was created by incompatible software.
Action: Either restart with a compatible software release or use CREATE CONTROLFILE to create a new control file that is compatible with this release.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00200: control file could not be created

ORA-00200: control file could not be created

ORA-00200: control file could not be created
Cause: It was not possible to create the control file.
Action: Check that there is sufficient disk space and no conflicts in filenames and try to create the control file again.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00166: remote/local nesting level is too deep

ORA-00166: remote/local nesting level is too deep

ORA-00166: remote/local nesting level is too deep
Cause: 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: Rearrange the query or co-locate the functions with the tables.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed

ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed

ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed
Cause: A request was made by the application to start a migratable distributed autonomous transaction with remote operation.
Action: none

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/