Oracle 9i connectivity issue

[daniel0623]

Hi all,

I install Information server v8.1.0 on AIX 5.3 .
I have searched the forum, but issue still can't be solved

I add following env to dsenv.

### ORACLE Environment Variables ###
export ORACLE_HOME=/opt/oracle/oraInventory
#export ORACLE_SID=etl
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export PATH=$PATH:$ORACLE_HOME/bin
export LIBPATH=$LIBPATH:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32

I add dsadm to oracle dba group.
After restart datstage service,
When I try to import metadata using plug-in table definition, receive the error: Unable to initialize plug-in.
When I try to import metadata using orchestrate table definition, receive the error:

0509-150 Dependent module libclntsh.so could not be loaded.
0509-022 Cannot load module libclntsh.so.
0509-026 System error: A file or directory in the path name does not exist.
0509-022 Cannot load module /opt/IBM/InfoServer/InformationServer/Server/DSComponents/bin/orchoracle.o.
0509-150 Dependent module /opt/IBM/InfoServer/InformationServer/Server/DSComponents/bin/orchoracle.o could not be loaded..


Output from "ldd orchoracle10g.o"

orchoracle10g.o needs:
/opt/IBM/InfoServer/InformationServer/Server/DSComponents/lib/libicui18n.a
/opt/IBM/InfoServer/InformationServer/Server/DSComponents/lib/libicuio.a
/opt/IBM/InfoServer/InformationServer/Server/DSComponents/lib/libicuuc.a
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/liborchaix64.a(libtemp.o)
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/liborchcoreaix64.a(libtemp.o)
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/liborchgeneralaix64.so
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/liborchcommondbaix64.so
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/liborchmonitoraix64.so
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/librwtool.a(librwtool.o)
Cannot find /usr/vacpp/lib/libC.a(shr_64.o)
/usr/vacpp/lib/libC.a(shr2_64.o)
/usr/vacpp/lib/libC.a(ansi_64.o)
/usr/lib/libpthreads.a(shr_xpg5_64.o)
/usr/lib/libc_r.a(shr_64.o)
/opt/IBM/InfoServer/InformationServer/Server/DSComponents/lib/libicuuc32.a
/opt/IBM/InfoServer/InformationServer/Server/DSComponents/lib/libicudata32.a
/usr/lib/libc.a(shr_64.o)
/opt/IBM/InfoServer/InformationServer/Server/DSComponents/lib/libicui18n32.a
/usr/lib/libpthread.a(shr_xpg5_64.o)
/usr/lib/libdl.a(shr_64.o)
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/liborchoslaix64.a(libtemp.o)
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/orchcommondb.o
/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib/orchmonitor.o
/usr/vacpp/lib/libC.a(ansicore_64.o)
/usr/vacpp/lib/libC.a(shrcore_64.o)
/usr/vacpp/lib/libC.a(shr3_64.o)
/unix
/usr/lib/libcrypt.a(shr_64.o)



$ echo $LIBPATH
/opt/IBM/InfoServer/InformationServer/Server/branded_odbc/lib:/opt/IBM/InfoServer/InformationServer/Server/DSComponents/lib:/opt/IBM/InfoServer/InformationServer/Server/DSComponents/bin:/opt/IBM/InfoServer/InformationServer/Server/DSEngine/lib:/opt/IBM/InfoServer/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InfoServer/InformationServer/Server/PXEngine/lib:/apps/jre/bin:/apps/jre/bin/classic:/lib/cpp:/apps/proxy/cpp/aix-all-ppc_64:/usr/vacpp/lib:/usr/lib:/usr/lib/threads:/unix:/dbinfo_app2/etlinst/sqllib/lib32:/opt/oracle/oraInventory/lib32:/opt/oracle/oraInventory/rdbms/lib32

Appreciate for any suggestion.

[keshav0307]

search for orchoracle.o
it will surely help you

see this viewtopic.php?t=120269

[daniel0623]

IBM support tells me Information Server 8.1 is 64-bit on AIX.
In this case, $ORACLE_HOME/lib and $ORACLE_HOME/rdbms/lib , not lib32 should be included in $LIBPATH.
I will do a testing and update this topic later.