ORA-01120: cannot remove online database file string
Cause: Attempting to drop a datafile when it is online
Action: Take file offline before dropping.
All posts by mpbod
ORA-01119: error in creating database file ‘string’
ORA-01119: error in creating database file ‘string’
Cause: Usually due to not having enough space on the device.
Action: none
ORA-01118: cannot add any more database files: limit of string exceeded
ORA-01118: cannot add any more database files: limit of string exceeded
Cause: There is no more room in the control file for adding database files.
Action: Resize the control file or drop other tablespaces.
ORA-01117: adding file ‘string’ with illegal block size: string; limit is string
ORA-01117: adding file ‘string’ with illegal block size: string; limit is string
Cause: An attempt was made to add a database file with a block size that is greater than the maximum block size allowed.
Action: Retry the DDL command with a smaller block size.
ORA-01116: error in opening database file string
ORA-01116: error in opening database file string
Cause: Usually the file is not accessible.
Action: Restore the database file.
ORA-01115: IO error reading block from file string (block # string)
ORA-01115: IO error reading block from file string (block # string)
Cause: Device on which the file resides is probably offline
Action: Restore access to the device
ORA-01114: IO error writing block to file string (block # string)
ORA-01114: IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
Action: Restore access to the device or remove unnecessary files to free up space.
ORA-01113: file string needs media recovery
ORA-01113: file string needs media recovery
Cause: An attempt was made to online or open a database with a file that is in need of media recovery.
Action: First apply media recovery to the file.
ORA-01112: media recovery not started
ORA-01112: media recovery not started
Cause: An attempt to continue media recovery is being made but media recovery was not started.
Action: None.
ORA-01111: name for data file string is unknown – rename to correct file
ORA-01111: name for data file string is unknown – rename to correct file
Cause: The data file was missing from a CREATE CONTROLFILE command or backup control file recovery was done with a control file that was saved before the file was created.
Action: Rename the MISSING file to the name of the real file.
Solution: Verify this Problem