Home » RDBMS Server » Server Administration » Database check (Solaris,Oracle10g)
Database check [message #332878] Thu, 10 July 2008 00:33 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

how to find number of database available in a server?
Re: Database check [message #332880 is a reply to message #332878] Thu, 10 July 2008 00:35 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
balaji1482 wrote on Wed, 09 July 2008 22:33
how to find number of database available in a server?


select count(server) from dual;
Re: Database check [message #332887 is a reply to message #332878] Thu, 10 July 2008 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way.

Regards
Michel
Re: Database check [message #332915 is a reply to message #332887] Thu, 10 July 2008 01:48 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

u mean to say there is no way to find out number of database available in server.
Re: Database check [message #332928 is a reply to message #332915] Thu, 10 July 2008 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Er... I think this is what I meant.

Regards
Michel
Re: Database check [message #333155 is a reply to message #332915] Thu, 10 July 2008 11:03 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you try with GOOGLE?
Did you check PARAMETER file?
Did you check DBCA tools?
Did you check ORATAB file?
Re: Database check [message #333242 is a reply to message #333155] Fri, 11 July 2008 00:16 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

what is ORATAB file??
Re: Database check [message #333247 is a reply to message #333242] Fri, 11 July 2008 00:29 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
balaji1482 wrote on Thu, 10 July 2008 22:16
what is ORATAB file??

All can be modified/changed/over rode/not conclusive
Re: Database check [message #333385 is a reply to message #333242] Fri, 11 July 2008 08:04 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
balaji1482 wrote on Fri, 11 July 2008 01:16
what is ORATAB file??


You obviously know how to use the web (you post here). Do you not know how to search on the web?
Re: Database check [message #333394 is a reply to message #333385] Fri, 11 July 2008 09:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
joy_division wrote on Fri, 11 July 2008 15:04
balaji1482 wrote on Fri, 11 July 2008 01:16
what is ORATAB file??


You obviously know how to use the web (you post here). Do you not know how to search on the web?

For the Web, I don't know but about Oracle documentation I can say the answer is no. Wink

Regards
Michel



Re: Database check [message #333548 is a reply to message #333242] Sat, 12 July 2008 09:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://www.orafaq.com/faq/what_is_oratab_and_what_is_it_used_for
Re: Database check [message #334110 is a reply to message #332887] Tue, 15 July 2008 08:12 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

there is a command to view number of database available in server.

OS - level--

ps -ef |grep SMON

[Updated on: Tue, 15 July 2008 08:12]

Report message to a moderator

Re: Database check [message #334117 is a reply to message #334110] Tue, 15 July 2008 08:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wrong, this only shows you active instances not databases.

Regards
Michel
Re: Database check [message #334118 is a reply to message #334110] Tue, 15 July 2008 08:29 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
balaji1482 wrote on Tue, 15 July 2008 06:12
there is a command to view number of database available in server.

OS - level--

ps -ef |grep SMON

& for instances that are not currently running how are they counted?
Re: Database check [message #335046 is a reply to message #334118] Sun, 20 July 2008 01:32 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

no idea
Re: Database check [message #335048 is a reply to message #335046] Sun, 20 July 2008 02:04 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 10 July 2008 07:55
No way.

Regards
Michel


Previous Topic: Automatic Storage Management (ASM) vs Raid 5
Next Topic: Monitoring Parallel Execution
Goto Forum:
  


Current Time: Fri Dec 09 13:58:45 CST 2016

Total time taken to generate the page: 0.07327 seconds