OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » How can i known...

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

How can i known... [message #240575]

Fri, 25 May 2007 04:22

akkumar81
Messages: 144
Registered: February 2007
Location: india

Senior Member

Dear Micheal,

How can i known how many database having in my system, please send replies.I need urgent.

Arun..

Report message to a moderator

Re: How can i known... [message #240580 is a reply to message #240575]

Fri, 25 May 2007 04:29

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Do you want to know how many databases you have in your system, or how many instances you have in a database?

Report message to a moderator

Re: How can i known... [message #240582 is a reply to message #240575]

Fri, 25 May 2007 04:31

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

Senior Member
Account Moderator

Which OS?
Do you want the started databases or all databases?

Regards
Michel

[Updated on: Fri, 25 May 2007 05:18]

Report message to a moderator

Re: How can i known... [message #240599 is a reply to message #240575]

Fri, 25 May 2007 05:12

akkumar81
Messages: 144
Registered: February 2007
Location: india

Senior Member

window xp

Report message to a moderator

Re: How can i known... [message #240604 is a reply to message #240599]

Fri, 25 May 2007 05:17

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

Senior Member
Account Moderator

And for the other question?

Regards
Michel

Report message to a moderator

Re: How can i known... [message #240608 is a reply to message #240575]

Fri, 25 May 2007 05:25

akkumar81
Messages: 144
Registered: February 2007
Location: india

Senior Member

I want to known which (databases are not running currently) are having in my system .

Any commands?

Report message to a moderator

Re: How can i known... [message #240610 is a reply to message #240608]

Fri, 25 May 2007 05:27

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

Senior Member
Account Moderator

No command.
Database are just files.
How to know which one belongs to an (valid) Oracle database?

Regards
Michel

Report message to a moderator

Re: How can i known... [message #240612 is a reply to message #240575]

Fri, 25 May 2007 05:31

akkumar81
Messages: 144
Registered: February 2007
Location: india

Senior Member

example

My system have Oracle,sql server are there.

How can i known these are having in my system.

I known changing one db to another using oracle_sid.

Arun..

Report message to a moderator

Re: How can i known... [message #240614 is a reply to message #240612]

Fri, 25 May 2007 05:39

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

Senior Member
Account Moderator

To change your ORACLE_SID you have to know which SID are there.
You can open your "Control Panel/Services" box and check all OracleServiceXXX to know available SID.
Remark: SID are instance names not databases.

Regards
Michel

Report message to a moderator

Previous Topic:	diff between until time and until cancel
Next Topic:	SGA Sizing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 25 04:03:14 CST 2025