Oracle Database - Environment Variables / Registry Values

Card Puncher Data Processing

About

To configure the database installation, Oracle provide several Environment variable / Registry Value.

If you start a database instance using spfile with an environment variable set, then its value is automatically stored in spfile. If you unset the environment variable subsequently and start the instance afresh, then database uses the parameter value of Oracle base stored in spfile.

Operating System

On Windows

Windows - Environment Variable

the registry

In Windows, you can find all Oracle registry value in

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

Oracle Registry Windows

On Linux

Display

To display the current value of an Linux environment variable, use the env command. For example, to display the value of the ORACLE_SID environment variable, run the following command:

$ env | grep ORACLE_SID

To display the current value of all environment variables, run the env command as follows:

$ env | more

Configure

Update the startup files of the oracle user and the operating system accounts of Oracle users, specifying the appropriate environment variables in the environment file.

  • For the Bourne, Bash, or Korn shell, add the environment variables to the .profile file, or the .bash_profile file for the Bash shell on Red Hat Enterprise Linux.
  • For the C shell, add the environment variables to the .login file.

You can use the oraenv or coraenv script to ensure that Oracle user accounts are updated.

Documentation / Reference





Discover More
Oracle Database Standard Installation Parameters
Oracle Database - (Initialization|System) Parameters

Parameter are global variable. Their values are initialized from a file during the start of the Oracle Database. environment variable The SCOPE of a parameter Scope depends on whether you started...
Oracle Database 12c Step 12
Oracle Database - 12c Installation on Windows 64 bit

Installation of Oracle Database 12c (12.1.0.1.0) on Windows. You can download the oracle software from OTN or better...
Card Puncher Data Processing
Oracle Database - ORACLE_HOSTNAME environment variable

If you are using a computer with multiple home alias, you can set this variable to point to the host name of the computer on which you are installing Oracle Database. While installing Enterprise Manager...
Card Puncher Data Processing
Oracle Database - ORACLE_SID environment variable

ORACLE_SID is an environment variable which identify the System Identifier (SID) of the database. The at sign (@) represents the ORACLE_SID environment variable. For example, to indicate a file that...
Card Puncher Data Processing
Oracle Database - ORACLE_UNQNAME environment variable

If you are prompted to set the ORACLE_UNQNAME environment variable, then set this variable and run the emctl command again. Set the variable to the database unique name (the value of the DB_UNIQUE_NAME...
Card Puncher Data Processing
Oracle Database - ORA_NLS

ORA_NLS is an environment variable. If your system is using multiple versions of Oracle, you must ensure that: The appropriate ORA_NLS variable is set. The corresponding NLS data files for the versions...
Oracle Home Location
Oracle Database - Oracle Home Directory (ORACLE_HOME|OH)

The Oracle home directory (ORACLE_HOME) is the directory where you choose to install the software for a particular Oracle product. You must install different Oracle products or different releases of the...
Card Puncher Data Processing
Oracle Database - Oracle base directory (ORACLE_BASE)

The Oracle base directory is a top-level directory for Oracle software installations. environment variable The Optimal Flexible Architecture (OFA) guidelines recommend that you use a path similar...
Card Puncher Data Processing
Oracle Database - PATH environment Variable

The path environment variable in a Oracle Database context. The directory that contains the oraenv, coraenv, and dbhome scripts is called the local bin directory. All database users must have...
Card Puncher Data Processing
Oracle Database - TNS_ADMIN environement variable

TNS_ADMIN is a environment variable value which give the directory where the file tnsnames.ora must be searched. It's really helpful when you have more than one Oracle Client Product installed. It takes...



Share this page:
Follow us:
Task Runner