liunx下安装Sql*Plus并连接远程Oralce服务器
-
环境
客户端:Ubuntu18.04LTS
服务端:Centos7 Oracle12c
-
下载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
-
安装alien工具
alien工具是将rpm包转换为deb包的工具
$ sudo apt install alien
-
安装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) ...
-
编辑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