Feeds:
Posts
Comments

Posts Tagged ‘jdbc’

The below error can happen when you run any kind of a process that uses JDBC:

ORA-28267: Invalid Namespace Value In SOA Suite 11.1.1.7
ORA-02063

This is a bug!
The cause of the problem is when using Oracle JDBC Driver file (ojdbc6dms.jar) and calling a DB object (procedure, function etc…) that issues SQL over a DB link from 11g to 10g DB.

There is no patch for that at the moment.
I found a workaround, that was approved by oracle:

Under the below folders, replace the ojdbc6dms.jar file with ojdbc6.jar file:
$MID_HOME/wlserver_10.3/server/ext/jdbc/oracle/11g
$MID_HOME/oracle_common/modules/oracle.jdbc_11.1.1

You can find the ojdbc6.jar driver in the below link:
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

It is also suppose to be under $MID_HOME/wlserver_10.3/server/lib. You can just copy it from there.

There is one exception: No JDBC metrics will be produced. If you need it, you will have to open SR.

Good Luck!

Read Full Post »