Home » RDBMS Server » Server Administration » How can i known...
How can i known... [message #240575] Fri, 25 May 2007 04:22 Go to next message
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..
Re: How can i known... [message #240580 is a reply to message #240575] Fri, 25 May 2007 04:29 Go to previous messageGo to next message
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?
Re: How can i known... [message #240582 is a reply to message #240575] Fri, 25 May 2007 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member



window xp
Re: How can i known... [message #240604 is a reply to message #240599] Fri, 25 May 2007 05:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And for the other question?

Regards
Michel
Re: How can i known... [message #240608 is a reply to message #240575] Fri, 25 May 2007 05:25 Go to previous messageGo to next message
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?
Re: How can i known... [message #240610 is a reply to message #240608] Fri, 25 May 2007 05:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No command.
Database are just files.
How to know which one belongs to an (valid) Oracle database?

Regards
Michel
Re: How can i known... [message #240612 is a reply to message #240575] Fri, 25 May 2007 05:31 Go to previous messageGo to next message
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..
Re: How can i known... [message #240614 is a reply to message #240612] Fri, 25 May 2007 05:39 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: diff between until time and until cancel
Next Topic: SGA Sizing
Goto Forum:
  


Current Time: Sat Dec 10 07:15:22 CST 2016

Total time taken to generate the page: 0.07321 seconds