下载客户端软件
客户端下载地址
链接:https://pan.baidu.com/s/1StXjSjQ_6wRuwj4tewRlaA 提取码:8ynu
sqlldr工具
链接:https://pan.baidu.com/s/1ZmGSY0ECliLhY5s6FXBNeA 提取码:8iab
plsql工具
链接:https://pan.baidu.com/s/1v8F-uR7X923qTy8SULHbEg 提取码:e2an
将软件上传至服务器,进入软件目录执行安装
rpm -ivh oracle-instantclient18.5-basic-18.5.0.0.0-3.x86_64.rpm rpm -ivh oracle-instantclient18.5-sqlplus-18.5.0.0.0-3.x86_64.rpm rpm -ivh oracle-instantclient18.5-tools-18.5.0.0.0-3.x86_64.rpm
配置环境变量
vi /etc/profile PATH=$PATH:$HOME/bin export ORACLE_HOME=/usr/lib/oracle/18.5/client64 export ORACLE_BASE=/usr/lib/oracle/18.5/ export TNS_ADMIN=$ORACLE_HOME/network/admin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export PATH source /etc/profile
配置监听
vi $ORACLE_HOME/network/admin/tnsnames.ora lol_114 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.114)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
连接测试
sqlplus tuser/123456@192.168.101.114:1521/orcl