centos安装oracle client客户端
2022/2/24 19:22:49
本文主要是介绍centos安装oracle client客户端,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
一、下载安装
1、官网下载所需的rpm包
rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm rpm -ivh oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm rpm -ivh oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm rpm -ivh oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm
2、添加环境变量
vim /etc/profile export ORACLE_HOME=/usr/lib/oracle/11.2/client64 export TNS_ADMIN=/usr/lib/oracle/11.2/client64 export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib export ORABIN=/usr/lib/oracle/11.2/client64/bin export PATH=$PATH:$ORABIN export PATH=$ORACLE_HOME:$PATH export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
3、使环境变量重新生效
source /etc/profile
4、配置监听配置文件
mkdir -p /usr/lib/oracle/11.2/client64/network/admin/ vim /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora TEST = (DESCRIPTION = (ENABLE = BROKEN) (FAILOVER = YES) (LOAD_BALANCE = OFF) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.201)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = testdb) (FAILOVER_MODE = (TYPE = session) (METHOD = BASIC) (RETRIES = 30) (DELAY = 10) ) ) ) 192.168.1.10 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = macpdb) ) )
二、登录使用
1、使用sqlplus连接数据库
登录本机数据库
sqlplus / as sysdba sqlplus username/password
登录远程数据库
sqlplus username/password@orcl sqlplus username/password@hosrIP:port/sid
2、示例
sqlplus abc/abc#123@192.168.20.201:1521/testdb
这篇关于centos安装oracle client客户端的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-06-26终极指南:Scrum中如何设置需求优先级
- 2024-06-26AI大模型企业应用实战(25)-为Langchain Agent添加记忆功能
- 2024-06-26小白家庭 nas 搭建方案-icode9专业技术文章分享
- 2024-06-23AI大模型企业应用实战(14)-langchain的Embedding
- 2024-06-23AI大模型企业应用实战(15)-langchain核心组件
- 2024-06-23AI大模型企业应用实战(16)-langchain核心组件
- 2024-06-23AI 大模型企业应用实战(06)-初识LangChain
- 2024-06-19EntBot.ai: AI Website Chatbot for Product Guides and Development Doc
- 2024-06-17zero-shot-learning-definition-examples-comparison
- 2024-06-06Package Easy(基于 NSIS 的打包exe安装包工具)使用方法-icode9专业技术文章分享