OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » How many databases

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How many databases [message #459425]

Sat, 05 June 2010 00:58

tvskumar2000
Messages: 5
Registered: June 2010
Location: Hyderabad

Junior Member

Hi how to know how many databases running in my oracle....
Please clarify..

Thanks and regards.

Report message to a moderator

Re: How many databases [message #459426 is a reply to message #459425]

Sat, 05 June 2010 01:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Hi how to know how many databases running in my oracle....
>Please clarify..

ALWAYS
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
or post Oracle version to 4 decimal places

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How many databases [message #459428 is a reply to message #459426]

Sat, 05 June 2010 01:09

tvskumar2000
Messages: 5
Registered: June 2010
Location: Hyderabad

Junior Member

k in windows xp 32 bit os, Oracle 10.1.0, How to know how many databases are running in my Oracle as sysdba

Report message to a moderator

Re: How many databases [message #459430 is a reply to message #459428]

Sat, 05 June 2010 01:29

Michel Cadot
Messages: 68766
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

When you are connected, you are connected to 1 database.
Please clarify your question and in first:
- what is a database for you
- from where (which program, DOS level, Windows level) do you want to get this information

Regards
Michel

Report message to a moderator

Re: How many databases [message #459431 is a reply to message #459430]

Sat, 05 June 2010 01:38

tvskumar2000
Messages: 5
Registered: June 2010
Location: Hyderabad

Junior Member

In My Oracle server I have few instances. I am not connected to any Instance I want to know how many instances available in my host.
So how can I know this. In nomount stage.

Report message to a moderator

Re: How many databases [message #459432 is a reply to message #459431]

Sat, 05 June 2010 02:25

Michel Cadot
Messages: 68766
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you are not connected, the database status is irrelevant.

Open Services box and see all the OracleService<SID> services.

Regards
Michel

Report message to a moderator

Previous Topic:	data storage
Next Topic:	ora-01110

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 21 04:23:55 CDT 2025