10G Data Guard (10)

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