老问题了,监听器无法打开,但就是解决不了 我的系统是WIN2K personal,sp4 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你设置的监听端口是不是1521?你的监听端口要和本地NET服务名配置的端口相同才可以,原因我也不清楚,最要把你的监听和服务名配置的内容帖出来 是下面这两个把,开始默认的端口是1521,后来我重新添加了个1520。xq是主机名# LISTENER.ORA Network Configuration File: D:\oracle\ora90\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xq)(PORT = 1520)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\ora90) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = xq.com) (ORACLE_HOME = D:\oracle\ora90) (SID_NAME = xq) ) )# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\network\admin\tnsnames.ora# Generated by Oracle configuration tools.INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xq)(PORT = 1520)) ) (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) ) )XQ = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xq)(PORT = 1520)) ) (CONNECT_DATA = (SERVICE_NAME = xq.com) ) ) 小问题.! 看看你能用几种办法解决 C#与Oracle数据库如何连接? 求一个存储过程 小虫Query Quiz游戏 No.1 如何统计表的结果? 求助:SQL Server 2000 数据库移植到Oracle 有关spool命令的使用 师兄请进,关于监听的问题 Oracle安裝后不能啟動監聽 救急!!! Oracle 连接 SQL Server 的乱码问题 这个SQL语句怎么写?(极具挑战性)高手进
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xq)(PORT = 1520))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = xq.com)
(ORACLE_HOME = D:\oracle\ora90)
(SID_NAME = xq)
)
)
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xq)(PORT = 1520))
)
(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)
)
)XQ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xq)(PORT = 1520))
)
(CONNECT_DATA =
(SERVICE_NAME = xq.com)
)
)