Error Code
ORA-00208
Description
Number of control file names exceeds limit of string.
Cause
Possible cause of this error is, an attempt was made to use more control files than Oracle supports.
Action
To fix this issue, shut down Oracle. Reduce the number of control files specified in the CONTROL_FILES parameter in the initialization parameter file, and restart Oracle. Delete usused files.
reference
Programming Tutorials on XHTML, CSS, JavaScript, JQuery, JSON, Python, Django, Amazon Web Services, ASP.NET, Web Forms, and SQL
Saturday, March 30, 2013
Wednesday, March 27, 2013
ORA-00207 Control Files are not for the Same Database
Error Code
ORA-00207
Description
Control files are not for the same database.
Cause
Possible cause of this error is, 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
To fix this error, check that the control file is for the correct database and is not an old version.
reference
ORA-00207
Description
Control files are not for the same database.
Cause
Possible cause of this error is, 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
To fix this error, check that the control file is for the correct database and is not an old version.
reference
ORA-00206 Error in Writing Block String of Control File
Error Code
ORA-00206
Description
Error in writing (block string, # blocks string) of control file.
Cause
Possible cause of this error is, a disk I/O failure was detected on writing the control file.
Action
To fix this error, 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.
reference
ORA-00206
Description
Error in writing (block string, # blocks string) of control file.
Cause
Possible cause of this error is, a disk I/O failure was detected on writing the control file.
Action
To fix this error, 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.
reference
ORA-00205 Error in Identifying Control File
Error Code
ORA-00205
Description
Error in identifying control file, check alert log for more info.
Cause
Possible cause of this error is, the system could not find a control file of the specified name and size.
Action
To fix this issue, check that ALL control files are online and that they are the same files that the system created at cold start time.
reference
ORA-00205
Description
Error in identifying control file, check alert log for more info.
Cause
Possible cause of this error is, the system could not find a control file of the specified name and size.
Action
To fix this issue, check that ALL control files are online and that they are the same files that the system created at cold start time.
reference
ORA-00204 Error in Reading Block String of Control File
Error Code
ORA-00204
Description
Error in reading (block string, # blocks string) of control file.
Cause
Possible cause of this error is, a disk I/O failure was detected on reading the control file.
Action
To fix this issue, 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.
reference
ORA-00204
Description
Error in reading (block string, # blocks string) of control file.
Cause
Possible cause of this error is, a disk I/O failure was detected on reading the control file.
Action
To fix this issue, 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.
reference
Subscribe to:
Posts (Atom)