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.