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

Last updated on MAY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1.0.2 [Release 9.2 to 12.1]
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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms