Oracle shared server模式连接ORA-12519

最新推荐文章于 2025-08-04 23:14:52 发布

weixin_30521161

最新推荐文章于 2025-08-04 23:14:52 发布

阅读量93

点赞数

CC 4.0 BY-SA版权

文章标签：数据库网络

原文链接：http://www.cnblogs.com/Clark-cloud-database/p/7818423.html

本文介绍了如何解决Oracle数据库在使用共享服务器模式下连接失败的问题。通过调整tnsnames.ora文件中的连接类型，并设置local_listener.ora初始化参数，成功实现了通过共享服务器模式连接数据库。

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

设置了shared server连接，dispatcher进程和shared server进程都没有问题
listener.ora文件配置如下：
LSNR2=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=edbjr2p1.example.com)(PORT=1526))
))
SID_LIST_LSNR2=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PROD1)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME=PROD1))
)

tnsnames.ora文件配置如下：
PROD1_S =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = edbjr2p1.example.com)(PORT = 1526))
(CONNECT_DATA =
(SERVER = SHARED)
(SID = PROD1)
)
)

但是连接出现错误：
[oracle@edbjr2p1 admin]$ sqlplus system/oracle@PROD1_S
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 4 09:40:27 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12519: TNS:no appropriate service handler found

tnsnames.ora文件中shared更改为dedicated连接正常。

此时需要把local_listener.ora初始化参数添加LSNR2监听器,问题解决.
alter system set local_listener='LSNR2','LISTENER';
此参数可以让pmon可以注册实例到监听器
LOCAL_LISTENER specifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in the TNSNAMES.ORA file or other address repository as configured for your system.

转载于:https://www.cnblogs.com/Clark-cloud-database/p/7818423.html