ORACLE启动监听出现The listener supports no services
来源:互联网 发布:mysql数据库存储路径 编辑:程序博客网 时间:2024/04/26 07:02
解决方案有以下几种:
第一种.通过重启服务器,来修复监听器.
登陆数据库,sqlplus / as sysdba;SQL>shudownSQL>startup
#startup 启动#shutdown 关闭#lsnrctl stop 关闭服务后,执行关闭监听器#lsnrctl start 然后再启动监听器.
退出命令行,查看监听器状态lsnrctl stat
LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 17-7月 -2010 18:51:36
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER————————Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 – ProductionStart Date 17-7月 -2010 10:51:00Uptime 0 days 8 hr. 0 min. 36 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Log File /oracle/product/10.2.0/network/log/listener.logListening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))Services Summary…Service “oracle” has 1 instance(s). Instance “oracle”, status READY, has 1 handler(s) for this service…Service “oracleXDB” has 1 instance(s). Instance “oracle”, status READY, has 1 handler(s) for this service…Service “oracle_XPT” has 1 instance(s). Instance “oracle”, status READY, has 1 handler(s) for this service…The command completed successfully
第二种.修改LISTENER.ORA与TNSNAME.ORA 文件.
# listener.ora Network Configuration File: oracle/oracle/network/admin/listener.ora# tnsnames.ora Network Configuration File: /oracle/oraclenetwork/admin/tnsnames.ora
LISTENER.ORA:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = oracle) (ORACLE_HOME = oracle/oracle) (PROGRAM = extproc) ) )
TNSNAME.ORA:
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) )
BOBJECMS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle) ) )
oracle = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle) ) )
EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = oracle) (PRESENTATION = RO) ) )
- ORACLE启动监听出现The listener supports no services
- oracle 启动监听提示 :The listener supports no services
- oracle 启动监听提示 :The listener supports no services
- oracle 启动监听提示 :The listener supports no services
- oracle 监听启动报错:the listener supports no services
- oracle 监听无法启动(the listener supports no services)
- Oracle启动监听报错:The listener supports no services The command completed successfully
- Oracle启动监听报错:The listener supports no services解决
- (总结)Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- (总结)Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听提示:The listener supports no services 的处理方法
- Oracle启动监听报错:The listener supports no services解决
- Oracle The listener supports no services
- 数据库和监听启动后,监听中提示The listener supports no services
- Spring AOP
- MySQL安装和engine配置
- 安装libvirt-snmp过程及报错undefined reference to `virDomainCreateWithFlags'
- 工作总结
- linux ipc
- ORACLE启动监听出现The listener supports no services
- Android FragmentManage FragmentTransaction介绍
- NoSQL数据库笔谈
- Redhat下svn 服务器端的安装及配置方法
- ps——删除背景
- 音视频编解码和多媒体格式总结
- Oracle RMAN 的 show,list,crosscheck,delete命令整理
- OpenCV学习笔记(八)——图像处理之直方图ImgProc
- c# xml节点查询