1、 下载Instant Client:
instantclient_10_2
并解压到同一文件夹下,例如/opt/instantclient_10_2 。
在/etc/ld.so.conf文件中加入"/opt/instantclient_10_2",
然后执行一次,即#ldconfig
2、 [root@trs-centos instantclient_10_2]# export ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
export PATH=$PATH:/opt/oracle/product/11.2.0/dbhome_1/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/oracle/product/11.2.0/dbhome_1/lib
export TNS_ADMIN=/opt/oracle/product/11.2.0/dbhome_1
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
也可将其加入/home/oracle/.bash_profile
3、
[root@trs-centos instantclient_10_2]# ./sqlplus syssd/sdsd@192.134.13.12:1521/orcl
./sqlplus username/password@ip:port/orcl