Top
PRIMECLUSTER Wizard for Oracle 4.3 Configuration and Administration Guide

3.1.1 Standby Operation

This section discusses how PRIMECLUSTER Wizard for Oracle controls Oracle in standby operation.

Oracle instance Startup

Startup procedure of an Oracle instance is as follows:

  1. su - <Oracle DBA user>

  2. sqlplus / nolog

  3. connect / as sysdba

  4. startup nomount or startup mount

  5. alter database mount (if "startup nomount" was executed at step "4")

  6. alter database open

Oracle instance Shutdown

Oracle instance Monitoring

Monitoring procedure of an Oracle instance is as follows:

  1. Check the background process (PMON, SMON) periodically. If the process status can be confirmed, go to step "2".

  2. su - <Oracle DBA user>

  3. Local connection to the Oracle instance as the SYSTEM user

  4. Check if Oracle status is OPEN

  5. Check if the background processes (PMON, SMON, DBWn, LGWR, CKPT) are alive.

  6. Check if "INSERT", "UPDATE", "DELETE" and "COMMIT" can be properly executed using the monitoring table on the SYSTEM user's default table space.

  7. Oracle is reconnected once every 24 hours.

If Oracle is stopped, "1" is executed at a 30 second interval (static).

If Oracle gets activated, "2" and after are executed. If node startup is completed then the node is operating, only "5" and "6" are executed at a regular interval. The default value is 30 seconds, and can be changed. Note that "6" is executed at a 60-second interval at least.

Listener Startup

Startup procedure of a Listener is as follows:

  1. su - <Oracle user>

  2. lsnrctl start <ListenerName>

  3. Makes sure that a Listener process does exist.

Listener Shutdown

Shutdown procedure of a Listener is as follows:

  1. su - <Oracle user>

  2. lsnrctl stop <ListenerName>

  3. Makes sure that a Listener process does not exist.

  4. If Listener is not stopped at step "3", shut it down forcibly by sending SIGKILL to the background process.

Listener Monitoring

Monitoring procedure of a Listener is as follows:

  1. Makes sure that a Listener process does not exist.

  2. Makes sure that the net service name is valid with "tnsping" if TNSName is set.

If a Listener of a standby node is stopped, execute "1" at regular time intervals.

If the Listener gets activated and becomes an operating node, execute "1" and "2" at regular time intervals.

The default interval time is 30 seconds, and it can be changed with Interval. Note that "2" is executed at a 60-second interval at least.

ASM instance Startup

Startup procedure of an ASM instance is as follows

  1. su - <Oracle DBA user>

  2. sqlplus / nolog

  3. connect / as sysasm

  4. startup mount (if "STARTED" already, "alter diskgroup all mount" is executed.)

ASM instance Shutdown

ASM instance Monitoring

ASM is not monitored. NullDetector flag is automatically enabled.