ORA-28267: Invalid NameSpace Value after upgrade to 11.1.1.5
Hi Guys,
So after we upgraded to 11.1.1.5 to fix an issue which effected 6 out of our 350 source tables in interfaces, we've hit a problem now which is effecting all 350 interfaces.
We are using a dblink from our 11.2.0.2 DWH to a 10.2.0.2 source database. When ODI goes to load the target table (reading from a C$_ collection view with the db link in it) Im hitting ORA-28267: Invalid NameSpace.
A little digging suggests it might be down to the jdbc driver.
In my 11.1.1.3 install I see this :
/oracledi/agent/drivers/ojdbc6.jar
in my 11.1.1.5 install I see this :
oracledi/agent/drivers/ojdbc6dms.jar
I've tried the obvious of renaming the ojdbc6dms.jar to a backup and copying in the 11.1.1.3 driver ojdbc6.jar in in its place but I see no change (restarted agent)
Can anyone suggest anything ? Do I need to start messing with classpaths in odiparams.sh ?
I have logged an SR already, waiting to jump through the usual hoops before I start getting suggestions.
Thanks in advance,
Alastair