Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Listing all Oracle instances in UNIX
Original Author wanted to know how to see all running instances of Oracle in a UNIX environment.
May I suggest from the UNIX command line: ps -ef | grep pmon
This will produce one line for each oracle instance running. If you think one of the Oracle background processes may have crashed you can use smon for pmon or if you want to see all the background processes at once use 'ora_' for pmon.
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Dec 03 1996 - 00:00:00 CST