Using the statcfg Utility

The statcfg utility enables the administrator to configure an Oracle Database sheet to report statistics for a specific Oracle Database instance. Until you run the statcfg utility, the oracle-database-stats SMF service is disabled, and you will not see an Oracle Database sheet.

The statcfg utility must be run as the root user or by assuming the root role.

Before you use the statcfg utility, export ORACLE_HOME as shown in the following example:

# export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

The following syntax shows how to use the statcfg utility with an Oracle Database instance:

# /usr/bin/statcfg [add] oracle-rdbms -u user -g group -s sid -c connectstring
# /usr/bin/statcfg remove oracle-rdbms -u user -g group -s sid

The add subcommand adds an Oracle Database sheet for the sid database instance as described in Adding an Oracle Database Sheet. The remove subcommand removes the Oracle Database sheet for the sid database instance as described in Removing an Oracle Database Sheet.

user, group

The Oracle Solaris user and group that this oracle-database-stats service instance will run as. See Additional User Configuration for Oracle Database Instances for additional configuration required for the user specified by user.

sid

The name of the Oracle Database instance that this oracle-database-stats:sid service instance will monitor.

connectstring

The alias for access credentials for the sid database instance. See “Oracle Wallet” in Additional User Configuration for Oracle Database Instances for more information.

Use the following command to show a help message about using the oracle-rdbms service value:

# /usr/bin/statcfg oracle-rdbms -h