oracle ping tns

最新推荐文章于 2023-07-12 17:58:42 发布

原创最新推荐文章于 2023-07-12 17:58:42 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

4 篇文章

订阅专栏

本文介绍在Linux环境中为Oracle配置环境变量的具体步骤，包括PATH和LD_LIBRARY_PATH等，并详细展示了如何设置tnsnames文件来定义Oracle数据库连接字符串，最后通过tnsping命令验证配置的有效性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

liunx ping前题

-------------------------------------------------------------------

PATH环境变量中配置oracle的bin和lib目录

还需配置oracle_home变量

export PATH=${PATH}:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1

--------------------------------------------------------------------------

在oracle目录tnsnames文件中配置连接串

oracltest =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.164.130.197)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)

--------------------------------------------------------------------

执行命令：tnsping orcltest