Oracle ORA-12514: TNS:listener does not currently know of service requested in conn解決方案

標籤：

# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)      (PROGRAM = extproc)    )    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS_LIST =        (ADDRESS = (PROTOCOL = TCP)(HOST = cust-e44050fe71)(PORT = 1521))      )      (ADDRESS_LIST =        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))      )    )  )

 如果你listener.ora設定檔是這樣的 說明少了一些配置資訊應指出監聽那個資料庫應加上

(SID_DESC =      (GLOBAL_DBNAME = GKBM2015) //為資料庫服務名      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)      (SID_NAME = GKBM2015) //為資料庫服務名     )    (SID_DESC =      (GLOBAL_DBNAME = ZYXX2015) //為資料庫服務名      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)      (SID_NAME = ZYXX2015) //為資料庫服務名    )

 之後的檔案是這樣的

# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)      (PROGRAM = extproc)    )    (SID_DESC =      (GLOBAL_DBNAME = GKBM2015)      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)      (SID_NAME = GKBM2015)     )    (SID_DESC =      (GLOBAL_DBNAME = ZYXX2015)      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)      (SID_NAME = ZYXX2015)    )    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS_LIST =        (ADDRESS = (PROTOCOL = TCP)(HOST = cust-e44050fe71)(PORT = 1521))      )      (ADDRESS_LIST =        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))      )    )  )

 之後重啟監聽程式

cmd命令中輸入 lsnrctl

stop

start

 

Oracle ORA-12514: TNS:listener does not currently know of service requested in conn解決方案