linux安装oracle client客户端

1、获取rpm安装包oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

2、rpm -ivh oracle-instantclient11.2-*.rpm

3、创建环境变量vi /etc/profileexport ORACLE_HOME=/usr/lib/oracle/11.2/client64export TNS_ADMIN=$ORACLE_HOME/network/adminexport NLS_LANG='simplified chinese_china'.ZHS16GBKexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport PATH=$ORACLE_HOME/bin:$PATH

4、环境变量立即生效source /etc/profile

5、创建监听文件cd /usr/lib/oracle/11.2/client64/network/adminvi tnsnames.ora晦倘佳鳎ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.169.1.109)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

6、sqlplus /nolog