When I want to shutdown the oracle database. I must kill many session client who connect to the database and running in background Os…

# ps -ef|grep -i local=no

oracle 19027 1 0 Sep 07 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 25918 1 0 Sep 07 ? 0:03 oracleSERVER (LOCAL=NO)
oracle 16403 1 0 Sep 07 ? 0:00 oracleSERVER (LOCAL=NO)
oracle 18858 1 0 Sep 06 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 7836 1 0 Sep 07 ? 0:02 oracleSERVER (LOCAL=NO)
oracle 9021 1 0 Sep 07 ? 0:00 oracleSERVER (LOCAL=NO)
oracle 27940 1 0 Sep 06 ? 0:00 oracleSERVER (LOCAL=NO)
oracle 25505 1 0 Sep 07 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 2427 1 0 Sep 07 ? 0:00 oracleSERVER (LOCAL=NO)
oracle 26640 1 0 Sep 06 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 15440 1 0 19:23:09 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 16712 1 0 Sep 07 ? 0:00 oracleSERVER (LOCAL=NO)
oracle 11544 1 0 Sep 06 ? 0:00 oracleSERVER (LOCAL=NO)
oracle 1411 1 0 Sep 07 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 18909 1 0 Sep 06 ? 0:00 oracleSERVER (LOCAL=NO)
oracle 15607 1 0 Sep 06 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 2873 1 0 Sep 06 ? 0:01 oracleSERVER (LOCAL=NO)
oracle 21197 1 0 17:36:49 ? 0:00 oracleSERVER (LOCAL=NO)
oracle 22318 1 0 Sep 06 ? 0:02 oracleSERVER (LOCAL=NO)
…

Show this the trick (when Nobody give up..:D)
# ps -ef|grep LOCAL|awk '{print $2'}|xargs kill -9

Tada..

Popularity: 16% [?]

You Should Also Check Out This Post:

• Troubleshooting for startup inconsistent DB
• Linux System information
• set hostname without reboot
• ssh[23593]: [ID 530472 user.error] Kerberos mechanism library initialization error:
• Tracking Down "Last Reboot" on windows

More Active Posts:

• Ssh in Solaris (2)
• ERROR! MySQL manager or server PID file could not be found! (1)