ORA-01157: cannot identify/lock data file string - see DBWR trace file

Oracle error

ORA-01157: cannot identify/lock data file string - see DBWR trace file

Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.

Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.

See more oracle error here.

Oracle error- ORA-01095: DML statement processed zero rows

Oracle error

ORA-01095: DML statement processed zero rows

Cause: During a call to OTEX, an update, delete, or insert statement being executed processed zero rows. The execution of statements by OTEX was halted at this point.

Action: None

See more oracle error here.

oracle error- ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

Oracle error

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

Cause: There is at least one more session other than the current one logged into the instance. ALTER DATABASE CLOSE is not permitted.

Action: Find the other sessions and log them out and resubmit the command

See more oracle error here.