Re: What file can I use to determine if the instance is up ?

Since you are in Unix, you could try

ps -deaf | grep -i oracle | grep -v LOCAL | grep -v grep

This should list the Oracle processes that are running ( if I remember correctly, the -v's get rid of the user processes)

In article <fQm46.1$1s1.8859313_at_WCG-Reader>,   "Richard Elliott" <richard.a.elliott_at_williams.com> wrote:
> For 7.3 I have been using
> /usr/oracle/dbs/sgadef$SID.dbf
>
> For 8.x I have been using
> /usr/oracle/product/8.1.6/dbs/lk$SID ]
> but this morning I found this file existed but the instance was not
 up.
>
> Is there a more correct file or way to do this ?
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com
http://www.deja.com/