Find Oracle Home in Windows Systems

1) How to find Oracle home in windows?

Open up a command prompt
Open "Command prompt" as administrator

Then, do the following

C:\Windows\system32> sqlplus / as sysdba

There's a system stored procedure called get_env for retrieving the value for ORACLE_HOME, thanks Sabdar Syed for the query.

SQL> var OHM varchar2(100);
SQL> EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;
SQL> PRINT OHM

Should return a path something like this:

D:\oracle\product\11.2.0\dbhome_1

2) How to check opatch lsinventory in windows?

Now set ORACLE_HOME like below:

C:\Windows\system32>set ORACLE_HOME=D:\oracle\product\11.2.0\dbhome_1

C:\Windows\system32>%ORACLE_HOME%\opatch\opatch lsinventory
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : D:\oracle\product\11.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : D:\oracle\product\11.2.0\dbhome_1\oui
Log file location : D:\oracle\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch2
018-05-07_09-10-22AM.log

Patch history file: D:\oracle\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch_
history.txt

Lsinventory Output file location : D:\oracle\product\11.2.0\dbhome_1\cfgtoollogs
\opatch\lsinv\lsinventory2018-05-07_09-10-22AM.txt

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

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.1.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


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


OPatch succeeded.

C:\Windows\system32>