IBM Support

IBM Security Guardium Security Assessment of Oracle Datasource Fails

Troubleshooting


Problem

You are running a classifier or vulnerability assessment for an Oracle datasource and you get an error similar to the following: com.guardium.dbSource.DataSourceConnectException: Could not connect to: 'ORACLE '.

Cause

Caused by: com.ibm.guardium.jdbc.oraclebase.ddej: [guardium][Oracle JDBC Driver][Oracle]ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

This is a setting on the Oracle user.

Diagnosing The Problem

Review the jobqueue.log to get the detailed error.

Resolving The Problem

The Guardium assessments require the setting to be 4.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Guardium Database Vulnerability Assessment","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.0;10.0.1;10.1;10.1.2;10.1.3;10.1.4","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg22012504