In this post, we will be listing all the Oracle error messages or error codes from ORA-00201 to ORA-000300.
Oracle Error Message ORA-00201 to ORA-000300
ORA-00201 |
control file version string incompatible with ORACLE version string |
ORA-00202 |
control file: ‘string’ |
ORA-00203 |
using the wrong control files |
ORA-00204 |
error in reading (block string, # blocks string) of control file |
ORA-00205 |
error in identifying control file, check alert log for more info |
ORA-00206 |
error in writing (block string, # blocks string) of control file |
ORA-00207 |
control files are not for the same database |
ORA-00208 |
number of control file names exceeds limit of string |
ORA-00209 |
control file blocksize mismatch, check alert log for more info |
ORA-00210 |
cannot open the specified control file |
ORA-00211 |
control file does not match previous control files |
ORA-00212 |
block size string below minimum required size of string bytes |
ORA-00213 |
cannot reuse control file; old file size string, string required |
ORA-00214 |
control file ‘string’ version string inconsistent with file ‘string’ version string |
ORA-00215 |
must be at least one control file |
ORA-00216 |
control file could not be resized for migration from 8.0.2 |
ORA-00217 |
control file could not be resized for new record types |
ORA-00218 |
block size string of control file ‘string’ does not match DB_BLOCK_SIZE (string) |
ORA-00219 |
required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks) |
ORA-00220 |
control file not mounted by first instance, check alert log for more info |
ORA-00221 |
error on write to control file |
ORA-00222 |
operation would reuse name of a currently mounted control file |
ORA-00223 |
convert file is invalid or incorrect version |
ORA-00224 |
control file resize attempted with illegal record type (string) |
ORA-00225 |
expected size string of control file differs from actual size string |
ORA-00226 |
operation disallowed while alternate control file open |
ORA-00227 |
corrupt block detected in control file: (block string, # blocks string) |
ORA-00228 |
length of alternate control file name exceeds maximum of string |
ORA-00229 |
operation disallowed: already hold snapshot control file enqueue |
ORA-00230 |
operation disallowed: snapshot control file enqueue unavailable |
ORA-00231 |
snapshot control file has not been named |
ORA-00232 |
snapshot control file is nonexistent, corrupt, or unreadable |
ORA-00233 |
copy control file is corrupt or unreadable |
ORA-00234 |
error in identifying or opening snapshot or copy control file |
ORA-00235 |
control file read without a lock inconsistent due to concurrent update |
ORA-00236 |
snapshot operation disallowed: mounted control file is a backup |
ORA-00237 |
snapshot operation disallowed: control file newly created |
ORA-00238 |
operation would reuse a filename that is part of the database |
ORA-00239 |
timeout waiting for control file enqueue: held by ‘string’ for more than string seconds |
ORA-00240 |
control file enqueue held for more than string seconds |
ORA-00241 |
operation disallowed: control file inconsistent with data dictionary |
ORA-00242 |
maximum allowed filename records used up in control file |
ORA-00243 |
failed to expand control file filename section by string records |
ORA-00244 |
concurrent control file backup operation in progress |
ORA-00245 |
control file backup failed; target is likely on a local file system |
ORA-00246 |
control file backup failed; error accessing backup target |
ORA-00250 |
archiver not started |
ORA-00251 |
LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string |
ORA-00252 |
log string of thread string is empty, cannot archive |
ORA-00253 |
character limit string exceeded by archive destination string string |
ORA-00254 |
error in archive control string ‘string’ |
ORA-00255 |
error archiving log string of thread string, sequence # string |
ORA-00256 |
cannot translate archive destination string string |
ORA-00257 |
archiver error. Connect internal only, until freed. |
ORA-00258 |
manual archiving in NOARCHIVELOG mode must identify log |
ORA-00259 |
log string of open instance string (thread string) is the current log, cannot archive |
ORA-00260 |
cannot find online log sequence string for thread string |
ORA-00261 |
log string of thread string is being archived or modified |
ORA-00262 |
current log string of closed thread string cannot switch |
ORA-00263 |
there are no logs that need archiving for thread string |
ORA-00264 |
no recovery required |
ORA-00265 |
instance recovery required, cannot set ARCHIVELOG mode |
ORA-00266 |
name of archived log file needed |
ORA-00267 |
name of archived log file not needed |
ORA-00268 |
specified log file does not exist ‘string’ |
ORA-00269 |
specified log file is part of thread string not string |
ORA-00270 |
error creating archive log string |
ORA-00271 |
there are no logs that need archiving |
ORA-00272 |
error writing archive log string |
ORA-00273 |
media recovery of direct load data that was not logged |
ORA-00274 |
illegal recovery option string |
ORA-00275 |
media recovery has already been started |
ORA-00276 |
CHANGE keyword specified but no change number given |
ORA-00277 |
illegal option to the UNTIL recovery flag string |
ORA-00278 |
log file ‘string’ no longer needed for this recovery |
ORA-00279 |
change string generated at string needed for thread string |
ORA-00280 |
change string for thread string is in sequence #string |
ORA-00281 |
media recovery may not be performed using dispatcher |
ORA-00282 |
UPI string call not supported, use ALTER DATABASE RECOVER |
ORA-00283 |
recovery session canceled due to errors |
ORA-00284 |
recovery session still in progress |
ORA-00285 |
TIME not given as a string constant |
ORA-00286 |
no members available, or no member contains valid data |
ORA-00287 |
specified change number string not found in thread string |
ORA-00288 |
to continue recovery type ALTER DATABASE RECOVER CONTINUE |
ORA-00289 |
suggestion : string |
ORA-00290 |
operating system archival error occurred. See error below |
ORA-00291 |
numeric value required for PARALLEL option |
ORA-00292 |
parallel recovery feature not installed |
ORA-00293 |
control file out of sync with redo log |
ORA-00294 |
invalid archivelog format specifier ‘string’ |
ORA-00295 |
datafile/tempfile number string is invalid, must be between 1 and string |
ORA-00296 |
maximum number of files (string) exceeded for RECOVER DATAFILE LIST |
ORA-00297 |
must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START |
ORA-00298 |
Missing or invalid attribute value |
ORA-00299 |
must use file-level media recovery on data file string |
ORA-00300 |
illegal redo log block size string specified – exceeds limit of string |