OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database check (Solaris,Oracle10g)

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

Database check [message #332878]

Thu, 10 July 2008 00:33

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

how to find number of database available in a server?

Report message to a moderator

Re: Database check [message #332880 is a reply to message #332878]

Thu, 10 July 2008 00:35

BlackSwan
Messages: 26766
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;

Report message to a moderator

Re: Database check [message #332887 is a reply to message #332878]

Thu, 10 July 2008 00:55

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

Senior Member
Account Moderator

No way.

Regards
Michel

Report message to a moderator

Re: Database check [message #332915 is a reply to message #332887]

Thu, 10 July 2008 01:48

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.

Report message to a moderator

Re: Database check [message #332928 is a reply to message #332915]

Thu, 10 July 2008 02:29

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

Senior Member
Account Moderator

Er... I think this is what I meant.

Regards
Michel

Report message to a moderator

Re: Database check [message #333155 is a reply to message #332915]

Thu, 10 July 2008 11:03

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?

Report message to a moderator

Re: Database check [message #333242 is a reply to message #333155]

Fri, 11 July 2008 00:16

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

what is ORATAB file??

Report message to a moderator

Re: Database check [message #333247 is a reply to message #333242]

Fri, 11 July 2008 00:29

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Database check [message #333385 is a reply to message #333242]

Fri, 11 July 2008 08:04

joy_division
Messages: 4963
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?

Report message to a moderator

Re: Database check [message #333394 is a reply to message #333385]

Fri, 11 July 2008 09:07

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

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

Report message to a moderator

Re: Database check [message #333548 is a reply to message #333242]

Sat, 12 July 2008 09:33

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

Report message to a moderator

Re: Database check [message #334110 is a reply to message #332887]

Tue, 15 July 2008 08:12

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

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

Senior Member
Account Moderator

Wrong, this only shows you active instances not databases.

Regards
Michel

Report message to a moderator

Re: Database check [message #334118 is a reply to message #334110]

Tue, 15 July 2008 08:29

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Database check [message #335046 is a reply to message #334118]

Sun, 20 July 2008 01:32

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

no idea

Report message to a moderator

Re: Database check [message #335048 is a reply to message #335046]

Sun, 20 July 2008 02:04

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

Senior Member
Account Moderator

Michel Cadot wrote on Thu, 10 July 2008 07:55

No way.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 21:43:48 CST 2025