After Applying JDBC Driver Patch (6779501) , Problem still occurs (ORA-28040) (Doc ID 1267169.1)

To Bottom

Modified:27-May-2011Type:PROBLEM

In this Document
  Symptoms
  Cause
  Solution

APPLIES TO:

Oracle Containers for J2EE - Version: 10.1.2.0.0 to 10.1.3.5.0 - Release: AS10gR2 to AS10gR3
Information in this document applies to any platform.

SYMPTOMS

A patch (Patch 6779501) has been applied to the 10.2.0.4 Oracle JDBC driver so that  an application deployed into 10.1.2 OC4J container can connect to the Oracle Database Server (configured with SQLNET.ALLOWED_LOGON_VERSION=10 in the sqlnet.ora configuration
file).
Though the patch is applied, the problem still occurs : the application cannot connect to the Oracle Database Server from OC4J container and fails ORA-28040 Error. . 

CAUSE

The startup java options in the oc4j instance jvm was set to classes12.jar :

-Xbootclasspath/a:/usr01/dba/product/ias/10.1.2/jdbc/jdbc10204/classes12.jar

The correct jar file  for Oracle JDBC driver to use  is ojdbc14.jar in Oracle Application Server context. And, patch (Patch 6779501)  has been applied to this library.

SOLUTION

The solution consists of using the in the patched ojdbc14.jar  instead of the classes12.jar library. 

Change the startup java options in the oc4j instance jvm by using

-Xbootclasspath/a:/usr01/dba/product/ias/10.1.2/jdbc/jdbc10204/ojdbc14.jar

instead of : 

-Xbootclasspath/a:/usr01/dba/product/ias/10.1.2/jdbc/jdbc10204/classes12.jar

• p6779501_10204_Generic.zip(214.31
  KB)