当我更改服务器名称后,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
那位大侠能够解决,谢谢
# 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
那位大侠能够解决,谢谢
解决方案 »
- oracle 存储过程更新图片的问题!
- 一句令人费解的SQL查询语句
- 数据库无法OPEN,请教
- 急求一个SQL语句的写法,有关半全角字符转化
- 关于通信通道的文件结束
- 关于数据字典问题
- 关于字符拆分的为题---跪求中……
- 数据库有时会断掉,要重连.网络中有冲击波.在线等待,很快结帖
- 再问:我执行一个存储过程,提示:ORA-01006: 赋值变量不存在.详细在内,请指教,谢谢!(Hothehe)
- 请教各位大佬执行插入语句时,如何生成 001 001001 001002 002 002001 002002这种编号,非常感谢!
- 从orcle8中数据导入到oracle9的问题(急!!解决补50分)
- 几行不懂的代码
$oracle_home\network\admin\listener.ora
也许是WINDOWS解析不出JZP,我建议使用IP地址来访问数据库。
2008 14:00:44Copyright (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@ifstestSQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 25 14:03:18 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:
ORA-12154: TNS:could not resolve the connect identifier specifiedIFSTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.2.60)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
当时的解决办法:
将IFSTEST 修改为IFSTEST.LOCALDOMAIN
就可以了,你可是试试看!
http://blog.sina.com.cn/s/blog_3f2ef1180100aikc.html
然后用 lsnrctl stop
lsnrctl start
命令重新启动监听