oracle 11g ORA-12514錯誤，我的解決辦法

前言:網上有很多解決辦法，刪listener.ora也好，還是什麼也好，都解決不了我這個問題，依然報12514錯誤，以下是我逐個嘗試後成功的監聽字串。。

listener.ora檔案：

# listener.ora Network Configuration File: d:/app/john/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = cjtfs)   
      (ORACLE_HOME = d:/app/john/product/11.1.0/db_1)
      (PROGRAM = cjtfs)
    )
     (SID_DESC =
      (GLOBAL_DBNAME = cjtfs)
      (ORACLE_HOME = d:/app/john/product/11.1.0/db_1)
      (SID_NAME = cjtfs)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    )
  )

tnsnames.ora檔案：

# tnsnames.ora Network Configuration File: d:/app/john/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

CJTFS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cjtfs)   #要和listener.ora裡面的cjtfs位置的名字保持一致
    )
  )

 

 

如果還解決不了，那就留言，我一般會常看blog的。。。。大家一起解決。。互相學習。