dgobserver.{ksh|ps1}

In an Oracle Dataguard environment with Fast-Start Failover activated, you should be able to automate the restart of an “Observer”. This exactly what the script performs.

First of all you need to prepare the environment.

• Add the ORACLE_SID into the ORATAB

• Create under ${DMK_ORA_ADMIN_SID} a “etc” directory

• Source DMK to load the new configuration

• Copy into “${DMK_ORA_ADMIN_SID}/etc” the dgobserver.cfg template

cat ${DMK_HOME}/templates/etc/dgobserver.cfg
# template dgcheck.cfg - defines variables for the observer monitoring script
#*************************************************************
# Connection string to the primary
ConnectStringPrim="sys/xxxx@<DB_UNIQUE_NAME>.<DB_DOMAIN>"
#*************************************************************
# Connection string to the Standby
ConnectStringStdb="sys/xxxx@<DB_UNIQUE_NAME>.<DB_DOMAIN>"
#*************************************************************
# Kill the Observer process once timeout has been reached (seconds)
ObserverStopHardlyTimeOut=30
#*************************************************************
# This parameter specify how long the script retries to reach
# the databases in order to start the observer (seconds)
ObserverRebootRetryTime=600

As highlighted by the above configuration the script tries to reach at least one database instance (regardless of the database role) in order to start/stop the observer and enter in a loop which retries to connect to the database for about 10minutes.

This is especially useful in case of a reboot; mostly the database servers needs more time to complete the boot sequence. Therefore the script loops for 10min before it gives-up.

Syntax

dgobserver.ksh [start|stop|status] [SID]

Do not forget to add the script into the “${DMK_HOME}/etc/service_start_stop.cfg” configuration file in order to start/ the observer in case of a reboot.