Oracle 11g部分 RAC资源不随机自启动解决办法

Oracle 11g RAC

部分资源不随机自启动解决办法

 

 

一、      现象描述

开启2节点RAC服务器时，某些资源不随系统开机自启动

 

# crs_stat -t

Name           Type           Target    State     Host       

------------------------------------------------------------

ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac2       

ora.FRA.dg     ora....up.type ONLINE    ONLINE    rac2       

ora....ER.lsnr ora....er.type OFFLINE   OFFLINE              

ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2       

ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac1       

ora.asm        ora.asm.type   ONLINE    ONLINE    rac1       

ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac2       

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              

ora....network ora....rk.type ONLINE    ONLINE    rac1       

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac2       

ora.ons        ora.ons.type   ONLINE    ONLINE    rac1       

ora.prod.db    ora....se.type OFFLINE   OFFLINE              

ora....SM1.asm application    ONLINE    ONLINE    rac1       

ora....C1.lsnr application    OFFLINE   OFFLINE              

ora.rac1.gsd   application    OFFLINE   OFFLINE              

ora.rac1.ons   application    ONLINE    ONLINE    rac1       

ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac2       

ora....SM2.asm application    ONLINE    ONLINE    rac2       

ora....C2.lsnr application    OFFLINE   OFFLINE              

ora.rac2.gsd   application    OFFLINE   OFFLINE              

ora.rac2.ons   application    ONLINE    ONLINE    rac2       

ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2       

ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac2       

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac2

 

二、      解决办法

2.1 查看资源名

# crs_stat -v

NAME=ora.DATA.dg

TYPE=ora.diskgroup.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.FRA.dg

TYPE=ora.diskgroup.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.LISTENER.lsnr

TYPE=ora.listener.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.LISTENER_SCAN1.lsnr

TYPE=ora.scan_listener.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.OCR_VOTE.dg

TYPE=ora.diskgroup.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.asm

TYPE=ora.asm.type

GEN_USR_ORA_INST_NAME@SERVERNAME(rac1)=+ASM1

GEN_USR_ORA_INST_NAME@SERVERNAME(rac2)=+ASM2

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.cvu

TYPE=ora.cvu.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.gsd

TYPE=ora.gsd.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=OFFLINE

STATE=OFFLINE

 

NAME=ora.net1.network

TYPE=ora.network.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.oc4j

TYPE=ora.oc4j.type

RESTART_ATTEMPTS=1

RESTART_COUNT=0

FAILURE_THRESHOLD=2

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.ons

TYPE=ora.ons.type

RESTART_ATTEMPTS=3

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.prod.db

TYPE=ora.database.type

GEN_START_OPTIONS@SERVERNAME(rac1)=open

GEN_START_OPTIONS@SERVERNAME(rac2)=open

GEN_USR_ORA_INST_NAME@SERVERNAME(rac1)=prod1

GEN_USR_ORA_INST_NAME@SERVERNAME(rac2)=prod2

RESTART_ATTEMPTS=2

RESTART_COUNT=0

USR_ORA_INST_NAME@SERVERNAME(rac1)=prod1

USR_ORA_INST_NAME@SERVERNAME(rac2)=prod2

FAILURE_THRESHOLD=1

FAILURE_COUNT=0

TARGET=OFFLINE

STATE=OFFLINE

 

NAME=ora.rac1.ASM1.asm

TYPE=application

GEN_USR_ORA_INST_NAME@SERVERNAME(rac1)=+ASM1

GEN_USR_ORA_INST_NAME@SERVERNAME(rac2)=+ASM2

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.rac1.LISTENER_RAC1.lsnr

TYPE=application

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=OFFLINE

STATE=OFFLINE on rac1

 

NAME=ora.rac1.gsd

TYPE=application

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=OFFLINE

STATE=OFFLINE

 

NAME=ora.rac1.ons

TYPE=application

RESTART_ATTEMPTS=3

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.rac1.vip

TYPE=ora.cluster_vip_net1.type

RESTART_ATTEMPTS=0

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.rac2.vip

TYPE=ora.cluster_vip_net1.type

RESTART_ATTEMPTS=0

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.registry.acfs

TYPE=ora.registry.acfs.type

RESTART_ATTEMPTS=5

RESTART_COUNT=0

FAILURE_THRESHOLD=

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

NAME=ora.scan1.vip

TYPE=ora.scan_vip.type

RESTART_ATTEMPTS=0

RESTART_COUNT=0

FAILURE_THRESHOLD=0

FAILURE_COUNT=0

TARGET=ONLINE

STATE=ONLINE on rac1

 

2.2 修改资源属性

u  # crsctl modify resource ora.rac1.LISTENER_RAC1.lsnr -attr "AUTO_START=always"

CRS-2720: 'ora.rac1.LISTENER_RAC1.lsnr' is a resource alias for 'ora.LISTENER.lsnr' and cannot be updated

CRS-4000: Command Modify failed, or completed with errors.

//修改不成功，按照提示修改ora.LISTENER.lsnr

 

u  # crsctl modify resource "ora.LISTENER.lsnr" -attr "AUTO_START=always"

 

u  重启crs

#crsctl stop crs

#crsctl start crs

 

u  检查crs

# crs_stat -t

Name           Type           Target    State     Host       

------------------------------------------------------------

ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1       

ora.FRA.dg     ora....up.type ONLINE    ONLINE    rac1       

ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1       

ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1       

ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac1       

ora.asm        ora.asm.type   ONLINE    ONLINE    rac1       

ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1       

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              

ora....network ora....rk.type ONLINE    ONLINE    rac1       

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1       

ora.ons        ora.ons.type   ONLINE    ONLINE    rac1       

ora.prod.db    ora....se.type OFFLINE   OFFLINE              

ora....SM1.asm application    ONLINE    ONLINE    rac1       

ora....C1.lsnr application    ONLINE    ONLINE    rac1       

ora.rac1.gsd   application    OFFLINE   OFFLINE              

ora.rac1.ons   application    ONLINE    ONLINE    rac1       

ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1       

ora....SM2.asm application    ONLINE    ONLINE    rac2       

ora....C2.lsnr application    ONLINE    ONLINE    rac2       

ora.rac2.gsd   application    OFFLINE   OFFLINE              

ora.rac2.ons   application    ONLINE    ONLINE    rac2       

ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2       

ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1       

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1     

监听资源正常

 

u  同样方法修改db资源

#crsctl modify resource "ora.prod.db" -attr "AUTO_START=always"

#crsctl stop crs

#crsctl start crs

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26217983/viewspace-1461408/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26217983/viewspace-1461408/