NC产品数据连接监听器问题

遇到的问题如下！

测试未通过，请检查输入和数据库：问题原因（监听服务器），报告错误如下：ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

修正方式：

1找到oracle数据库的安装目录下下：F:\app\ComeForLife\product\11.2.0\dbhome_1\NETWORK\ADMIN的listener.ora文件。

2.如果内容是如下：

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = F:\app\ComeForLife\product\11.2.0\dbhome_1)

(PROGRAM = extproc)

(ENVS = "EXTPROC_DLLS=ONLY:F:\app\ComeForLife\product\11.2.0\dbhome_1\bin\oraclr11.dll")

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

ADR_BASE_LISTENER = F:\app\ComeForLife

则修改成：

SID_LIST_LISTENER =
    (SID_LIST =
        (SID_DESC =
         (SID_NAME = PLSExtProc)
         (ORACLE_HOME = F:\app\ComeForLife\product\11.2.0\dbhome_1)
         (PROGRAM = extproc)
        )
        (SID_DESC =
         (GOLBAL_DBNAME= jin) 此处的jin是你安装数据库时候设置的名称
         (ORACLE_HOME = F:\app\ComeForLife\product\11.2.0\dbhome_1)
         (SID_NAME=jin)
        )
    )