Re: Oracle databases on a server

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 21 Feb 2009 11:10:44 +0100
Message-ID: <70a298Flu7lvU1_at_mid.individual.net>

On 20.02.2009 13:05, gareth_at_jamms.org wrote:
> On 20 Feb, 06:00, p..._at_qantas.com.au wrote:

>> I have Oracle installation on a SUN UNIX server. I tappears that it is
>> running Oracle 10.2 and Solaris 8.
>>
>> I want to find out how many databases are installed on this server.
>>
>> Would it be true to say that all databases installed on this server
>> are listed in tnsnames.ora where the 'HOST' entry points to this
>> server?

>
> In addition to Vladimir Zakharychev's suggestions, the following
> command will list all running instances:
>
> ps -eaf | grep pmon

Yet another option to find running instances is to query all listeners on the machine (that you know of) with lsnrctl's command "services". There are so many ways...

Cheers

        robert Received on Sat Feb 21 2009 - 04:10:44 CST