Oracle Instanc Client installation command tool

Oracle Instanc Client installation command tool
Prerequisites

1. Linux RHEL 6.X X86_64 Operating System

2. Oracle-related files (same OS) can be obtained from the server where the Oracle server is installed)

Software Download

Download the following software package from the Oracle Website:

1) instantclient-basic-linux.x64-11.2.0.4.0.zip (59.282 MB)

2)instantclient-sqlplus-linux.x64-11.2.0.4.0.zip (815KB)

3)instantclient-sdk-linux.x64-11.2.0.4.0.zip (629KB)

4)instantclient-jdbc-linux.x64-11.2.0.4.0.zip (1.572 MB)

The download URL of the Oracle software package is as follows:

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

Configuration process

The key to the configuration process is the configuration of environment variables. Configure the environment variables according to your actual situation.

Configure SQLPLUS

1. Log On As the root user and create the directory mkdir-p/opt/oracle.

2. Decompress all the software packages to the/opt/oracle directory:

# Unzp instantclient-basic-linux.x64-11.2.0.4.0.zip-d/opt/oracle

Note: All files will be automatically decompressed to the/opt/oracle/instantclient_11_2 directory.

3. Create configuration file

# Vi/opt/oracle/instantclie_11_2/tnsnames. ora

CZJGBS =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 81.17.1.23) (PORT = 1521) // ip address to be connected

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = czjgbs) // instance to be connected

)

)

 

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

Add the following configuration to the test user environment variables that require Oracle functionality:

# Vi ~ /. Bashrc

Export NLS_LANG = AMERICAN_AMERICA.ZHS16GBK

Export ORACLE_HOME =/opt/oracle/instantclient_11_2

Export TNS_ADMIN = $ ORACLE_HOME

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

Export LD_LIBRARY_PATH = $ ORACLE_HOME:/usr/lib

Export ORACLE_SID = czjgbs // (name of the instance to be connected)

Note: The TNS_ADMIN environment variable is used to specify the path of the tnsnames. ora file.

# Source ~ /. Bashrc

Test sqlplus command:

$ Sqlplus scott/tiger @ ora215

SQL * Plus: Release 10.2.0.4.0-Productionon Friday August 3 10:41:44 2012

Copyright (c) 1982,200 7, Oracle. All Rights Reserved.

 

Oracle Database 10g Enterprise EditionRelease 10.2.0.4.0-64bit Production

With the Partitioning, Real applicationters ters, OLAP, Data Mining

And Real Application Testing options

SQL>

Configure tnsping

Return to the root user and obtain the necessary files on other Oracle machines.

# Cd/opt/oracle/instantclient_11_2/

# Scp root@192.168.21.16:/oracle/orahome/product/11.2.0/bin/tnsping ./

The above command is to copy files from other servers that install the Oracle server.

# Mkdir-p network/mesg

# Cd network/mesg

# Scp root@192.168.21.16:/oracle/orahome/product/11.2.0/network/mesg/tnsus. msb ./

Tnsping tool:

$ Tnsping ora16

Configure SQLLDR

Oracle's InstantClient comes with no sqlldr consolidation and also needs to obtain relevant files from the Oracle server.

Log on as a root user:

# Cd/opt/oracle/instantclient_11_2/

# Scproot@192.168.21.16:/oracle/orahome/product/11.2.0/bin/sqlldr ./

# Mkdir-p rdbms/mesg/

# Cd rdbms/mesg/

# Scp root@192.168.21.16:/oracle/orahome/product/11.2.0/rdbms/mesg/ulus. msb ./

Run sqlldr in the test user:

$ Sqlldr

Configure IMP/EXP

Log on as a root user and copy related files from the Oracle server.

# Cd/opt/oracle/instantclient_11_2/

# Scp 192.168.21.16:/oracle/orahome/product/11.2.0/bin/imp ./

# Scp192.168.21.16:/oracle/orahome/product/11.2.0/bin/exp ./

# Cd rdbms/mesg/

# Scp192.168.21.16:/oracle/orahome/product/11.2.0/rdbms/mesg/impus. msb ./

# Scp 192.168.21.16:/oracle/orahome/product/10.2.0/rdbms/mesg/expus. msb ./

 

Appendix

 

Install the Oracle client InstantClient in Linux, but it lacks SQL * Loader, EXP, and other tools. This article describes how to install these command tools.

Copy the sqlldr executable file directly from the installation path of the database server of the same version. If you execute sqlldr, the following error will be reported:

Message 2100 notfound; No message file for product = RDBMS, facility = ULMessage 2100 not found; Nomessage file for product = RDBMS, facility = UL [etl @ m1 instantclient_10_2] $ ^ C

In fact, the Instant Client can only copy files when installing sqlldr. The error is because you still need to copy the following information file.

First, find the tnsus. msb file under $ ORACLE_HOME/network/mesg and the ulus. msb file under $ ORACLE_HOME/rdbms/mesg on the Oracle Database Server.

Copy them to the corresponding directory in the installation directory of InstantClient. For example:/usr/ocal/instantclient_10_2/[rdbms/mesg and network/mesg].

Now you can use the SQL * Loader tool.

If you just copy the executable file to the corresponding directory and configure the EXP and imp tools, the following error is reported:

Message 2100 notfound; No message file for product = RDBMS, facility = ULMessage 2100 not found; Nomessage file for product = RDBMS, facility = UL [etl @ m1 instantclient_10_2]

In this case, you need to find expus. msb and impus. msb under rdbms/mesg from the installation directory of the Oracle database server, and copy them to the corresponding directory to solve the problem.

Migration from 32-bit to 64-bit for a single Oracle instance

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Oracle RAC 11.2 (12C) correctly closes the order