Shell Programming and Scripting

Most of the code I've seen is been listing processes or capturing process ids, etc. But here's what I need to do. Preferably in Korn shell.

1. do a ps -ef |grep tns |grep -v grep
in order to get a list or Oracle listeners that are running.
2. parse the line into components which will contain the listener name and the path that it's attached to.
3. Then I have to execute a command to stop each listener which will contain the command, the path to execute from, and the listener name.
4. I will have to store this information out to a file to later start the same list of listeners.

So far trying to do a for loop on the ps output doesn't help as it tries to say everything in the ps line is a seperate entry. Maybe there is a way that to seperate entries based on carriage return/linefeed.

Michael

Can you post a representative sample output of report process status command below:

Code:

ps -ef |grep tns |grep -v grep

and desired output?

oracle 24031 1 0 Jan 16 ? 2:09 /oracle/g01/software/grid/11.2.0.3/bin/tnslsnr LISTENER_SCAN2 -inherit
oracle 24135 1 0 Jan 16 ? 1:53 /oracle/g01/software/grid/11.2.0.3/bin/tnslsnr LSNR_CXP -inherit
oracle 24140 1 0 Jan 16 ? 1:52 /oracle/g01/software/grid/11.2.0.3/bin/tnslsnr LSNR_NDW -inherit

I need to be able to output the path and listener name which is the ones like LISTENER_SCAN2, LSNR_CXP to a file. so I have a list something like:
/oracle/g01/software/grid/11.2.0.3 LISTENER_SCAN2
/oracle/g01/software/grid/11.2.0.3 LSNR_CXP
/oracle/g01/software/grid/11.2.0.3 LSNR_NDW

I was just thinking maybe I can do it with an awk statement in there.

Michael

Code:

ps -ef | awk '/tnslsnr/&&!/awk/{ print $(NF-2),$(NF-1) }' > filename

Thanks, that takes care of output to a file. But here is the 2nd part I need to do. I was hoping to do a for loop to stop the listeners which I have to do:
$ORACLE_HOME/bin/lsnrctl stop $ListenerName
on each of the listener names.

Since this is done inside some automation software I try to clean up the output and echo what's going on in a format the DBAs can read. That I can do if it's something I can do through for loop and echo things like $Path and $ListenerName etc. one at a time.


Thanks for your help.

Use a while loop to read Path and ListenerName one at a time:

Code:

while read Path ListenerName
do
   echo "${ORACLE_HOME}/bin/lsnrctl stop $ListenerName"
done < filename

Note: Remove highlighted echo and double quotes " if output looks good.

You can use the ps command itself to get at that info...

Code:

ps -C tnslsnr -oargs= | while read lp ln args
do
    echo "$lp stop $ln"  > lsnr_start
    echo "$lp start $ln" > lsnr_stop
done

First file contains commands to start while the other to stop the listener...