oracle中手动添加监听器

最新推荐文章于 2024-07-26 22:10:35 发布

p112823

最新推荐文章于 2024-07-26 22:10:35 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： 2011-07 文章标签： oracle list 数据库服务器 network tcp service

本文链接：https://blog.youkuaiyun.com/p112823/article/details/6620218

2011-07 专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了在Oracle环境下，如何手动添加监听器与用户，方便、快捷地通过PL/SQL连接数据库服务器。具体步骤包括配置监听程序参数文件、tnsnames.ora文件，并确保所有配置正确无误，从而实现高效数据库连接。

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

oracle中手动添加监听器与用户

为了方便、快捷、通过pl/sql连接数据库服务器，可以手动的添加监听器与用户。

准备：

1. 监听程序参数文件：E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora

文件内容为：

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-6T7KS8ECIRV)(PORT = 1521))
)
)

CANLIAN =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-6T7KS8ECIRV)(PORT = 1521))
)
)

CANLIAN就是新添加的实例

2. E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

tnsnames.ora文件配置如下：

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-6T7KS8ECIRV)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

canlian =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.25.9)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = canlian)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)