OraFAQ Forum: Server Administration » How Can find how much database is running in Oracle server

Home » RDBMS Server » Server Administration » How Can find how much database is running in Oracle server (Window Server 2003)

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

How Can find how much database is running in Oracle server [message #331583]

Fri, 04 July 2008 02:30

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

Can any body Help me that how can we know that how much database is running in Oracle Server

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331584 is a reply to message #331583]

Fri, 04 July 2008 02:34

Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How much?
Can you precise the question.

Regards
Michel

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331586 is a reply to message #331583]

Fri, 04 July 2008 02:41

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

if I have a database Server and 3 database is runnig like
payroll,hr,Account

so how can we know how much database is running with a single SQl command

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331597 is a reply to message #331586]

Fri, 04 July 2008 03:16

Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are these databases or accounts/schemas?
Are you running Oracle?

Regards
Michel

[Updated on: Fri, 04 July 2008 03:16]

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331602 is a reply to message #331583]

Fri, 04 July 2008 03:44

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

these are database sir,

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331609 is a reply to message #331602]

Fri, 04 July 2008 04:00

Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no SQL for this as databases are independant.

Regards
Michel

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331616 is a reply to message #331583]

Fri, 04 July 2008 04:18

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

ANY OTHER WAY TO GET THAT

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331619 is a reply to message #331616]

Fri, 04 July 2008 04:20

Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No answer to those who shout.

Regards
Michel

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331624 is a reply to message #331583]

Fri, 04 July 2008 04:30

ora110
Messages: 42
Registered: September 2007
Location: China

Member

You can get oracle instance information by running os command
for example:
linux(unix)
ps -ef | grep ora_
the above command can show the background progress of database server.
------
or you can get the oracle instance information from oracle listener.
run the command "ps -ef | grep tns "
to get the listener name
and then run the following command "lsnrctl service listener_name" to get the oracle instance name which is running under os .

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331631 is a reply to message #331624]

Fri, 04 July 2008 04:44

Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Read the title: Window Server 2003

Regadrs
Michel

Report message to a moderator

Re: How Can find how much database is running in Oracle server [message #331844 is a reply to message #331631]

Sat, 05 July 2008 23:24

ora110
Messages: 42
Registered: September 2007
Location: China

Member

oh,I made a mistake.thank you.
you can get the information from running dbca tools .
or you can just lookup services of your server by serching for :'control panel-> system management tools -> services' .

[Updated on: Sat, 05 July 2008 23:32]

Report message to a moderator

Previous Topic:	Query on 10 g Migration issue
Next Topic:	to take a job offline

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 22 15:56:34 CDT 2024