Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Listing all Oracle instances in UNIX

Re: Listing all Oracle instances in UNIX

From: <markp28665_at_aol.com>
Date: 1996/12/03
Message-ID: <19961203225000.RAA16036@ladder01.news.aol.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US