Shulou(Shulou.com)05/31 Report--

This article focuses on "how to install sqlplus and sqlldr tools". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to install sqlplus and sqlldr tools.

No matter what client tools are installed, you need to install the package instantclient-basic-linux.x64-11.2.0.4.0.zip first!

First of all, introduce the installation: sqlldr command!

Download address:

Https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Download the zip package directly and decompress it!

1. Set up the installation directory of oracle

[root@dev-bibaobiao-04] # mkdir-p / data/oracle

2. Put the installation package instantclient-basic-linux.x64-11.2.0.4.0.zip under / data/oracle/, and then decompress it

[root@dev-bibaobiao-04 oracle] # unzip instantclient-basic-linux.x64-11.2.0.4.0.zip

Generate directory: / data/oracle/instantclient_11_2

3. Create a new tnsnames.ora file in the / data/oracle/instantclient_11_2 directory and write the database connection information to

4. Configure environment variables: / ect/profile or / root/.bash_profile file

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Export ORACLE_IC_HOME=/data/oracle/instantclient_11_2

Export ORACLE_HOME=$ORACLE_IC_HOME

Export TNS_ADMIN=$ORACLE_IC_HOME

Export PATH=$PATH:$HOME/bin:$ORACLE_IC_HOME

Export LD_LIBRARY_PATH=$ORACLE_IC_HOME:/usr/lib

[root@dev-bibaobiao-04 ~] # source .bash _ profile

5. Create a new directory: / data/oracle/instantclient_11_2/rdbms/mesg, and put the ulus.msb file there. Note that the ulus.msb file can be copied from other machines where Oracle software is installed (path: $ORACLE_HOME/rdbms/mesg)

The following is the file for Oracle11.2.0.4

6. Put sqlldr into the / data/oracle/instantclient_11_2/ directory

Note that sqlldr and sqlplus are available through copy on the machine where the Oracle software is installed (directory at $ORACLE_HOME/bin/)

Here are the sqlplus and sqlldr files for Oracle11.2.0.4

So far, the sqlldr command has been installed successfully!

The next step is to install the sqlplus command:

1. After installing the sqlldr according to the previous installation, just download the instantclient-sqlplus-linux.x64-11.2.0.4.0.zip package, upload it to the / data/oracle/ directory, and unzip it!

Download address: https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

[root@dev-bibaobiao-04 oracle] # ll

Total 60104

Drwxr-xr-x 3 root root 4096 Dec 28 21:56 instantclient_11_2

-rw-r--r-- 1 root root 60704657 Dec 28 20:39 instantclient-basic-linux.x64-11.2.0.4.0.zip

-rw-r--r-- 1 root root 834491 Dec 28 21:51 instantclient-sqlplus-linux.x64-11.2.0.4.0.zip

[root@dev-bibaobiao-04 oracle] # unzip instantclient-sqlplus-linux.x64-11.2.0.4.0.zip

At this point, I believe you have a deeper understanding of the "installation method of sqlplus and sqlldr tools". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.