InfoScale™ 9.0 Cluster Server Agent for Oracle Installation and Configuration Guide - Solaris

Info entry point for Cluster Server agent for Oracle

The Cluster Server 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:

    # hares -value resource ResourceInfo [system]\
     [-clus cluster | -localclus]

For the above command to be executed successfully, you must perform 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.