Oracle 12.2 Simple Client Installation configuration

Installation of Oracle client time-consuming, and most of the functions are not available, Oracle has given a simple client, the direct decompression can be used,: http://www.oracle.com/technetwork/topics/ Linuxx86-64soft-092277.html

Here are the installation steps:

1, download the installation package, I've downloaded all of them here.

Instantclient-basic-linux.x64-12.2.0.1.0.zip

Instantclient-basiclite-linux.x64-12.2.0.1.0.zip

Instantclient-jdbc-linux.x64-12.2.0.1.0.zip

Instantclient-odbc-linux.x64-12.2.0.1.0-2.zip

Instantclient-sdk-linux.x64-12.2.0.1.0.zip

Instantclient-sqlplus-linux.x64-12.2.0.1.0.zip

Instantclient-tools-linux.x64-12.2.0.1.0.zip

2, Unzip decompression

Unzip out a directory instantclient_12_2

3. Configure Environment variables

Export Oracle_home=/home/tst1/instantclient_12_2

Export ld_library_path= $LD _library_path: $ORACLE _home

Export path= $ORACLE _home: $PATH

4. Configuring TNS

[[email protected] instantclient_12_2]$ mkdir-p network/admin[[email protected] instantclient_12_2]$ CD network/admin/ [[email protected] admin]$ cat Tnsnames.ora ora11g = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.22)    (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = ora11g)))

5, test Sqlplus, success

[[email protected] admin]$ sqlplus zx/[email protected]sql*plus:release 12.2.0.1.0 Production on Thu Nov 16 12:48:33 2017  Copyright (c) 1982, Oracle. All rights reserved.  Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit productionwith The partitioning, OLAP, Data Mining and Real Application testing optionssql>

6, install SQLLDR, I installed this version of the simple client has SQLLDR, if not the need to copy from the other client or server, but I test execution Sqlldr error:

[Email protected] instantclient_12_2]$ Sqlldrmessage 2100 not found; No message file for Product=rdbms, Facility=ulmessage 2100 not found; No message file for Product=rdbms, Facility=ul[[email protected] instantclient_12_2]$

Copy all files under RDBMS/MESG from server because of missing MESG file

