Oracle 无法正常关闭
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 immediate
You 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
Execute a
startup force
command.Don’t forget to start the listener back up
|
|