linux安装oracle客户端

groupadd oinstall
useradd -g oinstall oracle

passwd oracle

su - oracle

cd /usr/local/oracle/

上传三个文件


解压三个文件
instantclient-basic-linux.x64-11.2.0.4.0.zip  instantclient-sdk-linux.x64-11.2.0.4.0.zip  instantclient-sqlplus-linux.x64-11.2.0.4.0.zip
unzip  instantclient-basic-linux.x64-11.2.0.4.0.zip  -d oracle
unzip  -o instantclient-sdk-linux.x64-11.2.0.4.0.zip  -d oracle
unzip  -o instantclient-sqlplus-linux.x64-11.2.0.4.0.zip  -d oracle


vim .bash_profile 
添加
export PATH
export ORACLE_HOME=/usr/local/oracle/instantclient_11_2/
export ORACLE_SID=orcl----实例名字注意修改
export SQLPATH=/usr/local/oracle/instantclient_11_2/
export TNS_ADMIN=/usr/local/oracle/instantclient_11_2/
export NLS_LANG=american_america.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH




[oracle@localhost oracle]$ vim /usr/local/oracle/oracle/tnsnames.ora 


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )


ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.98.99)(PORT = 1521))---注意修改
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )

  )

sqlplus和exp不使用服务名，直接使用IP地址连接Oracle
sqlplus  username/password@192.168.2.181:1521/service_name @filelist.sql
exp  scott/tiger@127.0.0.1:1521/test