We need to upgrade ojdbc14-10.2.0.2.0.jar (in agent/bundles/pdk/lib/jdbc/) from ojdbc14-10.2.0.1.0.jar.
Customer's sqlquery plugins were running fine in 4.1.2. After upgrading to 4.5.0 they are ran into Bug 3735857 as described below:
The OSUSER column is null in V$SESSION when using the thin JDBC driver 10.2.0.1.
Bug 3735857 - OSUSER FIELD DOES NOT POPULATE IN V$SESSION USING JDBC 10G
Below is the error they were seeing in their environment:
2010-12-06 10:20:12,479 ERROR [ScheduleThread] [ScheduleThread] Metric Value not found: Query failed for Blocking Sessions, while attempting to issue query select COUNT( b.sid) from v$lock a, v$lock b where a.block = 1 and b.request > 0 and a.id1 = b.id1 and a.id2 = b.id2:ORA-00604: error occurred at recursive SQL level 1
ORA-01400: cannot insert NULL into ("USERDBA"."LOGON_REJECTED"."OS_USER")
ORA-06512: at "USERDBA.INSERT_FAILED_LOGON", line 13
ORA-06512: at "USERDBA.USER_LOGON_CHECK", line 53
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 3