Oracle DB Error ORA-01093 ALTER DATABASE CLOSE only permitted with no sessions connected

The following in the cause of this error:

There is at least one more session, other than the current one, logged in to the instance. ALTER DATABASE CLOSE is not permitted when other sessions are active.

Action you can take to resolve this issue: Find the other sessions and disconnect them. Then reissue the ALTER DATABASE CLOSE statement. Also, issue the SHUTDOWN IMMEDIATE command to force users off the system, or issue the SHUTDOWN ABORT command to shut down the database without waiting for users to be forced off.

Tags: Database, Education, Software

Related