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 laterOracle 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 |