Re: How to See oracle database without gui

In addition to the other good suggestions here, if you're on Unix you may also want to locate what's called an "oratab" file. In theory (and even sometimes in practice) this fie contains a list of all Oracle databases installed on a particular machine. O'Reilly has a script that you can look at (or run) to determine the typical locations for the oratab file:

http://examples.oreilly.de/english_examples/oraclescrp/CDROM/DBA/LOCATION

FYI, it is possible that one or more databases have been deleted from a machine but still have an oratab entry and multiple oratab entries may exist on a single machine.

-joe

peter wrote:
> Hello DBAs,
>
> Please tell me if there is any way through which we can see how many
> databases are there in my Operating System, without using any GUI
> components ( OEM,DBCA ).With any command.
> if yes, then what is the command.............
>
>
> Thank You
Received on Mon Jun 12 2006 - 14:48:31 CDT