oracle9i...编程连接数据库是提示:ORA-12154: TNS: 无法处理服务名 ? 服務名寫錯了,或者tnsname.ora里面的SERVICE_NAME = MODOSE、 (ADDRESS = (PROTOCOL = TCP)(HOST = s2003)(PORT = 1521))有誤 。檢察一下吧 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 重新做的# TNSNAMES.ORA Network Configuration File: c:\oracle\ora90\network\admin\tnsnames.ora# Generated by Oracle configuration tools.##################################### Date..........: Mon Sep 08 21:16:58 CST 2003####################################INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = s2003)(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) ) )EBOOK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = s2003)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = eBook) ) ) 可以用 Net Configuration Assistant 来重新配置过,不要自己改 文件啦... :) 把服务器的listener.ora也贴出来,tnsnames.ora与listener.ora中的内容要对应 listener.ora# LISTENER.ORA Network Configuration File: c:\oracle\ora90\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = s2003)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = c:\oracle\ora90) (PROGRAM = extproc) ) ) 连数据库时,主机字符串写的什么,即用的tnsnames里的哪个名字?看样子listener.ora需要配一下,或者用个偷懒的办法,重新启动数据库,注意不是重启机器,是只重启oracle,9i新特性,启动数据库时,如果此时listener已经启动了,会自动注册listener 肯定是监听没有配好,我也经常碰到这样的问题,先把文件备份一下,然后删除,在DBA中也删除已有的数据库树,再重新建一个,它会自动在原目录下建立一个.ora文件的 用什么工具重启oracle,9i新特性 请问为什么返回01427错误 一个oracle得问题 两表关联的问题 求sql文。。我真想不出解决方法了。。。急~~~ 移动控制文件出现的问题 请大家帮我下 sqL提问,急急急 求教几个小问题。。。。 将oracle库中一张表的内容导出到一个txt文件后,为什么字段之间有空格? 请教Oracle+Delphi+Ado的连接问题! 修改oracle数据库字段把vchar2的由50改为10时,提示要减小列长度必须修改道感必须为空(empty),这是什么意思? PL/SQL如何读取BLOB字段?谢谢! 初次介入数据库开发,请教数据库备份有哪些方案?
# Generated by Oracle configuration tools.####################################
# Date..........: Mon Sep 08 21:16:58 CST 2003
####################################INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s2003)(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)
)
)EBOOK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s2003)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = eBook)
)
)
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s2003)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora90)
(PROGRAM = extproc)
)
)
看样子listener.ora需要配一下,或者用个偷懒的办法,重新启动数据库,注意不是重启机器,是只重启oracle,9i新特性,启动数据库时,如果此时listener已经启动了,会自动注册listener