Oracle Instanc Client Installation Command tool

Conditions

1.Linux RHEL 6.X x86_64 operating system

2. This acquisition of Oracle-related files (same OS) from the server installing Oracleserver

Software download

From Oracle Package:

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

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.572MB)

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

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

Configuration process

Configuration process is the key to the configuration of environment variables, please configure according to their actual situation.

Configure Sqlplus

1. Log in with the root user. Create folder: Mkdir-p/opt/oracle

2. Unzip all the packages into the/opt/oracle folder:

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

Note: All files will be extracted to the/opt/oracle/instantclient_11_2 folder on their own initiative.

3. Create a configuration file

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

Czjgbs =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 81.17.1.23) (PORT = 1521))//IP required to connect

(Connect_data =

(SERVER = dedicated)

(service_name = Czjgbs)//Required Connection instance

)

)

Extproc_connection_data =

(DESCRIPTION =

(Address_list =

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

)

(Connect_data =

(SID = Plsextproc)

(PRESENTATION = RO)

)

)

Include the following configuration in the test user environment variable that requires the use of 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 that needs to be connected)

Note: The TNS_ADMIN environment variable is used to specify the path where the Tnsnames.ora file resides.

#source ~/.BASHRC

Test sqlplus Command:

$ sqlplus Scott/[email protected]

Sql*plus:release 10.2.0.4.0-productionon Friday August 3 10:41:44 2012

Copyright (c) 1982, Oracle. All rights Reserved.

Oracle Database 10g Enterprise editionrelease 10.2.0.4.0-64bit Production

With the partitioning, Real applicationclusters, OLAP, Data Mining

and Real Application Testing options

Sql>

Configure Tnsping

Go back to the root user and get the necessary files on the other Oracle machines.

# cd/opt/oracle/instantclient_11_2/

# SCP [Email protected]:/oracle/orahome/product/11.2.0/bin/tnsping./

The above command is to copy files from other servers that are installing Oracleserver.

# mkdir-p NETWORK/MESG

# CD NETWORK/MESG

# SCP [Email protected]:/oracle/orahome/product/11.2.0/network/mesg/tnsus.msb./

Test tnsping Tool:

$tnsping Ora16

Configure Sqlldr

Oracle's instantclient comes with no SQLLDR consolidation and requires documentation from Oracleserver.

Log in with the root user:

# cd/opt/oracle/instantclient_11_2/

# [Email protected]:/oracle/orahome/product/11.2.0/bin/sqlldr./

# mkdir-p rdbms/mesg/

# CD rdbms/mesg/

# SCP [Email protected]:/oracle/orahome/product/11.2.0/rdbms/mesg/ulus.msb./

Test the user to perform SQLLDR:

$sqlldr

Configure Imp/exp

Log in with the root user. Copy the relevant files from the Oracleserver.

# 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 oracleclientinstantclient in Linux system, but it lacks sql*loader, exp and other tools, this article describes how to install these command tools.

Copy the Sqlldr files directly from the same version number of the database server installation path, and run the SQLLDR to report such errors as the following:

Message 2100 NotFound; No message file for Product=rdbms, Facility=ulmessage 2100 not found; Nomessage file for Product=rdbms, Facility=ul[[email protected] Instantclient_10_2]$^c

In fact, Instant client installation Sqlldr can only be used to copy files. The above error is due to the fact that you still need to copy the following information files.

First, locate the TNSUS.MSB file under $ORACLE_HOME/NETWORK/MESG and the ULUS.MSB file under $ORACLE_HOME/RDBMS/MESG from the ORACLE database server.

Then, copy them to the corresponding folder in the Instantclient installation folder. For example:/USR/OCAL/INSTANTCLIENT_10_2/[RDBMS/MESG and NETWORK/MESG].

Now you can use the Sql*loader tool.

How to configure the EXP and IMP tools, assuming that just copy the executable file to the appropriate folder, it will report errors such as the following:

Message 2100 NotFound; No message file for Product=rdbms, Facility=ulmessage 2100 not found; Nomessage file for Product=rdbms, Facility=ul[[email protected] instantclient_10_2]

At this point, you'll need to find EXPUS.MSB and IMPUS.MSB under RDBMS/MESG from the installation folder in Oracle database server. The corresponding files are then copied to a folder to be resolved.

Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.

Oracle Instanc Client Installation Command tool