본문 바로가기

ETL Tools/Oracle Data Integrator

[ODI 11g] ORA-28267 Inavlid Namespace Value

When using dblink, the error occured

ORA-28267 Inavlid Namespace Value.

It is in SR, something like Bug, I'm not sure but I solve this problem down ojdbc driver from ojdbc6dms.jar to ojdbc6.jar 

ojdbc6dms.jar  is using default oracle driver in Version 11.1.1.5.
and  ojdbc6.jar  is using default oracle driver in Version 11.1.1.3.

It works after change jar file to ojdbc6.jar.

you should change all of 4 different directory's files

that is :

11gODI/modules/oracle.jdbc_11.1.1/ojdbc6dms.jar
11gODI/odi_misc/ojdbc6dms.jar
11gODI/oracledi/agent/drivers/ojdbc6dms.jar
11gODI/oracledi/client/jdev/extensions/oracle.odi.navigator/lib/ojdbc6dms.jar 
 
Reference: 
https://forums.oracle.com/forums/post!reply.jspa?messageID=9808707