Case Study:
Scorfield is working in support team. He needs to kill Listener if the listener is in hung state at night when DBA’s are not available.
Solution:
Create a script that can kill the listener process and provide sudo access to scorfield to execute the script.
[root@stagedb3 ~]# vi /usr/local/bin/kill_listener.sh
#!/bin/sh
kill -9 `ps -ef|grep -v grep|grep LISTENER|grep oracle|awk '{print $2}'|xargs`
echo "Tried to kill Oracle listener(s), check with ps -ef if the process(es) died "
[root@stagedb3 ~]# chown oracle:dba /usr/local/bin/kill_listener.sh
[root@stagedb3 ~]# chmod 600 /usr/local/bin/kill_listener.sh
[root@stagedb3 ~]# vi /etc/sudoers
scorfield ALL=(oracle) NOPASSWD: /usr/local/bin/kill_listener.sh
Now Test it:
[scorfield@stagedb3 ~]$ sudo -i -u oracle /usr/local/bin/kill_listener.sh
Tried to kill Oracle listener(s), check with ps -ef if the process(es) died
[scorfield@stagedb3 ~]$ ps -ef | grep LISTENER|grep oracle
There should not be any process running.