tnslistener是监听程序么 怎么启动呀说细点 初学者
解决方案 »
- 一个小sql 看看 谁 的最高效,谢谢
- ORA-00911錯誤
- 存储过程循环语句,哪个效率高?
- 如何查询一个database link 是否存在?
- Create index 问题
- 急急急!在Solaris10上装oracle10出现ora-00600问题
- 向高手们请教升级Oracle的时候都应该注意哪儿些问题
- 在一个60多条记录的小表中删除一条记录需要3秒钟,ORACLE究竟在干什么?!!!
- 关于ORA-08103 object no longer exists错误,请指教,急
- 在oracle8.17不可以建共享数据库连接到ora7.3.4吗?
- 急:我把C:\oracle\oradata\TEST\下面的UNDOTBS01.DBF这个文件删除了,ORACLE不好用了.
- 求救 简单问题
by the listener. Compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file
(or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener
on the remote machine.
我的地址是唯一的没有冲突LISTENER.ORA :
# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ewa-ws-t1-37)(PORT = 8088))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ewa-ws-t1-37.EWASOLUTIONSI)(PORT = 1521))
)
2:04Copyright (c) 1991, 2004, Oracle. All rights rStarting tnslsnr: please wait...Failed to start service, error 1058.
TNS-12536: TNS:operation would block
TNS-12560: TNS:protocol adapter error
TNS-00506: Operation would block
32-bit Windows Error: 997: Unknown error
建议你修改你的配置文件试试看,把host用IP地址代替,
LISTENER.ORA :
# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ewa-ws-t1-37)(PORT = 8088))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ewa-ws-t1-37.EWASOLUTIONSI)(PORT = 1521))
)
这样启动也可以
控制面板-》管理工具-》服务-》oracleTNSlistener 启动