Installation configuration for Oracle Connection client Sqlplus under Linux

1. Download the installation package:        

oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm

2.RPM Installation

[[email protected] ~]# rpm -ihv oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64. rpm   --nodeps[[email protected] ~]# rpm -ihv  Oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm --nodeps 

3. Configure connection Information  

[[email protected] ~]#  vi /usr/lib/oracle/11.2/client64/tnsnames.ora  oracletest=  #要连接Oracle库的库名    (description =     (address_list =        (address =  (protocol = tcp) (host =  110.103.211.310) (port = 1521))   #数据库IP, open ports     )      ( connect_data =       (service_name=oracletest )   #要连接Oracle库的库名     )   ) 

4. Environment variable configuration  

[Email protected] ~]# vi/etc/profile #在文件末尾添加下面配置export oracle_home=/usr/lib/oracle/11.2/client64export tns_admin=$ Oracle_homeexport path= $PATH: $ORACLE _home/binexport ld_library_path= $LD _library_path: $ORACLE _home/lib

5. Verifying the configuration

[[email protected] ~]# sqlplus account name/password as role name #登录进数据说明配置成功.

This article is from "Desert Camel" blog, please make sure to keep this source http://maomaochong.blog.51cto.com/9260445/1890711

Installation configuration for Oracle Connection client Sqlplus under Linux