Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ons offline
发新帖
北柏

60

积分

1

好友

6

主题

[Exadata常规管理] ons offline

1#
发表于 2014-6-25 20:37:01 | 查看: 3610| 回复: 1
oracle rac 11203
Linux 64 bit

###################
# log in ons.log.db1
###################



[2014-06-25T19:54:59+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 3f,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:55:31+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 40,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:56:03+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 41,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:56:35+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 42,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:56:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 43,db2,6201 connect (Connection refused)
[2014-06-25T19:57:07+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 44,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:57:39+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 45,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:58:11+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 46,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:58:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 47,db2,6201 connect (Connection refused)
[2014-06-25T19:58:43+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 48,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:59:15+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 49,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T19:59:47+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 4a,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:00:19+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 4b,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:00:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 4c,db2,6201 connect (Connection refused)
[2014-06-25T20:00:51+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 4d,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:01:23+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 4e,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:01:55+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 4f,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:02:27+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 50,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:02:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 51,db2,6201 connect (Connection refused)
[2014-06-25T20:02:59+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 52,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:03:31+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 53,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:04:03+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 54,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:04:35+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 55,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:04:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 56,db2,6201 connect (Connection refused)
[2014-06-25T20:05:07+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 57,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:05:39+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 58,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:06:11+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 59,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:06:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 5a,db2,6201 connect (Connection refused)
[2014-06-25T20:06:43+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 5b,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:07:15+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 5c,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:07:47+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 5d,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:08:19+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 5e,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:08:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 5f,db2,6201 connect (Connection refused)
[2014-06-25T20:08:51+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 60,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:09:23+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 61,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:09:55+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 62,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:10:27+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 63,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:10:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 64,db2,6201 connect (Connection refused)
[2014-06-25T20:10:59+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 65,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:11:31+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 66,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:12:03+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 67,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:12:35+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 69,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid
[2014-06-25T20:12:42+08:00] [ons] [NOTIFICATION:1] [74] [ons-connect] Connection 6a,db2,6201 connect (Connection refused)
[2014-06-25T20:13:07+08:00] [ons] [WARNING:1] [59] [ons-connect] Local connection 6c,0.0.0.1,6101 invalid form factor
Pid=23545; Home=/usr/oracle/app/11.2.0/grid



[root@db1 logs]# crs_stat -t -v  
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.ARCDG.dg   ora....up.type 0/5    0/     ONLINE    ONLINE    db1   
ora.CRS.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    db1   
ora.DATADG.dg  ora....up.type 0/5    0/     ONLINE    ONLINE    db1   
ora.FRADG.dg   ora....up.type 0/5    0/     ONLINE    ONLINE    db1   
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    db1   
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    db2   
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    db1   
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    db1   
ora....B1.lsnr application    0/5    0/0    ONLINE    ONLINE    db1   
ora....db1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
ora....db1.ons application    0/3    0/0    ONLINE    OFFLINE               
ora....db1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    db1   
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    db2   
ora....B2.lsnr application    0/5    0/0    ONLINE    ONLINE    db2   
ora....db2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
ora....db2.ons application    0/3    0/0    ONLINE    OFFLINE               
ora....db2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    db2   
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    db2   
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    db1   
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    OFFLINE               
ora.ons        ora.ons.type   0/3    0/     ONLINE    OFFLINE               
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    db2   
ora.xxxx.db    ora....se.type 0/2    0/1    ONLINE    ONLINE    db1   




[root@db1 logs]# crsctl start res ora.ons
CRS-2672: Attempting to start 'ora.ons' on 'db2'
CRS-2672: Attempting to start 'ora.ons' on 'db1'
CRS-5016: Process "/usr/oracle/app/11.2.0/grid/opmn/bin/onsctli" spawned by agent "/usr/oracle/app/11.2.0/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/usr/oracle/app/11.2.0/grid/log/db2/agent/crsd/oraagent_grid/oraagent_grid.log"
CRS-5016: Process "/usr/oracle/app/11.2.0/grid/opmn/bin/onsctli" spawned by agent "/usr/oracle/app/11.2.0/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/usr/oracle/app/11.2.0/grid/log/db1/agent/crsd/oraagent_grid/oraagent_grid.log"
CRS-2674: Start of 'ora.ons' on 'db1' failed
CRS-2674: Start of 'ora.ons' on 'db2' failed
CRS-4000: Command Start failed, or completed with errors.
2#
发表于 2014-6-25 20:43:58
[root@db1 logs]# onsctl start
CRS-2672: Attempting to start 'ora.ons' on 'db1'
CRS-5016: Process "/usr/oracle/app/11.2.0/grid/opmn/bin/onsctli" spawned by agent

"/usr/oracle/app/11.2.0/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in

"/usr/oracle/app/11.2.0/grid/log/db1/agent/crsd/oraagent_grid/oraagent_grid.log"
CRS-2674: Start of 'ora.ons' on 'db1' failed
CRS-4000: Command Start failed, or completed with errors.

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-21 01:39 , Processed in 0.048079 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569