Oracle-安装好oracle就有的tnsnames文件

最新推荐文章于 2025-10-22 17:14:50 发布

原创最新推荐文章于 2025-10-22 17:14:50 发布 · 698 阅读

0 ·

CC 4.0 BY-SA版权

Orale MySQL 专栏收录该内容

73 篇文章

订阅专栏

本文详细介绍了Oracle数据库中tnsnames.ora文件的配置方法。包括监听器配置、连接描述符设置等内容，适用于Oracle数据库管理员及开发人员进行网络配置。


tnsnames.ora

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )