Bo's Oracle Station

查看: 4193|回复: 3

ASM磁盘组又坏了, 只是配置了网络。。。除了删除重建还有其他方法吗

[复制链接]

17

主题

32

帖子

140

积分

版主

Rank: 7Rank: 7Rank: 7

积分
140
发表于 2016-9-5 22:42:06 | 显示全部楼层 |阅读模式
[oracle@station55 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 5 22:42:08 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL> quit
[oracle@station55 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    OFFLINE               
ora.FRA.dg     ora....up.type ONLINE    OFFLINE               
ora....ER.lsnr ora....er.type ONLINE    ONLINE    station55   
ora.asm        ora.asm.type   ONLINE    OFFLINE               
ora.cssd       ora.cssd.type  ONLINE    ONLINE    station55   
ora.diskmon    ora....on.type ONLINE    ONLINE    station55   
ora.orcl.db    ora....se.type ONLINE    OFFLINE      

回复

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-9-6 11:02:38 | 显示全部楼层
crsctl start res ora.DATA.dg 试下,可能只是没启动
回复 支持 反对

使用道具 举报

17

主题

32

帖子

140

积分

版主

Rank: 7Rank: 7Rank: 7

积分
140
 楼主| 发表于 2016-9-6 18:58:46 | 显示全部楼层
[oracle@station55 admin]$ crsctl start res ora.DATA.dg
CRS-2672: Attempting to start 'ora.asm' on 'station55'
ORA-01031: insufficient privileges
CRS-5011: Check of resource "+ASM" failed: details at "(:CLSN00006" in "/u01/app/oracle/product/11.2.0/grid/log/station55/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
CRS-5011: Check of resource "+ASM" failed: details at "(:CLSN00006" in "/u01/app/oracle/product/11.2.0/grid/log/station55/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
CRS-2674: Start of 'ora.asm' on 'station55' failed
CRS-2679: Attempting to clean 'ora.asm' on 'station55'
CRS-5011: Check of resource "+ASM" failed: details at "(:CLSN00006" in "/u01/app/oracle/product/11.2.0/grid/log/station55/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
CRS-5011: Check of resource "+ASM" failed: details at "(:CLSN00006" in "/u01/app/oracle/product/11.2.0/grid/log/station55/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
CRS-2681: Clean of 'ora.asm' on 'station55' succeeded
CRS-4000: Command Start failed, or completed with errors.
回复 支持 反对

使用道具 举报

17

主题

32

帖子

140

积分

版主

Rank: 7Rank: 7Rank: 7

积分
140
 楼主| 发表于 2016-9-6 19:09:14 | 显示全部楼层
日志:
2016-09-06 19:08:56.476: [ora.LISTENER.lsnr][2936007568] [check] return val (clsagfwret) = 0
2016-09-06 19:08:56.476: [ora.LISTENER.lsnr][2936007568] [check] LsnrAgent::check }
2016-09-06 19:08:56.476: [    AGFW][2936007568] check for resource: ora.LISTENER.lsnr station55 1 completed with status: ONLINE
2016-09-06 19:09:54.435: [    AGFW][2969557904] Agent received the message: AGENT_HB[Engine] ID 12293:6662
2016-09-06 19:09:54.496: [    AGFW][2969557904] Agent received the message: RESOURCE_START[ora.asm station55 1] ID 4098:6671
2016-09-06 19:09:54.496: [    AGFW][2969557904] Preparing START command for: ora.asm station55 1
2016-09-06 19:09:54.496: [    AGFW][2969557904] ora.asm station55 1 state changed from: OFFLINE to: STARTING
2016-09-06 19:09:54.497: [    AGFW][2980047760] Executing command: start for resource: ora.asm station55 1
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] clsn_agent::start {
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] InstAgent::start {
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] AsmAgent: ORACLE_HOME = /u01/app/oracle/product/11.2.0/grid
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] Agent::valueOfAttribIs attrib: USR_ORA_OPI compare value: true attribute value: false
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] Agent::valueOfAttribIs returns 0
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] AsmAgent:getOracleSid 2 oracle_sid = +ASM
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] AsmAgent:getOracleSid oracle_sid = +ASM
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] getOracleHomeAttrib: oracle_home = /u01/app/oracle/product/11.2.0/grid
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] updating GEN_USR_ORA_INST_NAME to +ASM
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] sModifyConfig for +ASM
2016-09-06 19:09:54.497: [ora.asm][2980047760] [start] getOracleHomeAttrib: oracle_home = /u01/app/oracle/product/11.2.0/grid
2016-09-06 19:09:54.498: [ora.asm][2980047760] [start] sUpdateOratab oratab is /etc/oratab
2016-09-06 19:09:54.498: [ora.asm][2980047760] [start] ConfigFile::setAltName altName = +ASM
2016-09-06 19:09:54.498: [ora.asm][2980047760] [start] ConfigFile::setAltValue altValue = /u01/app/oracle/product/11.2.0/grid:N
2016-09-06 19:09:54.498: [ora.asm][2980047760] [start] ConfigFile::parseLine tmpEntry +ASM

回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-12-5 03:21 , Processed in 0.040146 second(s), 24 queries .

快速回复 返回顶部 返回列表