Hi
I installed the oracle client and these are the things that i did
updated the dsenv file
if [ -z "$ORACLE_HOME" ]
then
ORACLE_HOME=/opt/oracle/product/10.2.0; export ORACLE_HOME
export TNS_ADMIN=/var/opt/oracle
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/lib32
export LIBPATH=$LIBPATH:$ORACLE_HOME/lib32
fi
when i installed the script in DSComponets/./install.liborchoracle
dsadm@vmzlsliis07:/opt/IBM/InformationServer/Server/DSComponents/install> ./install.liborchoracle
Installing Oracle driver.
Setting PX_DBCONNECTHOME variable for PXOperators
Installing driver for Oracle Version 10g
Oracle driver installation is completed
But after installation i didnt see any file by name orchoracle10g.o in PXEngine/lib. So i created the links manuvally and they are in red color.
These are the files in the /opt/IBM/InformationServer/PXEngine/lib/
lrwxrwxrwx 1 dsadm dstage 15 2010-09-01 09:30 orchoracle.o -> orchoracle10g.o
lrwxrwxrwx 1 dsadm dstage 23 2010-09-01 09:31 liborchoracles390x.so -> liborchoracle10s390x.so
I edit the tnsnames.ora file and when i execute the job i am getting the following error.
ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so.10.1: cannot open shared object file: No such file or directory.
My Question here when installing the install.liborchoracle script where the contents are being placed? I mean in which folder?
Any suggestion ?
Oracle Client Installation Error. error in dlopen of oraoci9
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration