Oracle Database - Environment Variables / Registry Values

> Database > Oracle Database

1 - 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.

Advertising

3 - Operating System

3.1 - On Windows

3.1.1 - the registry

In Windows, you can find all Oracle registry value in

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

3.2 - On Linux

3.2.1 - 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

3.2.2 - 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.

Advertising

4 - Documentation / Reference