Re: many instances of Oracle on single machine

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 27 Apr 2006 08:24:37 -0700
Message-ID: <1146151477.000691.47030@i39g2000cwa.googlegroups.com>

schw wrote:
> it's under linux or unix but what about win platform ?

On *nix
ps -ef | grep -i ora_pmon_ | grep -v grep | cut -d_ -f 3-4

On Win*
net start | find /i "OracleService"

Note: Windows method only shows you if the service is running. It does not tell you whether the database is open or not like you can with one command on *nix. You have to use pslist.exe or tlist.exe to query the process list and look for oracle* processes. Then get the process command line which looks like %ORACLE_HOME%\bin\oracle.exe SID (Where SID is database SID).

Regards
/Rauf Received on Thu Apr 27 2006 - 10:24:37 CDT