ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

原因:listener沒設定好(很奇怪用configuration manager 新增的listener不能用)
手動改了listener.ora之後就好了

LISTENER =
(DESCRIPTION_LIST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = cimsdb)(PORT = 1521))
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  )
)
SID_LIST_LISTENER=
(SID_LIST=
  (SID_DESC=
    (GLOBAL_DBNAME=cimsTrai)
    (ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1)
    (SID_NAME=cimsTrai))
  (SID_DESC=
    (SID_NAME=plsextproc)
    (ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1)
    (PROGRAM=extproc)))

順便紀錄一下tnsnames.ora的內容

# tnsnames.ora Network Configuration File:C:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

CIMSPROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = cimsdb)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cimsProd)
    )
  )

CIMSTRAI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cimsdb)(PORT = 1521))
    )
    (CONNECT_DATA =
  (SERVER = DEDICATED)
      (SERVICE_NAME = cimsTrai)
    )
  )