- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Error using perl DBD module for Oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 08:20 AM
тАО11-12-2002 08:20 AM
Error using perl DBD module for Oracle
Using perl DBD-ORacle-1.12 and DBI-1.30
Am running a perl script to run an Oracle Store procedure. Getting folowing message from perl script.
Can't load /opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/auto/DBD/Oracle/Oracle.slOracle.sl for module DBD::Oracle:Exec format error at /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multiDynaLoader.pm line 206
HP-UX 11.00 - Sept 2002 release
Oracle 8.1.7
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 08:26 AM
тАО11-12-2002 08:26 AM
Re: Error using perl DBD module for Oracle
*******************
/usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage: /us
r/lib/libcl.2
/usr/lib/dld.sl: Exec format error
Can't load '/opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/auto/DBD/Oracl
e/Oracle.sl' for module DBD::Oracle: Exec format error at /opt/perl/lib/5.6.1/PA
-RISC1.1-thread-multi/DynaLoader.pm line 206.
Compilation failed in require at ./hillerbundle.pl line 7.
BEGIN failed--compilation aborted at ./hillerbundle.pl line 7.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 02:28 PM
тАО11-12-2002 02:28 PM
Re: Error using perl DBD module for Oracle
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 03:42 AM
тАО11-13-2002 03:42 AM
Re: Error using perl DBD module for Oracle
threaded perl combined with Oracle is deadly!
For Oracle prepared perls, either fetch the appropriate port (including DBI-1.30) from my ITRC site on https://www.beepz.com/personal/merijn or fetch a recent perl from the HP porting center (read recent as not older than 3 month)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 06:36 AM
тАО11-13-2002 06:36 AM
Re: Error using perl DBD module for Oracle
Thanks for your reply here is the system information -
HP-UX11.00 32bit, 64 bit OS
CPU - PA2.0 PA8700
I had gotten latest 5.6.1 perl which is multithreaded and used DBI-1.30 and DBD-Oracle-1.12.
Also I looked up your site, and was having problems downloading the Oracle prepped perl. If clicked on the link on your site , it brought up the binary version.
Also I noticed in your notes, you do not mention DBD-Oracle for your perl build.
-Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 06:42 AM
тАО11-13-2002 06:42 AM
Re: Error using perl DBD module for Oracle
Is it correct to understand that to work with Oracle modules ,the perl should not be multithreaded? Because perl5.6.1 from HP-Unix porting center is multithreaded.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 07:41 AM
тАО11-13-2002 07:41 AM
Re: Error using perl DBD module for Oracle
My ports are not SD (software depot), but tbz's (tar bzip). Both GNU tar and bzip2 are also available on beepz.
Right click on the link and choose "save target as"
# cd /opt
# bzip2 -d
(I think) It should end up in /opt/perl
a5:/u/usr/merijn 101 > ll /opt/perl
total 4
9033 drwxrwxrwx 5 root sys 1024 Aug 2 16:28 .
2 drwxr-xr-x 39 root root 1024 Nov 11 18:47 ..
12813 -rw-rw-rw- 1 root sys 387 Aug 2 16:11 README
10472 drwxr-xr-x 2 merijn softwr 1024 Aug 2 16:07 bin
10474 drwxr-xr-x 4 merijn softwr 96 Jul 19 12:16 lib
10482 drwxr-xr-x 4 merijn softwr 96 Jul 19 12:17 man
a5:/u/usr/merijn 102 >
perl's to be used with Oracle should defenitely not be threaded perls, because they interfere with Oracles understanding of threads.
That the OS is 64bit does not inhibit you to run the (much faster) 32bit perl
I cannot supply DBD-Oracle, because of the zillions of different ports of Oracle out there in the scary real world. You should build it yourself.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 10:51 AM
тАО11-13-2002 10:51 AM
Re: Error using perl DBD module for Oracle
THANKS FOR YOUR HELP!!
It was the multithreded perl that was causing the problem.
From HP Unix Porting center I got perl 5.8.0 , which was just put in the last couple of days (I think).
Once I got this perl I loaded DBI-1.30 and DBD-Oracle-1.12
And I was able to connect to a remote DB via perl script.
Thank You
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 10:52 AM
тАО11-13-2002 10:52 AM
Re: Error using perl DBD module for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-14-2005 02:04 AM
тАО01-14-2005 02:04 AM
Re: Error using perl DBD module for Oracle
Finally was able to compile my perl 5.8.6 and the DBI and DBD modules. Two sites below were usefull
http://coding.derkeiler.com/Archive/Perl/perl.dbi.users/2003-10/0037.html
http://www.codecomments.com/PERL_DBI/message156458.html
NOTE:
Either set TWO_TASK or ORACLE_SID not both. They both mean same thing. Learnt the hard way.
Also while compiling perl got two errors during make test. one was ping test and other on lib/ExtUtils/t/Constant). Just ignore them. So far Everything looks good.
I am doing cut and paste of one of above links and attaching it as file, just in case that link is removed in future