Re: Oracle databases on a server

From: <>
Date: Fri, 20 Feb 2009 04:05:58 -0800 (PST)
Message-ID: <>

On 20 Feb, 06:00, 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

Original text of this message