登陆oracle 9i,提示我TNS没有监听器,但是TNS启动了,并且lsnrctl status状态正常 实在是不知道怎么办了,上周五提问的,各位的回答我也都试了,现在不是TNS无法启动的问题,是TNS启动了,并且状态正常,依然提示我TNS没有监听器,例如有朋友说删除监听器重建,我试过了,停止重新运行TNS,试过了,配置的名字与主机的名字不一样,我试过了 一样的,HOST 是我的主机名称。我不知道还有什么漏掉了。求解答 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看一下服务器端的listener.ora,在client端用netca重新建立本地连接,试一试 # TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora# Generated by Oracle configuration tools.DAHENG = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = wd70004)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = daheng) ) )INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = wd70004)(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) ) )这是listener.ora楼上的朋友 我用oracle时间比较短,能详细说下怎么操作么, 怪异的ORA-12154 创建ORACLE控制文件副本的问题 在线急等,高手请进 请教一个查询 语句 用PLSQL进数据库时,出现了'无法处理服务名'的错误! 创建Instance 为什么不能生成control文件 初学这问题 数据库链接问题 w2000下安装oracle8,能否对solaris中的oracle7.2.x进行数据访问。net8如何连sql*net v1呢 oracle安装完后,有没有在线帮助一类的东西????? oracle 查询两个字段值相同的记录 oracle中修改字段为null 的写法
在client端用netca重新建立本地连接,试一试
# Generated by Oracle configuration tools.DAHENG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wd70004)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = daheng)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wd70004)(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)
)
)
这是listener.ora
楼上的朋友 我用oracle时间比较短,能详细说下怎么操作么,