Oracle listener.ora&tnsnames.ora配置模板(监听)

z1blog

已于 2024-01-01 01:15:25 修改

阅读量479

点赞数 6

分类专栏：数据库管理员(DBA) 文章标签： oracle 数据库

于 2024-01-01 01:15:10 首次发布

本文链接：https://blog.csdn.net/weixin_41824599/article/details/135321387

版权

数据库管理员(DBA) 专栏收录该内容

39 篇文章 0 订阅

订阅专栏

本文详细解释了Oracle数据库的listener.ora和tnsnames.ora配置模板，包括DESCRIPTION_LIST,SID_LIST_LISTENER,和TNSNAMES.ora中关键参数如ADDRESS,PROTOCOL,SID_NAME等的设置。

摘要由CSDN通过智能技术生成

1、listener.ora配置模板

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary )(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = primarydb)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0.1/dbhome_1/)
(SID_NAME = primarydb)
)
)

2、tnsnames.ora配置模板
primarydb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.x )(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = primarydb )
)
)