Oracle ODBC collection missing or invalid option

Issue

Invalid option when try to connect to the Oracle database.

18:48:32 Mytest nw[13718]: [OdbcCollection] [failure] [odbc:WrkUnit[1]:13746] [doWork:155] [oracle_11g_auditing.TEST01] [processing] [TEST01] [processing] An error occurred creating an ODBC connection.#011 The DSN for this connection is: TEST01 The trapped error is: Unable to create an ODBC connection. DSN: TEST01; username: SATest; reason: state: S1000; error-code: 140088948294554; description: [RSA][ODBC Oracle Wire Protocol driver][Oracle]ORA-00922: missing or invalid option 
May 21 18:48:32 Mytest nw[13718]: [OdbcCollection] [failure] [odbc:WrkUnit[1]:13746] [WorkUnitThreadExecutionFunction:2456] [oracle_11g_auditing.TEST01] [processing] [TEST01] [processing failure] odbc:WrkUnit[1] Processing failed. 

Cause

What causes the issue is the following entry on the DSN (on the SA GUI -> event source -> ODBC -> DSN) or odbc.ini

Example:
 "EditionName=oracle 11g"

Resolution

Make sure the following entry on DSN (on the SA GUI -> event source -> ODBC -> DSN) or /etc/netwitness/ng/odbc.ini is empty and should not have any value there EditionName.

Example:
    "EditionName="

Product Details

RSA Product Set: Security Analytics
RSA Product/Service Type: Log Collector, VLC or PLC
RSA Version/Condition: 10.4.0.2
Platform: CentOS
Platform (Other): ODBC, Oracle 11g
O/S Version: EL6

Summary

Oracle 11g connection with log collector EDITION = oracle 11g [Oracle]ORA-00922: missing or invalid option

Approval Reviewer Queue

ASOC Approval Group