Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Listing all Oracle instances in UNIX
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
![]() |
![]() |