Go to main content

man pages section 1: User Commands

Exit Print View

Updated: Wednesday, February 10, 2021
 
 

statcfg(1)

Name

statcfg - sstore statistics client configuration

Synopsis

/usr/bin/statcfg help
/usr/bin/statcfg service -h
/usr/bin/statcfg [add | remove] service service-options
/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

Description

The statcfg utility adds, configures and removes services that publish statistics for reporting by the sstore(1) command and graphically in the Oracle Solaris System Web Interface. The utility must be run with sufficient privilege to add the service, make service configuration changes and remove the service: Either run as root or as a user with the solaris.smf.modify authorization. See CONFIGURATION below.

The Oracle Solaris user for each service that is configured by using the statcfg utility must have the following authorizations in order to update statistics with sstored:

solaris.sstore.update.res
solaris.sstore.write

See CONFIGURATION below for the command to run to assign these authorizations to a user.

The oracle-rdbms service value adds, configures and removes an instance of the svc:/application/oracle-database-stats service. Instances of the oracle-database-stats service monitor corresponding instances of the Oracle RDBMS. An instance-specific Oracle Solaris System Web Interface sheet is created as part of configuring this service.

The following command assigns the appropriate sstored authorizations to Oracle Solaris users that will be specified as user in the service configuration. In this example, admin is the user:

# usermod -A +solaris.sstore.update.res,solaris.sstore.write admin

Sub Commands

The following subcommands are supported:

statcfg help

This command displays the general usage of the command

To display usage for a specific service, use statcfg service help

statcfg add service service-options
  • This subcommand adds and configures the service

  • statcfg remove service service-options
  • This subcommand removes the service

  • Examples

    Example 1 View Service Usage Information

    The following command shows how to view usage information for a service that is supported by statcfg:

    # /usr/bin/statcfg service -h
    Example 2 Add and configure an instance of Oracle Database StatStore Service

    The following command creates a new instance of the oracle-database-stats service with service instance name same as the specified database instance name (sid) and with the specified properties:

    # /usr/bin/statcfg add oracle-rdbms -u admin -g staff -s orcldnfs -c pdb
    admin
    staff

    The Oracle Solaris user and group that this oracle-database-stats service instance will run as.

    orcldnfs

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

    pdb

    The alias for access credentials for the orcldnfs database instance. See below for information about configuring the user's Oracle Wallet.

    Ensure the following configuration is complete for the specified user:

    ORACLE_HOME

    The shell startup script for user must specify ORACLE_HOME and also create ORACLE_HOME in the service as shown in the following example:

    # export ORACLE_HOME=/u0/app/oracle/product/12.2.0/dbhome_2
    # svccfg -s application/stats/oracle-database-stats:orcldnfs \
    	setenv ORACLE_HOME /u0/app/oracle/product/12.2.0/dbhome_2

    The script should be run with sufficient privilege to make service configuration changes: Either run as root or as a user with the solaris.smf.modify authorization.

    Oracle Wallet

    The $HOME/.sqlnet.ora file for user must specify:

    • The Oracle Wallet location for that user.

    • The Oracle Wallet db_connect_string alias for this database instance.

    Follow the instructions in "Managing the Secure External Password Store for Password Credentials" in the Database Security Guide to configure the user's Oracle Wallet. See the SEE ALSO section for database security guide links.

    See rdbms-stat(1) for more information about the svc:/application/oracle-database-stats service.

    Example 3 Remove an instance of Oracle Database StatStore Service

    The following command removes an instance of the oracle-database-stats service with the specified properties:

    # /usr/bin/statcfg remove oracle-rdbms -u admin -g staff -s orcldnfs
    admin
    staff

    The Oracle Solaris user and group that this oracle-database-stats service instance is running as.

    orcldnfs

    The name of the Oracle Database instance that this oracle-database-stats:orcldnfs service instance is monitoring.

    Attributes

    See attributes(7) for descriptions of the following attributes:

    ATTRIBUTE TYPE
    ATTRIBUTE VALUE
    Availability
    service/system/statcfg
    Interface Stability
    Uncommitted

    See Also

    rdbms-stat(1), sstore(1), svcs(1), analytics(7), smf(7), smf_security(7), webui(7), sstored(8), svcadm(8), svccfg(8), usermod(8)

    For information about Oracle Wallet, go to Oracle Database Documentation (https://docs.oracle.com/en/database/oracle/oracle-database/index.html), select your Oracle Database version, select Security under the Topics heading, and then select the Database Security Guide under the Access Management heading.

    Using Oracle Solaris 11.4 StatsStore and System Web Interface