Access to Oracle Server from powerhouse 8.43g

[Adrian Hudson]

Just to let you know I finally got this to work. The way I did it was
to 'deversionize' the Oracle client libraries. This was done with
these commands, but would obviously be different depending on the
Oracle Client you had installed

ln -s libclntsh.so.10.1 libclntsh.so
ln -s libheteroxa10.so libheteroxa.so
ln -s libnnz10.so libnnz.so
ln -s libocci.so.10.1 libocci.so
ln -s libocijdbc10.so libocijdbc.so


On Fri, Apr 27, 2012 at 4:14 PM, Adrian Hudson
<adrianhudsonuk at googlemail.com> wrote:
> Hi All,
>
> Our migration is now well underway - thanks again to all who I have
> exchanged emails with!
>
> One problem we are having is connecting from the Linux box to an
> Oracle database on a Windows server. We can connect using SQLPLUS via
> a 32-bit client, but QSHOW responds with:-
>
> DMS-E-YV_LOADSGIFAILED, Unable to load the 'ordba' gateway. Please ensure that
> the database software is configured correctly and is supported on this version
> of the operating system.
>
> I believe the LD_LIBRARY_PATH is set correctly and the PDL connection
> string matches the strings we have used with SQLPLUS
>
> LD_LIBRARY_PATH=/usr/cognos/ph843g/bin:/usr/oracle/lib32/10.1.0.5
>
> Anyone got any ideas what is failing?
>
> Thanks
>
> Adrian