Stop the listener - you can at least prevent others from connecting to the instance that you’re trying to shut down:
bash-3.00$ lsnrctl stop
Get a list of processes hitting the database. You’ll need that before you start killing them off one by one: bash-3.00$ ps -eaf|grep LOCAL
Kill the processes. Take the second column’s output from step #2 and execute the following:
bash-3.00$ kill -9 396- where “396” is the processid you wish to kill.
Enter into SQLPlus and connect as SYSDBA:
SQL> conn /as sysdba- you’ll receive
"Connected to an idle instance"
Shutdown the database via
SQL> shutdown immediateYou may be given the following:
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01090: shutdown in progress - connection is not permitted
Reconnect to SQLPlus via sysdba via
SQL> conn /as sysdba
Don’t forget to start the listener back up