http://otndnld.oracle.co.jp/document/products/oracle10g/101/doc_v5/server.101/B12448-02/net12500.htm
O[[R]]AORA-12505: TNS: リスナーは接続記述子で指定されたSIDを現在認識していませんO[[R]]AORA-12514: TNS: リスナーは接続記述子で要求されたサービスを現在認識していません
サーバーの環境を移行したりしたら、上記のようなエラー
=====tnsnames.ora=====
XE =
(DESC[[R]]IPTION DESCRIPTION = (ADD[[R]]ESS ADDRESS = (P[[R]]OTOCOL PROTOCOL = TCP)(HOST = localhost)(PO[[R]]T PORT = 1521))
(CONNECT_DATA =
(SE[[R]]VE[[R]] SERVER = DEDICATED) (SE[[R]]VICE_NAME SERVICE_NAME = XE)
)
)
EXTP[[R]]OC_CONNECTION_DATA EXTPROC_CONNECTION_DATA = (DESC[[R]]IPTION DESCRIPTION = (ADD[[R]]ESS_LIST ADDRESS_LIST =
(ADDRESS = (PROTOCOL = I[[PC]])(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(P[[R]]ESENTATION PRESENTATION = [[R]]ORO)
)
)
O[[R]]ACL[[R]]_CONNECTION_DATA ORACLR_CONNECTION_DATA = (DESC[[R]]IPTION DESCRIPTION = (ADD[[R]]ESS_LIST ADDRESS_LIST =
(ADDRESS = (PROTOCOL = I[[PC]])(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CL[[R]]ExtProcCLRExtProc) (P[[R]]ESENTATION PRESENTATION = [[R]]ORO)
)
)