ds_loadlibrary: error in dlopen - Dynamic Error
Moderators: chulett, rschirm, roy
ds_loadlibrary: error in dlopen - Dynamic Error
Dear all,
I am having the connectivity problem with oracle oci stage ,when i view the data through oarcle stage gives error
ds_loadlibrary: error in dlopen - Dynamic Error
upon execution gives a warning and job aborts
-usr/lib/dld.sl: Bad magic number for shared library: /u01/app/oracle/product/10.1.0.2/lib/libclntsh.sl
/usr/lib/dld.sl: Exec format error
configured the ODBC stage and it works fine for the view data and as well execution.
Oracle client was installed on the Datastage server(DS-server) and i am able to talk with oracle database(DB-server) using SQLPLUS .
just for your information
Datastage :7.5.1A
Unix :HP-UX 11.23
Database: 10.1.0.2
orcale path in dsenv file is :
ORACLE_HOME=/u01/app/oracle/product/10.1.0.2
ORAHOME=/u01/app/oracle/product/10.1.0.2
LD_LIBRARY_PATH=$ORACLE_HOME/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
Apart from this do i need to configure any information in any other files please advice ....
Thanks in Advance
I am having the connectivity problem with oracle oci stage ,when i view the data through oarcle stage gives error
ds_loadlibrary: error in dlopen - Dynamic Error
upon execution gives a warning and job aborts
-usr/lib/dld.sl: Bad magic number for shared library: /u01/app/oracle/product/10.1.0.2/lib/libclntsh.sl
/usr/lib/dld.sl: Exec format error
configured the ODBC stage and it works fine for the view data and as well execution.
Oracle client was installed on the Datastage server(DS-server) and i am able to talk with oracle database(DB-server) using SQLPLUS .
just for your information
Datastage :7.5.1A
Unix :HP-UX 11.23
Database: 10.1.0.2
orcale path in dsenv file is :
ORACLE_HOME=/u01/app/oracle/product/10.1.0.2
ORAHOME=/u01/app/oracle/product/10.1.0.2
LD_LIBRARY_PATH=$ORACLE_HOME/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
Apart from this do i need to configure any information in any other files please advice ....
Thanks in Advance
Regards,
Raj
Raj
Put your 32bit libraries first. Actually, you can remove the 64bit libraries as they won't be used. No need to declare them twice, either.
![Wink :wink:](./images/smilies/icon_wink.gif)
Code: Select all
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:Put your 32bit libraries first. Actually, you can remove the 64bit libraries as they won't be used. No need to declare them twice, either.![]()
Code: Select all
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
Thanks for the info chulett , but still the same error
Regards,
Raj
Raj
Re: ds_loadlibrary: error in dlopen - Dynamic Error
And make sure you remove the line I didn't qoute to you!
Leaving that one in will hork up the other change and was what I was referring to when I said 'no need to declare them twice'.
Code: Select all
LD_LIBRARY_PATH=$ORACLE_HOME/lib
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: ds_loadlibrary: error in dlopen - Dynamic Error
chulett wrote:And make sure you remove the line I didn't qoute to you!
Leaving that one in will hork up the other change and was what I was referring to when I said 'no need to declare them twice'.Code: Select all
LD_LIBRARY_PATH=$ORACLE_HOME/lib
Thanks chulett ,its working fine
Regards,
Raj
Raj
Re: ds_loadlibrary: error in dlopen - Dynamic Error
Just wanted to know why we need to point only 32 bit libraries ? why not 64 bit libararies ?chulett wrote:And make sure you remove the line I didn't qoute to you!
Leaving that one in will hork up the other change and was what I was referring to when I said 'no need to declare them twice'.Code: Select all
LD_LIBRARY_PATH=$ORACLE_HOME/lib
Regards,
Raj
Raj