日期:2014-05-17  浏览次数:21026 次

plsql报: 监听程序当前无法识别连接描述符中请求的服务
我在用plsql时,报:   监听程序当前无法识别连接描述符中请求的服务,我看是配置的问题,可以试了几次又不对
---------------------------
listener.ora:
SID_LIST_LISTENER   =
    (SID_LIST   =
        (SID_DESC   =
            (SID_NAME   =   PLSExtProc)
            (ORACLE_HOME   =   d:\oracle\product\10.2.0\db_1)
            (PROGRAM   =   extproc)
        )
    )

LISTENER   =
    (DESCRIPTION_LIST   =
        (DESCRIPTION   =
            (ADDRESS   =   (PROTOCOL   =   IPC)(KEY   =   EXTPROC1))
            (ADDRESS   =   (PROTOCOL   =   TCP)(HOST   =   localhost)(PORT   =   1521))
        )
    )
---------------------------
tnsnames.ora
ORCL   =
    (DESCRIPTION   =
        (ADDRESS   =   (PROTOCOL   =   TCP)(HOST   =   localhost)(PORT   =   1521))
        (CONNECT_DATA   =
            (SERVER   =   DEDICATED)
            (SERVICE_NAME   =   orcl)
        )
    )

EXTPROC_CONNECTION_DATA   =
    (DESCRIPTION   =
        (ADDRESS_LIST   =
            (ADDRESS   =   (PROTOCOL   =   IPC)(KEY   =   EXTPROC1))
        )
        (CONNECT_DATA   =
            (SID   =   PLSExtProc)
            (PRESENTATION   =   RO)
        )
    )
大家帮看看是哪里出问题嘛,在线等,急啊

------解决方案--------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = orcl)
)
)

你最好去NET MANAGER中配置