Re: Oracle databases on a server
From: <gareth_at_jamms.org>
Date: Fri, 20 Feb 2009 04:05:58 -0800 (PST)
Message-ID: <6e318c46-0779-41af-916a-d11ebf798a88_at_l1g2000yqj.googlegroups.com>
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?
Date: Fri, 20 Feb 2009 04:05:58 -0800 (PST)
Message-ID: <6e318c46-0779-41af-916a-d11ebf798a88_at_l1g2000yqj.googlegroups.com>
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
HTH -g Received on Fri Feb 20 2009 - 06:05:58 CST