Início > Linux, Oracle, RedHat > Oracle RAC 11.2.0.3 – Red Hat 6.2: DiskGroup resource are not running on nodes. Database instance may not come up on these nodes

Oracle RAC 11.2.0.3 – Red Hat 6.2: DiskGroup resource are not running on nodes. Database instance may not come up on these nodes

DiskGroup resource are not running on nodes. Database instance may not come up on these nodes.
erro dg2
Let´s check the resources on both nodes:

[grid@rac2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.DATA2.dg
ONLINE  ONLINE       rac1
OFFLINE OFFLINE      rac2
ora.FRA1.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.LISTENER.lsnr
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.OCR.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.VOT.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.asm
ONLINE  ONLINE       rac1                 Started
ONLINE  ONLINE       rac2                 Started
ora.gsd
OFFLINE OFFLINE      rac1
OFFLINE OFFLINE      rac2
ora.net1.network
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.ons
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1        ONLINE  ONLINE       rac2
ora.LISTENER_SCAN2.lsnr
1        ONLINE  ONLINE       rac1
ora.LISTENER_SCAN3.lsnr
1        ONLINE  ONLINE       rac1
ora.cvu
1        ONLINE  ONLINE       rac1
ora.rac1.vip
1        ONLINE  ONLINE       rac1
ora.rac2.vip
1        ONLINE  ONLINE       rac2
ora.oc4j
1        ONLINE  ONLINE       rac1
ora.scan1.vip
1        ONLINE  ONLINE       rac2
ora.scan2.vip
1        ONLINE  ONLINE       rac1
ora.scan3.vip
1        ONLINE  ONLINE       rac1
ora.dbprod.db
1        ONLINE  ONLINE       rac1                 Open
2        ONLINE  ONLINE       rac2                 Open

As you can see DiskGroup ora.DATA2.dg in OFFLINE on node rac2.

ora.DATA2.dg
ONLINE  ONLINE       rac1
OFFLINE OFFLINE      rac2

Let´s start DiskGroup resource on second node and check again:

[grid@rac2 ~]$ crs_start ora.DATA2.dg
Attempting to start `ora.DATA2.dg` on member `rac2`
Start of `ora.DATA2.dg` on member `rac2` succeeded.

[grid@rac2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.DATA2.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.FRA1.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.LISTENER.lsnr
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.OCR.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.VOT.dg
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.asm
ONLINE  ONLINE       rac1                 Started
ONLINE  ONLINE       rac2                 Started
ora.gsd
OFFLINE OFFLINE      rac1
OFFLINE OFFLINE      rac2
ora.net1.network
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
ora.ons
ONLINE  ONLINE       rac1
ONLINE  ONLINE       rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1        ONLINE  ONLINE       rac2
ora.LISTENER_SCAN2.lsnr
1        ONLINE  ONLINE       rac1
ora.LISTENER_SCAN3.lsnr
1        ONLINE  ONLINE       rac1
ora.cvu
1        ONLINE  ONLINE       rac1
ora.rac1.vip
1        ONLINE  ONLINE       rac1
ora.rac2.vip
1        ONLINE  ONLINE       rac2
ora.oc4j
1        ONLINE  ONLINE       rac1
ora.scan1.vip
1        ONLINE  ONLINE       rac2
ora.scan2.vip
1        ONLINE  ONLINE       rac1
ora.scan3.vip
1        ONLINE  ONLINE       rac1
ora.dbprod.db
1        ONLINE  ONLINE       rac1                 Open
2        ONLINE  ONLINE       rac2                 Open
[grid@rac2 ~]$
Categorias:Linux, Oracle, RedHat
  1. Nenhum comentário ainda.
  1. No trackbacks yet.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s

%d blogueiros gostam disto: