Add new comment

Hi,

Context of this script is to run on a single server, you are free to use it as a basis for future scripts.

Involving multiple servers brings up many issues that I can't address for you.

As far as the operating system rights needed to run "ps -ef", do you have SSH equivalency set up?

For the DB side of things I know by default many organizations disallow logging in as "/ as sysdba" from remote servers.

If you have SSH equivalency set up between servers you may be able to use SSH command to run "ps -ef" remotely to determine what servers are running. Then you can use that list to form a command line that would work for logging into them.

Good luck!