11gR2CRSOracle

Oracle Restart configuration after Renaming the Database – 11gR2

Posted Anand

The Oracle Restart ensures that various Oracle components gets automatically restarted after hardware or software failures.In my last post as i had renamed the database, i had to update the OLR (Oracle Local Registry)for the database to come up automatically.

[[email protected] bin]$ ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       anand-lab
ora.DATA02.dg
               ONLINE  ONLINE       anand-lab
ora.LISTENER.lsnr
               ONLINE  ONLINE       anand-lab
ora.asm
               ONLINE  ONLINE       anand-lab                Started
ora.ons
               OFFLINE OFFLINE      anand-lab
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       anand-lab
ora.diskmon
      1        ONLINE  ONLINE       anand-lab
ora.evmd
      1        ONLINE  ONLINE       anand-lab
ora.orcl.db
      1        ONLINE  OFFLINE                               Instance Shutdown

Now to add the database to Oracle Restart configuration we use SRVCTL utility.

[[email protected] ~]$ srvctl add database -d MATRIX -o /u01/app/oracle/product/11.2.0/dbhome_1 -n MATRIX -p '+DATA/matrix/spfilematrix.ora' -s OPEN -t IMMEDIATE -r PRIMARY -y AUTOMATIC -a "+DATA,+DATA02"
PRCR-1070 : Failed to check if resource ora.+DATA.dg is registered
Invalid resource name
[[email protected] ~]$ srvctl add database -d MATRIX -o /u01/app/oracle/product/11.2.0/dbhome_1 -n MATRIX -p '+DATA/matrix/spfilematrix.ora' -s OPEN -t IMMEDIATE -r PRIMARY -y AUTOMATIC -a "DATA,DATA02"
[[email protected] ~]$

This added the entry in OLR which can be seen by dumping it using ocrdump -local command.OHASD log shows

2011-06-21 15:10:07.871: [UiServer][2980248464] {0:0:189} processMessage called
2011-06-21 15:10:07.871: [UiServer][2980248464] {0:0:189} Container [ Name: UI_REGISTER
        ATTR_LIST:
        TextMessage[AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%CHECK_INTERVAL=1CHECK_TIMEOUT=30CLUSTER_DATABASE=falseDATABASE_TYPE=SINGLEDB_UNIQUE_NAME=MATRIXDEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)DESCRIPTION=Oracle Database resourceFAILURE_INTERVAL=60FAILURE_THRESHOLD=1GEN_AUDIT_FILE_DEST=GEN_START_OPTIONS=GEN_USR_ORA_INST_NAME=INSTANCE_FAILOVER=1MANAGEMENT_POLICY=AUTOMATICONLINE_RELOCATION_TIMEOUT=0ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1RESTART_ATTEMPTS=2ROLE=PRIMARYSERVER_POOLS=SPFILE=+DATA/matrix/spfilematrix.oraSTART_TIMEOUT=600STOP_TIMEOUT=600TYPE=ora.database.typeTYPE_VERSION=2.2USR_ORA_DB_NAME=MATRIXUSR_ORA_DOMAIN=USR_ORA_FLAGS=USR_ORA_INST_NAME=MATRIXUSR_ORA_OPEN_MODE=openUSR_ORA_OPI=
2011-06-21 15:10:07.871: [UiServer][2980248464]falseUSR_ORA_STOP_MODE=immediateVERSION=11.2.0.2.0PLACEMENT=balancedACL=owner:oracle:rwx,pgrp:dba:r-x,other::r--,group:oinstall:r-x,user:oracle:rwxCARDINALITY=1START_DEPENDENCIES=hard(ora.DATA.dg,ora.DATA02.dg) weak(type:ora.listener.type,uniform:ora.ons) pullup(ora.DATA.dg,ora.DATA02.dg)STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.DATA02.dg)]
        CLIENT:
        TextMessage[]
        CLIENT_PRIMARY_GROUP:
        TextMessage[oinstall]
        LOCALE:
        TextMessage[AMERICAN_AMERICA.US7ASCII]
        QUEUE_TAG:
        TextMessage[1]
        RESOURCE:
        TextMessage[ora.matrix.db]
]
2011-06-21 15:10:07.871: [UiServer][2980248464] {0:0:189} Sending message to PE. ctx= 0xb7d0350
2011-06-21 15:10:07.872: [UiServer][2980248464] {0:0:189} Sending command to PE: 124
2011-06-21 15:10:07.872: [   CRSPE][2982349712] {0:0:189} Cmd : 0xb3507cd8 : flags: QUEUE_TAG
2011-06-21 15:10:07.872: [   CRSPE][2982349712] {0:0:189} Processing PE command id=226. Description: [Register|Update Resource :  : 0xb3507cd8]
2011-06-21 15:10:07.881: [   CRSPE][2982349712] {0:0:189} DM flushing its state to repository.ri_seed = 100, config version = 83
2011-06-21 15:10:07.883: [  CRSOCR][2990754704] {0:0:189} Multi Write Batch processing...
2011-06-21 15:10:08.001: [   CRSPE][2982349712] {0:0:189} Resource ora.matrix.db has been registered with the PE data model:0xb350e8b8
2011-06-21 15:10:08.001: [   CRSPE][2982349712] {0:0:189} PE Command [ Register|Update Resource : ora.matrix.db : 0xb3507cd8 ] has completed
2011-06-21 15:10:08.001: [   CRSPE][2982349712] {0:0:189} UI Command [Register|Update Resource : ora.matrix.db : 0xb3507cd8] is replying to sender.
2011-06-21 15:10:08.002: [  CRSOCR][2990754704] {0:0:189} Multi Write Batch done.
2011-06-21 15:10:08.003: [  CRSRPT][2980248464] {0:0:189} Published to EVM CRS_RESOURCE_PROFILE_CHANGE for ora.matrix.db
2011-06-21 15:10:08.003: [UiServer][2980248464] {0:0:189} Container [ Name: UI_DATA
        ora.matrix.db:
        TextMessage[0]
]
2011-06-21 15:10:08.006: [UiServer][2980248464] {0:0:189} Done for ctx=0xb7d0350

