René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Setting registry values for Oracle under Windows

KEY_OraHome%ORACLE_SID%

MSHELP_TOOLS

Path to the location of Windows help files.
default: ORACLE_BASE\ORACLE_HOME\mshelp

NLS_LANG

Specifies supported language, territory, and character set.
Affects
  • message language
  • convetntions for date calculations (such as week and day numbers)
  • displayed character set
See also nls_lang.

ORA_CWD

The current working directory. This is the directory where log files are written to.

ORA_%ORACLE_SID%_AUTOSTART

If "TRUE", starts the database automatically when OracleService%ORACLE_SID% service is started.
default: TRUE

ORA_%ORACLE_SID%_PFILE

Default: %ORACLE_BASE%\admin\DB_NAME\pfile\init.ora

ORA%ORACLE_SID%SHUTDOWN

If true, instance of Oracle Database will be shut down when OracleService%ORACLE_SID% is shut down.
Default: true

ORA%ORACLE_SID%SHUTDOWN_TIMEOUT

Maximum time in seconds to wait for shutdown to complete before the service for a particular SID stops.
Default: 30

ORA_%ORACLE_SID%_SHUTDOWNTYPE

How Oracle Database is shut down when OracleServiceSID is stopped. Possible values
Default: i

ORA_TZFILE

Location of time zone file.
Default Value: ORACLE_HOME\oracore\zoneinfo\timezlrg.dat

ORACLE_AFFINITY

Format:
name1:cpumask1;name2:cpumask2

ORACLE_BASE

Default: %ORACLE_BASE%.

ORACLE_GROUP_NAME

Location of icons for Oracle products.
Default: HOME_NAME

ORACLE_HOME

The location of ORACLE_HOME.

ORACLE_HOME_KEY

Location of HKEY_LOCAL_MACHINE for Oracle parameters.
Default: software\oracle\HOMEID.

ORACLE_HOME_NAME

Name of ORACLE_HOME.

ORACLE_PRIORITY

ORACLE_SID

Name of the instance (= SID).

OSAUTH_PREFIX_DOMAIN

Used for user authentication.

OSAUTH_X509_NAME

RDBMS_ARCHIVE

RDBMS_CONTROL

SQLPATH

The location where SQL*Plus searches for scripts run with start (@, @@).