CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
Hi Gurus Facing DBD:ORACLE Client Driver Error

 



shakeel_cs
New User

Aug 18, 2015, 11:33 PM

Post #1 of 4 (6414 views)
Hi Gurus Facing DBD:ORACLE Client Driver Error Can't Post

Hi All,
We are having client 11g and installed DBD driver. After installing there is a script which needs to be run for importing the data into table from database. Below error is pasted. Please guide as we have installed DBD multiple times.

***************************************************

[idsaspro@c1t07704 ~]$ cd /opt/batchapps/dsas/Jobs/LOAD_VSM_DATA_INTO_DSAS
[idsaspro@c1t07704 LOAD_VSM_DATA_INTO_DSAS]$ perl dsasfeed.pl -source VSMI -batchsize 100000 -destination DSASP -tnspath /opt/batchapps/dsas -dbusr IT -dbpwd '+251?3F5W7S(P,30`' -verbose
Wed Aug 19 06:07:47 UCT 2015
Debugging turned on
Receiving data from : VSMI
install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed
at dsasfeed.pl line 84

************************************************************


FishMonger
Veteran / Moderator

Aug 19, 2015, 6:57 AM

Post #2 of 4 (6386 views)
Re: [shakeel_cs] Hi Gurus Facing DBD:ORACLE Client Driver Error [In reply to] Can't Post

The error message is telling you that perl can't find the Oracle client libs. That could be because you don't have them installed, or they're not where the module expects.

Did you install and properly configure the Oracle client before installing the DBD module?

Did you setup the required Oracle environment variables?

How did you install the DBD::Oracle driver module?

Were there any errors during the install?


shakeel_cs
New User

Aug 19, 2015, 8:10 AM

Post #3 of 4 (6382 views)
Re: [FishMonger] Hi Gurus Facing DBD:ORACLE Client Driver Error [In reply to] Can't Post

Thanks for your reply ,
1) Yes we configured the oracle client properly because some other shell script is ruining fine .
2) Could you let me know how i check the Oracle environment variables is setup properly ?
3) Using the yum install perl-DBD-Pg command
4) NO error during installation but overwritten then its saying latest version available.


In Reply To


FishMonger
Veteran / Moderator

Aug 19, 2015, 8:38 AM

Post #4 of 4 (6372 views)
Re: [shakeel_cs] Hi Gurus Facing DBD:ORACLE Client Driver Error [In reply to] Can't Post


Quote
2) Could you let me know how i check the Oracle environment variables is setup properly ?

I don't work with Oracle so I can't give exact details on its environment requirements, but a quick google search will give you that answer.
https://www.google.com/search?q=oracle+client+environment+variables&ie=utf-8&oe=utf-8


Quote
3) Using the yum install perl-DBD-Pg command

That's the driver module for PostgreSQL databases, not Oracle.

Use cpan or cpanm to install DBD::Oracle.
sudo cpan install DBD::Oracle

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives