1. Using Oracle Solaris 11.4 StatsStore and System Web Interface
  2. Using Oracle Solaris System Web Interface
  3. Oracle Database Sheet
  4. Configuring an Oracle Database Sheet
  5. Additional User Configuration for Oracle Database Instances

Additional User Configuration for Oracle Database Instances

Perform the following configuration for the user specified by user:

Authorizations

Ensure that user has the following authorizations assigned:

  • solaris.sstore.update.res

  • solaris.sstore.write

The following example shows how to add these authorizations for user: 

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

Ensure that user has the SYSDBA connect privilege for the specified sid database instance.

ORACLE_HOME

The shell startup script for user must specify ORACLE_HOME, or specify ORACLE_HOME in the service as shown in the following example: 

# svccfg -s application/stats/oracle-database-stats:sid \
setenv ORACLE_HOME /u01/app/oracle/product/19.0.0.0/dbhome_1
Oracle Wallet

The sqlnet.ora parameter file must specify the Oracle Wallet location for user.

The tnsnames.ora file must specify the Oracle Wallet db_connect_string alias for the sid database instance.

By default, both sqlnet.ora and tnsnames.ora are located in the $ORACLE_HOME/network/admin directory.

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. For example, see Oracle Database Security Guide 20c .