[VCS] Setting up detail monitoring for Oracle
Detail monitoring for an Oracle resource verifies whether a database is ready for transactions by performing an update transaction against a table within the database. The update action is taken by the two scripts, SqlTest.pl and
SimpleTest.pl, provided with the Veritas High Availability Agent for Oracle. The scripts are available under the directory /opt/VRTSagents/ha/bin/Oracle/. Both scripts update the timestamp to monitor the database.
To set up detail monitoring for Oracle
1 Make the VCS configuration writable:
haconf -makerw
2 Freeze the service group to avoid automated actions by VCS caused by an incomplete reconfiguration:
hagrp -freeze service_group
3 Log on as an Oracle user.
su -
4 Set the environment variables for ORACLE_HOME and ORACLE_SID.
export ORACLE_HOME=
export ORACLE_SID=
5 Start the svrmgrl or sqlplus utility to set up a database table:
$ORACLE_HOME/bin/svrmgrl
or
$ORACLE_HOME/bin/sqlplus /nolog
6 As the database administrator, issue the following statements at the svrmgrl or sqlplus prompt to create the test table:
connect / as sysdba
create user
identified by
default tablespace USERS
temporary tablespace TEMP
quota 100K on USERS;
grant create session to;
create table. ( tstamp date );
SimpleTest.pl, provided with the Veritas High Availability Agent for Oracle. The scripts are available under the directory /opt/VRTSagents/ha/bin/Oracle/. Both scripts update the timestamp to monitor the database.
To set up detail monitoring for Oracle
1 Make the VCS configuration writable:
haconf -makerw
2 Freeze the service group to avoid automated actions by VCS caused by an incomplete reconfiguration:
hagrp -freeze service_group
3 Log on as an Oracle user.
su -
4 Set the environment variables for ORACLE_HOME and ORACLE_SID.
export ORACLE_HOME=
export ORACLE_SID=
5 Start the svrmgrl or sqlplus utility to set up a database table:
$ORACLE_HOME/bin/svrmgrl
or
$ORACLE_HOME/bin/sqlplus /nolog
6 As the database administrator, issue the following statements at the svrmgrl or sqlplus prompt to create the test table:
connect / as sysdba
create user
identified by
default tablespace USERS
temporary tablespace TEMP
quota 100K on USERS;
grant create session to
create table
