求注：关于ORA-12514报错问题

[jzpang1980]

当我更改服务器名称后，PLSQL Developer不能使用了，提示不能找到server_name。我把所有配置文件的服务器名称更改过来了，还是不可以。在网上搜索相关帖子，也不能解决。现把tnsnames.ora内容贴下：
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = JZP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

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

ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = JZP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORACLE)
)
)
当前服务器名称为JZP,默认数据库的名称为ORACLE
那位大侠能够解决，谢谢

[jzpang1980]

自己顶一下

[ora321]

试着把监听的也改下:
$oracle_home\network\admin\listener.ora

[jzpang1980]

更改了,没有用.
谢谢

[jzpang1980]

难道没有人回答吗?

[guoxb691]

将本地net服务全部删除重新配置

[snowy_howe]

hosts文件修改没？
也许是WINDOWS解析不出JZP，我建议使用IP地址来访问数据库。

[dotnba]

偶有一个类似问题：

服务器端和其它客户端都是可以的。Net Manager 测试成功，Tnsping 也没问题。但是sqlplus 报12514无法解析，XP客户端。

C:\Documents and Settings\IBM>tnsping ifstest

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-8月 -
2008 14:00:44

Copyright (c) 1997, 2005, Oracle. All rights reserved.

已使用的参数文件:
D:\oracle\product\10.2.0\client_2_2\network\admin\sqlnet.ora


已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.10.2.60)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = TEST)))
OK (20 毫秒)


C:\Documents and Settings\IBM>sqlplus ifsapp/ifsapp@ifstest

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 25 14:03:18 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

IFSTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.2.60)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)

[throat]

我也遇到过类似的问题，
当时的解决办法：
将IFSTEST 修改为IFSTEST.LOCALDOMAIN
就可以了，你可是试试看！

[dotnba]

http://blog.sina.com.cn/s/blog_3f2ef1180100aj1a.html
http://blog.sina.com.cn/s/blog_3f2ef1180100aikc.html

[ruihuahan]

服务器端的 listener.ora 做相应的修改。
然后用 lsnrctl stop
lsnrctl start
命令重新启动监听