***ORA—12541:TNS:没有监听器???*** 应该是你没有将你需要的Oracle注册到你自己的机器上,即使注册了,可能是目标Oracle服务器的监听端口号错误,可能目标机器换了默认的端口号,这时你应该在Oracle Net ***里面配置一下就可以了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 在\oracle\ora81\bin\执行下面的命令lsnrctl start 我的系统是win2000 professional。我不知道怎么在oracle net里配置啊,能大致说明一下吗? 给你一个 listener.ora 文件的示例,把其中的 host改成你的机器的 IPlistener.ora文件的存放路径在注释里有\oracle\ora92\network\admin\listener.ora# LISTENER.ORA Network Configuration File: F:\oracle\ora92\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = genome)(PORT = 1521)) ) ) ) 这个是完整的,其中的sid_name,dbname,ip都要改成你自己的# LISTENER.ORA Network Configuration File: F:\oracle\ora92\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = genome)(PORT = 1521)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = F:\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = test) (ORACLE_HOME = F:\oracle\ora92) (SID_NAME = test) ) ) 我看帮助里说:确保先启动 Oracle Management Server,然后再在“Oracle Enterprise Manager 登录”对话框中输入身份证明。我在“控制面板”>“服务”里也找不到 Management Server。为什么啊? 打开Oracle Net Manager,选择区域里面的服务命名,找一下有你的服务器有没有在里面,没有则添加,有则看看端口是否正确,重新配置好就可以了~~~~~希望能给你点帮助~~~ ora-01489错误怎么解决! 2亿条数据,如何解决模糊查询的问题。 oracle存储过程,变量如何加单引号 这个sql语句的意义? Linux Oracle Weblogic Brio8 Windows 2003 这五个软件(系统)的服务期限问题 ORACLE 一个单元格的值拆分成多个 ,请见例子 关于oracle中的imp的管道应用 求OSB客户端实例 oracle基础问题 怎么判断是否取出数据? 在Startup时候,出现通信通道错误,怎么回事啊? 关于表之间的约束问题????
lsnrctl start
我不知道怎么在oracle net里配置啊,能大致说明一下吗?
listener.ora文件的存放路径在注释里有\oracle\ora92\network\admin\listener.ora
# LISTENER.ORA Network Configuration File: F:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = genome)(PORT = 1521))
)
)
)
# LISTENER.ORA Network Configuration File: F:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = genome)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = F:\oracle\ora92)
(SID_NAME = test)
)
)