Where is my ORACLE_HOME Windows directory?
I'm trying to find my
listener.orafile to edit it, but the docs say it's in theORACLE_HOMEdirectory, but where is that?I'm running 12.1.0 on Windows Server 2008
Open up a command prompt
Start -> Run -> "cmd.exe"Start sqlplus as administrator
sqlplus / as sysdbaThere's a system stored procedure called
get_envfor retrieving the value forORACLE_HOME, thanks Sabdar Syed for the query.SQL > var OHM varchar2(100); SQL > EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ; SQL > PRINT OHMShould return a path like this:
C:\app\oracle_account\product\12.1.0\dbhome_1
On Windows platform you can find oracle_home path in the registry.
Run regedit, then navigate to:
hkey local machine/software/oracle
Under oracle folder in the registry you will find something like:
KEY_OraDb10g_home1
There you can see oracle_home variable.
- Start
regedit(search for it from the Start menu) - Open the HKEY_LOCAL_MACHINE folder
- Open the Oracle folder
- Open a folder called ORACLEMTSR
- Open the setup folder
- Access to the current version
There you will find a "file" called HOME; open it and you will see where Oracle was installed.
At a guess, you've left out `SOFTWARE` under `HKEY_LOCAL_MACHINE` (on my machine, the items under `HKEY_LOCAL_MACHINE` are all generic, and there's only 6 of them - I'd expect Oracle's registry entry to be in `SOFTWARE`). Also, I suspect that `ORACLEMTSR` might actually be `ORACLEMSTR` (though I'm not sure, as I don't have an Oracle install handy to check). Could you double-check, to make sure the answer is in fact complete and correct?
- Start
On cmd, type
echo %ORACLE_HOME%. IfORACLE_HOMEis set it will return you the path or else it will return%ORACLE_HOME%.
License under CC-BY-SA with attribution
Content dated before 6/26/2020 9:53 AM
user194056 one year ago
Windows - start the universal installer - click "Intalled Products" then the "Environment" tab.