oracle12c客户端安装配置,Oracle 12.2简易客户端安装配置

1、下载安装包，我这里把所有的都下载下来了

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解压

解压出来一个目录instantclient_12_2

3、配置环境变量

export ORACLE_HOME=/home/tst1/instantclient_12_2

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME

export PATH=$ORACLE_HOME:$PATH

4、配置tns

[tst1@rhel7 instantclient_12_2]$ mkdir -p network/admin

[tst1@rhel7 instantclient_12_2]$ cd network/admin/

[tst1@rhel7 admin]$ cat tnsnames.ora

ora11g =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.22)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ora11g)

)

)

5、测试sqlplus，成功

[tst1@rhel7 admin]$ sqlplus zx/zx@ora11g

SQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 16 12:48:33 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

<