10G Data Guard (10)
10G Data Guard (09)
10G Data Guard (11)

Saturday 23 August, 2008 - 21:05

I am having problems with using the Data Guard wizard under Grid Control:

  1. The cluster on botany was not recognised by srvctl.  Fixed - see below.
  2. The monitoring user for a physical standby database must have SYSDBA (the user is hardcoded as DBSNMP in Grid Control)
  3. The password for SYS is not recognised when I use the wizard to access the database cluster on botany .  Works for local access.

To fix the srvctl problem, 

srvctl add database           \
    -d BOTANY                 \
    -o $ORACLE_HOME           \
    -r PHYSICAL_STANDBY       \
    -n example                \
    -m yaocm.id.au            \
    -p +DATA/botany/spfileexample.ora
  • -d corresponds to the DB_UNIQUE_NAME
  • -n corresponds to the database name

Once this was done, Grid Control recognised the cluster database once agent discovery was complete (executed on both nodes): 

$ORA_AGENT_HOME/bin/agentca -d -c botany1,botany2