設置了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

總結

以上是生活随笔為你收集整理的Oracle shared server模式连接ORA-12519的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。