Re: DBD-Oracle on AIX
I went through this and checked the patch and it was not fully applied I have patched trunk and your can find it here http://svn.perl.org/modules/dbd-oracle/trunk Please note It will be release in 1.28 not 1.27 Cheers John Scoles On Tue, Sep 14, 2010 at 6:48 PM, John R Pierce wrote: > On 09/14/10 6:58 AM, John Scoles wrote: > >> On 9/14/2010 9:17 AM, John R Pierce wrote: >> >>> Sorry, I meant, the make test problems with t/58object on big endian >>> machines like Sparc, IBM Power >>> >> >> Ok that clears it up a little. >> >> I am not sure if it was fixed yet. >> >> Give the latest trunk version a try and see what happens. Just a side >> note if you are not using VARRY, TABLE or OBJECT in your tables you can >> ignore this failure as you will never hit it. >> > > yup, aware thats the case, and yes, we've been ignoring the failure as the > perl programs in question are truly ancient and wouldn't know what these > things are if they bit them :) > > I'll try and find the time to get around to building this again from trunk > and seeing whether or not it recurs. > > > -- >From the Pythian family to yours, Happy Holidays and all the best in 2011!
Re: DBD-Oracle on AIX
On 09/14/10 6:58 AM, John Scoles wrote: On 9/14/2010 9:17 AM, John R Pierce wrote: Sorry, I meant, the make test problems with t/58object on big endian machines like Sparc, IBM Power Ok that clears it up a little. I am not sure if it was fixed yet. Give the latest trunk version a try and see what happens. Just a side note if you are not using VARRY, TABLE or OBJECT in your tables you can ignore this failure as you will never hit it. yup, aware thats the case, and yes, we've been ignoring the failure as the perl programs in question are truly ancient and wouldn't know what these things are if they bit them :) I'll try and find the time to get around to building this again from trunk and seeing whether or not it recurs.
Re: DBD-Oracle on AIX
On 9/14/2010 9:17 AM, John R Pierce wrote: On 09/14/10 5:35 AM, John Scoles wrote: Did this ever get tested and entered into the DBD-Oracle release ? This issue has surfaced at work, so I can probably try testing your patches some time in the next week or so, possibly on both sparc and aix/power platforms, but if someone else has already done this and I missed it, I'd as soon not duplicate the effort To which issue are you referring the hack to the make file or the problem with t/58object.t? Sorry, I meant, the make test problems with t/58object on big endian machines like Sparc, IBM Power Ok that clears it up a little. I am not sure if it was fixed yet. Give the latest trunk version a try and see what happens. Just a side note if you are not using VARRY, TABLE or OBJECT in your tables you can ignore this failure as you will never hit it. Cheers John Scoles
Re: DBD-Oracle on AIX
On 09/14/10 5:35 AM, John Scoles wrote: Did this ever get tested and entered into the DBD-Oracle release ? This issue has surfaced at work, so I can probably try testing your patches some time in the next week or so, possibly on both sparc and aix/power platforms, but if someone else has already done this and I missed it, I'd as soon not duplicate the effort To which issue are you referring the hack to the make file or the problem with t/58object.t? Sorry, I meant, the make test problems with t/58object on big endian machines like Sparc, IBM Power
Re: DBD-Oracle on AIX
On 9/14/2010 12:41 AM, John R Pierce wrote: On 05/18/10 9:41 AM, Charles Jardine wrote: On 17/05/10 23:05, John R Pierce wrote: I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using IBM XL C v11.1 + the latest PTF. to build DBD-Oracle, i had to hack the makefile slightly to remove a bogus -q32 from the LD commands, this per the README.aix.txt notes, otherwise my build is pretty much bog stock. Since I used cc_r to compile perl (per the Perl readmes for AIX) I also used this variant of the compiler for DBD-Oracle... Its failing just one test t/58object.t ... make test output is below... I don't know how to resolve this. The description of ORA-24334 is darn cryptic. There are problems with the support for objects on big endian platforms. http://www.mail-archive.com/dbi-users@perl.org/msg32902.html is a previous report for Sparc Solaris. The patches in the mail archive are mangled, much like your test output. I have attached two patches from that thread. I expect that sparc_patch will fix your immediate problem, allowing t/58object.t to get further, and report another test failure. sparc_patch2 may fix this second problem. I would like to know either way. I have no big endian hardware on which to test these patches. Did this ever get tested and entered into the DBD-Oracle release ? This issue has surfaced at work, so I can probably try testing your patches some time in the next week or so, possibly on both sparc and aix/power platforms, but if someone else has already done this and I missed it, I'd as soon not duplicate the effort To which issue are you referring the hack to the make file or the problem with t/58object.t? cheers John
Re: DBD-Oracle on AIX
On 05/18/10 9:41 AM, Charles Jardine wrote: On 17/05/10 23:05, John R Pierce wrote: I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using IBM XL C v11.1 + the latest PTF. to build DBD-Oracle, i had to hack the makefile slightly to remove a bogus -q32 from the LD commands, this per the README.aix.txt notes, otherwise my build is pretty much bog stock. Since I used cc_r to compile perl (per the Perl readmes for AIX) I also used this variant of the compiler for DBD-Oracle... Its failing just one test t/58object.t ... make test output is below... I don't know how to resolve this. The description of ORA-24334 is darn cryptic. There are problems with the support for objects on big endian platforms. http://www.mail-archive.com/dbi-users@perl.org/msg32902.html is a previous report for Sparc Solaris. The patches in the mail archive are mangled, much like your test output. I have attached two patches from that thread. I expect that sparc_patch will fix your immediate problem, allowing t/58object.t to get further, and report another test failure. sparc_patch2 may fix this second problem. I would like to know either way. I have no big endian hardware on which to test these patches. Did this ever get tested and entered into the DBD-Oracle release ? This issue has surfaced at work, so I can probably try testing your patches some time in the next week or so, possibly on both sparc and aix/power platforms, but if someone else has already done this and I missed it, I'd as soon not duplicate the effort
Re: DBD-Oracle on AIX
On 17/05/10 23:05, John R Pierce wrote:
> I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM
> AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using IBM XL
> C v11.1 + the latest PTF.
>
> to build DBD-Oracle, i had to hack the makefile slightly to remove a
> bogus -q32 from the LD commands, this per the README.aix.txt notes,
> otherwise my build is pretty much bog stock. Since I used cc_r to
> compile perl (per the Perl readmes for AIX) I also used this variant of
> the compiler for DBD-Oracle...
>
> Its failing just one test t/58object.t ... make test output is
> below... I don't know how to resolve this. The description of
> ORA-24334 is darn cryptic.
There are problems with the support for objects on big endian
platforms. http://www.mail-archive.com/dbi-users@perl.org/msg32902.html
is a previous report for Sparc Solaris. The patches in the mail archive
are mangled, much like your test output. I have attached two patches
from that thread.
I expect that sparc_patch will fix your immediate problem, allowing
t/58object.t to get further, and report another test failure.
sparc_patch2 may fix this second problem. I would like to know
either way.
I have no big endian hardware on which to test these patches.
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.ukTel: +44 1223 334506, Fax: +44 1223 334679
diff -r -u DBD-Oracle-1.24/dbdimp.h DBD-Oracle-1.24.patched/dbdimp.h
--- DBD-Oracle-1.24/dbdimp.h2010-01-18 13:32:54.0 +
+++ DBD-Oracle-1.24.patched/dbdimp.h2010-04-19 15:17:18.871847234 +0100
@@ -158,7 +158,7 @@
OCIType *obj_type; /*if an embeded
object this is the OCIType returned by a OCIObjectPin*/
ub1 is_final_type; /*object's
OCI_ATTR_IS_FINAL_TYPE*/
fbh_obj_t *fields;/*one object
for each field/property*/
- int field_count;/*The number of
fields Not really needed but nice to have*/
+ ub2 field_count;/*The number of
fields Not really needed but nice to have*/
fbh_obj_t *next_subtype; /*There is strored
information about subtypes for inteherited objects*/
AV *value; /*The
value to send back to Perl This way there are no memory leaks*/
SV *full_type_name;/*Perl value of
full type name = schema_name "." type_name*/
diff -r -u DBD-Oracle-1.24/oci8.c DBD-Oracle-1.24.patched/oci8.c
--- DBD-Oracle-1.24/oci8.c 2010-01-28 15:27:54.0 +
+++ DBD-Oracle-1.24.patched/oci8.c 2010-04-23 11:34:34.013185166 +0100
@@ -2034,6 +2034,7 @@
textstr_buf[200];
double dnum;
size_t str_len;
+ ub4 ub4_str_len;
OCIRaw *raw= (OCIRaw *) 0;
OCIString *vs = (OCIString *) 0;
ub1 *temp = (ub1 *)0;
@@ -2057,7 +2058,7 @@
fbh->imp_sth->errhp,
attr_value,
str_buf,
- 200,
+ (size_t)200,
&str_len,
status);
str_buf[str_len+1] = '\0';
@@ -2069,9 +2070,9 @@
case OCI_TYPECODE_TIMESTAMP :
- str_len = 200;
+ ub4_str_len = 200;
OCIDateTimeToText_log_stat(fbh->imp_sth->envhp,
-
fbh->imp_sth->errhp,attr_value,&str_len,str_buf,status);
+
fbh->imp_sth->errhp,attr_value,&ub4_str_len,str_buf,status);
if (typecode == OCI_TYPECODE_TIMESTAMP_TZ || typecode ==
OCI_TYPECODE_TIMESTAMP_LTZ){
char s_tz_hour[3]="000";
@@ -2093,19 +2094,19 @@
sprintf(s_tz_min,":%02d", tz_minute);
strcat((signed char*)str_buf, s_tz_hour);
strcat((signed char*)str_buf, s_tz_min);
- str_buf[str_len+7] = '\0';
+ str_buf[ub4_str_len+7] = '\0';
} else {
- str_buf[str_len+1] = '\0';
+ str_buf[ub4_str_len+1] = '\0';
}
av_push(list, newSVpv( (char *) str_buf,0));
break;
case OCI_TYPECODE_DATE :
/* fixed length string*/
-
Re: DBD-Oracle on AIX
John R Pierce wrote: ugh, the make test output came out unreadable, lets try again... dang. one last time, and if this fails, I dunno whats going on, I'm copy/pasting this from my ssh session into this email. the important part is ... t/58object.t 1/51 DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for Statement "select * from dbd_test__obj_table order by id"] at t/58object.t line 116. t/58object.t Dubious, test returned 255 (wstat 65280, 0xff00) Failed 46/51 subtests $ make test PERL_DL_NONLAZY=1 /opt/fis/perl5/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/01base.t .. # Test loading DBI, DBD::Oracle and version t/01base.t .. ok t/10general.t ... ok t/12impdata.t ... ok t/14threads.t ... ok t/15nls.t ... ok t/20select.t ok t/21nchar.t . ok t/22nchar_al32utf8.t ok t/22nchar_utf8.t ok t/23wide_db.t ... ok t/23wide_db_8bit.t .. ok t/23wide_db_al32utf8.t .. ok t/24implicit_utf8.t . ok t/25plsql.t . ok t/26exe_array.t . ok t/28array_bind.t ok t/30long.t .. ok t/31lob.t ... ok t/31lob_extended.t .. ok t/32xmltype.t ... ok t/34pres_lobs.t . ok t/40ph_type.t ... 1/19 Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version. Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x Your system doesn't. If that seems odd, let us know. t/40ph_type.t ... ok t/50cursor.t ok t/51scroll.t ok t/55nested.t ok t/56embbeded.t .. ok t/58object.t 1/51 DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for Statement "select * from dbd_test__obj_table order by id"] at t/58object.t line 116. t/58object.t Dubious, test returned 255 (wstat 65280, 0xff00) Failed 46/51 subtests t/60reauth.t skipped: ORACLE_USERID_2 not defined. t/70meta.t .. ok t/80ora_charset.t ... ok Test Summary Report --- t/58object.t (Wstat: 65280 Tests: 5 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 51 tests but ran 5. Files=30, Tests=2227, 16 wallclock secs ( 0.58 usr 0.06 sys + 7.31 cusr 0.99 csys = 8.94 CPU) Result: FAIL Failed 1/30 test programs. 0/2227 subtests failed. make: 1254-004 The error code from the last command is 255. Stop.
Re: DBD-Oracle on AIX
John R Pierce wrote: I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using IBM XL C v11.1 + the latest PTF. to build DBD-Oracle, i had to hack the makefile slightly to remove a bogus -q32 from the LD commands, this per the README.aix.txt notes, otherwise my build is pretty much bog stock. Since I used cc_r to compile perl (per the Perl readmes for AIX) I also used this variant of the compiler for DBD-Oracle... Its failing just one test t/58object.t ... make test output is below... I don't know how to resolve this. The description of ORA-24334 is darn cryptic. ugh, the make test output came out unreadable, lets try again... $ make test PERL_DL_NONLAZY=1 /opt/fis/perl5/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/01base.t .. # Test loading DBI, DBD::Oracle and version t/01base.t .. ok t/10general.t ... ok t/12impdata.t ... ok t/14threads.t ... ok t/15nls.t ... ok t/20select.t ok t/21nchar.t . ok t/22nchar_al32utf8.t ok t/22nchar_utf8.t ok t/23wide_db.t ... ok t/23wide_db_8bit.t .. ok t/23wide_db_al32utf8.t .. ok t/24implicit_utf8.t . ok t/25plsql.t . ok t/26exe_array.t . ok t/28array_bind.t ok t/30long.t .. ok t/31lob.t ... ok t/31lob_extended.t .. ok t/32xmltype.t ... ok t/34pres_lobs.t . ok t/40ph_type.t ... 1/19 Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version. Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x Your system doesn't. If that seems odd, let us know. t/40ph_type.t ... ok t/50cursor.t ok t/51scroll.t ok t/55nested.t ok t/56embbeded.t .. ok t/58object.t 1/51 DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for Statement "select * from dbd_test__obj_table order by id"] at t/58object.t line 116. t/58object.t Dubious, test returned 255 (wstat 65280, 0xff00) Failed 46/51 subtests t/60reauth.t skipped: ORACLE_USERID_2 not defined. t/70meta.t .. ok t/80ora_charset.t ... ok Test Summary Report --- t/58object.t (Wstat: 65280 Tests: 5 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 51 tests but ran 5. Files=30, Tests=2227, 16 wallclock secs ( 0.58 usr 0.06 sys + 7.31 cusr 0.99 csys = 8.94 CPU) Result: FAIL Failed 1/30 test programs. 0/2227 subtests failed. make: 1254-004 The error code from the last command is 255. Stop.
DBD-Oracle on AIX
I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using IBM XL C v11.1 + the latest PTF. to build DBD-Oracle, i had to hack the makefile slightly to remove a bogus -q32 from the LD commands, this per the README.aix.txt notes, otherwise my build is pretty much bog stock. Since I used cc_r to compile perl (per the Perl readmes for AIX) I also used this variant of the compiler for DBD-Oracle... Its failing just one test t/58object.t ... make test output is below... I don't know how to resolve this. The description of ORA-24334 is darn cryptic. $ make test PERL_DL_NONLAZY=1 /opt/fis/perl5/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/01base.t .. # Test loading DBI, DBD::Oracle and version t/01base.t .. ok t/10general.t ... ok t/12impdata.t ... ok t/14threads.t ... ok t/15nls.t ... ok t/20select.t ok t/21nchar.t . ok t/22nchar_al32utf8.t ok t/22nchar_utf8.t ok t/23wide_db.t ... ok t/23wide_db_8bit.t .. ok t/23wide_db_al32utf8.t .. ok t/24implicit_utf8.t . ok t/25plsql.t . ok t/26exe_array.t . ok t/28array_bind.t ok t/30long.t .. ok t/31lob.t ... ok t/31lob_extended.t .. ok t/32xmltype.t ... ok t/34pres_lobs.t . ok t/40ph_type.t ... 1/19 Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version. Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x Your system doesn't. If that seems odd, let us know. t/40ph_type.t ... ok t/50cursor.t ok t/51scroll.t ok t/55nested.t ok t/56embbeded.t .. ok t/58object.t 1/51 DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for Statement "select * from dbd_test__obj_table order by id"] at t/58object.t line 116. t/58object.t Dubious, test returned 255 (wstat 65280, 0xff00) Failed 46/51 subtests t/60reauth.t skipped: ORACLE_USERID_2 not defined. t/70meta.t .. ok t/80ora_charset.t ... ok Test Summary Report --- t/58object.t (Wstat: 65280 Tests: 5 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 51 tests but ran 5. Files=30, Tests=2227, 16 wallclock secs ( 0.58 usr 0.06 sys + 7.31 cusr 0.99 csys = 8.94 CPU) Result: FAIL Failed 1/30 test programs. 0/2227 subtests failed. make: 1254-004 The error code from the last command is 255. Stop. and, my perl looks like... $ perl -V Summary of my perl5 (revision 5 version 12 subversion 0) configuration: Platform: osname=aix, osvers=6.1.0.0, archname=aix-thread-multi uname='aix my-power520 1 6 00c5e4454c00 ' config_args='-d -Dcc=cc_r -Duseshrplib -Dusethreads -Dprefix=/opt/fis/perl5' hint=recommended, useposix=true, d_sigaction=define useithreads=define, usemultiplicity=define useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=undef, use64bitall=undef, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='cc_r -q32', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong', optimize='-O', cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT' ccversion='11.1.0.1', gccversion='', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='ld', ldflags =' -brtl -bdynamic -b32 -bmaxdata:0x8000' libpth=/lib /usr/lib /usr/ccs/lib libs=-lbind -lnsl -ldbm -ldb -ldl -lld -lm -lcrypt -lpthreads -lc perllibs=-lbind -lnsl -ldl -lld -lm -lcrypt -lpthreads -lc libc=/lib/libc.a, so=a, useshrplib=true, libperl=libperl.a gnulibc_version='' Dynamic Linking: dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -bE:/opt/fis/perl5/lib/5.12.0/aix-thread-multi/CORE/perl.exp' cccdlflags=' ', lddlflags='-bhalt:4 -G -bI:$(PERL_INC)/perl.exp -bE:$(BASEEXT).exp -bnoentry -lpthreads -lc -lm' Characteristics of this binary (from libperl): Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_ITHREADS USE_LARGE_FILES USE_PERLIO USE_PERL_ATOF USE_REENTRANT_API Built under aix Compiled at May 12 2010 18:06:22 @INC:
Re: DBI use failure with DBI/DBD::Oracle on AIX 5.2
On 11/26/2004 08:14 AM, Chris Holt said: Thanks , I needed some one to tell me it was definately permissions. It made me look harder at the perms on higher level directories. Now I'll look at my connection problem . Can't connect to data source exua, no database driver specified and DBI_DSN env var not set at ./ora.pl line 24 The example you sent earlier does specify a driver in "dbi:Oracle:$dbname". You'll have to show what you are actually using for anyone to give a better hint. Please keep this on list. I am not the sole source of all wisdom. -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Cthulhu in 2004. Don't settle for the lesser evil.
Re: DBI use failure with DBI/DBD::Oracle on AIX 5.2
On 11/25/2004 08:03 AM, Chris Holt said:
After being prepped by experiences of others in the README.aix
> file. I beleive (see below), I have a good installation. But
> on running my fist test prog I appear to have a permissions
> problem. This litlle ditty does not fail when run as root,
> but anyone else and it aborts on the 'use DBI;'.
That is certainly an indication that you don't have permission for
something. Especially since root succeeds.
$ cat ora.pl
#!/bin/perl -w
use DBI;
use strict;
my ($dbname, $user, $passwd) = ('exua', 'remote', 'remote');
#$dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd);
#$dbh->do("SELECT * FROM DUAL");
$
$ ./ora.pl
Can't locate loadable object for module DBI in @INC
> (@INC contains: /usr/opt/perl5/lib/5.8.0/aix-thread-multi
> /usr/opt/perl5/lib/5.8.0
> /usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi
> /usr/opt/perl5/lib/site_perl/5.8.0
> /usr/opt/perl5/lib/site_perl .) at
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBI.pm line 254
BEGIN failed--compilation aborted at
> /usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBI.pm line 254.
Compilation failed in require at ./ora.pl line 3.
BEGIN failed--compilation aborted at ./ora.pl line 3.
...
permissions on the directories and files under /usr/opt/perl5 appear
> to be OK, at least world readable. Any ideas?
DBI.so is executable which was my first guess at the problem, make sure
the directories have executable permisson for you too.
...
364664 260 -r-xr-xr-x 1 root exua 264738 Nov 25 10:14
>/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/DBI.so
--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Cthulhu in 2004. Don't settle for the lesser evil.
DBI use failure with DBI/DBD::Oracle on AIX 5.2
After being prepped by experiences of others in the README.aix file. I beleive
(see below), I have a good installation. But on running my fist test prog I
appear to have a permissions problem. This litlle ditty does not fail when run
as root, but anyone else and it aborts on the 'use DBI;'.
$ cat ora.pl
#!/bin/perl -w
use DBI;
use strict;
my ($dbname, $user, $passwd) = ('exua', 'remote', 'remote');
#$dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd);
#$dbh->do("SELECT * FROM DUAL");
$
$ ./ora.pl
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/opt/perl5/lib/5.8.0/aix-thread-multi /usr/opt/perl5/lib/5.8.0
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi
/usr/opt/perl5/lib/site_perl/5.8.0 /usr/opt/perl5/lib/site_perl .) at
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBI.pm line 254
BEGIN failed--compilation aborted at
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBI.pm line 254.
Compilation failed in require at ./ora.pl line 3.
BEGIN failed--compilation aborted at ./ora.pl line 3.
$
permissions on the directories and files under /usr/opt/perl5 appear to be OK,
at least world readable. Any ideas?
Perl info
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=aix, osvers=5.2.0.0, archname=aix-thread-multi
uname='aix rocky 2 5 000ad7df4c00 '
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc_r', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES -qlonglong',
optimize='-O',
cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT'
ccversion='', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -brtl -b32'
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lbind -lnsl -ldbm -ldl -lld -lm -lpthreads -lc_r -lcrypt -lbsd -lPW
perllibs=-lbind -lnsl -ldl -lld -lm -lpthreads -lc_r -lcrypt -lbsd -lPW
libc=/lib/libc.a, so=a, useshrplib=true, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='
-bE:/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE/perl.exp'
cccdlflags=' ', lddlflags='-bhalt:4 -bM:SRE -bI:$(PERL_INC)/perl.exp
-bE:$(BASEEXT).exp -bnoentry -lpthreads -lc_r'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_CONTEXT
Built under aix
Compiled at Jul 26 2002 13:48:15
@INC:
/usr/opt/perl5/lib/5.8.0/aix-thread-multi
/usr/opt/perl5/lib/5.8.0
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi
/usr/opt/perl5/lib/site_perl/5.8.0
/usr/opt/perl5/lib/site_perl
.
***
The BUILD
using
ORACENV=xlc_r
ORACLE_APPS=/data/exua/usr
ORACLE_HOME=/applications/ora92/app/oracle/product/9.2.0
ORACLE_PATH=/data/exua/usr/oraexe:/applications/mgua/release/bin:/applications/ora92/app/oracle/product/9.2.0/bin
ORACLE_SID=exua
ORACLE_USERID=remote/remote
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBI-1.46: perl
Makefile.PL
*** You are using a perl configured with threading enabled.
*** You should be aware that using multiple threads is
*** not recommended for production environments.
Creating DBI::PurePerltest variant: t/zvpp_01basics.t
Creating DBI::PurePerltest variant: t/zvpp_02dbidrv.t
Creating DBI::PurePerltest variant: t/zvpp_03handle.t
Creating DBI::PurePerltest variant: t/zvpp_04mods.t
Creating DBI::PurePerltest variant: t/zvpp_05thrclone.t (use threads)
Creating DBI::PurePerltest variant: t/zvpp_06attrs.t
Creating DBI::PurePerltest variant: t/zvpp_07kids.t
Creating DBI::PurePerltest variant: t/zvpp_08keeperr.t
Creating DBI::PurePerltest variant: t/zvpp_09trace.t
Creating DBI::PurePerltest variant: t/zvpp_10examp.t
Creating DBI::PurePerltest variant: t/zvpp_14utf8.t
Creating DBI::PurePerltest variant: t/zvpp_15array.t
Creating DBI::PurePerltest variant: t/zvpp_20meta.t
Creating DBI::PurePerltest variant: t/zvpp_30subclass.t
Creating DBI::PurePerltest variant: t/zvpp_40profile.t
Creating DBI::PurePerltest variant: t/zvpp_41prof_dump.t
Creating DBI::PurePerltest variant: t/zvp
RE: make fails with "ld: cannot open libgcc.a" for DBD::Oracle on AIX 5.1, gcc
Hi, We installed perl 5.8 & DBI & DBD using the same platform u mentioned. AIX 5.2 Oracle 9.2.0.2 perl v5.8.3 DBI 1.41 DBD-Oracle 1.15 But we never succeeded using "gcc". Try to install everything (perl & DBI & DBD ) using xlc_r. You can find xlc_r trial versions...then u can buy the original if u r interested -Sudhahar -Original Message- From: Vonnahme, Nathan [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 11:26 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: make fails with "ld: cannot open libgcc.a" for DBD::Oracle on AIX 5.1, gcc Hi, I'm trying to get DBD::Oracle to compile using AIX 5.1 Oracle 8.1.7.4 gcc 2.9-aix51-020209 perl v5.8.3 DBI 1.41 I compiled this perl and DBI with gcc just fine. Other CPAN modules compile OK with gcc. We don't have xlc or cc compilers; is this even possible? I've tried setting the LIB/LIBHOME/LIBPATH env vars to where libgcc.a lives, and I've tried including that path in Oracle's sysliblist file. I suspected make was using AIX's ld so I symlinked ld to gld (GNU ld) but I get the same error either way. Help? Here's the output of perl Makefile.PL && make: 08:56:09 /tmp/cpan/build/DBD-Oracle-1.15 # root:@fai02020 # perl Makefile.PL Using DBI 1.41 (for perl 5.008003 on aix) installed in /usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u01/oracle/product/8.1.7.4 Oracle version 8.1.7.0.0 (8.107) Found /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Found /u01/oracle/product/8.1.7.4/otrace/demo/atmoci.mk Using /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/product/8.1.7.4/rdbms/lib/env_rdbms.mk Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Attempting to discover Oracle OCI build rules gcc-c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c by executing: [make -f /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o] Oracle oci build command: [-L/u01/oracle/product/8.1.7.4/lib/ -L/u01/oracle/product/8.1.7.4/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o /u01/oracle/product/8.1.7.4/rdbms/lib/kpudfo.o /u01/oracle/product/8.1.7.4/lib/nautab.o /u01/oracle/product/8.1.7.4/lib/naeet.o /u01/oracle/product/8.1.7.4/lib/naect.o /u01/oracle/product/8.1.7.4/lib/naedhs.o -lclntsh /u01/oracle/product/8.1.7.4/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lld -lm /lib/crt0_r.o -ldl -lc -lpthreads -lodm -lm -lbsd_r -lld -lm -bI:/u01/oracle/product/8.1.7.4/lib/pw-syscall.exp -bI:/u01/oracle/product/8.1.7.4/lib/ksms.imp -lpthreads] Found header files in rdbms/public rdbms/demo. Checking for functioning wait.ph System: perl5.008003 aix fai02020 1 5 000470bf4c00 Compiler: gcc -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -D_LARGE_FILES Linker: /opt/freeware/GNUPro/bin/ld Sysliblist: /lib/crt0_r.o -ldl -lc -lpthreads -lodm -lm -lbsd_r -lld Oracle makefiles would have used these definitions but we override them: CC: $(ORACLE_HOME)/bin/oraxlc $(ORAXLCFLAGS) CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) [$(GFLAG) -O3 $(CDEBUG) $(QACCFLAGS) -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/plsql/public -I/u01/oracle/product/8.1.7.4/network/public $(SPFLAGS) $(LPFLAGS) $(USRFLAGS)] LDFLAGS: -L$(LIBHOME) -L$(RDBMSLIB) [-L$(LIBHOME) -L/u01/
make fails with "ld: cannot open libgcc.a" for DBD::Oracle on AIX 5.1, gcc
Hi, I'm trying to get DBD::Oracle to compile using AIX 5.1 Oracle 8.1.7.4 gcc 2.9-aix51-020209 perl v5.8.3 DBI 1.41 I compiled this perl and DBI with gcc just fine. Other CPAN modules compile OK with gcc. We don't have xlc or cc compilers; is this even possible? I've tried setting the LIB/LIBHOME/LIBPATH env vars to where libgcc.a lives, and I've tried including that path in Oracle's sysliblist file. I suspected make was using AIX's ld so I symlinked ld to gld (GNU ld) but I get the same error either way. Help? Here's the output of perl Makefile.PL && make: 08:56:09 /tmp/cpan/build/DBD-Oracle-1.15 # root:@fai02020 # perl Makefile.PL Using DBI 1.41 (for perl 5.008003 on aix) installed in /usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u01/oracle/product/8.1.7.4 Oracle version 8.1.7.0.0 (8.107) Found /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Found /u01/oracle/product/8.1.7.4/otrace/demo/atmoci.mk Using /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/product/8.1.7.4/rdbms/lib/env_rdbms.mk Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Attempting to discover Oracle OCI build rules gcc-c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c by executing: [make -f /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o] Oracle oci build command: [-L/u01/oracle/product/8.1.7.4/lib/ -L/u01/oracle/product/8.1.7.4/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o /u01/oracle/product/8.1.7.4/rdbms/lib/kpudfo.o /u01/oracle/product/8.1.7.4/lib/nautab.o /u01/oracle/product/8.1.7.4/lib/naeet.o /u01/oracle/product/8.1.7.4/lib/naect.o /u01/oracle/product/8.1.7.4/lib/naedhs.o -lclntsh /u01/oracle/product/8.1.7.4/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lld -lm /lib/crt0_r.o -ldl -lc -lpthreads -lodm -lm -lbsd_r -lld -lm -bI:/u01/oracle/product/8.1.7.4/lib/pw-syscall.exp -bI:/u01/oracle/product/8.1.7.4/lib/ksms.imp -lpthreads] Found header files in rdbms/public rdbms/demo. Checking for functioning wait.ph System: perl5.008003 aix fai02020 1 5 000470bf4c00 Compiler: gcc -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -D_LARGE_FILES Linker: /opt/freeware/GNUPro/bin/ld Sysliblist: /lib/crt0_r.o -ldl -lc -lpthreads -lodm -lm -lbsd_r -lld Oracle makefiles would have used these definitions but we override them: CC: $(ORACLE_HOME)/bin/oraxlc $(ORAXLCFLAGS) CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) [$(GFLAG) -O3 $(CDEBUG) $(QACCFLAGS) -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/plsql/public -I/u01/oracle/product/8.1.7.4/network/public $(SPFLAGS) $(LPFLAGS) $(USRFLAGS)] LDFLAGS: -L$(LIBHOME) -L$(RDBMSLIB) [-L$(LIBHOME) -L/u01/oracle/product/8.1.7.4/rdbms/lib/] Linking with OTHERLDFLAGS = -L/u01/oracle/product/8.1.7.4/lib/ -L/u01/oracle/product/8.1.7.4/rdbms/lib/ /u01/oracle/product/8.1.7.4/rdbms/lib/kpudfo.o /u01/oracle/product/8.1.7.4/lib/nautab.o /u01/oracle/product/8.1.7.4/lib/naeet.o /u01/oracle/product/8.1.7.4/lib/naect.o /u01/oracle/product/8.1.7.4/lib/naedhs.o -lclntsh /u01/oracle/product/8.1.7.4/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname
Re: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
On Mon, Feb 23, 2004 at 04:03:44PM +0100, [EMAIL PROTECTED] wrote: > Tim, > > I'm trying it on 5.8 right now. Is there a separate file for a 64-bit > build? Or maybe a newer version? Eh? Tim. > Greetz > Bjorn Naessens > > -Original Message- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: maandag 23 februari 2004 15:03 > To: [EMAIL PROTECTED] > Cc: Bjorn Naessens; [EMAIL PROTECTED] > Subject: Re: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > On Mon, Feb 23, 2004 at 08:47:44AM -0500, Rafael Caceres wrote: > > Bjorn: > > > > No, I abandoned the idea after reading several postings indicating > that > > there were problems with 64 bit perl. > > Can you be more specific? Which version of perl, for example. > > Tim. > > > regards, > > Rafael Caceres > > > > On Mon, 2004-02-23 at 07:59, [EMAIL PROTECTED] wrote: > > > Rafael, > > > > > > Were you ever able to build a full 64-bit perl, DBI and DBD-ORACLE? > > > > > > Kind regards > > > Bjorn Naessens > > > > > > -Original Message----- > > > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > > > Sent: donderdag 19 juni 2003 20:13 > > > To: Bjorn Naessens > > > Cc: [EMAIL PROTECTED] > > > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > > > Bjorn: > > > > > > I intend to write a brief 'howto' with all the details on it, but in > > > short: > > > -use Perl 5.8.0 (the latest stable from CPAN) > > > -use the xlc_r version of IBM's compiler and build 32 bit Perl. All > > > tests should be successfull. > > > -get and install DBI > > > -get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle, > > > changing references to Oracle's ../lib to ../lib32. and change > crt0_64.o > > > to crt0_r.o. Remove the -q32 and/or -q64 options from the list of > > > libraries to link with. Do the make and make test. All tests should > be > > > successfull -against Oracle 9.x at least. > > > You should have no problems with Oracle 8.1.7, but accessing Oracle > 7.x > > > or previous is not possible (you'll core dump, or simply hang). The > same > > > goes for a Linux build or a Digital build, regarding access of > different > > > Oracle versions. > > > > > > I plan to try a full 64 bit build of Perl, DBI and DBD::Oracle next > > > week, and will post results. If you try this route, per Tim Bunce's > > > comment, disregard a DBI test fail on 03handle.pl indicating that > the > > > wrong number of bytes was returned. > > > > > > regards, > > > Rafael Caceres > > > > > > On Wed, 2003-06-18 at 08:42, [EMAIL PROTECTED] wrote: > > > > > > > > Guys, I'm having the same problem atm. I have to install perl on > aix > > > 5l > > > > system for oracle 9.2 and need to stay supported to the other > versions > > > ( > > > > 8.1.7 ). > > > > > > > > So these questions : > > > > 1. Do you guys know where the newest version for aix is located ( > 5.6 > > > on > > > > bull website ) > > > > > > > > 2. Which environment needs to be set before make of Perl, DBI and > > > > DBD:Oracle? > > > > > > > > 3. Which additional parameters are required > > > > > > > > thanks for any help you can offer > > > > > > > > Bjorn Naessens > > > > > > > > -Original Message- > > > > From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] > > > > Sent: dinsdag 17 juni 2003 14:40 > > > > To: 'Rafael Caceres'; [EMAIL PROTECTED] > > > > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > > > > > Yes, use the 32-bit oracle libraries. I will forward a previous > post > > > on > > > > this issue. > > > > > > > > > > > > Thanks, > > > > Sam Gold > > > > > > > > > > > > -Original Message- > > > > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > > > > Sent: Monday, June 16, 2003 6:54 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > > > > > > > > > Friends, I've worked with DBD::Oracle on various Linux and Digital > > > boxes > > > > with no problems. > > > > I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from > > > > scratch: > > > > Perl 5.8.0 built with xlc_r > > > > With this perl, DBI builds and install just fine. The DBD::Oracle > > > build > > > > process stops with a "XCOFF64 files are not allowed in 32-bit > mode". > > > > This has to do with the fact that the OCI interface is 64bit and > > > > libraries like crt0_64.o are included in the DBD::Oracle build. > > > > > > > > The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force > 64 > > > > bits), I get a problem with integer size conversions under DBI, > and > > > DBI > > > > does not build correctly. > > > > > > > > Can anyone point at the 'right' combination of Perl build > parameters > > > to > > > > enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? > > > > > > > > Rafael Caceres > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Tim, I'm trying it on 5.8 right now. Is there a separate file for a 64-bit build? Or maybe a newer version? Greetz Bjorn Naessens -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: maandag 23 februari 2004 15:03 To: [EMAIL PROTECTED] Cc: Bjorn Naessens; [EMAIL PROTECTED] Subject: Re: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 On Mon, Feb 23, 2004 at 08:47:44AM -0500, Rafael Caceres wrote: > Bjorn: > > No, I abandoned the idea after reading several postings indicating that > there were problems with 64 bit perl. Can you be more specific? Which version of perl, for example. Tim. > regards, > Rafael Caceres > > On Mon, 2004-02-23 at 07:59, [EMAIL PROTECTED] wrote: > > Rafael, > > > > Were you ever able to build a full 64-bit perl, DBI and DBD-ORACLE? > > > > Kind regards > > Bjorn Naessens > > > > -Original Message- > > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > > Sent: donderdag 19 juni 2003 20:13 > > To: Bjorn Naessens > > Cc: [EMAIL PROTECTED] > > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > Bjorn: > > > > I intend to write a brief 'howto' with all the details on it, but in > > short: > > -use Perl 5.8.0 (the latest stable from CPAN) > > -use the xlc_r version of IBM's compiler and build 32 bit Perl. All > > tests should be successfull. > > -get and install DBI > > -get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle, > > changing references to Oracle's ../lib to ../lib32. and change crt0_64.o > > to crt0_r.o. Remove the -q32 and/or -q64 options from the list of > > libraries to link with. Do the make and make test. All tests should be > > successfull -against Oracle 9.x at least. > > You should have no problems with Oracle 8.1.7, but accessing Oracle 7.x > > or previous is not possible (you'll core dump, or simply hang). The same > > goes for a Linux build or a Digital build, regarding access of different > > Oracle versions. > > > > I plan to try a full 64 bit build of Perl, DBI and DBD::Oracle next > > week, and will post results. If you try this route, per Tim Bunce's > > comment, disregard a DBI test fail on 03handle.pl indicating that the > > wrong number of bytes was returned. > > > > regards, > > Rafael Caceres > > > > On Wed, 2003-06-18 at 08:42, [EMAIL PROTECTED] wrote: > > > > > > Guys, I'm having the same problem atm. I have to install perl on aix > > 5l > > > system for oracle 9.2 and need to stay supported to the other versions > > ( > > > 8.1.7 ). > > > > > > So these questions : > > > 1. Do you guys know where the newest version for aix is located ( 5.6 > > on > > > bull website ) > > > > > > 2. Which environment needs to be set before make of Perl, DBI and > > > DBD:Oracle? > > > > > > 3. Which additional parameters are required > > > > > > thanks for any help you can offer > > > > > > Bjorn Naessens > > > > > > -Original Message- > > > From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] > > > Sent: dinsdag 17 juni 2003 14:40 > > > To: 'Rafael Caceres'; [EMAIL PROTECTED] > > > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > > > Yes, use the 32-bit oracle libraries. I will forward a previous post > > on > > > this issue. > > > > > > > > > Thanks, > > > Sam Gold > > > > > > > > > -Original Message- > > > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > > > Sent: Monday, June 16, 2003 6:54 PM > > > To: [EMAIL PROTECTED] > > > Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > > > > > > Friends, I've worked with DBD::Oracle on various Linux and Digital > > boxes > > > with no problems. > > > I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from > > > scratch: > > > Perl 5.8.0 built with xlc_r > > > With this perl, DBI builds and install just fine. The DBD::Oracle > > build > > > process stops with a "XCOFF64 files are not allowed in 32-bit mode". > > > This has to do with the fact that the OCI interface is 64bit and > > > libraries like crt0_64.o are included in the DBD::Oracle build. > > > > > > The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 > > > bits), I get a problem with integer size conversions under DBI, and > > DBI > > > does not build correctly. > > > > > > Can anyone point at the 'right' combination of Perl build parameters > > to > > > enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? > > > > > > Rafael Caceres > > > > > > > > > > > > > > > > > > > > > >
Fwd: Re: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Tim, > > On Mon, Feb 23, 2004 at 08:47:44AM -0500, Rafael Caceres wrote: > > > Bjorn: > > > > > > No, I abandoned the idea after reading several postings indicating > > that > > > there were problems with 64 bit perl. > > > > Can you be more specific? Which version of perl, for example. > > > > Tim. > > The following recomendation comes to mind.. > -Original Message- > From: Alan Burlison [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 14, 2003 4:13 AM > To: Richard Felkins > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: DBD::Oracle - wrong ELF class: ELFCLASS64 > > > Richard Felkins wrote: > > > The compiler is the latest version from Sun as Forte or > > I guess it is SunOne now. I had tried to build a 5.8 > > 64 bit Perl a few months back and ran into serious make > > problems and abandoned that idea. I have checked and > > have the sparcv9 version of ld in the path. This Oracle > > is patched to 9.2.0.3.0 currently. > > 64-bit perl does build OK, but unless you need huge (>4Gb) amounts of > data, > I'd recommend you avoid it. > > > I have mixed feelings about forcing it to use the 32 bit > > library set. I'll try this as a last resort work around. > > We are building customer deliverables and need this process > > to be repeatable with documentation on the next CPAN upgrade. > > You won't *ever* get it to link unless you do. I know a patch was > submitted > > for this a while back, and I'm sure Tim has something in the works. > If your > > perl is 32-bit (and as I said I recommend that it is) you will need to > link > against the 32-bit Oracle libraries. There should be absolutely *no* > issue > with running a 32-bit client (e.g. DBD::Oracle) against a 64-bit > Database > server. > > -- > Alan Burlison > -- Regards, Rafael Caceres
Re: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
On Mon, Feb 23, 2004 at 08:47:44AM -0500, Rafael Caceres wrote: > Bjorn: > > No, I abandoned the idea after reading several postings indicating that > there were problems with 64 bit perl. Can you be more specific? Which version of perl, for example. Tim. > regards, > Rafael Caceres > > On Mon, 2004-02-23 at 07:59, [EMAIL PROTECTED] wrote: > > Rafael, > > > > Were you ever able to build a full 64-bit perl, DBI and DBD-ORACLE? > > > > Kind regards > > Bjorn Naessens > > > > -Original Message- > > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > > Sent: donderdag 19 juni 2003 20:13 > > To: Bjorn Naessens > > Cc: [EMAIL PROTECTED] > > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > Bjorn: > > > > I intend to write a brief 'howto' with all the details on it, but in > > short: > > -use Perl 5.8.0 (the latest stable from CPAN) > > -use the xlc_r version of IBM's compiler and build 32 bit Perl. All > > tests should be successfull. > > -get and install DBI > > -get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle, > > changing references to Oracle's ../lib to ../lib32. and change crt0_64.o > > to crt0_r.o. Remove the -q32 and/or -q64 options from the list of > > libraries to link with. Do the make and make test. All tests should be > > successfull -against Oracle 9.x at least. > > You should have no problems with Oracle 8.1.7, but accessing Oracle 7.x > > or previous is not possible (you'll core dump, or simply hang). The same > > goes for a Linux build or a Digital build, regarding access of different > > Oracle versions. > > > > I plan to try a full 64 bit build of Perl, DBI and DBD::Oracle next > > week, and will post results. If you try this route, per Tim Bunce's > > comment, disregard a DBI test fail on 03handle.pl indicating that the > > wrong number of bytes was returned. > > > > regards, > > Rafael Caceres > > > > On Wed, 2003-06-18 at 08:42, [EMAIL PROTECTED] wrote: > > > > > > Guys, I'm having the same problem atm. I have to install perl on aix > > 5l > > > system for oracle 9.2 and need to stay supported to the other versions > > ( > > > 8.1.7 ). > > > > > > So these questions : > > > 1. Do you guys know where the newest version for aix is located ( 5.6 > > on > > > bull website ) > > > > > > 2. Which environment needs to be set before make of Perl, DBI and > > > DBD:Oracle? > > > > > > 3. Which additional parameters are required > > > > > > thanks for any help you can offer > > > > > > Bjorn Naessens > > > > > > -Original Message- > > > From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] > > > Sent: dinsdag 17 juni 2003 14:40 > > > To: 'Rafael Caceres'; [EMAIL PROTECTED] > > > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > > > Yes, use the 32-bit oracle libraries. I will forward a previous post > > on > > > this issue. > > > > > > > > > Thanks, > > > Sam Gold > > > > > > > > > -Original Message- > > > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > > > Sent: Monday, June 16, 2003 6:54 PM > > > To: [EMAIL PROTECTED] > > > Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > > > > > > Friends, I've worked with DBD::Oracle on various Linux and Digital > > boxes > > > with no problems. > > > I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from > > > scratch: > > > Perl 5.8.0 built with xlc_r > > > With this perl, DBI builds and install just fine. The DBD::Oracle > > build > > > process stops with a "XCOFF64 files are not allowed in 32-bit mode". > > > This has to do with the fact that the OCI interface is 64bit and > > > libraries like crt0_64.o are included in the DBD::Oracle build. > > > > > > The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 > > > bits), I get a problem with integer size conversions under DBI, and > > DBI > > > does not build correctly. > > > > > > Can anyone point at the 'right' combination of Perl build parameters > > to > > > enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? > > > > > > Rafael Caceres > > > > > > > > > > > > > > > > > > > > > >
RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Bjorn: No, I abandoned the idea after reading several postings indicating that there were problems with 64 bit perl. regards, Rafael Caceres On Mon, 2004-02-23 at 07:59, [EMAIL PROTECTED] wrote: > Rafael, > > Were you ever able to build a full 64-bit perl, DBI and DBD-ORACLE? > > Kind regards > Bjorn Naessens > > -Original Message- > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > Sent: donderdag 19 juni 2003 20:13 > To: Bjorn Naessens > Cc: [EMAIL PROTECTED] > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > Bjorn: > > I intend to write a brief 'howto' with all the details on it, but in > short: > -use Perl 5.8.0 (the latest stable from CPAN) > -use the xlc_r version of IBM's compiler and build 32 bit Perl. All > tests should be successfull. > -get and install DBI > -get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle, > changing references to Oracle's ../lib to ../lib32. and change crt0_64.o > to crt0_r.o. Remove the -q32 and/or -q64 options from the list of > libraries to link with. Do the make and make test. All tests should be > successfull -against Oracle 9.x at least. > You should have no problems with Oracle 8.1.7, but accessing Oracle 7.x > or previous is not possible (you'll core dump, or simply hang). The same > goes for a Linux build or a Digital build, regarding access of different > Oracle versions. > > I plan to try a full 64 bit build of Perl, DBI and DBD::Oracle next > week, and will post results. If you try this route, per Tim Bunce's > comment, disregard a DBI test fail on 03handle.pl indicating that the > wrong number of bytes was returned. > > regards, > Rafael Caceres > > On Wed, 2003-06-18 at 08:42, [EMAIL PROTECTED] wrote: > > > > Guys, I'm having the same problem atm. I have to install perl on aix > 5l > > system for oracle 9.2 and need to stay supported to the other versions > ( > > 8.1.7 ). > > > > So these questions : > > 1. Do you guys know where the newest version for aix is located ( 5.6 > on > > bull website ) > > > > 2. Which environment needs to be set before make of Perl, DBI and > > DBD:Oracle? > > > > 3. Which additional parameters are required > > > > thanks for any help you can offer > > > > Bjorn Naessens > > > > -Original Message- > > From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] > > Sent: dinsdag 17 juni 2003 14:40 > > To: 'Rafael Caceres'; [EMAIL PROTECTED] > > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > Yes, use the 32-bit oracle libraries. I will forward a previous post > on > > this issue. > > > > > > Thanks, > > Sam Gold > > > > > > -Original Message- > > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 16, 2003 6:54 PM > > To: [EMAIL PROTECTED] > > Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > > > > Friends, I've worked with DBD::Oracle on various Linux and Digital > boxes > > with no problems. > > I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from > > scratch: > > Perl 5.8.0 built with xlc_r > > With this perl, DBI builds and install just fine. The DBD::Oracle > build > > process stops with a "XCOFF64 files are not allowed in 32-bit mode". > > This has to do with the fact that the OCI interface is 64bit and > > libraries like crt0_64.o are included in the DBD::Oracle build. > > > > The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 > > bits), I get a problem with integer size conversions under DBI, and > DBI > > does not build correctly. > > > > Can anyone point at the 'right' combination of Perl build parameters > to > > enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? > > > > Rafael Caceres > > > > > > > > > > > > >
RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Rafael, Were you ever able to build a full 64-bit perl, DBI and DBD-ORACLE? Kind regards Bjorn Naessens -Original Message- From: Rafael Caceres [mailto:[EMAIL PROTECTED] Sent: donderdag 19 juni 2003 20:13 To: Bjorn Naessens Cc: [EMAIL PROTECTED] Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 Bjorn: I intend to write a brief 'howto' with all the details on it, but in short: -use Perl 5.8.0 (the latest stable from CPAN) -use the xlc_r version of IBM's compiler and build 32 bit Perl. All tests should be successfull. -get and install DBI -get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle, changing references to Oracle's ../lib to ../lib32. and change crt0_64.o to crt0_r.o. Remove the -q32 and/or -q64 options from the list of libraries to link with. Do the make and make test. All tests should be successfull -against Oracle 9.x at least. You should have no problems with Oracle 8.1.7, but accessing Oracle 7.x or previous is not possible (you'll core dump, or simply hang). The same goes for a Linux build or a Digital build, regarding access of different Oracle versions. I plan to try a full 64 bit build of Perl, DBI and DBD::Oracle next week, and will post results. If you try this route, per Tim Bunce's comment, disregard a DBI test fail on 03handle.pl indicating that the wrong number of bytes was returned. regards, Rafael Caceres On Wed, 2003-06-18 at 08:42, [EMAIL PROTECTED] wrote: > > Guys, I'm having the same problem atm. I have to install perl on aix 5l > system for oracle 9.2 and need to stay supported to the other versions ( > 8.1.7 ). > > So these questions : > 1. Do you guys know where the newest version for aix is located ( 5.6 on > bull website ) > > 2. Which environment needs to be set before make of Perl, DBI and > DBD:Oracle? > > 3. Which additional parameters are required > > thanks for any help you can offer > > Bjorn Naessens > > -Original Message- > From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] > Sent: dinsdag 17 juni 2003 14:40 > To: 'Rafael Caceres'; [EMAIL PROTECTED] > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > Yes, use the 32-bit oracle libraries. I will forward a previous post on > this issue. > > > Thanks, > Sam Gold > > > -Original Message----- > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > Sent: Monday, June 16, 2003 6:54 PM > To: [EMAIL PROTECTED] > Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > Friends, I've worked with DBD::Oracle on various Linux and Digital boxes > with no problems. > I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from > scratch: > Perl 5.8.0 built with xlc_r > With this perl, DBI builds and install just fine. The DBD::Oracle build > process stops with a "XCOFF64 files are not allowed in 32-bit mode". > This has to do with the fact that the OCI interface is 64bit and > libraries like crt0_64.o are included in the DBD::Oracle build. > > The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 > bits), I get a problem with integer size conversions under DBI, and DBI > does not build correctly. > > Can anyone point at the 'right' combination of Perl build parameters to > enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? > > Rafael Caceres > > > > >
Tip for DBI and DBD::Oracle on AIX 5.1 and Oracle 9.2
Here is a tip for compiling DBD::Oracle as a 32 bit application on AIX 5.1 64 bit and Oracle 9.2 64 bit without editting any makefiles. I hope people find this useful: First, the versions of products I used: DBI version 1.32 DBD::Oracle version 1.14 Oracle 9.2.0.2 - default 64 bit application with 32 bit libraries AIX 5.1 ML03 - 64 bit kernel - ships with Perl as a 32 bit application. VisualAge C/C++ 5.0.2 Basically DBD must be compiled as 32 bit to link with Perl's 32 bit libraries. gunzip -c DBD-Oracle-1.14.tar.gz | tar xvf cd DBD-Oracle-1.14 perl Makefile.PL -m $ORACLE_HOME/rdbms/demo/demo_rdbms32.mk make NB: I think there is a bug in the Oracle 9.2.0.3 file $ORACLE_HOME/rdbms/lib/env_rdbms.mk I corrected this (before running the above commands) by replacing the invalid linker option LDFLAGS32=-q32 with LDFLAGS32=-b32 Have fun: KC. _ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger
RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Rafael, Thanks for the info. Will try to compile it sometime today, maybe Monday. Keep us in touch about the 64 bit build. -Original Message- From: Rafael Caceres [mailto:[EMAIL PROTECTED] Sent: donderdag 19 juni 2003 20:13 To: Bjorn Naessens Cc: [EMAIL PROTECTED] Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 Bjorn: I intend to write a brief 'howto' with all the details on it, but in short: -use Perl 5.8.0 (the latest stable from CPAN) -use the xlc_r version of IBM's compiler and build 32 bit Perl. All tests should be successfull. -get and install DBI -get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle, changing references to Oracle's ../lib to ../lib32. and change crt0_64.o to crt0_r.o. Remove the -q32 and/or -q64 options from the list of libraries to link with. Do the make and make test. All tests should be successfull -against Oracle 9.x at least. You should have no problems with Oracle 8.1.7, but accessing Oracle 7.x or previous is not possible (you'll core dump, or simply hang). The same goes for a Linux build or a Digital build, regarding access of different Oracle versions. I plan to try a full 64 bit build of Perl, DBI and DBD::Oracle next week, and will post results. If you try this route, per Tim Bunce's comment, disregard a DBI test fail on 03handle.pl indicating that the wrong number of bytes was returned. regards, Rafael Caceres On Wed, 2003-06-18 at 08:42, [EMAIL PROTECTED] wrote: > > Guys, I'm having the same problem atm. I have to install perl on aix 5l > system for oracle 9.2 and need to stay supported to the other versions ( > 8.1.7 ). > > So these questions : > 1. Do you guys know where the newest version for aix is located ( 5.6 on > bull website ) > > 2. Which environment needs to be set before make of Perl, DBI and > DBD:Oracle? > > 3. Which additional parameters are required > > thanks for any help you can offer > > Bjorn Naessens > > -Original Message- > From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] > Sent: dinsdag 17 juni 2003 14:40 > To: 'Rafael Caceres'; [EMAIL PROTECTED] > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > Yes, use the 32-bit oracle libraries. I will forward a previous post on > this issue. > > > Thanks, > Sam Gold > > > -Original Message----- > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > Sent: Monday, June 16, 2003 6:54 PM > To: [EMAIL PROTECTED] > Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > Friends, I've worked with DBD::Oracle on various Linux and Digital boxes > with no problems. > I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from > scratch: > Perl 5.8.0 built with xlc_r > With this perl, DBI builds and install just fine. The DBD::Oracle build > process stops with a "XCOFF64 files are not allowed in 32-bit mode". > This has to do with the fact that the OCI interface is 64bit and > libraries like crt0_64.o are included in the DBD::Oracle build. > > The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 > bits), I get a problem with integer size conversions under DBI, and DBI > does not build correctly. > > Can anyone point at the 'right' combination of Perl build parameters to > enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? > > Rafael Caceres > > > > >
RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Bjorn: I intend to write a brief 'howto' with all the details on it, but in short: -use Perl 5.8.0 (the latest stable from CPAN) -use the xlc_r version of IBM's compiler and build 32 bit Perl. All tests should be successfull. -get and install DBI -get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle, changing references to Oracle's ../lib to ../lib32. and change crt0_64.o to crt0_r.o. Remove the -q32 and/or -q64 options from the list of libraries to link with. Do the make and make test. All tests should be successfull -against Oracle 9.x at least. You should have no problems with Oracle 8.1.7, but accessing Oracle 7.x or previous is not possible (you'll core dump, or simply hang). The same goes for a Linux build or a Digital build, regarding access of different Oracle versions. I plan to try a full 64 bit build of Perl, DBI and DBD::Oracle next week, and will post results. If you try this route, per Tim Bunce's comment, disregard a DBI test fail on 03handle.pl indicating that the wrong number of bytes was returned. regards, Rafael Caceres On Wed, 2003-06-18 at 08:42, [EMAIL PROTECTED] wrote: > > Guys, I'm having the same problem atm. I have to install perl on aix 5l > system for oracle 9.2 and need to stay supported to the other versions ( > 8.1.7 ). > > So these questions : > 1. Do you guys know where the newest version for aix is located ( 5.6 on > bull website ) > > 2. Which environment needs to be set before make of Perl, DBI and > DBD:Oracle? > > 3. Which additional parameters are required > > thanks for any help you can offer > > Bjorn Naessens > > -Original Message- > From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] > Sent: dinsdag 17 juni 2003 14:40 > To: 'Rafael Caceres'; [EMAIL PROTECTED] > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > Yes, use the 32-bit oracle libraries. I will forward a previous post on > this issue. > > > Thanks, > Sam Gold > > > -Original Message----- > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > Sent: Monday, June 16, 2003 6:54 PM > To: [EMAIL PROTECTED] > Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > Friends, I've worked with DBD::Oracle on various Linux and Digital boxes > with no problems. > I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from > scratch: > Perl 5.8.0 built with xlc_r > With this perl, DBI builds and install just fine. The DBD::Oracle build > process stops with a "XCOFF64 files are not allowed in 32-bit mode". > This has to do with the fact that the OCI interface is 64bit and > libraries like crt0_64.o are included in the DBD::Oracle build. > > The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 > bits), I get a problem with integer size conversions under DBI, and DBI > does not build correctly. > > Can anyone point at the 'right' combination of Perl build parameters to > enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? > > Rafael Caceres > > > > >
RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Guys, I'm having the same problem atm. I have to install perl on aix 5l system for oracle 9.2 and need to stay supported to the other versions ( 8.1.7 ). So these questions : 1. Do you guys know where the newest version for aix is located ( 5.6 on bull website ) 2. Which environment needs to be set before make of Perl, DBI and DBD:Oracle? 3. Which additional parameters are required thanks for any help you can offer Bjorn Naessens -Original Message- From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] Sent: dinsdag 17 juni 2003 14:40 To: 'Rafael Caceres'; [EMAIL PROTECTED] Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 Yes, use the 32-bit oracle libraries. I will forward a previous post on this issue. Thanks, Sam Gold -Original Message- From: Rafael Caceres [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 6:54 PM To: [EMAIL PROTECTED] Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 Friends, I've worked with DBD::Oracle on various Linux and Digital boxes with no problems. I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from scratch: Perl 5.8.0 built with xlc_r With this perl, DBI builds and install just fine. The DBD::Oracle build process stops with a "XCOFF64 files are not allowed in 32-bit mode". This has to do with the fact that the OCI interface is 64bit and libraries like crt0_64.o are included in the DBD::Oracle build. The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 bits), I get a problem with integer size conversions under DBI, and DBI does not build correctly. Can anyone point at the 'right' combination of Perl build parameters to enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? Rafael Caceres
RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Yes, use the 32-bit oracle libraries. I will forward a previous post on this issue. Thanks, Sam Gold -Original Message- From: Rafael Caceres [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 6:54 PM To: [EMAIL PROTECTED] Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 Friends, I've worked with DBD::Oracle on various Linux and Digital boxes with no problems. I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from scratch: Perl 5.8.0 built with xlc_r With this perl, DBI builds and install just fine. The DBD::Oracle build process stops with a "XCOFF64 files are not allowed in 32-bit mode". This has to do with the fact that the OCI interface is 64bit and libraries like crt0_64.o are included in the DBD::Oracle build. The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 bits), I get a problem with integer size conversions under DBI, and DBI does not build correctly. Can anyone point at the 'right' combination of Perl build parameters to enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? Rafael Caceres
Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
Friends, I've worked with DBD::Oracle on various Linux and Digital boxes with no problems. I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from scratch: Perl 5.8.0 built with xlc_r With this perl, DBI builds and install just fine. The DBD::Oracle build process stops with a "XCOFF64 files are not allowed in 32-bit mode". This has to do with the fact that the OCI interface is 64bit and libraries like crt0_64.o are included in the DBD::Oracle build. The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 bits), I get a problem with integer size conversions under DBI, and DBI does not build correctly. Can anyone point at the 'right' combination of Perl build parameters to enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? Rafael Caceres
DBD::Oracle on AIX 4.3.3
Hello,
we want to install DBI and DBD::Oracle on lots of Oracle servers running on
AIX 4.3.3. When compiling the latest CPAN sources everything works well.
There are, however, precompiled DBI and DBD::Oracle packages for AIX offered
by Bull, and installing these packages is much faster. But when trying to
run our scripts we receive the following error message:
> install_driver(Oracle) failed: Can't load
> '/usr/opt/perl5/lib/site_perl/5.005/aix/auto/DBD/Oracle/Oracle.so' for
module
> DBD::Oracle: dlopen:
> /usr/opt/perl5/lib/site_perl/5.005/aix/auto/DBD/Oracle/Oracle.so: A file
or
> directory in the path name does not exist. at
> /usr/opt/perl5/lib/5.00503/aix/DynaLoader.pm line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at ./statement.pl line 5
The file Oracle.so does exist in the specified directory.
Setting LD_LIBRARY_PATH to ${ORACLE_HOME}/lib as proposed in another thread
in this list does not work either.
Our script looks as follows:
> #!/usr/bin/perl
>
> use DBI;
>
> my $dbh = DBI->connect("dbi:Oracle:test","user","passwd")
> or die "Error connecting database: $DBI::errstr\n";
> [...]
We also tried compiling the script using perl2exe for AIX. But when running
the "exe" file on another machine with no perl database modules installed
the following error occurs:
> Can't load '/tmp/Oracle.so' for module DBD::Oracle: dlopen:
/tmp/Oracle.so:
> A file or directory in the path name does not exist. at
> PERL2EXE_STORAGE/DynaLoader.pm line 206.
> at statement.pl line 4
> Compilation failed in require at statement.pl line 4.
> BEGIN failed--compilation aborted at statement.pl line 4.
(line 4 is then "use DBD::Oracle;" which is necessary for compiling the
script).
indigostar (perl2exe) could not help us.
Regards, Michael
