Gave command: "SQL> shutdown immediate" to shutdown DB. But it is hung.
Also I am not able to connect to DB via PL/SQL Developer. Its throwing error: "ORA 12537: TNS Connection closed
Oracle DB Shutdown issue
oracle
Related Question
- Sql-server – SQL Server to Oracle export using Microsoft OLEDB Provider for Oracle
- Oracle PLSQL code recovery
- Ora-12514 Error While Connecting local Oracle EXPRESS EDITION 11
- Oracle Database 11g Failing to mount on windows server 2012
- Windows – Cannot connect to Oracle 19 instance running in a container under Ubuntu 20.04 via WSL2 on Docker for Windows
Best Answer
shutdown immediate
will end idle sessions, but my understanding is that it will not kill of any statements which are in the middle of processing. But once issued, it will stop any new sessions from starting (thus you cannot connect any more).So you can either wait for the operations to finish, or try
shutdown abort
.