How to find Oracle Client & Oracle Server installed on machine

Well, the question "How to find oracle client and server installed on machine" is quite simple task... but for newbie it is still a tuff question.

Below are the way through we can find out

1.  Whenever you installed oracle client or server "system will create directories with their respective type called "CLIENT_1 for CLIENT & DB_1 for Server"

so we can check the above directories.

For Clients

D:\app\confadmin\product\11.1.0\client_1\

For DB Server

D:\app\Administrator\11.2.0\db

2.  there is a second way to check through opatch lsinventory

set oracle_home and go to oracle_home directory

execute opatch lsinventory

D:\app\confadmin\product\11.1.0\client_1\OPatch>set oracle_home=D:\APP\confadmin

\product\11.1.0\CLIENT_1

D:\app\confadmin\product\11.1.0\client_1\OPatch>opatch lsinventory

File Not Found

Invoking OPatch 11.1.0.6.0

Oracle Interim Patch Installer version 11.1.0.6.0

Copyright (c) 2007, Oracle Corporation.  All rights reserved.

Oracle Home       : D:\APP\confadmin\product\11.1.0\CLIENT_1

Central Inventory : C:\Program Files\Oracle\Inventory

   from           : n/a

OPatch version    : 11.1.0.6.0

OUI version       : 11.1.0.6.0

OUI location      : D:\APP\confadmin\product\11.1.0\CLIENT_1\oui

Log file location : D:\APP\confadmin\product\11.1.0\CLIENT_1\cfgtoollogs\opatch\

opatch2011-09-08_08-58-17AM.log

Lsinventory Output file location : D:\APP\confadmin\product\11.1.0\CLIENT_1\cfgt

oollogs\opatch\lsinv\lsinventory2011-09-08_08-58-17AM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Client                                                        11.1.0.6.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.

For Database Server

D:\app\Administrator\11.2.0\db\OPatch>opatch lsinventory

Invoking OPatch 11.2.0.1.6

Oracle Interim Patch Installer version 11.2.0.1.6

Copyright (c) 2011, Oracle Corporation.  All rights reserved.

Oracle Home       : D:\app\Administrator\11.2.0\db

Central Inventory : C:\Program Files\Oracle\Inventory

   from           : n/a

OPatch version    : 11.2.0.1.6

OUI version       : 11.2.0.2.0

Log file location : D:\app\Administrator\11.2.0\db\cfgtoollogs\opatch\opatch2011

-09-08_08-49-24AM.log

Lsinventory Output file location : D:\app\Administrator\11.2.0\db\cfgtoollogs\op

atch\lsinv\lsinventory2011-09-08_08-49-24AM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.2.0

There are 1 products installed in this Oracle Home.

3.  there is a third way to check through oracle services 

If oracle database services is created , it mean ORACLE SERVER is installed

but if you installed only oracle software then you will not find oracle database services.