Re: how to find instances on server ??

opnets_at_yahoo.co.uk (Dave) wrote in message news:<c9e9d941.0305270855.796f1c8e_at_posting.google.com>...
> Hi all,
>
> I just need top list out all the instances on the server running oracle.
>
> Pls let me know how to do this??
>
> Thanks in advance
>
> Dave.

1. Get all running instances.

*nix:
$ ps -ef | grep dbw

WinNT/2K:
C:\> net start | find /i "OracleService"

2) Get all installed instances.

*nix:
$ grep ^[A-Z,a-z] /etc/oratab | awk -F : '{print $1}'

WinNT/2K:
You would need an NT resource kit utility called Reg.exe. Put it somewhere in path and,
C:\> FOR /F "delims=[,]OracleService" %A IN ('REG QUERY HKLM\SYSTEM\CURRENTCONTROLSET\SERVICES^|find /i "OracleService"') DO ECHO %A Regards
/Rauf Sarwar Received on Wed May 28 2003 - 13:21:05 CDT