How to configure environment variables in oracle

Oracle Environment Variable Configuration Guide: Create an ORACLE_HOME environment variable, pointing to the Oracle home directory. Add the Oracle binary directory to the PATH environment variable. Set the TNS_ADMIN environment variable (if the file is named using TNS). Verify the environment variable settings to make sure the output displays the set variables.

Configuring Oracle environment variables

How to configure Oracle environment variables?

step:

1. Create an ORACLE_HOME environment variable

• Right-click this computer and select Properties.
• Click Advanced System Settings.
• On the Advanced tab, click Environment Variables.
• In the System Variables section, click New.
• In the Variable Name field, enter ORACLE_HOME.
• In the Variable Value field, enter the path to the Oracle home directory, for example: "C:\oracle\product\19.0.0.0\dbhome_1".

2. Add Oracle binary directory to PATH environment variables

• In the System Variables section, select the Path variable.
• Click Edit.
• At the end of the Variable Value field, add the path to the Oracle binary directory, for example: ";C:\oracle\product\19.0.0.0\dbhome_1\bin".

3. Set the TNS_ADMIN environment variable (optional)

• If you use TNS to name files, you need to set the TNS_ADMIN environment variable.
• In the System Variables section, click New.
• In the Variable Name field, enter TNS_ADMIN.
• In the Variable Value field, enter the path to the TNS named file, for example: "C:\oracle\tns_admin".

4. Verify environment variable settings

• Open a command prompt.
• Enter the following command:

 <code>echo %ORACLE_HOME% echo %PATH% echo %TNS_ADMIN%</code>

• The output should display the Oracle environment variables that have been set.

hint:

• Environment variables are case sensitive.
• The paths to the Oracle home directory and binary directory may vary depending on your installation.
• If you are using multiple versions of the Oracle database, repeat these steps for each version.

The above is the detailed content of How to configure environment variables in oracle. For more information, please follow other related articles on the PHP Chinese website!