The Veritas high availability agent for Oracle supports the Info entry point, which provides static and dynamic information about the state of the database.
To invoke the Info entry point, type the following command:
The entry point retrieves the following static information:
The entry point retrieves the following dynamic information:
You can add additional attributes by adding sql statements to the file /opt/VRTSagents/ha/bin/Oracle/resinfo.sql. For example:
select 'static:HostName:'||host_name from v$instance;
select 'dynamic:ShutdownPending:'||shutdown_pending from v$instance;
The format of the selected record must be as follows:
attribute_type
:userkey_name:userkey_value
The variable attribute_type can take the value static and/or dynamic.