plsql不能连接到数据库，提示ora-12514

[干饭人之路]

---数据库中的 tnsnames.ora 内容如下：
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MS-20160313FPEY)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
---数据库中的 listener.ora 内容如下：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\oraclexe\app\oracle\product\11.2.0\server\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = XE)
(ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server)
(SID_NAME = XE)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = MS-20160313FPEY)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)
---oracle 客户端中的tnsname.ora配置如下：
XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

plsql连接数据库时老是提示：
ora-12514:tns:listener does not currently know of service requested in connect descriptor
请问怎么修改配置才能连接到数据库

[pengpeng409]

plsql有没有配置啊

[pengpeng409]

[Piupiu小虾米]

配置文件中的SID不一样。。

[干饭人之路]

pengpeng409 plsql已经设置完成了。 longfly04 SID不是都是XE吗？哪里不一样呀？

[zy18755122285]

当登陆时报错：ORA-12514时， （1）计算机 管理里面-->服务-->打开oracleTNSlistener服务。 （2）在F:\PLSQL\instantclient_12_1\NETWORK\ADMIN\listener.ora中：加入 (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME =E:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = ORCL) )

[寡丶人]

1、先直接填写连接字符串连接，确定数据库用pl/sql可以连接上 2、查看是否是ora配置错了，可以把别人的好的ora文件考过来改一下SID、ip等。 3、要是还不行查看你连接的admin文件夹是不是对的，可能用的事client中的admin。