PL/SQL登陆报错ORA-12154 TNS无法解析指定的连接标识符,用sql plus能登陆 求大神解救啊!

监听服务已打开 tnsnames.ora如下
# tnsnames.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)
NEVERGONE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
服务命没写对, “SERVICE_NAME = orcl”, 检查一下服务器端友衡简的tnsname.ora的service_name是怎拦运么写的,正确的写法应该是 service_name = database_name + domain_name.

建议不要手工编辑tnsname.ora,而是用Oracle NCA(Net configuration assistant)来配置比好裤较好。