Troubleshooting Configuring an Oracle Database Sheet

Make sure the database instance is up and running.

Make sure the user has sufficient privilege to run the statcfg command. Run the statcfg command as the root user or assume the root role.

Make sure ORACLE_HOME is set in the environment where you run statcfg.

Check the state of the oracle-database-stats:sid service.

$ svcs oracle-database-stats:sid

If any of the Oracle RDBMS connections fail to communicate with their respective databases, the service will enter the degraded state.

If the service is in maintenance or is otherwise not online, check the service log as shown in the following example:

$ svcs -xL oracle-database-stats:sid

To check the settings of the service instance, use the svcprop command to show the values of the following properties:

• user

• group

• db/sid

• db/db_connect_string

For more information about service commands, see Managing System Services in Oracle Solaris 11.4.