My Oracle Support Banner

How to Set or Switch Oracle Homes on Windows (Doc ID 969581.1)

Last updated on APRIL 09, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Microsoft Windows x64 (64-bit)

Goal

To provide guidance regarding setting (or better stated:  not setting) Oracle Home on Windows.  Unlike on other platforms, one should never keep ORACLE_HOME set as a fixed environment variable on Windows environments.  This is largely due to the fact that Oracle determines where executable files reside at run-time. 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Why Should 'ORACLE_HOME' not be set on Oracle for Windows Environments
 How does Oracle Determine the executable location?
 Starting Oracle Executables
 Modifying the default Oracle Home and PATH environment variables using the Oracle Universal Installer (OUI)
 Summary

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.