Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database names?
ps -edf|grep pmon
On a unix box will show you all the pmon processes. You will have one
for each instance running. If you are running on windoze -- sorry.
-- Andrew Allen James wrote:Received on Wed Feb 19 2003 - 10:53:00 CST
> 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
>
>