在CentOS环境下配置SQL*Plus通常涉及以下步骤:
安装Oracle客户端:
/opt/oracle/instantclient
。配置环境变量:
~/.bashrc
文件或 /etc/profile.d/oracle.sh
文件来设置环境变量。export ORACLE_HOME=/opt/oracle/instantclient
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORACLE_SID=orcl
source ~/.bashrc
验证安装:
sqlplus /nolog
命令来验证安装是否成功。如果一切正常,你应该会看到SQL*Plus的提示符:SQL*Plus: Release 19.0.0.0.0.0 - Production on Mon Sep 27 14:48:34 2021
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.3.0.0.0 - 64bit Production
with the Partitioning, OLAP, Data Mining and Real Application Testing options
配置TNSNAMES.ORA(可选):
tnsnames.ora
文件。这个文件通常位于 $ORACLE_HOME/network/admin
目录下。MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_host)(PORT = your_port))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = your_service_name)
)
)
测试连接:
sqlplus username/password@MYDB
username
、password
和 MYDB
替换为你的数据库用户名、密码和 tnsnames.ora
中定义的别名。如果在安装过程中遇到任何问题,请检查Oracle官方网站的文档或寻求社区支持。