statcfg - sstore statistics client configuration
/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
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
The following subcommands are supported:
This command displays the general usage of the command
To display usage for a specific service, use statcfg service help
This subcommand adds and configures the service
This subcommand removes the service
The following command shows how to view usage information for a service that is supported by statcfg:
# /usr/bin/statcfg service -hExample 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
The Oracle Solaris user and group that this oracle-database-stats service instance will run as.
The name of the Oracle Database instance that this oracle-database-stats:orcldnfs service instance will monitor.
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:
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.
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 ServiceThe 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
The Oracle Solaris user and group that this oracle-database-stats service instance is running as.
The name of the Oracle Database instance that this oracle-database-stats:orcldnfs service instance is monitoring.
See attributes(7) for descriptions of the following attributes:
|
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