Question about shell scripting

[jlakhani]

I have a tuning script that I want to run on all NT/Unix boxes. We have over 60 instances total. I dont want to sit there and run this script on all 60 instances. Any ideas how I can incoporate my tuning script to run all these instances??? We follow OFA

thanks
Jigar

[stecal]

ps -ef | grep smon |awk or cut the SID out of it| wc -l >>some file

read that file, line by line (and there are about a million ways to do that) where you set $SID_TO_BE_PROCESSED equal to the current line, followed by your script being called inside the shell script. In your shell script, of course, you will be connecting and disconnecting to and from each SID, so don't forget to incorporate that aspect.

You run the script only against active instances and it's done for you in one step.

[marist89]

http://otn.oracle.com/docs/products/...yast.htm#21532