Register the ASM or Database resource to CRS
Symptoms
The resource ora.DATA.dg does not exist
~]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE oracle11gasm01 ora.ons OFFLINE OFFLINE oracle11gasm01 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd 1 OFFLINE OFFLINE ora.diskmon 1 OFFLINE OFFLINE ora.evmd 1 ONLINE ONLINE oracle11gasm01
|
Adding ASM resource
Command: srvctl add asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]
Login as grid.
~]$ srvctl add asm -l LISTENER -p +OCR/asm/asmparameterfile/registry.253.1232644765 ~]$ srvctl config asm ASM home: /u01/app/11.2.0/grid ASM listener: LISTENER Spfile: +OCR/asm/asmparameterfile/registry.253.1232644765 ASM diskgroup discovery string:
~]$ srvctl start asm ~]$ crsctl stat res -t | grep ora.asm -A1 ora.asm ONLINE ONLINE oracle11gasm01 Started
|
Adding DiskGroup resource
Login as grid.
~]$ cat > /tmp/ocr.profile << EOF NAME=ora.OCR.dg TYPE=ora.diskgroup.type ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r-- START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm) STOP_DEPENDENCIES=hard(intermediate:ora.asm) VERSION=11.2.0.4.0 EOF
~]$ cat > /tmp/data.profile << EOF NAME=ora.DATA.dg TYPE=ora.diskgroup.type ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r-- START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm) STOP_DEPENDENCIES=hard(intermediate:ora.asm) VERSION=11.2.0.4.0 EOF
~]$ crsctl add resource ora.OCR.dg -type ora.diskgroup.type -file /tmp/ocr.profile ~]$ crsctl add resource ora.DATA.dg -type ora.diskgroup.type -file /tmp/data.profile ~]$ srvctl start diskgroup -g OCR ~]$ srvctl start diskgroup -g DATA
~]$ crsctl stat res -t | grep ora.*.dg -A1 ora.DATA.dg ONLINE ONLINE oracle11gasm01 -- ora.OCR.dg ONLINE ONLINE oracle11gasm01
|
Adding Database resource
Command: srvctl add database [ -d db_name] [ -o db_home ] [ -p spfile ] [ -r role ] [ -a asm_diskgroup ]
Login as oracle.
~]$ srvctl add database -d orcl -o /u01/app/oracle/product/11.2.0/db_1 -p +DATA/orcl/spfileorcl.ora -r primary -a DATA ~]$ srvctl config database -d orcl ~]$ srvctl start database -d orcl
|