"James" <james_at_nothing.com> wrote in message
news:1045650195.584305_at_ftp.adept.co.za...
> Hi there
> Can someone tell me how I can get the names of all the Databases on a
> server? I understand that the that the database structure of a n oracle
> server is very different to a SQL server.
>
> I wand to be able to determin all the names of all the database on the
> server that I'm working with.
> I'm using oracle 9i server and have full rights to the server!
>
> Hope someone can help.
> Thanks in Advance
> cheers
> James
>
>
On an Unix box you should have a configuration (ASCII) file,oratab,
located under
/var/opt/oracle (SOLARIS)
/etc (Other Unix)
that contains the SID and the ORACLE_HOME for each instance configured on
the server,
the form is
<SID_VALUE>:<ORACLE_HOME_VALUE>:<FLAG_RESTART>
FLAG_RESTART tells you if, wher the server starts, the instance must
restart(Y) or not (N)
in a windows server you should look the registry
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\ORACLE_SID
HTH
Francesco
Received on Wed Feb 19 2003 - 05:21:47 CST
