Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
来源:互联网 发布:验证码java 编辑:程序博客网 时间:2024/05/18 02:05
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...,有需要的朋友可以参考下。
今天将服务器的监听程序重启了一下,重启后成功,但是数据库死活注册不上去,导致客户端没法连接到数据库:
<span style="font-family: Arial, Helvetica, sans-serif;">-- 启动监听[oracle@localhost dbs]$ lsnrctl start</span>
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-FEB-2015 13:43:40Copyright (c) 1991, 2011, Oracle. All rights reserved.TNS-01106: Listener using listener name LISTENER has already been started[oracle@localhost dbs]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-FEB-2015 13:43:45Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date 04-FEB-2015 13:43:21Uptime 0 days 0 hr. 0 min. 23 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/network/admin/listener.oraListener Log File /u01/app/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.100)(PORT=1521)))Services Summary...Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully启动后,提示Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...这个提示一般认为很正常,是由于实例没有注册到监听服务中去,于是注册实例
SQL> alter system register;System altered.
实例已经注册,再来看看监听状态:
[oracle@localhost dbs]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-FEB-2015 13:43:40Copyright (c) 1991, 2011, Oracle. All rights reserved.TNS-01106: Listener using listener name LISTENER has already been started[oracle@localhost dbs]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-FEB-2015 13:43:45Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date 04-FEB-2015 13:43:21Uptime 0 days 0 hr. 0 min. 23 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/network/admin/listener.oraListener Log File /u01/app/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.100)(PORT=1521)))Services Summary...Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully
发现orcl 还是未知状态(Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...),查看监听配置是否有问题
--监听文件的内容[oracle@localhost admin]$ pwd/u01/app/oracle/network/admin[oracle@localhost admin]$ more listener.ora # listener.ora Network Configuration File: /u01/app/oracle/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = /u01/app/oracle) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = /u01/app/oracle) (SID_NAME = orcl) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.3.100)(PORT = 1521)) ) )ADR_BASE_LISTENER = /u01/app
监听文件貌似没有问题,因为我之前是没有问题,看看前面监听的日志:
[oracle@localhost admin]$ tail -30 /u01/app/diag/tnslsnr/localhost/listener/alert/log.xml<msg time='2015-02-04T13:43:21.139+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='localhost.localdomain' host_addr='::1'> <txt>WARNING: Subscription for node down event still pending </txt></msg><msg time='2015-02-04T13:43:21.140+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='localhost.localdomain' host_addr='::1'> <txt>04-FEB-2015 13:43:21 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0 </txt></msg><msg time='2015-02-04T13:43:40.091+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='localhost.localdomain' host_addr='::1'> <txt>04-FEB-2015 13:43:40 * ping * 0 </txt></msg><msg time='2015-02-04T13:43:45.083+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='localhost.localdomain' host_addr='::1'> <txt>WARNING: Subscription for node down event still pending </txt></msg><msg time='2015-02-04T13:43:45.084+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='localhost.localdomain' host_addr='::1'> <txt>04-FEB-2015 13:43:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0 </txt>发现监听在启动时,读取了主机名:localhost.localdomain ,个人感觉应该是主机名解析有问题,于是看看hosts文件
[root@localhost oracle]# hostnamelocalhost.localdomain[root@localhost oracle]# more /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.3.100 localhost.localdomain发现三个IP都对应了机器名localhost.localdomain ,可能这种情况导致监听无法解析导致数据库不能注册到监听程序中
[root@localhost oracle]# more /etc/hosts#127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4172.0.0.1 localhost192.168.3.100 localhost.localdomain#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
然后再重启监听程序
[oracle@localhost dbs]$ lsnrctlLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-FEB-2015 15:10:10Copyright (c) 1991, 2011, Oracle. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> stopConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))The command completed successfullyLSNRCTL> startStarting /u01/app/oracle/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionSystem parameter file is /u01/app/oracle/network/admin/listener.oraLog messages written to /u01/app/diag/tnslsnr/localhost/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.100)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date 04-FEB-2015 15:10:29Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/network/admin/listener.oraListener Log File /u01/app/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.100)(PORT=1521)))Services Summary...Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...The command completed successfullyLSNRCTL>
实例注册后,再看看监听状态
LSNRCTL> statusConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date 04-FEB-2015 15:10:29Uptime 0 days 0 hr. 1 min. 29 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/network/admin/listener.oraListener Log File /u01/app/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.100)(PORT=1521)))Services Summary...Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...Service "orcl.localdomain" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service...Service "orcl11gXDB.localdomain" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service...The command completed successfully
发现实例已经处于ready状态了。
OK,到此,客户端已经可以连接到数据库了
转自:http://blog.csdn.net/csdnones/article/details/72903344
阅读全文
0 0
- Oracle error:Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Service "SYS$SYS.KUPC$C_1_20140110224935.RAC" has 1 instance(s)
- PHP-FPM stop/reload: Unknown instance, service status `stop/waiting`
- 132.The tnsnames.ora file has an entry for the service alias ORCL as follows: ORCL = ( DESCRIPTION =
- ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
- oracle重启后,启动监听出现Instance "PLSExtProc", status UNKNOWN
- oracle重启后,启动监听出现Instance "PLSExtProc", status UNKNOWN
- tnsping orcl;lsnrctl status
- Centos7 安装kilo报错 “has no endpoint in ! Available endpoints for this service”
- HTTP Status 500 No adapter for handler
- Illegal access: this web application instance has been stopped already
- this web application instance has been stopped alr
- this web application instance has been stopped already解决办法
- this web application instance has been stopped already
- 删除git库中untracked files(未监控)的文件
- 2017-12-05——iOS——懒加载浅谈
- 动态规划—最大子矩阵和(两种题型)
- Celery
- 198-House Robber
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- GreenDao+存储数据库
- Retrofit工具类的封装
- HTML5——拖拽,地理定位,web存储,缓存
- 学习笔记_008
- 人工智能领域的争议
- getimagesize() php 获取图片真实类型,大小等
- 原型模式 C#
- MySQL的GTID