Oracle Windows registry tips
Oracle Database Tips by Donald Burleson
Updated June 3, 2015
Question: I have
multiple ORACLE_HOME directories on my Windows server and I need
to understand the registry entries for these settings.
Answer: In Windows,
there is a place called the Registry (like the SYSGEN Parameter
file on VMS) that stores values that are used by the OS and
various software packages, and that includes Oracle.
The command at the Windows 'run' prompt is 'regedit'. I won't
get into Registry Editing here, since that is a full topic in
itself, but below are some of the main entries, and what they
is the home registry key.
- the path to your pfile
- tells whether the sid should start when the service does.
Generally this should be TRUE
- tells whether to shutdown when the service stops. Again,
this should be TRUE.
- How to shutdown by default when the service stops. IMMEDIATE
ORACLE_HOME - path to Oracle
NLS_LANG - nls language setting for
registry allows for multiple instances and your can adjust the
following registry entries for each Oracle instance:
For complete details, see notes 124353.1 and note 208256.1 from
Main Oracle Windows Registry keys
To make Oracle on Windows automatically start and stops we use these
Also, the registry hkey_local_machine->software->oracle->key_home_name
holds some other very useful entries:
- oracle_base: The location of the oracle base directory for
this oracle home.
- oracle_home: The location of the oracle home
directory for this oracle home.
- oracle_sid: The oracle system identifier or sid.
- sqlpath: The location of sql scripts.
- rdbms_control: The location of Oracle control files
and the spfile/pfile for this instance.
To check the Oracle Windows Registry
registry with regedit. Always back up the registry before making changes.
Navigate to the key entry in the Windows registry:
There will be a key called:
SID is your database System ID and
SID should be set to TRUE.
If not the server starts but does
not start the database. There is also an ORA_SID_SHUTDOWN which you
want to be TRUE so that if the server is shut down the service will shutdown
If you want to manually start the database set
ORA_SID_AUTOSTART to FALSE. The Windows service will start but not the
The difference between ORACLE_HOME and ORACLE_BASE
Check oracle_home Tips
Oracle Enterprise Manager - emctl not found in windows and HP-UX