Re: Listing all Oracle instances in UNIX

From: Richard L. Flores <flores_at_ccnet.com>
Date: 1996/12/03
Message-ID: <01bbe14f$98520a40$753550ce@tmekscds>#1/1

If an instance has crashed and has not been brought up again, its sgadef file will still exist. I think an easier, probably surer way is to use the command, "ps -ef | grep ora_pmon" -- may piping this to cut or awk to extract the instance name from the pmon process name.

(the particular ps options may differ on your machine; also you may wish to include only process owned by the oracle id -- though you'll miss those instances brought up as some other dba id!)

Richard L. Flores

George Dau <gedau_at_mim.com.au> wrote in article <32a3d79b.467111290_at_203.12.176.153>...
> You can see which ones are running in $ORACLE_HOME/dbs/sgadef*
> This is fine if you only have one level of Oracle installed, i.e. one
> $ORACLE_HOME. I check /var/opt/oratab to get the $ORACLE_HOME
> directories, then check $ORACLE_HOME/dbs/sgadef* for each of those
> $ORACLE_HOMEs.
>
> Regards,
> George Dau
> gedau_at_mim.com.au
>
Received on Tue Dec 03 1996 - 00:00:00 CST