oracle set environment variables

Oracle is a powerful relational database management system that is widely used in enterprise-level applications. Before using Oracle, you need to make some initial settings, an important part of which is setting Oracle's environment variables. This article will introduce how to set Oracle environment variables in Windows and Linux systems.

1. Set Oracle environment variables in Windows system

1. Find Oracle installation path

Before setting Oracle environment variables, you need to confirm your Oracle installation In which directory. It can be found through the following methods:

a. Open the "Control Panel" and select "Programs"->"Uninstall a Program";
b. Find the Oracle software in the list of installed programs;
c. Right-click the software, select "Properties", and you can see the installation path of the Oracle software in the pop-up window.

2. Create Oracle environment variables

a. Open the "Control Panel" and select "System"->"Advanced System Settings";
b. In the pop-up In the window, select the "Advanced" tab, and then click the "Environment Variables" button;
c. In the user variables or system variables, click the "New" button;
d. Give the new variable a name : "ORACLE_HOME";
e. In the "Variable Value" column, fill in the installation path of the Oracle software;
f. Click the "OK" button to save the settings.

3. Modify the Path variable

The purpose of modifying the Path variable is to allow the operating system to find the Oracle executable file in any directory.

a. In the "Environment Variables" setting page, find the Path variable in the system variables area and double-click to modify it;
b. At the end of the Path variable, add ";%ORACLE_HOME% in ";
c. Click the "OK" button to save the settings.

4. Set the tnsnames.ora and sqlnet.ora file paths

The tnsnames.ora and sqlnet.ora files are configuration files used by Oracle clients to connect to the database. Their paths need to be added to environment variables so that Oracle clients can find them.

a. In the "Environment Variables" setting page, create two new variables in the system variables area: "TNS_ADMIN" and "LDAP_ADMIN". (Note that these two variables only need to be set when the Oracle client local software is installed)
b. In the "Variable Value" column, fill in the path to the directory where the tnsnames.ora and sqlnet.ora files are located.
c. Click the "OK" button to save the settings.

2. Setting Oracle environment variables in Linux system

Setting Oracle environment variables in Linux system can be achieved by modifying the .bash_profile file.

1. Find the Oracle installation path

Same as the Windows system, you need to determine the installation path of the Oracle software first.

2. Modify the .bash_profile file

a. Open the .bash_profile file:
vi ~/.bash_profile
b. Add the following content to the file:
export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/lib64
export PATH=$ORACLE_HOME/bin: $PATH
c. Save and exit the .bash_profile file.
d. Run the following command to make the .bash_profile file take effect:
source ~/.bash_profile

At this point, you have successfully set the Oracle environment variables.

Summary:

Setting Oracle environment variables is something that must be done before using Oracle. Different operating systems have different setting methods, but the core idea is the same. In Windows systems, you need to create the ORACLE_HOME variable, modify the Path variable, and set the tnsnames.ora and sqlnet.ora file paths; in Linux systems, you need to modify the .bash_profile file. Correctly setting Oracle environment variables can make it more convenient for you to use Oracle.

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