Re: Find out the name of Oracle DB on a solaris server?

lazyboy_2k_at_yahoo.com wrote:
> Hi,
>
> Is there a way to find out how many oracle db & their names on a
> solaris server? I run ps -ef |grep ora, however the output is too
> broad & I'd like to narrow it down. Any helps are appreciated.
>
> TIA,
> -Chris
>

To see the SID's of the currently running instances, do any of the following:

ps -ef|grep smon
ps -ef|grep pmon

To see which Oracle instances are scheduled to be started on reboot of your Solaris server, do the following:

cat /var/opt/oracle/oratab

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown