Hi,
Well, as such their is no full proof method of finding this, but, the following may be of help:

On Windows:
Just go to the services panel and look for services starting with ORACLESERVICE<SID> where SID is your DB_SID.

On Unix:
The following will give you all the databases ever present on your system
# cd /var/opt/oracle
# more oratab
To list the currently running databases,
# ps -ef|grep pmon

Regards,
Vibhor Agarwal
Executive - DBA
Mastek Ltd.
SEEPZ, Mumbai
Mob: +91-98195-35552
Email: [Email address protected]


----- Original Message -----
From: "karunakar katta " <oracledba-ezmlmshield-x84100107.[Email address protected]
Date: Sun, 13 Jun 2004 22:14:31 -0700 (PDT)
To: "LazyDBA Discussion" <[Email address protected]
Subject: to list all databases available in oracle

hi,

I want to list all databases which are running using query. how.

when i excute following query

select name from v_$database;

it list only one database name which i connected even though oracle has more databases.

so help me how to list all database which are available in oracle.


karun.


---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html


--
India.com free e-mail - www.india.com.
Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes!

Powered by Outblaze

Oracle LazyDBA home page