Oracle Cmd to list all Databases

[Japskunk72]

I was wondering if you where the admin to an oracle db server what is the command to list all the DB's on the system? is there an SQL command that will display all databases?
Thanks
JT

 

[alexhu]

THere isn't a reliable one. Most depend on the databases being active - they cannot find the ones shut down

Alex

 

[carp]

Your best clue would probably be the listener.ora file.

 

[alexhu]

Carp - only if its up to date

Alex

 

[Turkbear]

Hi,
If you have access to the server itself, (and it is Windows-based) then looking in the services list will show you which instances are created on that box...

( In Unix you can probably find some info somewhere under /etc or in $ORACLE_HOME )

If there is an Oracle Agent running on the server, then Enterprise Manager can 'discover' the instances...

 

[Japskunk72]

there isnt a select statement or a SQL command to run in the SQL Plus tool? I am running Windows 2000 on a windows 2000 server with SQL 2000 running on it. can i get to it from SQL2000?
Thanks

BTW
SQL 2000 is on a different computer then ORACLE and doesnt have Oracle instance of anything on it.

Thanks again
JT

 

[Turkbear]

Hi,
No, a SqlPlus query can only tell you about the database instance it is connected to ( either directly or by a db link)... As a SqlServer person you may be confusing databases( in SqlServer terms) with schemas ( which is what an commonly-owned set of objects [tables,views etc] is called in Oracle-speak).

As to part 2 of your question, in almost all cases ( except using some 3rd-party thin-client ODBC drivers) you need to have SqlNet client software on any server or workstation that needs to connect to a remote Oracle instance...