Instances cluster orphelines
Bonjour à tous,
J'ai un cluster RAC Oracle 10g avec plusieurs instances, voici le résultat du crsstat.vbs :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| ora.ORPHEE.ORPHEE1.inst 0/5 ONLINE ONLINE on w2k8orav10a
ora.ORPHEE.ORPHEE2.inst 0/5 ONLINE ONLINE on w2k8orav10b
ora.ORPHEE.db 0/0 ONLINE ONLINE on w2k8orav10b
ora.ORPHEET.ORPHEET1.inst 0/5 ONLINE ONLINE on w2k8orav10a
ora.ORPHEET.ORPHEET2.inst 0/5 ONLINE ONLINE on w2k8orav10b
ora.ORPHEET.db 0/0 ONLINE ONLINE on w2k8orav10b
ora.PROGMIG.PROGMIG1.inst 0/5 ONLINE ONLINE on w2k8orav10a
ora.PROGMIG.PROGMIG2.inst 0/5 ONLINE ONLINE on w2k8orav10b
ora.PROGMIG.db 0/0 ONLINE ONLINE on w2k8orav10a
ora.PROGOS.PROGOS1.inst 0/5 ONLINE ONLINE on w2k8orav10a
ora.PROGOS.PROGOS2.inst 0/5 ONLINE ONLINE on w2k8orav10b
ora.PROGOS.db 0/0 ONLINE ONLINE on w2k8orav10a
ora.orpheet.orphee2.inst 0/5 ONLINE OFFLINE
ora.orpheet.orpheet2.inst 0/5 ONLINE OFFLINE
ora.w2k8orav10a.ASM1.asm 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GABO.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GABOT.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GAFOR.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GAPRO.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GAREC.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_W2K8ORAV10A.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.gsd 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.ons 0/3 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.vip 0/0 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10b.ASM2.asm 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GABO.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GABOT.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GAFOR.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GAPRO.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GAREC.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_W2K8ORAV10B.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.gsd 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.ons 0/3 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.vip 0/0 ONLINE ONLINE on w2k8orav10b |
On peut voir qu'il y a 2 instances en target ONLINE state OFFLINE.
Ces instances n'existent plus sur le rac mais je ne parviens pas à supprimer ces deux lignes dans le cluster.
Y-a-t-il une commande particulière pour mettre à jour l'état du cluster ?
Merci.
Instances cluster orphelines
C'est bon j'ai trouvé la commande qui va bien :ccool:
Code:
1 2 3
|
crs_unregister.exe ora.orpheet.orpheet2.inst
crs_unregister.exe ora.orpheet.orphee2.inst |
Résultat dans le RAC :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
ora.ORPHEE.ORPHEE1.inst 0/5 ONLINE ONLINE on w2k8orav10a
ora.ORPHEE.ORPHEE2.inst 0/5 ONLINE ONLINE on w2k8orav10b
ora.ORPHEE.db 0/0 ONLINE ONLINE on w2k8orav10b
ora.ORPHEET.ORPHEET1.inst 0/5 ONLINE ONLINE on w2k8orav10a
ora.ORPHEET.ORPHEET2.inst 0/5 ONLINE ONLINE on w2k8orav10b
ora.ORPHEET.db 0/0 ONLINE ONLINE on w2k8orav10b
ora.PROGMIG.PROGMIG1.inst 0/5 ONLINE ONLINE on w2k8orav10a
ora.PROGMIG.PROGMIG2.inst 0/5 ONLINE ONLINE on w2k8orav10b
ora.PROGMIG.db 0/0 ONLINE ONLINE on w2k8orav10a
ora.PROGOS.PROGOS1.inst 0/5 ONLINE ONLINE on w2k8orav10a
ora.PROGOS.PROGOS2.inst 0/5 ONLINE ONLINE on w2k8orav10b
ora.PROGOS.db 0/0 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.ASM1.asm 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GABO.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GABOT.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GAFOR.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GAPRO.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_GAREC.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.LISTENER_W2K8ORAV10A.lsnr 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.gsd 0/5 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.ons 0/3 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10a.vip 0/0 ONLINE ONLINE on w2k8orav10a
ora.w2k8orav10b.ASM2.asm 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GABO.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GABOT.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GAFOR.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GAPRO.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_GAREC.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.LISTENER_W2K8ORAV10B.lsnr 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.gsd 0/5 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.ons 0/3 ONLINE ONLINE on w2k8orav10b
ora.w2k8orav10b.vip 0/0 ONLINE ONLINE on w2k8orav10b |