liunx下安装SqlPlus并连接远程Oralce服务器

liunx下安装Sql*Plus并连接远程Oralce服务器

1. 环境

   客户端:Ubuntu18.04LTS

   服务端:Centos7 Oracle12c

2. 下载oracle sqlplus

   []: https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

   根据自己版本信息,下载合适的版本:

   oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm

   oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm

   oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm

3. 安装alien工具

   alien工具是将rpm包转换为deb包的工具

   $ sudo apt install alien
   

4. 安装rpm包

   依次安装这三个rpm包:

   sudo alien -i oracle-instantclient18.3-*.rpm

   eric@ray:~/Downloads/sqlplus
   $ sudo alien -i oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm 
   	dpkg --no-force-overwrite -i oracle-instantclient18.3-devel_18.3.0.0.0-2_amd64.deb
   (Reading database ... 219747 files and directories currently installed.)
   Preparing to unpack oracle-instantclient18.3-devel_18.3.0.0.0-2_amd64.deb ...
   Unpacking oracle-instantclient18.3-devel (18.3.0.0.0-2) over (18.3.0.0.0-2) ...
   Setting up oracle-instantclient18.3-devel (18.3.0.0.0-2) ...
   
   

5. 编辑sqlplus配置文件

   成功安装rpm包后,oracle客户端的默认路径为:

   eric@ray:/usr/lib/oracle/18.3/client64/lib
   $ ls
   glogin.sql             libmql1.so       libocijdbc18.so   network
   libclntshcore.so.18.1  libnnz18.so      libons.so         ojdbc8.jar