文章目录一. 下载二. 配置1. 配置环境变量2. 配置tnsnames.ora文件三. 测试1. 链接语法2. 连接测试四. 通过rpm安装mysql一. 下载下载地址基础包连接工具二. 配置上传、解压、配置环境变量这里安装在/data01目录下unzip instantclient-sqlplus-linux.x64-19.20.0.0.0dbru.zip unzip instantclient-basic-linux.x64-19.20.0.0.0dbru.zip1. 配置环境变量vim ~/.bash_profileexport ORACLE_HOME/data01/oracle-client/instantclient_19_20/export TNS_ADMIN$ORACLE_HOME/network/admin export LD_LIBRARY_PATH$ORACLE_HOME export PATH$ORACLE_HOME:$PATHsource ~/.bash_profile2. 配置tnsnames.ora文件cd/data01/oracle-client/instantclient_19_20/network/admin vim tnsnames.ora ora11g(DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOST10.1.1.1)(PORT1521))(CONNECT_DATA(SERVERDEDICATED)(SERVICE_NAMEora11g)))三. 测试1. 链接语法sqlplususername/password//hostname:port/sidusername是你的数据库用户名password是你的数据库密码hostname是数据库的主机名port是数据库的监听端口号sid是数据库的 SID数据库实例标识符。2. 连接测试sqlplus scott/tiger//localhost:1521/ORCLSQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 24 20:10:56 2023 Version 19.20.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL说明访问成功。接着执行sql查询SQLSELECT*FROM TEST.FLINKX_KINGBASE_TEST2;ID USERNAME AGE----------------------------------------------------------------------1abc252zxc263vbn27四. 通过rpm安装mysql通过rpm安装mysql
