Datastage OCI Plugin Error
Posted: Fri Jun 02, 2006 5:50 am
AOA,
We have installed Datastage server ver 7x on AIX. When i try to import any metadata it prompt me following error: " Unable to initialize Plugin"
At the same time when i click viewdata button in OracleOCI plugin it give me following error: "ds_loadlibrary: error in dlopen"
I have full rights at OS level, full right on datastage directory, I have login through administrator ans still facing the same problem.
Let me clarify once more. I have Oracle 10g Release 2 database server installed on the same AIX 5.3 server where Datastage server is installed. Oracle was installed first. After reading the installation doc, I have modified the $DSHOME/dsenv file and specified values for ORACLE_HOME,ORACLE_SID and LIBPATH. Now the enviornment for dsadm user looks like:
$ env
_=/usr/bin/env
LANG=en_US
LOGIN=dsadm
APT_ORCHHOME=
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/u01/app/datastage/bin:/usr/bin/X11:/sbin:.
LC__FASTMSG=true
LOGNAME=dsadm
MAIL=/usr/spool/mail/dsadm
ORACLE_SID=pakedwt
LOCPATH=/usr/lib/nls/loc
USER=dsadm
AUTHSTATE=files
UDTHOME=/u01/app/datastage/Ascential/DataStage/ud41
SHELL=/usr/bin/ksh
DSHOME=/u01/app/datastage/Ascential/DataStage/DSEngine
ODMDIR=/etc/objrepos
UDTBIN=/u01/app/datastage/Ascential/DataStage/ud41/bin
ODBCINI=/u01/app/datastage/Ascential/DataStage/DSEngine/.odbc.ini
HOME=/u01/app/datastage
TERM=xterm
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/u01/app/oracle/102
PWD=/u01/app/datastage/Ascential/DataStage/DSEngine
TZ=CST6CDT
A__z=! LOGNAME
LIBPATH=/u01/app/datastage/Ascential/DataStage/branded_odbc/lib:/u01/app/datastage/Ascential/DataStage/DSEngine/lib:
/u01/app/datastage/Ascential/DataStage/DSEngine/uvdlls:/u01/app/datastage/Ascential/DataStage/DSEngine/java/jre/bin/classic:
/u01/app/datastage/Ascential/DataStage/DSEngine/java/jre/bin::/u01/app/oracle/102/lib:/u01/app/oracle/102/rdbms/lib
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
I restarted the Datastage server as well but still get the same error. I have also verified that plugins for oracle9i have been installed. Infact all the available plugins are installed in my datastage installation.
Note: No oracle client has been installed on the server As I already have Oracle database server, which provides all the shared libraries required by Datastage.
We have installed Datastage server ver 7x on AIX. When i try to import any metadata it prompt me following error: " Unable to initialize Plugin"
At the same time when i click viewdata button in OracleOCI plugin it give me following error: "ds_loadlibrary: error in dlopen"
I have full rights at OS level, full right on datastage directory, I have login through administrator ans still facing the same problem.
Let me clarify once more. I have Oracle 10g Release 2 database server installed on the same AIX 5.3 server where Datastage server is installed. Oracle was installed first. After reading the installation doc, I have modified the $DSHOME/dsenv file and specified values for ORACLE_HOME,ORACLE_SID and LIBPATH. Now the enviornment for dsadm user looks like:
$ env
_=/usr/bin/env
LANG=en_US
LOGIN=dsadm
APT_ORCHHOME=
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/u01/app/datastage/bin:/usr/bin/X11:/sbin:.
LC__FASTMSG=true
LOGNAME=dsadm
MAIL=/usr/spool/mail/dsadm
ORACLE_SID=pakedwt
LOCPATH=/usr/lib/nls/loc
USER=dsadm
AUTHSTATE=files
UDTHOME=/u01/app/datastage/Ascential/DataStage/ud41
SHELL=/usr/bin/ksh
DSHOME=/u01/app/datastage/Ascential/DataStage/DSEngine
ODMDIR=/etc/objrepos
UDTBIN=/u01/app/datastage/Ascential/DataStage/ud41/bin
ODBCINI=/u01/app/datastage/Ascential/DataStage/DSEngine/.odbc.ini
HOME=/u01/app/datastage
TERM=xterm
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/u01/app/oracle/102
PWD=/u01/app/datastage/Ascential/DataStage/DSEngine
TZ=CST6CDT
A__z=! LOGNAME
LIBPATH=/u01/app/datastage/Ascential/DataStage/branded_odbc/lib:/u01/app/datastage/Ascential/DataStage/DSEngine/lib:
/u01/app/datastage/Ascential/DataStage/DSEngine/uvdlls:/u01/app/datastage/Ascential/DataStage/DSEngine/java/jre/bin/classic:
/u01/app/datastage/Ascential/DataStage/DSEngine/java/jre/bin::/u01/app/oracle/102/lib:/u01/app/oracle/102/rdbms/lib
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
I restarted the Datastage server as well but still get the same error. I have also verified that plugins for oracle9i have been installed. Infact all the available plugins are installed in my datastage installation.
Note: No oracle client has been installed on the server As I already have Oracle database server, which provides all the shared libraries required by Datastage.