Once you have finished Installing the Management Pack (Oracle Database) and Configuring the Management Pack (Oracle Database), check the Collection State and Collection Status for the adapter instance on the Solutions page. If they show as Not Collecting or No Data Receiving, respectively, the following troubleshooting topics can help you diagnose and correct common problems with your adapter instance.

  • Test Connection Errors
  • Adapter and Collector Log Files

Test Connection Errors

When Creating an Adapter Instance (Oracle Database), click Test Connection after entering all of your configuration settings to ensure vROps can connect to the specified host.

The following errors are possible:

User Authentication Error

Error Message: Unable to establish a valid connection to target system. User Authentication error.

Description: Ensure the correct Oracle Database User Name and Password were entered when Creating a Credential (Oracle Database).

Host, port, or SSL settings are incorrect

Error Message: Host, port, or SSL settings are incorrect.

Description: Ensure the correct hostname, port number, and SSL settings for the Oracle Database instance were entered when adding your adapter instance. Ensure you are using the default port that corresponds to the applicable SSL settings (non-SSL = 1521; SSL = 2484).

SID/Service Name is invalid

Error Message: The given SID/Service Name is invalid.

Description: Check your Oracle Database database system and ensure your SID/Service name is the same as the one entered for your adapter instance.

Invalid character(s) found in SID/Service Name

Error Message: Invalid character(s) found in SID/Service Name.

Description: Make sure your SID/Service Name contains only alpha-numberic characters.

SSL RC4 Cipher Suites compromised

Error Message: SSL RC4 Cipher Suites are considered compromised (and disabled) with Java 1.8.0_60+.

Description: Configure the Oracle Database to not use SSL RC4 Cipher Suites. To configure valid SSL Cipher Suites for an Oracle database either use the netca utility installed with Oracle Database, or edit the sqlnet.ora file.

Adapter and Collector Log Files

You can review adapter errors in the adapter and collector log files, which can be viewed in the vROps UI or in an external log viewer.

  • Adapter log files are located in the $VCOPS_BASE/user/log/adapters/OracleDatabaseAdapter/ folder.
  • Collector log files are located in the $VCOPS_BASE/user/log/ folder.

To set the base log level for the collector in vROps:

  1. Navigate to Administration > Logs
  2. Expand the MASTER folder, then select the COLLECTOR folder.
  3. Click the Edit Properties configure_iconicon.
  4. In the Root logger level drop-down menu, select the desired option:

    • The default logging level is warning.
    • To troubleshoot issues, set the logging level to info. 
    • To view detailed messages, including micro steps, queries, and returned results, set the logging level to debug. 

      Note: If you set the logging level to  debug , log files can become large very quickly. Set the logging level to  debug only for short periods of time.

For more information about viewing log files and modifying levels, refer to the vROps online help.