Shulou(Shulou.com)06/01 Report--

Application scenarios:

Sometimes we need to export DMP files to ORACLE regularly, but we don't need to install Oracle software.

1. Prepare

1.1

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

Download three files

Oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.zip

Oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.zip

Oracle-instantclient11.2-sdk-11.2.0.4.0-1.x86_64.zip

1.2

Copy the exp command on the machine to ORACLE installed

/ u01/app/oracle/product/11.2.0/bin/exp

2. Decompress and install

The command is as follows:

Cd / usr/local/unzip oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.zip unzip oracle-instantclient11.2-sdk-11.2.0.4.0-1.x86_64.zip unzip oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.zip

3. Create a database connection file

Create a network/admin directory under the instantclient_11_2 directory, using the command

Mkdir-p network/admin

And create a tnsnames.ora file in the admin directory, which is similar to the following:

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.11) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)

5. Configure environment variables

The root user environment variable is configured here:

Vim / etc/profile.d/oracle.sh adds the following: export ORACLE_HOME=/usr/local/instantclient_11_2 export PATH=$ORACLE_HOME:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH export NLS_LANG='simplified chinese_china.ZHS16GBK'

To make the environment variable effective:

Source / etc/profile.d/oracle.sh

6. Testing

Sqlplus / nolog

The following results appear

SQL*Plus: Release 11.2.0.4.0 Production on Tuesday November 7 15:14:37 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.SQL >

At this point, the installation results, the test also passed! But the exp command is often used, and then configuring the exp command is very simple.

7. Exp configuration

1)

Copy the exp command file to

/ usr/local/instantclient_12_2

2)

Create a directory

/ your installation path / instantclient_12_2 / rdbms/mesg/

3)

Will:

/ oracle/orahome/product/12.2.0.4.0/rdbms/mesg/expus.msb

/ oracle/orahome/product/12.2.0.4.0/rdbms/mesg/impus.msb

Copy to

/ your installation path / instantclient_12_2 / rdbms/mesg/

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.