ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务解决

修改listener.ora文件如下内容:

SID_LIST_LISTENER =
    (SID_LIST =
        (SID_DESC =
        (SID_NAME = CLRExtProc)
        (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
        (PROGRAM = extproc)
        (ENVS = "EXTPROC_DLLS=ONLY:F:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
)

为:

SID_LIST_LISTENER =
    (SID_LIST =
       (SID_DESC =
       (GLOBAL_DBNAME = ORCL)
       (SID_NAME = ORCL)
       (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
       (PROGRAM = extproc)
       (ENVS = "EXTPROC_DLLS=ONLY:F:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
)

 

posted @ 2016-01-04 11:43  天之涯0204  阅读(178)  评论(0编辑  收藏  举报