#4547 [HHQ-4501] Upgrade our shipped ojdbc jar to 10.2.0.2 version

Bug
open
Hyperic Team
None
5
2012-10-09
2010-12-10
Hyperic Team
No

http://jira.hyperic.com/browse/HHQ-4501
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:



Symptoms


The OSUSER column is null in V$SESSION when using the thin JDBC driver 10.2.0.1.


Cause


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

Discussion


Anonymous


Cancel   Add attachments