linux安装oracle客户端


首先Oracle官网下载安装包:

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html   安装解压缩到/usr/local/oracle mkdir /usr/local/oracle unzip /usr/local/oracle/instantclient-basic-linux.x64-11.2.0.4.0.zip unzip /usr/local/oracle/instantclient-sqlplus-linux.x64-11.2.0.4.0.zip cd /usr/local/oracle/instantclient_11_2 mkdir -p network/admin cd network/admin 新建tnsnames.ora文件   CM =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.11)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = orcl)     )   )      添加环境变量 vi .bash_profile   export ORACLE_HOME=/usr/local/oracle/instantclient_11_2 export TNS_ADMIN=$ORACLE_HOME/network/admin ##export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 export LD_LIBRARY_PATH=$ORACLE_HOME export PATH=$ORACLE_HOME:$PATH   执行环境变量 source .bash_profile   测试数据库连接 sqlplus username/passwd@cm 直接连接:(密码含有特殊字符如@时,需加双引号) sqlplus username/passwd@host:port/orcl 先进入sqlplus,然后再连接 sqlplus /nolog conn username/passwd@host:port/orcl   例:conn user/"pwd"@127.0.0.1:1521/orcl   本文参考 https://blog.csdn.net/andy_wcl/article/details/79470705