[Email protected] instantclient_12_2]$ mkdir-p rdbms/mesg[[email protected] instantclient_12_2]$ cp/u01/app/oracle/ product/12.2/db_home1/rdbms/mesg/* rdbms/mesg/

Execute SQLLDR successfully again

7, install Oerr, the simple client does not have the Oerr command, need to copy from the server side

[Email protected] instantclient_12_2]$ cp/u01/app/oracle/product/12.2/db_home1/bin/oerr/[[email protected] instantclient_12_2]$ oerr/home/tst1/instantclient_12_2/oerr:line:/home/tst1/instantclient_12_2/perl/bin/perl: No such file or directory

Perform an error stating that a missing file is being copied from the server side

[[email protected] instantclient_12_2]$ cp -r /u01/app/oracle/product/12.2/db_home1/ perl/* ./[[email protected] instantclient_12_2]$ cp -r /u01/app/oracle/product/ 12.2/db_home1/perl/* ./perl/[[email protected] instantclient_12_2]$ oerr ora  1Can ' t open perl script  "/home/tst1/instantclient_12_2/bin/oerr.pl":  (null) [email  protected] instantclient_12_2]$ mkdir bin[[email protected] instantclient_12_2] $ scp /u01/app/oracle/product/12.2/db_home1/bin/oerr.pl ./bin/[[email protected]  Instantclient_12_2]$ oerr ora 1could not open facilities list file:  /home/tst1/instantclient_12_2/lib/facility.lis2[[email protected] instantclient_12_2]$  Mkdir lib[[email protected] instantclient_12_2]$ cp /u01/app/oracle/product/12.2/db_ home1/lib/facility.lis ./lib/[[email protected] instantclient_12_2]$ oerr ora 100001, 00000,  " unique constraint  (%s.%s)  violated "// *cause: an update or insert  statement attempted to insert a duplicate key.//          For Trusted Oracle configured in DBMS MAC  Mode, you may see//         this message  if a duplicate entry exists at a different level.// *action :  either remove the unique restriction or do not insert the  key.

Note: Oerr also used the files in the RDBMS/MESG directory, but the 6th step to the entire directory is copied over, here is convenient.

8, installation tnsping, simple installation package also does not have this tool, need to copy from the server side

[Email protected] instantclient_12_2]$ cp/u01/app/oracle/product/12.2/db_home1/bin/tnsping/[[email protected] instantclient_12_2]$ tnspingtns Ping Utility for linux:version 12.2.0.1.0-production on 16-nov-2017 13:09:12Copyright (  C) 1997, Oracle. All rights reserved. Tns-03502:message 3502 not found; No message file for Product=network, Facility=tns

Error execution due to missing MESG file

[Email protected] instantclient_12_2]$ cp-r/u01/app/oracle/product/12.2/db_home1/network/mesg/./network/[[email Protected] instantclient_12_2]$ tnsping 192.168.56.22:1521/ora11gtns Ping Utility for Linux:version 12.2.0.1.0-product  Ion on 16-nov-2017 13:11:04copyright (c) 1997, Oracle. All rights reserved. Used parameter files:used HOSTNAME adapter to resolve the aliasattempting to contact (description= (Connect_data= (service_ name=ora11g)) (Address= (PROTOCOL=TCP) (host=192.168.56.22) (port=1521))) OK (msec)

The installation was successful.

9, install exp, imp, EXPDP, IMPDP, not in the installation package, directly from the server copy

[Email protected] instantclient_12_2]$ cp/u01/app/oracle/product/12.2/db_home1/bin/imp/[[email protected] instantclient_12_2]$ cp/u01/app/oracle/product/12.2/db_home1/bin/exp/[[email protected] instantclient_12_2]$ CP/ U01/APP/ORACLE/PRODUCT/12.2/DB_HOME1/BIN/IMPDP./[[email protected] instantclient_12_2]$ cp/u01/app/oracle/product /12.2/DB_HOME1/BIN/EXPDP./

IMP and EXP Test no problem, but EXPDP and IMPDP error:

[Email protected] instantclient_12_2]$ expdpsegmentation fault[[email protected] instantclient_12_2]$ Impdpsegmentation fault

Query MoS Find a workaround, add export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK to the environment variable

Problem solving.

At this point, the simple client installation is complete, you can put the entire directory into a package, to other machines installed directly decompression, configuration environment variables can be used. More convenient than installing the client.

Note:

If you use a tool to report missing library files, you can use the LDD command to see which library files are missing from the command, as follows:

[Email protected] instantclient_11_2]# ldd sqlldrlinux-vdso.so.1 = (0x00007fffe63fe000) libclntsh.so.11.1 = Not foundlibnnz11.so = not foundlibpthread.so.0 =/lib64/libpthread.so.0 (0x00007f014b85c000) libdl.so.2 =/ Lib64/libdl.so.2 (0x00007f014b658000) libm.so.6 =/lib64/libm.so.6 (0x00007f014b355000) libnsl.so.1 =/lib64/ Libnsl.so.1 (0x00007f014b13c000) libc.so.6 =/lib64/libc.so.6 (0x00007f014ad7b000)/lib64/ld-linux-x86-64.so.2 ( 0x00007f014ba8b000)

From the above output can be seen missing libclntsh.so.11.1 and libnnz11.so These two files, from the server side copy.

Reference: http://hanqunfeng.iteye.com/blog/1955277

This article is from the "DBA fighting!" blog, so be sure to keep this source http://hbxztc.blog.51cto.com/1587495/1982318

Oracle 12.2 Simple Client Installation configuration