Thank all to help. Sorry I forgot about oratab.
debuzna_at_gmail.com wrote:
> 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 Tue Jun 13 2006 - 08:23:26 CDT
