RE: DBD error
Hi Bala, I’d show this to my sys admin, looks like there are missing libraries on your system. Cheers From: Bala GANESH Sent: Tuesday, July 21, 2020 3:18 AM To: Kevin Moore Cc: Christopher Jones ; dbi-users@perl.org Subject: Re: DBD error HI Kevin, While DB:Oracle , am facing below error , based on your availability tell me the free time , am ready to share my screen [root@vm-postgresql DBD-Oracle-1.75_2]# make "/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs 644 rm -f blib/arch/auto/DBD/Oracle/Oracle.so gcc -lpthread -shared -Wl,-z,relro -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -L/usr/local/lib -fstack-protector-strong Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \ -L/opt/oracle/product/12.1.0/client_1/lib -lclntsh -ldl -lm -lpthread -lnsl -lirc -limf -lirc -lrt -laio -lresolv -lsvml -lperl \ /usr/bin/ld: cannot find -lnsl /usr/bin/ld: cannot find -laio collect2: error: ld returned 1 exit status make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/Oracle.so] Error 1 On Mon, Jul 20, 2020 at 7:35 PM Kevin Moore mailto:kmo...@esntech.com> > wrote: If you’re using an 11.2.0.4 client and that versions libraries, you may want to upgrade the client to something more current because I’m not sure this client is supported by Oracle. Here is what was posted that makes me believe that way: ld: 0711-736 ERROR: Input file /oracle/product/11.2.0.4/lib/libclntsh.so <https://urldefense.com/v3/__http:/11.2.0.4/lib/libclntsh.so__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXh-SIBnPA$> : From: Christopher Jones mailto:christopher.jo...@oracle.com> > Sent: Sunday, July 19, 2020 4:38 PM To: dbi-users@perl.org <mailto:dbi-users@perl.org> ; bala_gan...@carrefour.com <mailto:bala_gan...@carrefour.com> Subject: Re: DBD error On 17/7/20 10:02 pm, Bala GANESH wrote: Hi Support, "Support" ? :) I am receiving following error while installing DBD Perl module on IBM AIX 7.1 .Please help me to solve this.. bash-3.2# perl Makefile.PL * ld: 0711-736 ERROR: Input file /oracle/product/11.2.0.4/lib/libclntsh.so <https://urldefense.com/v3/__http:/11.2.0.4/lib/libclntsh.so__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXh-SIBnPA$> : XCOFF64 object files are not allowed in 32-bit mode. make: 1254-004 The error code from the last command is 8. * pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# export ORACLE_HOME=/oracle/product/19.7/ pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# export LD_LIBRARY_PATH=/oracle/product/19.7/lib pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# perl Makefile.PL Using DBI 1.643 (for perl 5.028001 on aix-thread-multi) installed in /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/ Configuring DBD::Oracle for perl 5.028001 on aix (aix-thread-multi) If you encounter any problem, a collection of troubleshooting guides are available under lib/DBD/Oracle/Troubleshooting. 'DBD::Oracle::Troubleshooting' is the general troubleshooting guide, while platform-specific troubleshooting hints live in their labelled sub-document (e.g., Win32 hints are gathered in 'lib/DBD/Oracle/Troubleshooting/Win32.pod'). Installing on a aix, Ver#7.1 Using Oracle in /oracle/product/19.7 DEFINE _SQLPLUS_RELEASE = "190700" (CHAR) Oracle Version 19.7.0.0 (19.7) Found direct-link candidates: libclntsh.a libclntsh.so Oracle sysliblist: /lib/crt0_64.o -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld -lperfstat Found header files in /oracle/product/19.7/rdbms/public. Your LIBPATH env var is set to '' WARNING: Your LIBPATH env var doesn't include '/oracle/product/19.7/lib' but probably needs to. Did you try setting LIBPATH instead of LD_LIBRARY_PATH? https://www.ibm.com/support/pages/libpath-environment-variables-aix-platforms <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_pages_libpath-2Denvironment-2Dvariables-2Daix-2Dplatforms=DwMFaQ=oYSInPoxeTs4m10ilnGu9Q=epNtSOT0Nv3ejsgXp-J4jOmfo8HlYyawp_IXKa881cY=6ifBm5aRmkE9Ys1nxaSfQ_qUlmJZ7osJjwXqYzzV2Fo=eahDz0l4E-ozVHu3LelqHyh6OVOY6waGt9afuyWYQ2g=> Chris client_version=19.7 DEFINE= -DUTF8_SUPPORT -DORA_OCI_VERSION=\"19.7.0.0\" -DORA_OCI_102 -DORA_OCI_112 Checking for functioning wait.ph <https://urldefense.com/v3/__http:/wait.ph__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXjwPaqgsA$> System: perl5.028001 aix fvt-p7a2-lp2 1 7 668a7a00 Compil
RE: ORA-12154 - (DBD: login failed)
The problem I’m seeing here is you are using a "service name" when you should
be using a SID. If the database name is ECLD, I would suggest dropping the
.WORLD and retrying the connection where you have my $sid = "ECLD.WORLD";
Your sid setting should look like this: $sid = "ECLD";
The connect string should look something like this:
my $dbh = DBI->connect("dbi:Oracle:ecd", $usr, $pas) or die $DBI::errstr;
If you still have problems, feel free to post the tnsnames.ora file from the
client with the host names removed and the listener.ora from the database
server also with the hostnames removed.
For giggles, do a tnsping for ECLD.WORLD and post the results.
-Kevin
-Original Message-
From: Christopher Jones [mailto:christopher.jo...@oracle.com]
Sent: Monday, August 08, 2016 7:07 PM
To: dbi-users@perl.org
Subject: Re: ORA-12154 - (DBD: login failed)
You can connect to 12c using 10gR2 client.
Chris
On 9/08/2016 12:40 AM, Mike Towery wrote:
> I don't think the 10G Oracle client works with Oracle 12. Have you tried the
> Oracle 12 client?
>
> On Mon, Aug 8, 2016 at 9:25 AM, Howard, Chris > wrote:
>
>
>
> ORACLE_HOME not defined correctly?
>
> (I would test by printing out all ENV from within script)
>
>
>
> -Original Message-
> From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com
> ]
> Sent: Monday, August 08, 2016 5:38 AM
> To: Nelson, Erick; mohammed.must...@wipro.com
> ; dbi-users@perl.org
>
> Subject: RE: ORA-12154 - (DBD: login failed)
>
> Instead of @, we define the connection string in TWO_TASK,
> and it still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.
>
> Arunkumar Mani
> ITO Service Delivery Consultant
> Database Engineering, BMS Account
>
> arunkumar.m...@hpe.com
> +91 80 338 59305 Office
> +91 74062 71026 Mobile
>
> Bangalore, Karnataka/India
> hpe.com
>
>
>
> -Original Message-
> From: Nelson, Erick [mailto:erick.nel...@hdsupply.com
> ]
> Sent: Monday, August 8, 2016 5:01 PM
> To: Mani, Arunkumar (BMS - India GDC) >; mohammed.must...@wipro.com
> ; dbi-users@perl.org
>
> Subject: Re: ORA-12154 - (DBD: login failed)
>
> Did you try TWO_TASK env var ?
> >
> >
>
>
> Erick Nelson
> Cell 858-740-6523
> Home 760-930-0461
>
>
> From: "Mani, Arunkumar (BMS - India GDC)" >>
> Date: Monday, August 8, 2016 at 1:14 AM
> To: "mohammed.must...@wipro.com
> >"
> >>,
> "dbi-users@perl.org >" >>
> Subject: RE: ORA-12154 - (DBD: login failed)
>
> All were done earlier. The problem is perl doesn't recognize my
> sqlnet.ora or tnsnames.ora, though I define TNS_ADMIN correctly in the script.
> Note: This was working when we used Oracle 8 client.
>
> Arunkumar Mani
> ITO Service Delivery Consultant
> Database Engineering, BMS Account
>
> arunkumar.m...@hpe.com
> >
> +91 80 338 59305 Office
> +91 74062 71026 Mobile
>
> Bangalore, Karnataka/India
> hpe.com
>
> [hpesm_pri_grn_pos_email_06]
>
> From: mohammed.must...@wipro.com
> >
> [mailto:mohammed.must...@wipro.com ]
> Sent: Thursday, August 4, 2016 8:53 PM
> To: Mani, Arunkumar (BMS - India GDC) >>; dbi-users@perl.org
> >
> Subject: Re: ORA-12154 - (DBD: login
RE: Re: oracle instant client for Linux (oracle 9.2) ?
I'd recommend the 11gR2 (current) client. I believe it is backwards compatible with the 9.2 database. If you have problems installing the client or at runtime, it will be easier to get help with the newer client. And BTW, the readme in the exploded distribution has what you need to set so that the client installs properly. I've been down that road. Hope it helps.. -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Monday, October 01, 2012 11:19 AM To: dbi-users@perl.org Subject: Fwd: Re: oracle instant client for Linux (oracle 9.2) ? Oops, forgot dbi-users: Original Message Subject:Re: oracle instant client for Linux (oracle 9.2) ? Date: Mon, 01 Oct 2012 19:17:43 +0100 From: Martin J. Evans martin.ev...@easysoft.com Organisation: Easysoft Limited To: Jack Craig jack.craig.ap...@gmail.com On 01/10/2012 19:14, Jack Craig wrote: Ok, A further install question; on my webserver that has no oracle, it seems i need oracle instant client for oracle 9.2, but i am only seeing options for 10.2 or later. that is ok. Some clients only work with some servers. trying to 'perl Makefile.PL', i get the error about LD_LIBRARY_PATH not having ORACLE_HOME, so i added the path as will be true on host B, ... You didn't mention the platform. On Linux set LD_LIBRARY_PATH NOT ORACLE_HOME and rerun perl Makefile.PL. any pointers how to get this install accomplished on my webserver? will instantclient 10.2 work on 9.2? I believe so. TIA, jackc... Martin
RE: (Fwd) DBD::Oracle Continuous Query Notification
Hi John, Forgive me in advance if I've missed something but when you talk about FAN and TAF, are these in the context of Oracle RAC? Thanks, Kevin -Original Message- From: John Scoles [mailto:byter...@hotmail.com] Sent: Wednesday, August 29, 2012 3:26 AM To: rune.hens...@trapezegroup.eu; dbi-users@perl.org Subject: RE: (Fwd) DBD::Oracle Continuous Query Notification Yes it is possiable but it has not been programmed yet in DBD::Oracle. So far it is on the list of things to do for DBD::Oracle and at the Last Yapc EU conferance the other Maintainers and I have penceled it in once we get FAN and TAF fully working. Look for it by Christmass sometime. Cheers John Scoles Date: Tue, 28 Aug 2012 13:06:59 +0100 From: tim.bu...@pobox.com To: dbi-users@perl.org CC: rune.hens...@trapezegroup.eu Subject: (Fwd) DBD::Oracle Continuous Query Notification - Forwarded message from Rune Henssel rune.hens...@trapezegroup.eu - Date: Tue, 28 Aug 2012 13:03:08 +0200 From: Rune Henssel rune.hens...@trapezegroup.eu To: t...@cpan.org Subject: DBD::Oracle Continuous Query Notification Hi Tim I hope that you might be able to help me with a problem that I have. I am part of a team developing an application that needs to be notified whenever data is changed in certain tables in a Oracle database. I know that this is possible in .NET using ODP.NET but is it also possible in Perl and if so how? Yours Rune Henssel Systemdeveloper Trapeze Group Europe A/S Hersted stervej 27-29 Bygning A DK-2620 Albertslund www.trapezegroup.com r...@trapezegroup.eu - End forwarded message -
Displaying fetched values in html form
I'm not sure if this is the right forum so i'd appreciate pointers to the correct place if i'm wrong. I've got DBI running between apache and an Oracle 10gR2 database. I can insert data with no problem. Here's what i'm attempting to do. 1. Put up a HTML form where user enters his userid, password, and emailid. 2. I pass this information t a perl module and verify his user exists in the database. 3. If successfully validating this user I get account information from the database, put up a html form, and post that information to text boxes in the html form. The problem i'm having is returning the data to the text areas in the form. I can print the data coming back from the database so that piece is working. When I set the value in the text box to $username in the text box I get $username instead of what was returned from the database. I can print the actual returned username by doing a print of $username variable but outside the text block. Ultimately I would like the user to be able to make changes to their user information then i'll update the database. I'm sure this can be done and that means i'm probably looking past something really obvious. Google has not been much use. Any ideas? Stumped
DBD module loading problem
Objective - execute perl modules from apache that access an oracle database Oracle database - 10gr2, SUSE SLES9 linux Apache server - RHAS 4.0, oracle 10gr2 instant client Perl Version perl -v This is perl, v5.8.5 built for i386-linux-thread-multi Apache Version apachectl -v Server version: Apache/2.0.55 Server built: Feb 28 2006 10:15:42 mod_perl, DBI, DBD versions mod_perl -2.0.2 DBI-1.50 DBD-Oracle 1.17 Apache DBI-0.9901 Error when running perl module from apache error_log file [Sat Apr 22 20:48:04 2006] emahni.pl: install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libnnz10.so: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. ORACLE_HOME, LD_LIBRARY_PATH ($ORACLE_HOME/lib), TWO_TASK, and LD_RUN_PATH($ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib) set in httpd.conf Running the script from the command line connects to the database and returns correct results. I've googled using the following: module DBD::Oracle: libnnz10.so The third and fourth google entries look as though they may be helpful but i'm receiving a server busy message. Anyone got an idea what is on these pages or experienced the same problem and would like to share a resolution? Thanks.
Re: DBD module loading problem
One more thing - all perl makefile.pl, make, make test, make install, were successful for mod_perl, DBI, DBD Kevin Moore wrote: Objective - execute perl modules from apache that access an oracle database Oracle database - 10gr2, SUSE SLES9 linux Apache server - RHAS 4.0, oracle 10gr2 instant client Perl Version perl -v This is perl, v5.8.5 built for i386-linux-thread-multi Apache Version apachectl -v Server version: Apache/2.0.55 Server built: Feb 28 2006 10:15:42 mod_perl, DBI, DBD versions mod_perl -2.0.2 DBI-1.50 DBD-Oracle 1.17 Apache DBI-0.9901 Error when running perl module from apache error_log file [Sat Apr 22 20:48:04 2006] emahni.pl: install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libnnz10.so: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. ORACLE_HOME, LD_LIBRARY_PATH ($ORACLE_HOME/lib), TWO_TASK, and LD_RUN_PATH($ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib) set in httpd.conf Running the script from the command line connects to the database and returns correct results. I've googled using the following: module DBD::Oracle: libnnz10.so The third and fourth google entries look as though they may be helpful but i'm receiving a server busy message. Anyone got an idea what is on these pages or experienced the same problem and would like to share a resolution? Thanks.
Re: problem DBD-Oracle-1.17 linux enterprise AS
Oscar, Are there errors in your alert log? The ora-600 is a generic message. It's quite possible oracle generated a trace file that may also help. Kevin Oscar Gomez wrote: i have this error when i made interface program perl with oracle 10g trough DBD module. DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments: [kpofdr-long], [], [], [], [], [], [], [] (DBD ERROR: error possibly near * indicator at char 37 in 'select itmpar, texpar from useru.*par where ciapar = :p1 and fampar = :p2 ') [for Statement select itmpar, texpar from useru.par where ciapar = ? and fampar = ? with ParamValues: :p1=0, :p2='py-ley'] at ./1230.pl line 28. but,if I execute it for the second time it work ok. thanks -- Open WebMail Project (http://openwebmail.org) --- End of Forwarded Message --- -- Open WebMail Project (http://openwebmail.org)
Executing Oracle stored procedures
All, I've got Apache v2.x, Oracle 9i, running on Red Hat linux 9, mod_perl, and DBI installed and working. I'd like to be able to execute Oracle stored procedures. Is anyone doing this without the mod_plsql plugin? If so, would you be wlling to share tips for making this work. I've already got stored procedures and am connecting to the database but am seeing the following errors. DBD::Oracle::db do failed ORA-06502.: PL/SQL: numeric or value error ORA-06502: at SYS.OWA_UTIL, line 323 I really need to know if there is something Apche needs to display pages generated fro stored procedures. Any help will be appreciated. thanks. Kevin
Oracle 10g database and DBI connectivity
Perl experts, I've got DBI and Apache configured to connect to an Oracle 9.2 database. I'm considering upgrading the database to 10g. Not expecting any problems but if anyone has gone that route and are willing to share any gotchas or additional suggestions i'd certainly appreciate it. Thanks, Kevin
Re: DBI with ORACLE encryption
I assume you have enabled Oracle Advanced Security. There are client and server specific settings as well as the CRYPTO SEED which must be the same on both. I'm sure you can find this on google or the free Oracle forums. Hope it helps. Kevin Tim Bunce wrote: [moved to [EMAIL PROTECTED] I can't help unless you, or someone, can indicate what OCI calls the driver needs to make (assuming that is the problem). Tim. On Wed, Mar 10, 2004 at 02:05:49PM +0530, [EMAIL PROTECTED] wrote: Hi, We are using Oracle version 8.1.7.4 as the database running on the solaris 2.8 operating system. We are trying to connect to the database using a perl script on the same solaris server. With the tnsnames.ora settings, it works fine. The moment we enable the oracle encryption using SQLNET.ORA, when we try to connect to the database via the perl script using DBI, we get the following error. ORA-12649: Unknown encryption or data integrity algorithm (DBD ERROR: OCIServerAttach) The version of the perl and the DBI version is Perl: version 5.005_03 built for sun4-solaris DBI : DBI.pm,v 10.10 thks Regards Jayashree Ability is what you're capable of doing...Motivation determines what you do...Attitude determines how well you do it. This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited. Visit Us at http://www.polaris.co.in
Apache problem when using DBI
I have a perl script that runs flawlessly from command line but gived
the ERROR 500 when attempting to run same script through Apache. O/S is
red hat linux 9
Perl version
perl -v
This is perl, v5.8.0 built for i386-linux-thread-multi
(with 1 registered patch, see perl -V for more detail)
Error from apache log file
[Tue Feb 24 18:11:31 2004] [error] [client 192.168.1.3] Premature end of
script headers: dbcheck.pl
[Tue Feb 24 18:11:31 2004] [error] [client 192.168.1.3] Can't locate
Apache/Constants.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.6.1 /usr/perl/mod_perl-1.27/Apache/blib/lib
/usr/lib/perl5/5.8.0/CGI /usr/lib/perl5/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at
/usr/lib/perl5/site_perl/5.6.1/Apache.pm line 6.
[Tue Feb 24 18:11:31 2004] [error] [client 192.168.1.3] BEGIN
failed--compilation aborted at /usr/lib/perl5/site_perl/5.6.1/Apache.pm
line 6.
[Tue Feb 24 18:11:31 2004] [error] [client 192.168.1.3] Compilation
failed in require at /home/httpd/cgi-bin/dbcheck.pl line 13.
[Tue Feb 24 18:11:31 2004] [error] [client 192.168.1.3] BEGIN
failed--compilation aborted at /home/httpd/cgi-bin/dbcheck.pl line 13.
Top of script
#! /usr/bin/perl
$ENV{ORACLE_HOME} = '/home/oracle/product/9ias';
$ENV{TWO_TASK} = 'WEBAPP.WORLD';
print Content-type: text/html, \n\n;
print HTML, \n;
print HEAD;
print TITLE Testing Team ListTITLE, \n;
print /HEAD, \n;
print BODY;
use Apache;
use Apache::DBI;
use DBI;
use CGI::Carp qw(fatalsToBrowser);
use strict;
my $dbh =
Oracle database is 9.2.0.4.
Apache version is 2.0.40
DBI version is DBI-1.40
I've googled this to death, read notes everywhere, and quite frankly
need help with where/how to fix this. I'm guessing I need to add
something to the httpd.conf file to fix this. Would appreciate any help
I can get. Thanks.
Kevin
Re: Apache, Oracle, Perl DBI Problems
Well, I've gotten past this error. There was an excessive line in my httpd.conf . Fixed it and the next problem was in my cgi script. Thanks for all the replies. :-[ Michael Nhan wrote: Hi, Are you sure the the oracle client library is readable/accessible by the web user or by user nobody? The error you were getting seems to suggest that it could not load the shared library libclnt... Two things can cause this, 1) ld_library_path does not include $oracle_home/lib (location where the oracle client library is), 2) permission on libclnt is not readable by web user or oracle_lib directory is not accessible by user nobody/web user. Regards, Michael I added it at the end of the httpd.conf file. I may have another problem though
Re: Apache, Oracle, Perl DBI Problems
All:
Thanks all for your replies. I'm still unable to make this work. Is
there a How To doc for configuring Apache 2.x to run perl scripts
somewhere I can review to find out where my install went bad? I've not
found anything out there like this and am floundering. Thanks.
Kevin
Tim Bunce wrote:
On Thu, Dec 11, 2003 at 08:29:14PM -0800, Kevin Moore wrote:
Hi Steve,
I can run the scripts from the command line. The script connects to
the database with no questions asked and selects data from tables. I'm
pretty sure the problem is with Apache interfacing with Perl/DBI. My
problem is knowing what to do to fix this. Should environments such as
LD_LIBRARY_PATH be set in the Apache configuration or what?
Yes.
Tim.
I'm new to
this area as you can tell. I'm looking for somebody who has made this
work to point me in the right direction. Any pointers are appreciated.
Thanks.
Kevin
Steve Baldwin wrote:
Did you try executing your Perl CGI script from the command line (as
opposed to via the web server) ? None of our CGI scripts set
LD_LIBRARY_PATH, (although we use Apache 1 not 2). Could it be a
permissions thing ? Did you confirm that the Oracle client library is
present and accessible ? If the cgi executes from the command line,
maybe it's an Apache setup thing rather than a DBI thing.
-Original Message-
From: Kevin Moore [mailto:[EMAIL PROTECTED]
Sent: Friday, 12 December 2003 11:12 AM
To: '[EMAIL PROTECTED]'
Subject: Apache, Oracle, Perl DBI Problems
Gang,
I'm attempting to write a perl script, callable from a URL, that
connects me to an Oracle 9i database. I've combed the help pages and
think i'm just missing something simple. From what i've read it appears
that my LD_LIBRARY_PATH is not being set correctly. I've set the
LD_LIBRARY_PATH variable in the perl script and installed the DBI
modules. Below is the environment, code snippet, and error message. Any
ideas anyone? Completely lost here. - Kevin
Environment:
Red Hat Linux 9.0
Apache 2.0.40
Apache-DBI-0.91
DBD-Oracle-1.14
DBI-1.35
Code Snippet:
#!/usr/bin/perl -w
use strict subs;
use Apache::DBI;
use DBI;
use DBD::Oracle;
use CGI;
use CGI::Carp qw(fatalsToBrowser);
use CGI::Cookie;
#use Apache::Registry;
package CGIBook::Error;
use vars qw( $dbh $CGI $TABLE $q $r @FIELD_NAMES);
my ( $sth, @row );
@FIELD_NAMES = (uinp_uname, uinp_fname, uinp_lname, uinp_active,
uinp_email, uinp_passwd, uinp_signup,
last_login,
conf_passwd);
$TABLE = webusers;
$ENV{'ORACLE_HOME'} = '/home/oracle/product/9ias';
#$ENV{'LD_LIBRARY_PATH'} = '/home/oracle/product/9ias/lib';
$ENV{'TWO_TASK'} = 'webapp'; $ENV{'LD_RUN_PATH'} =
/home/oracle/product/9ias/lib:/home/oracle/product/9ias/r
dbms/lib;
LD_LIBRARY_PATH = '/home/oracle/product/9ias/lib';
# $CGI = new CGI();
### Connect To Database
my $dbh = DBI-connect( dbi:Oracle:WEBAPP.WORLD, user, password ,
{
PrintError = 0,
RaiseError = 0
} ) or die Can't connect To Database: $DBI::errstr\n;
Error message:
[error] [client 192.168.1.3] Premature end of script headers: signup.cgi
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/Oracle/
Oracle.so'
for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object
file: No such file or directory at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] at
/home/httpd/cgi-bin/signup.cgi line 6
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] Compilation
failed in require at /home/httpd/cgi-bin/signup.cgi line 6. [Thu Dec 11
16:01:14 2003] [error] [client 192.168.1.3] BEGIN
failed--compilation aborted at /home/httpd/cgi-bin/signup.cgi line 6.
Re: Apache, Oracle, Perl DBI Problems
I added it at the end of the httpd.conf file. I may have another problem though Hardy Merrill wrote: Michael Nhan [EMAIL PROTECTED] wrote: In fact Tim Bunce suggested setting LD_LIBRARY_PATH in the apache configuration - I don't know how to do that. in the httpd.conf SetEnv LD_LIBRARY_PATH blah:blah I just went in there and searched for 'SetEnv' and didn't find anything. Anyplace special that needs to be?
Apache, Oracle, Perl DBI Problems
Gang,
I'm attempting to write a perl script, callable from a URL, that
connects me to an Oracle 9i database. I've combed the help pages and
think i'm just missing something simple. From what i've read it appears
that my LD_LIBRARY_PATH is not being set correctly. I've set the
LD_LIBRARY_PATH variable in the perl script and installed the DBI
modules. Below is the environment, code snippet, and error message. Any
ideas anyone? Completely lost here. - Kevin
Environment:
Red Hat Linux 9.0
Apache 2.0.40
Apache-DBI-0.91
DBD-Oracle-1.14
DBI-1.35
Code Snippet:
#!/usr/bin/perl -w
use strict subs;
use Apache::DBI;
use DBI;
use DBD::Oracle;
use CGI;
use CGI::Carp qw(fatalsToBrowser);
use CGI::Cookie;
#use Apache::Registry;
package CGIBook::Error;
use vars qw( $dbh $CGI $TABLE $q $r @FIELD_NAMES);
my ( $sth, @row );
@FIELD_NAMES = (uinp_uname, uinp_fname, uinp_lname, uinp_active,
uinp_email, uinp_passwd, uinp_signup, last_login,
conf_passwd);
$TABLE = webusers;
$ENV{'ORACLE_HOME'} = '/home/oracle/product/9ias';
#$ENV{'LD_LIBRARY_PATH'} = '/home/oracle/product/9ias/lib';
$ENV{'TWO_TASK'} = 'webapp';
$ENV{'LD_RUN_PATH'} =
/home/oracle/product/9ias/lib:/home/oracle/product/9ias/r
dbms/lib;
LD_LIBRARY_PATH = '/home/oracle/product/9ias/lib';
# $CGI = new CGI();
### Connect To Database
my $dbh = DBI-connect( dbi:Oracle:WEBAPP.WORLD, user, password , {
PrintError = 0,
RaiseError = 0
} ) or die Can't connect To Database: $DBI::errstr\n;
Error message:
[error] [client 192.168.1.3] Premature end of script headers: signup.cgi
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object
file: No such file or directory at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] at
/home/httpd/cgi-bin/signup.cgi line 6
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] Compilation
failed in require at /home/httpd/cgi-bin/signup.cgi line 6.
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] BEGIN
failed--compilation aborted at /home/httpd/cgi-bin/signup.cgi line 6.
Re: Apache, Oracle, Perl DBI Problems
Hi Steve,
I can run the scripts from the command line. The script connects to
the database with no questions asked and selects data from tables. I'm
pretty sure the problem is with Apache interfacing with Perl/DBI. My
problem is knowing what to do to fix this. Should environments such as
LD_LIBRARY_PATH be set in the Apache configuration or what? I'm new to
this area as you can tell. I'm looking for somebody who has made this
work to point me in the right direction. Any pointers are appreciated.
Thanks.
Kevin
Steve Baldwin wrote:
Did you try executing your Perl CGI script from the command line (as
opposed to via the web server) ? None of our CGI scripts set
LD_LIBRARY_PATH, (although we use Apache 1 not 2). Could it be a
permissions thing ? Did you confirm that the Oracle client library is
present and accessible ? If the cgi executes from the command line,
maybe it's an Apache setup thing rather than a DBI thing.
-Original Message-
From: Kevin Moore [mailto:[EMAIL PROTECTED]
Sent: Friday, 12 December 2003 11:12 AM
To: '[EMAIL PROTECTED]'
Subject: Apache, Oracle, Perl DBI Problems
Gang,
I'm attempting to write a perl script, callable from a URL, that
connects me to an Oracle 9i database. I've combed the help pages and
think i'm just missing something simple. From what i've read it appears
that my LD_LIBRARY_PATH is not being set correctly. I've set the
LD_LIBRARY_PATH variable in the perl script and installed the DBI
modules. Below is the environment, code snippet, and error message. Any
ideas anyone? Completely lost here. - Kevin
Environment:
Red Hat Linux 9.0
Apache 2.0.40
Apache-DBI-0.91
DBD-Oracle-1.14
DBI-1.35
Code Snippet:
#!/usr/bin/perl -w
use strict subs;
use Apache::DBI;
use DBI;
use DBD::Oracle;
use CGI;
use CGI::Carp qw(fatalsToBrowser);
use CGI::Cookie;
#use Apache::Registry;
package CGIBook::Error;
use vars qw( $dbh $CGI $TABLE $q $r @FIELD_NAMES);
my ( $sth, @row );
@FIELD_NAMES = (uinp_uname, uinp_fname, uinp_lname, uinp_active,
uinp_email, uinp_passwd, uinp_signup,
last_login,
conf_passwd);
$TABLE = webusers;
$ENV{'ORACLE_HOME'} = '/home/oracle/product/9ias';
#$ENV{'LD_LIBRARY_PATH'} = '/home/oracle/product/9ias/lib';
$ENV{'TWO_TASK'} = 'webapp'; $ENV{'LD_RUN_PATH'} =
/home/oracle/product/9ias/lib:/home/oracle/product/9ias/r
dbms/lib;
LD_LIBRARY_PATH = '/home/oracle/product/9ias/lib';
# $CGI = new CGI();
### Connect To Database
my $dbh = DBI-connect( dbi:Oracle:WEBAPP.WORLD, user, password ,
{
PrintError = 0,
RaiseError = 0
} ) or die Can't connect To Database: $DBI::errstr\n;
Error message:
[error] [client 192.168.1.3] Premature end of script headers: signup.cgi
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/Oracle/
Oracle.so'
for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object
file: No such file or directory at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] at
/home/httpd/cgi-bin/signup.cgi line 6
[Thu Dec 11 16:01:14 2003] [error] [client 192.168.1.3] Compilation
failed in require at /home/httpd/cgi-bin/signup.cgi line 6. [Thu Dec 11
16:01:14 2003] [error] [client 192.168.1.3] BEGIN
failed--compilation aborted at /home/httpd/cgi-bin/signup.cgi line 6.
Re: Oracle dbi ?
Jared,
Since I've got no experience with OCI and not much play time right now
I'm going to ask this question. Can you execute a command line shell
script using OCI? If so there is no reason you cannot invoke sqlplus and
startup or shutdown an Oracle database.
Kevin
Jared Still wrote:
The problem is, these aren't actually SQL commands.
Rather, these are SQL*Plus commands. The DBD::Oracle
doesn't know what to do with these.
If you could figure out how to do this with OCI, then
you could probably patch DBD::Oracle to provide this
functionality.
Tim would appreciate that patch when you're done. :)
Jared
On Tue, 2003-11-04 at 07:03, Kevin Moore wrote:
What user are you conneted as when you try to shut down the database?
I've used shutdown, shutdown imediate, and in worst cases shutdown abort
to stop an Oracle database. This has been the method (sql ) from 8i
forward.
Kevin
[EMAIL PROTECTED] wrote:
Since shutdown is not a sql command, has anyone figured out how to
shutdown a 8.1.7 or higher database
When you connect with:
$dbh=DBI-connect($tns,$connect,'',{ ora_session_mode = 2})
Mike Bacovcin
Unix and Database administrator
Ch2mhill
[EMAIL PROTECTED]
720.286.2038
Re: Oracle dbi ?
What user are you conneted as when you try to shut down the database?
I've used shutdown, shutdown imediate, and in worst cases shutdown abort
to stop an Oracle database. This has been the method (sql ) from 8i
forward.
Kevin
[EMAIL PROTECTED] wrote:
Since shutdown is not a sql command, has anyone figured out how to
shutdown a 8.1.7 or higher database
When you connect with:
$dbh=DBI-connect($tns,$connect,'',{ ora_session_mode = 2})
Mike Bacovcin
Unix and Database administrator
Ch2mhill
[EMAIL PROTECTED]
720.286.2038
Re: (Fwd) DBD module install problem
Try setting your LD_LIBRARY_PATH variable. my %env_info = ( ORACLE_HOME = /home/oracle/product/9ias, LD_LIBRARY_PATH = /home/oracle/product/9ias/lib ); Kevin Tim Bunce wrote: - Forwarded message from Nigel Henden [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] From: Nigel Henden [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: DBD module install problem Date: Tue, 21 Oct 2003 13:21:42 +0900 Tim, I have installed Solaris 9, with all the recent patches on an Ultra 2 - Test box. I then installed Oracle 9i second release, 64 bit. I downloaded and built from source the lastest Perl from CPAN. I built it with gcc compiler which was built as a 64 bit binary. Also make is a 64 bit compiled binary. Well, Perl gave no errors or warnings for make and make test. I was able to add the DBI module for Oracle, with no problem, but when I during the make of DBD I get this warning and an error message, and am unable to install it. I followed all the advice in the Perl for Oracle DBAs book, but am at a loss. Here is the message I get: WARNING: can't access blib/arch/auto/DBD/Oracle/Oracle.so Any help would be grately appreciated. Thank you. N.D.H. ___ Based on the height above sea level, which South American city is the highest capital city in the world? Find out at postmaster.co.uk http://www.postmaster.co.uk/cgi-bin/meme/quiz.pl?id=184 - End forwarded message -
Re: DBD-Oracle fails to install
Question:
The newer versions of Oracle on LINUX are 32 bit and will be so for a
while. There are 64 bit versions for LINUX as well. Hopefully the new
DBD-Oracle will be backwards compatible. Will this be the case Tim?
Kevin
Harter, Douglas wrote:
This problem is becoming more and more of a faq. I talked to Tim, the maintainer of
DBD-Oracle and he said there is
a new release in the works.
Your problem is caused because Oracle 9.2.0 uses 64 bit. This is what caused your 'wrong ELF class' error. You will have to go thru the Makefile and change every instance of 9.2.0/lib to 9.2.0/lib32. I also got a problem because there are 2 -o options in some of the commands. (-o build and -o file-name). I had to delete the '-o build' options from the makefile also. It then did a good make for me and I was able to make install. Oraperl seems to work OK, but I am not sure whether removing the -o build will cause problems down the road. That question was asked on the list once before, but I have not found an answer.
-Original Message-
From: Gulcsi Tams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:47 AM
To: [EMAIL PROTECTED]
Subject: DBD-Oracle fails to install
Dear Sir,
I've used your DBI-1.38 and DBD-Oracle-1.14 on AIX 4.3,
Oracle Database 8.1.7 without any problems (except for the
perl shipped with that ancient AIX, but that's another story).
Now the machine was upgraded: got AIX 5.2 with perl 5.8.0 and
Oracle Database 9.2.0 and DBI installs without notice, but
DBD-Oracle aborts with som linking problems about Oracle.so
The same is produced on a Sun UltraSparc 10 with Solaris 9,
perl 5.6.1 - here is the log file of the install of DBD-1.12
('cause CPAN says this had been tested on Solaris):
perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1)
configuration:
Platform:
osname=solaris, osvers=2.9, archname=sun4-solaris-64int
uname='sunos localhost 5.9 sun4u sparc sunw,ultra-1'
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=define use64bitall=undef uselongdouble=undef
Compiler:
cc='cc', ccflags ='-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-xO3 -xdepend',
cppflags=''
ccversion='Sun WorkShop', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
d_longlong=define, longlongsize=8, d_longdbl=define,
longdblsize=16
ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t', lseeksize=8
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef,
ccdlflags='-R /usr/perl5/5.6.1/lib/sun4-solaris-64int/CORE'
cccdlflags='-KPIC', lddlflags='-G'
Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_LARGE_FILES
Locally applied patches:
9676 Port the OpenBSD glob() security patch
9678 Addendum to #9676: some missing changes from OpenBSD glob.c
9679 Up $File::Glob::VERSION, add OpenBSD glob version note
9693 $VERSION and Version() on same line provokes CPAN.pm warning
9706 #7210 broke .packlist generation
9707 ExtUtils::Installed doesn't quote regex
metacharacters in paths
9775 Typo in utf8.h
9950 Revert integration of #8254,#8255 in #8620 (causes coredump)
10021 Insecure regexes
10091 $ref1 == $ref2 behaves unpredictably if not NV_PRESERVES_UV
10093 Incorrect line numbers in AutoSplit
10100 [20010514.027] PL_last_in_gv may not be GV if stale
filehandle
10145 [20010515.004] Segfaults from premature GC
10203 Don't think about UTF8
10250 [20010422.005] perl -e '{s//${}/; //}' segfaults
10394 Leakage of file scope lexicals into predeclared subroutines
10404 eval.t was relying on pre-#10394 buggy behavior
10412 Rationalize locale handling to fix bugs uncovered by #10394
10422 Potential buffer overrun if the radix separator 1 byte
10448 Lexicals outside eval weren't resolved correctly pre-#10394
10450 Optimize #10448 slightly
10543 Add LC_MESSAGES constant to POSIX module
10667 #10449 broke visibility of lexicals inside DB::DB()
10739 Ceval /x$\r\n/x fails to compile correctly
10939 Proposed fix for Pod::Man
11169 Doc patch for Tie::Hash
11374 Make h2ph grok ccsymbols fo the form 1234L, 1234ULL etc
11427 t/harness wasn't picking up all the tests
11428 run/runenv.t needs fflushNULL sanity
11431 pod/*.t tests not picked up by t/TEST either
11510 eval 'format foo=' would loop indefinitely
11713 UTF8 wasn't printing for PVMGs
11716 UTF8 flag should be meaningful only when POK
Apache/Perl/Oracle9i
Hi All I'm attempting to use perl DBI/DBD in a .cgi script to access an oracle database. I can run the script using perl file.cgi successfully but when I attempt to execute the same cgi script through apache I receive the following: Software error: install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206. at (eval 4) line 3 Compilation failed in require at (eval 4) line 3. Perhaps a required shared library or dll isn't installed where expected at /home/httpd/cgi-bin/signup.cgi line 32 Are there environment variables I need to set to find the path to this file, if so, where can I find a list of these variables. The install of DBI and DBD were successful. Also, the oracle files/shared library files are indeed where they are supposed to be. Thanks for any help. Kevin