Checking the status

[[email protected] bin]$ ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       anand-lab
ora.DATA02.dg
               ONLINE  ONLINE       anand-lab
ora.LISTENER.lsnr
               ONLINE  ONLINE       anand-lab
ora.asm
               ONLINE  ONLINE       anand-lab                Started
ora.ons
               OFFLINE OFFLINE      anand-lab
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       anand-lab
ora.diskmon
      1        ONLINE  ONLINE       anand-lab
ora.evmd
      1        ONLINE  ONLINE       anand-lab
ora.matrix.db
      1        OFFLINE OFFLINE
ora.orcl.db
      1        ONLINE  OFFLINE                               Instance Shutdown

The TARGET and STATE for db shows OFFLINE. If the instance is up from before (using sqlplus), in that case using “srvctl start database -d ” to start the database,aborts the instance and restarts it again.OS, shutdown the database from sqlplus and then start using srvctl command.

[[email protected] ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 21 16:48:51 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[[email protected] ~]$ srvctl config database -d MATRIX
Database unique name: MATRIX
Database name: MATRIX
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/matrix/spfilematrix.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,DATA02
Services:
[[email protected] ~]$ srvctl start database -d MATRIX
[[email protected] ~]$

[[email protected] bin]$ ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       anand-lab
ora.DATA02.dg
               ONLINE  ONLINE       anand-lab
ora.LISTENER.lsnr
               ONLINE  ONLINE       anand-lab
ora.asm
               ONLINE  ONLINE       anand-lab                Started
ora.ons
               OFFLINE OFFLINE      anand-lab
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       anand-lab
ora.diskmon
      1        ONLINE  ONLINE       anand-lab
ora.evmd
      1        ONLINE  ONLINE       anand-lab
ora.matrix.db
      1        ONLINE  ONLINE       anand-lab                Open                
ora.orcl.db
      1        ONLINE  OFFLINE                               Instance Shutdown

Remove the ORCL info using “srvctl remove database -d ORCL”.

One thought on “Oracle Restart configuration after Renaming the Database – 11gR2”

  1. Hi,
    This was my exam question, still not sure about the answer.
    Any help is much appreciatedl
    You are creating a resource definition called webapp for a web-based application that runs application called webvip
    Both webapp and webvip are normally active on a single node, but may failover if required to another cluster node in your eight node cluster.
    A second VIP application resource called appsvip exists, used by a second application resource called secapp.
    Webvip and webapp must start in correct sequence.
    Which two start dependincies would you use for the WEbapp application resource definition
    a-)hard(SECAPP)
    b-)pullup (SECAPP)
    c-)pullup(WEBVIP)
    d-)hard (WEBVIP)
    e-)dispersion (WEBVIP)
    f-)weak (WEBVIP)

    Reply

Leave a Reply