• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 571
  • Last Modified:

How to check whether the oracle client is installed in my windows.?

How to check whether the oracle client is installed in my windows.?
0
sakthikumar
Asked:
sakthikumar
1 Solution
 
MilleniumaireCommented:
Can you see any Oracle entries on the start menu?  The client usually says something like "Oracle - Client 11g".

Another way is to try running sqlplus: On the start menu enter "sqlplus" in the Run field.

You could also look for "Oracle" directories in the root (top level) of your C: drive.
0
 
OP_ZaharinCommented:
- few ways you can do:

1- from command prompt, execute TNSPING command and see if it runs that utility.

2- again from command prompt, if you have selected to install SQLPLUS, you can run that utility too to see if its installed.

3- check the registry, under HKEY_Local_Machine>Software>WOW6432Node>Oracle or HKEY_Local_Machine>Software>Oracle. if there is client installed, you should see an entry of KEY_ORAXXXXXX and one of the sub_key shows the Oracle_Home pointing to the Oracle directory

4- check the environment variable under PATH, should a path to oracle folder is sets or under ORACLE_HOME.

5- from startmenu, under Oracle, run the Universal Installer, click "Installed Products...". This will give you a more detailed list of all installed components of the client install, e.g., drivers, SQL*Plus, etc.
0
 
johnsoneSenior Oracle DBACommented:
These methods would work with the full client install.  If instant client is installed, there really isn't any way to know it is there other than searching the drive for the files.
0
 
rkkpottyCommented:
check for the path in command prompt


if in path then check at the path for oracle folder
0
 
schwertnerCommented:
Oracle server comes with very specific procecesses in th the Control Panel\System and Security\Administrative Tools.
Go to the section "Services"
Oracle server will have following services: TNSListener, OEM, OracleServiceORCL, Scheduler and other services. The OracleListener and OracleServiceORCL are the bigest evidence that you have installed server. The Client installtion doesn't have such services.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now