Error in WEbI only Version 6.5

We are on version 6.5.1. Several users, not all, are receiving the following error when they refresh or edit documents through WebI. Does not happen in full client.

What’ up??

Exception: CS, DBDriver failed to load : /u01/app/bo/bo65/dataAccess/RDBMS/connectionServer/libdbd_oci8.so (ld.so.1: /u01/app/bo/bo65/bin/ConnectionServer: fatal: libclntsh.so.8.0: open failed: No such file or directory)


susie (BOB member since 2005-05-02)

It looks like something is wrong with the connectivity on the server.
I have noticed a few similar Oracle errors with ppl that have migrated.
Check the Oracle_Home & setup including your BO connections on the server but it looks like something has corrupted the data access drivers.
When you mentioned Full Client, is that refreshing them in Infoview?
Did you do an Oracle upgrade recently?


MikeD :south_africa: (BOB member since 2002-06-18)

Yes the reports are full client and refreshing them in infoview. We migrated our repository to an Oracle 9i database which was an upgrade for us. Do you think I need the Oracle 8 drivers as well on the server? All our universe do not point to 9i databases so they use an oracle 8 client. So I assume the reports do as well. I thought the Oracle drivers were backword compatible but maybe not??

Thanks for your help!!

Susie


susie (BOB member since 2005-05-02)

Oracle is backward compatible, but upgrades around version 8 have always caused issues with the dll’s and BO.
You might have to replace the ociw32.dll in system32 with the oracle home version.


MikeD :south_africa: (BOB member since 2002-06-18)

We are on Unix. Am I going to have to go into every Universe and changes the Oracle Client from 8 to 9 and then re-export ?? Please say No :)!


susie (BOB member since 2005-05-02)

Lol - hopefully not!
Basically, you have an issue with the Oracle installation. The upgrade has probably also created a separate set of entries in the registry and has not removed/replaced the dll references everywhere.
If you simply locate and correct this, it should resolve the issue - it’s been a while since I was using Oracle … but I’m pretty sure this can be resolved on the s/w level as opposed to changing all your unv connections etc


MikeD :south_africa: (BOB member since 2002-06-18)