Home » RDBMS Server » Server Administration » How Can find how much database is running in Oracle server (Window Server 2003)
How Can find how much database is running in Oracle server [message #331583] Fri, 04 July 2008 02:30 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
How much?
Can you precise the question.

Regards
Michel
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
Member
these are database sir,
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There is no SQL for this as databases are independant.

Regards
Michel
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 Go to previous messageGo to next message
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
Member
ANY OTHER WAY TO GET THAT
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No answer to those who shout.

Regards
Michel
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 Go to previous messageGo to next message
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 .


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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Read the title: Window Server 2003

Regadrs
Michel
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 Go to previous message
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:
  


Current Time: Thu Dec 05 07:58:15 CST 2024