TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

Oracle

Set ORACLE_HOME environment variable on Windows

Overview

In this tutorial, we will learn the steps involved to set ORACLE_HOME environment variable on Windows 10. This variable should point to the install location of the Oracle Database on the machine. We can set this variable after the Oracle installation on the machine.

For example, if the Oracle base install location is installed on c:\oracle then we need to set this variable to:

ORACLE_HOME=C:\oracle

Oracle Install on Windows:

https://www.testingdocs.com/install-oracle-19c-database-on-windows-10/

Check if the variable is set:

Open the command prompt and issue the following command.

\> echo %ORACLE_HOME%

ORACLE_HOME not Set

If we get the same name displayed on the screen and not the real directory path, then the variable is not set on the machine.

Set ORACLE_HOME

Let’s see the steps to set the variable on Windows.

Type the following  “system environment variables” in the Search Bar.

Click on the ‘Edit the system environment variables’  Control Panel search result.

In the System Properties window, choose the Advanced tab. Click on the Environment Variables… button.

In the System Variables section, click on the New… button.

Set ORACLE_HOME Windows 10

Add the environment variable

Variable name: -> ORACLE_HOME

Variable value: -> C:\oracle

Click on the OK button. Alternatively, we can choose the install folder by clicking on the Browse Directory… button.

Append to PATH

Locate the PATH system variable. Double click on it to edit the variable. Click on New button.

Add the bin directory to the PATH variable.

%ORACLE_HOME%\bin

 

Add ORACLE bin to PATH

Verify

Open command prompt and issue the following echo command to verify that the variable is set.

\> echo %ORACLE_HOME%

That’s it. The environment variable has been set on the Windows machine.

 

—

Database Tutorials on this website:

https://www.testingdocs.com/oracle-database-tutorials-for-beginners/

More information about Oracle Database:

https://www.oracle.com/database/

Related Posts

Download SQL Developer

Oracle /

Download Oracle SQL Developer

Oracle Databse 19c Download

Oracle /

Install Oracle 19c Database On Windows 10

ORA-01109 Database Not Open

Oracle /

Fix ORA-01109: database not open Error

Oracle SQL Update Statement

Oracle /

Oracle SQL Update Statement

Oracle SQL Insert Statement

Oracle /

Oracle SQL INSERT Statement

‹ Connect to Oracle Database from SQL*Plus on Windows› Oracle SQL CREATE TABLE Statement

Recent Posts

  • MS Access Data Types
  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Build & Run CLion Project
  • Create New CLion C Project on Windows
  • Configure CLion Toolchains on Windows
  • Launch CLion IDE on Windows
  • Activate CLion IDE
  • CLion IDE for C/C++ Development

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version