How to find how many database reside in Oracle server in query?

  • Interview Candidate
  • 7
  • 8918

Showing Answers 1 - 7 of 7 Answers

Nazim

  • Feb 13th, 2006
 

select count(*) from v$database;

  Was this answer useful?  Yes

Sivaramasamy

  • Apr 26th, 2006
 

select * from db;

  Was this answer useful?  Yes

cmanne

  • Jul 29th, 2006
 

grep oratab , Oratab is the best source to get the list of all the databases on  a server and another method is ps -ef|grep -i pmon ( this is useful if all the databases are restarted in case of a server reboot)

  Was this answer useful?  Yes

Mohammed Abdul Afroze

  • Mar 25th, 2007
 

Answer:

  The Scenario to find out the instances are up and running is.

In $ prompt ps -ef |grep smon
in sql> prompt !ps -ef |grep smon

  Was this answer useful?  Yes

Krishna Miryala

  • Apr 15th, 2007
 

$ ps -eaf|grep pmon

  Was this answer useful?  Yes

cmanne

  • Sep 2nd, 2009
 

1. Check the oratab file to get the list of databases on a server.

Caveat: If the database is created manually, then the oratab won't updated automatically which should be done manually as oratab is updated only when the database is created using DBCA.

2. Check "smon" or "pmon" process at os level using the following command.

ps -ef|grep smon|grep -v grep

3. Check the IPCS parameters at OS level which would also provide some information about the existing database instances on that server.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions