Re: how to find instances on server ??

From: Harry Boswell <hboswel1_at_bellsouth.net>
Date: Fri, 30 May 2003 16:47:21 -0500
Message-ID: <avjfdv43f1qqcaf05r4j75d80p24dudf5m@4ax.com>

On Tue, 27 May 2003 20:50:45 +0100, "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote:

>"Dave" <opnets_at_yahoo.co.uk> 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.
>
>If it's *ix, ps -ef|grep dbw

I've always used pmon. But I've wondered if there wasn't an Oracle utility that I'd missed somehow, that would tell you what instances existed on the machine and what their status was.

I wrote a script for the netowrk admins to use, in case I'm not available, to check on the instances on our Solaris boxes. Nothing fancy at all, but it does tell them what's running:

echo
echo "Listener Status:"

echo "----------------"

lsnrctl status | grep service
echo
echo
echo
echo "Databases currently running:"

echo "----------------------------"

ps -ef -o comm | grep pmon | grep -v grep | cut -c10-20 echo
echo

Harry Boswell Received on Fri May 30 2003 - 16:47:21 CDT