waseemcs

 Profile Answers by waseemcs Questions by waseemcs

• Sep 17th, 2009

 

From dollar prompt $ps -ef|grep pmon
or
$ps aux|grep oracle

aravindhreturns

 Profile Answers by aravindhreturns 

• Apr 22nd, 2010

 

Renjith,

Waseem has explained for UNIX. Let me tell you how you can find the same on Windows.

Go to Start Menu, Then RUN. Type “Regedit” and Get inside the registry.

Go to this path “HKEY_LOCAL_MACHINESOFTWAREORACLE”

Under this path, you will not find a lot of folders (We’re not considering the unusual application support situations. We’re just considering a basic setup). The folders with the version names (8i, 9i, 10g, 11g… etc) are the number of databases that are running on the current server.

Also,

Go to Start Menu, Then RUN. Type “services.msc” and Get inside the Services. Click on any name (Don’t double click) and press the alphabet “O”.

You will get a list of services of Oracle unless you have some other software which starts with the same letter. The numbers of oracle homes found under those services are equal to the number of databases you hold on the server.

Guess that sorted out your question for now.

bhanu prakash

• May 6th, 2017

 

we can verify number of databases running by using pf -ef|grep pmon or smon.