Wed. Aug 4th, 2021

Requirement: In this post, I will describe some of the processes to get the ORACLE_HOME path. After we have the ORACLE_HOME path, then we will set how we can Set the ORACLE_HOME path.

Explanation: ORACLE_HOME is a directory name which will come at the time of Oracle software installation. The specified directory path of ORACLE_HOME directory is been stored in an environment variable. The ORACLE_HOME file will always used to ensure the correct oracle version is accessed running against the database.

Various ways to get the ORACLE_HOME path: There are multiple ways to get the ORACLE_HOME path. I will be describing here three different approaches to get the ORACLE_HOME path.

Approach 1: Please follow the steps as shown below:

  1. Open Command Prompt in Administrator mode
  2. Connect to the Oracle Database using the command sqs / as sysdba
  3. Execute the below code, and with that we will get the path of the ORACLE_HOME
SQL > var OHM varchar2(100);
SQL > EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;
SQL > PRINT OHM

Approach 2: On Windows Operating System we can also find ORACLE_HOME path in the registry.. For that please follow the steps as shown below:

  1. Run regedit
  2. Go to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDB19Home1
  3. There against the ORACLE_HOME variable name we will ORACLE_HOME path

Approach 3: Open Command Prompt, type echo %ORACLE_HOME%. If ORACLE_HOME is set it will return you the path or else it will return %ORACLE_HOME%.

Set the ORACLE_HOME path: To set the ORACLE_HOME path follow the below steps

  • Open System Properties and Click on Environment Variables.

Create the System Variable with Variable name as ORACLE_HOME as Variable value as C:\Softwares\WINDOWS.X64_193000_db_home

Hence, the solution to our requirement.

If you like the post please comment, share, and do join me on Facebook. Please subscribe to my YouTube Channel for video tutorials.

Thanks & Regards,
Susanto Paul

 627 total views,  2 views today

By Susanto Paul

Susanto is an Oracle ACE, a qualified MCA, MBA, and a highly-skilled Senior Oracle Specialist. He is an enthusiastic Blogger and YouTuber who helps learners to solve their complex problems more efficiently. He has 9+ years of experience in multiple technologies like AWS, Oracle ADF, Oracle APEX, Oracle JET, Oracle VBCS, Oracle IDCS, Oracle PL/SQL, Oracle Integration Cloud, Java, JDBC, Servlets, JSP, Spring, Hibernate, HTML5, CSS3, JavaScript, TypeScript, NodesJS, Angular, MySQL, Oracle WebLogic Server, JUnit, JMeter, Selenium Web Driver, etc. He is a certified: Oracle Certified Professional Java SE 6 Programmer, Oracle ADF 11g Certified Implementation Specialist, Oracle Cloud Platform Application Integration 2020 Certified Specialist, Oracle Cloud Infrastructure Foundations 2020 Certified Associate, and Oracle Cloud Infrastructure Developer 2020 Certified Associate

Leave a Reply

Your email address will not be published. Required fields are marked *