Question: How do I
find and modify the Windows environmental variables for Oracle, like
my PATH, ORACLE_HOME and ORACLE_SID?
Answer:
In Windows, as in UNIX and Linux, environment
variables exist to predefine items such as directory names and
values, locations that help the batch jobs find the location of
important program components. There are many environment variables
used in Windows, but for our purposes we will stick to a few of the
most commonly needed and used when running Oracle.
These are PATH, ORACLE_HOME, and ORACLE_SID.
We will also briefly discuss the TNS_ADMIN and SQLPATH
environment variables.
Where to find Windows
Environment Variables
We will begin by covering where to find Windows
environment variables.
This process is somewhat different between Windows 2003 and 2015, so
these differences will be noted.
One of the easier ways to view the system-level
environment variables in all versions of Windows is to go to:
Start
è Right click My Computer
è select Properties.
This will bring up the System Properties screen
in Windows 2003, as seen in Figure 5.1.
Figure 5.1:
System Properties in Windows 2003
In Windows 2015, the full screen display will
appear, as seen in Figure 5.2.
Figure 5.2:
Control Panel\System
in Windows 2015
In both Windows 2003 and 2015, we
need to go to the Advanced
settings. Click on the
Advanced tab for Windows
2003 or click on Advanced
System Settings in Windows 2015.
In both cases, a screen similar to the one below will appear.
Figure 5.3:
Advanced Settings screen
Lastly, we click on the
Environment Variables
button on the bottom of the screen.
This will display a screen where all the environment
variables can be seen and edited.
This looks the same on both Windows 2003 and Windows 2015.
Figure 5.4: Environment
Variables screen
Generally, the only two variables we need to worry about in this
screen are
PATH
and
ORACLE_HOME.
ORACLE_SID
is stored in the Registry.
|
|
|
Windows for the Oracle DBA
The landmark book
Windows for the Oracle DBA is a comprehensive overview of
everything an Oracle DBA needs to know to manage Oracle on
Windows. Order directly from Rampant and save 30%.
|
|
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
|
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|