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::PurePerl test variant: t/zvpp_01basics.t
Creating DBI::PurePerl test variant: t/zvpp_02dbidrv.t
Creating DBI::PurePerl test variant: t/zvpp_03handle.t
Creating DBI::PurePerl test variant: t/zvpp_04mods.t
Creating DBI::PurePerl test variant: t/zvpp_05thrclone.t (use threads)
Creating DBI::PurePerl test variant: t/zvpp_06attrs.t
Creating DBI::PurePerl test variant: t/zvpp_07kids.t
Creating DBI::PurePerl test variant: t/zvpp_08keeperr.t
Creating DBI::PurePerl test variant: t/zvpp_09trace.t
Creating DBI::PurePerl test variant: t/zvpp_10examp.t
Creating DBI::PurePerl test variant: t/zvpp_14utf8.t
Creating DBI::PurePerl test variant: t/zvpp_15array.t
Creating DBI::PurePerl test variant: t/zvpp_20meta.t
Creating DBI::PurePerl test variant: t/zvpp_30subclass.t
Creating DBI::PurePerl test variant: t/zvpp_40profile.t
Creating DBI::PurePerl test variant: t/zvpp_41prof_dump.t
Creating DBI::PurePerl test variant: t/zvpp_42prof_data.t
Creating DBI::PurePerl test variant: t/zvpp_50dbm.t
Creating DBI::PurePerl test variant: t/zvpp_60preparse.t
Creating DBI::PurePerl test variant: t/zvpp_80proxy.t
Checking if your kit is complete...
Looks good
I see you're using perl 5.008 on aix-thread-multi, okay.
Remember to actually *read* the README file!
Use 'make' to build the software (dmake or nmake on Windows).
Then 'make test' to execute self tests.
Then 'make install' to install the DBI and then delete this working
directory before unpacking and building any DBD::* drivers.
Writing Makefile for DBI
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBI-1.46:
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBI-1.46: make
cp Changes blib/lib/DBI/Changes.pm
cp Roadmap.pod blib/lib/DBI/Roadmap.pm
cp lib/DBD/DBM.pm blib/lib/DBD/DBM.pm
cp DBIXS.h blib/arch/auto/DBI/DBIXS.h
cp Roadmap.pod blib/lib/Roadmap.pod
cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h
cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm
cp lib/DBI/Const/GetInfoType.pm blib/lib/DBI/Const/GetInfoType.pm
cp lib/DBI/DBD/Metadata.pm blib/lib/DBI/DBD/Metadata.pm
cp lib/DBI/Const/GetInfo/ODBC.pm blib/lib/DBI/Const/GetInfo/ODBC.pm
cp lib/DBD/NullP.pm blib/lib/DBD/NullP.pm
cp Driver.xst blib/arch/auto/DBI/Driver.xst
cp lib/DBD/File.pm blib/lib/DBD/File.pm
cp lib/DBI/ProfileDumper/Apache.pm blib/lib/DBI/ProfileDumper/Apache.pm
cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h
cp dbivport.h blib/arch/auto/DBI/dbivport.h
cp lib/DBI/FAQ.pm blib/lib/DBI/FAQ.pm
cp lib/DBI/SQL/Nano.pm blib/lib/DBI/SQL/Nano.pm
cp dbi_sql.h blib/arch/auto/DBI/dbi_sql.h
cp DBI.pm blib/lib/DBI.pm
cp lib/DBI/Const/GetInfoReturn.pm blib/lib/DBI/Const/GetInfoReturn.pm
cp lib/DBD/Sponge.pm blib/lib/DBD/Sponge.pm
cp lib/DBI/Const/GetInfo/ANSI.pm blib/lib/DBI/Const/GetInfo/ANSI.pm
cp lib/Bundle/DBI.pm blib/lib/Bundle/DBI.pm
cp lib/DBI/W32ODBC.pm blib/lib/DBI/W32ODBC.pm
cp lib/DBI/Profile.pm blib/lib/DBI/Profile.pm
cp lib/DBI/ProfileDumper.pm blib/lib/DBI/ProfileDumper.pm
cp dbipport.h blib/arch/auto/DBI/dbipport.h
cp lib/DBI/DBD.pm blib/lib/DBI/DBD.pm
cp lib/Win32/DBIODBC.pm blib/lib/Win32/DBIODBC.pm
cp lib/DBI/ProxyServer.pm blib/lib/DBI/ProxyServer.pm
cp lib/DBI/PurePerl.pm blib/lib/DBI/PurePerl.pm
cp lib/DBD/ExampleP.pm blib/lib/DBD/ExampleP.pm
cp lib/DBI/ProfileData.pm blib/lib/DBI/ProfileData.pm
/usr/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists("NAME" =>
"DBI", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_VARS" => []);'
/usr/bin/perl -p -e "s/~DRIVER~/Perl/g" ./Driver.xst > Perl.xsi
/usr/bin/perl /usr/opt/perl5/lib/5.8.0/ExtUtils/xsubpp -typemap
/usr/opt/perl5/lib/5.8.0/ExtUtils/typemap -typemap typemap Perl.xs > Perl.xsc
&& mv
Perl.xsc Perl.c
cc_r -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES
-qlonglong -O -DVERSION=\"1.46\" -DXS_VERSION=\"1.46\"
"-I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE" Perl.c
/usr/bin/perl /usr/opt/perl5/lib/5.8.0/ExtUtils/xsubpp -typemap
/usr/opt/perl5/lib/5.8.0/ExtUtils/typemap -typemap typemap DBI.xs > DBI.xsc &&
mv DBI.xsc
DBI.c
cc_r -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES
-qlonglong -O -DVERSION=\"1.46\" -DXS_VERSION=\"1.46\"
"-I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE" DBI.c
Running Mkbootstrap for DBI ()
chmod 644 DBI.bs
rm -f blib/arch/auto/DBI/DBI.so
LD_RUN_PATH="" ld -bhalt:4 -bM:SRE
-bI:/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE/perl.exp -bE:DBI.exp
-bnoentry -lpthreads -lc_r DBI.o -o
blib/arch/auto/DBI/DBI.so
chmod 755 blib/arch/auto/DBI/DBI.so
cp DBI.bs blib/arch/auto/DBI/DBI.bs
chmod 644 blib/arch/auto/DBI/DBI.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiprof.PL dbiprof
Extracted dbiprof from dbiprof.PL with variable substitutions.
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiproxy.PL dbiproxy
Extracted dbiproxy from dbiproxy.PL with variable substitutions.
cp dbiprof blib/script/dbiprof
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/dbiprof
cp dbiproxy blib/script/dbiproxy
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/dbiproxy
Manifying blib/man3/DBI::FAQ.3
Manifying blib/man1/dbiproxy.1
Manifying blib/man3/DBI::SQL::Nano.3
Manifying blib/man3/DBD::Proxy.3
Manifying blib/man3/DBI::Const::GetInfo::ANSI.3
Manifying blib/man3/DBD::DBM.3
Manifying blib/man3/DBI.3
Manifying blib/man3/DBI::Const::GetInfoReturn.3
Manifying blib/man3/DBD::Sponge.3
Manifying blib/man1/dbiprof.1
Manifying blib/man3/Roadmap.3
Manifying blib/man3/DBI::Const::GetInfoType.3
Manifying blib/man3/DBI::W32ODBC.3
Manifying blib/man3/DBI::DBD::Metadata.3
Manifying blib/man3/DBI::Const::GetInfo::ODBC.3
Manifying blib/man3/DBI::ProfileDumper::Apache.3
Manifying blib/man3/Bundle::DBI.3
Manifying blib/man3/DBI::Profile.3
Manifying blib/man3/DBI::ProfileDumper.3
Manifying blib/man3/DBD::File.3
Manifying blib/man3/DBI::ProxyServer.3
Manifying blib/man3/DBI::DBD.3
Manifying blib/man3/Win32::DBIODBC.3
Manifying blib/man3/DBI::PurePerl.3
Manifying blib/man3/DBI::ProfileData.3
Target "makemakerdflt" is up to date.
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBI-1.46: make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01basics............ok
4/131 skipped: developer tests
t/02dbidrv............ok
t/03handle............ok
t/04mods..............ok
t/05thrclone..........ok
t/06attrs.............ok
t/07kids..............ok
t/08keeperr...........ok
t/09trace.............ok
t/10examp.............ok
t/14utf8..............ok
t/15array.............ok
t/20meta..............ok
t/30subclass..........ok
t/40profile...........ok
t/41prof_dump.........ok
t/42prof_data.........ok
t/50dbm...............ok
t/60preparse..........ok
t/80proxy.............ok
t/pod.................skipped
all skipped: Test::Pod 1.00 required for testing POD
t/zvpp_01basics.......ok
4/131 skipped: developer tests
t/zvpp_02dbidrv.......ok
10/51 skipped: various reasons
t/zvpp_03handle.......ok
69/124 skipped: various reasons
t/zvpp_04mods.........ok
t/zvpp_05thrclone.....ok
t/zvpp_06attrs........ok
7/137 skipped: various reasons
t/zvpp_07kids.........skipped
all skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zvpp_08keeperr......ok
t/zvpp_09trace........ok
t/zvpp_10examp........ok
39/252 skipped: various reasons
t/zvpp_14utf8.........ok
t/zvpp_15array........ok
t/zvpp_20meta.........ok
t/zvpp_30subclass.....ok
t/zvpp_40profile......skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvpp_41prof_dump....skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvpp_42prof_data....skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvpp_50dbm..........ok
t/zvpp_60preparse.....skipped
all skipped: preparse not supported for DBI::PurePerl
t/zvpp_80proxy........skipped
all skipped: DBD::Proxy currently has a problem under DBI::PurePerl
All tests successful, 7 tests and 133 subtests skipped.
Files=41, Tests=2283, 17 wallclock secs (11.94 cusr + 1.89 csys = 13.83 CPU)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
test.pl
DBI test application $Revision: 11.7 $
Switch: DBI 1.46 by Tim Bunce, 1.46
Available Drivers: DBM, ExampleP, File, Oracle, Proxy, Sponge
dbi:ExampleP:: testing 5 sets of 20 connections:
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Made 100 connections in 0 wallclock secs ( 0.02 usr + 0.00 sys = 0.02 CPU)
Testing handle creation speed...
11494 NullP sth/s perl 5.008 aix-thread-multi (cc_r -O)
test.pl done
Target "test" is up to date.
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBI-1.46:
Now for DBD, again removed directory, and re-untared CPAN download
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16: perl
Makefile.PL -m $ORACLE_HOME/rdbms/demo/demo_rdbms32.mk
Using DBI 1.46 (for perl 5.008 on aix-thread-multi) installed in
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /applications/ora92/app/oracle/product/9.2.0
DEFINE _SQLPLUS_RELEASE = "902000500" (CHAR)
Oracle version 9.2.0.5 (9.2)
Found /applications/ora92/app/oracle/product/9.2.0/rdbms/demo/demo_rdbms32.mk
Found /applications/ora92/app/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk
Found /applications/ora92/app/oracle/product/9.2.0/otrace/demo/atmoci.mk
Found /applications/ora92/app/oracle/product/9.2.0/precomp/demo/proc/proc.mk
Found
/applications/ora92/app/oracle/product/9.2.0/precomp/demo/proc/demo_proc.mk
Using /applications/ora92/app/oracle/product/9.2.0/rdbms/demo/demo_rdbms32.mk
Reading /applications/ora92/app/oracle/product/9.2.0/rdbms/demo/demo_rdbms32.mk
Reading /applications/ora92/app/oracle/product/9.2.0/rdbms/lib/env_rdbms.mk
Deleting -b64 from COMPOBJS because -b64 doesn't exist.
Attempting to discover Oracle OCI build rules
cc_r -O -c DBD_ORA_OBJ.c
by executing: [make -f
/applications/ora92/app/oracle/product/9.2.0/rdbms/demo/demo_rdbms32.mk build
ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true
OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
[ true -b32
-L/applications/ora92/app/oracle/product/9.2.0/lib32/
-L/applications/ora92/app/oracle/product/9.2.0/rdbms//lib32/ -o DBD_ORA_EXE
DBD_ORA_OBJ.o -lclntsh -lld -lm `cat
/applications/ora92/app/oracle/product/9.2.0/lib32/sysliblist` -lm -lpthreads]
Found header files in plsql/public rdbms/public rdbms/demo.
Checking for functioning wait.ph
System: perl5.008 aix rocky 2 5 000ad7df4c00
Compiler: cc_r -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES
-qlonglong
Linker: /usr/bin/ld
Sysliblist: /lib/crt0.o -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld -lperfstat
Oracle makefiles would have used these definitions but we override them:
CC: $(ORACLE_HOME)/bin/oraxlc $(ORAXLCFLAGS)
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -O3 $(CDEBUG) -q64
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/public
-I/applications/ora92/app/oracle/product/9.2.0/plsql/public
-I/applications/ora92/app/oracle/product/9.2.0/network/public $(SPFLAGS)
$(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/applications/ora92/app/oracle/product/9.2.0/rdbms/lib/
-L$(LIBHOME)]
Linking with OTHERLDFLAGS = -b32
-L/applications/ora92/app/oracle/product/9.2.0/lib32/
-L/applications/ora92/app/oracle/product/9.2.0/rdbms//lib32/ -lclntsh
-lld -lm `cat /applications/ora92/app/oracle/product/9.2.0/lib32/sysliblist`
-lm -lpthreads [from 'build' rule]
Warning: You will may need to rebuild perl using the xlc_r compiler.
You may also need do: ORACCENV='cc=xlc_r'; export ORACCENV
Also see the README about the -p option
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/applications/ora92/app/oracle/product/9.2.0/lib32:/applications/ora92/app/oracle/product/9.2.0/rdbms/lib32
Using DBD::Oracle 1.16.
Using DBD::Oracle 1.16.
Using DBI 1.46 (for perl 5.008 on aix-thread-multi) installed in
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16:
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16: make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp oraperl.ph blib/lib/oraperl.ph
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists("NAME" =>
"DBD::Oracle", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_VARS" => []);'
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI//Driver.xst >
Oracle.xsi
/usr/bin/perl /usr/opt/perl5/lib/5.8.0/ExtUtils/xsubpp -typemap
/usr/opt/perl5/lib/5.8.0/ExtUtils/typemap -typemap typemap Oracle.xs >
Oracle.xsc && mv
Oracle.xsc Oracle.c
cc_r -c -I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/public
-I/applications/ora92/app/oracle/product/9.2.0/plsql/public
-I/applications/ora92/app/oracle/product/9.2.0/network/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/applications/ora92/app/oracle/product/9.2.0/plsql/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/ -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias
-DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.16\"
-DXS_VERSION=\"1.16\" "-I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE"
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.5\" Oracle.c
cc_r -c -I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/public
-I/applications/ora92/app/oracle/product/9.2.0/plsql/public
-I/applications/ora92/app/oracle/product/9.2.0/network/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/applications/ora92/app/oracle/product/9.2.0/plsql/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/ -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias
-DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.16\"
-DXS_VERSION=\"1.16\" "-I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE"
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.5\" dbdimp.c
cc_r -c -I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/public
-I/applications/ora92/app/oracle/product/9.2.0/plsql/public
-I/applications/ora92/app/oracle/product/9.2.0/network/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/applications/ora92/app/oracle/product/9.2.0/plsql/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/public
-I/applications/ora92/app/oracle/product/9.2.0/rdbms/demo
-I/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/ -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias
-DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.16\"
-DXS_VERSION=\"1.16\" "-I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE"
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.5\" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/applications/ora92/app/oracle/product/9.2.0/lib32:/applications/ora92/app/oracle/product/9.2.0/rdbms/lib32"
ld -bhalt:4 -bM:SRE
-bI:/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE/perl.exp -bE:Oracle.exp
-bnoentry -lpthreads -lc_r Oracle.o dbdimp.o oci8.o -b32
-L/applications/ora92/app/oracle/product/9.2.0/lib32/
-L/applications/ora92/app/oracle/product/9.2.0/rdbms//lib32/ -lclntsh -lld
-lm `cat
/applications/ora92/app/oracle/product/9.2.0/lib32/sysliblist` -lm -lpthreads
-o blib/arch/auto/DBD/Oracle/Oracle.so
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/ora_explain
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3
Target "makemakerdflt" is up to date.
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16:
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16: make
test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............ok
t/15nls.................ok
t/20select..............ok
t/21nchar............... Database and client versions and character sets:
Database 9.2.0.5.0 CHAR set is WE8ISO8859P15 (Non-Unicode), NCHAR set is
AL16UTF16 (Unicode)
Client 9.2.0.5 NLS_LANG is 'AMERICAN_AMERICA.WE8ISO8859P15', NLS_NCHAR is
'<unset>'
t/21nchar...............ok
t/22nchar_al32utf8......ok
t/22nchar_utf8..........ok
t/23wide_db.............skipped
all skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped
all skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped
all skipped: Database character set is not Unicode
t/24implicit_utf8.......ok
t/25plsql...............ok
t/30long................ok
122/470 skipped: various reasons
t/31lob.................ok
t/40ph_type.............ok 11/19 Placeholder behaviour for ora_type=1 (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.............ok
t/50cursor..............ok
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................ok
All tests successful, 4 tests and 122 subtests skipped.
Files=18, Tests=893, 13 wallclock secs ( 8.74 cusr + 1.69 csys = 10.43 CPU)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
Extra tests. These are less formal and you need to read the output
to see if it looks reasonable and matches what the tests says is expected.
Oraperl emulation interface version 1.44
DBD::Oracle 1.16 using OCI9.2.0.5 by Tim Bunce
DBI 1.46 by Tim Bunce
Data sources:
dbi:Oracle:ASP
dbi:Oracle:DBYTE
dbi:Oracle:DBYTE.world
dbi:Oracle:DEAMGCP1.world
dbi:Oracle:DEAMGCP2.world
dbi:Oracle:DEAMGCP3.WORLD
dbi:Oracle:DEAMGCP4.WORLD
dbi:Oracle:DEAMGCP5.WORLD
dbi:Oracle:DEAMGCP6.WORLD
dbi:Oracle:DEAMGCPS.WORLD
dbi:Oracle:DEAMGCT1
dbi:Oracle:DEAMGCT1.world
dbi:Oracle:DEAMGCT2
dbi:Oracle:DEAMGCT2.world
dbi:Oracle:DEAMGCT3
dbi:Oracle:DEAMGCT3.world
dbi:Oracle:DEAMGCTR
dbi:Oracle:DEAMGCTR.world
dbi:Oracle:DWHOP
dbi:Oracle:DWHOP.world
dbi:Oracle:FKFTLIFE
dbi:Oracle:GHSSRAID.WORLD
dbi:Oracle:GHSSRAIP.WORLD
dbi:Oracle:HBDEAMD1.world
dbi:Oracle:HBDEAMT1.world
dbi:Oracle:HBEDMSP1.us.db.com
dbi:Oracle:HBGPD2U.world
dbi:Oracle:HBGPDP.world
dbi:Oracle:HBGPDU.world
dbi:Oracle:HBSEBLD1.WORLD
dbi:Oracle:HBSLGXP.us.db.com
dbi:Oracle:HBXSPP.us.db.com
dbi:Oracle:LIFEP
dbi:Oracle:LIFEP.world
dbi:Oracle:LIFET
dbi:Oracle:LIFET.world
dbi:Oracle:P101
dbi:Oracle:P101.WORLD
dbi:Oracle:PCAMAIP.world
dbi:Oracle:PI01.world
dbi:Oracle:PI03.world
dbi:Oracle:PI04.world
dbi:Oracle:PISA
dbi:Oracle:PISA.world
dbi:Oracle:PR00.world
dbi:Oracle:PR12.world
dbi:Oracle:Q101
dbi:Oracle:Q101.WORLD
dbi:Oracle:QRAPecsp.world
dbi:Oracle:T031.WORLD
dbi:Oracle:T109
dbi:Oracle:T110
dbi:Oracle:TMSP
dbi:Oracle:TMSP.WORLD
dbi:Oracle:TMST4
dbi:Oracle:TMST4.world
dbi:Oracle:TMST9
dbi:Oracle:TMST9.world
dbi:Oracle:a2lv
dbi:Oracle:a2lv.world
dbi:Oracle:ablv
dbi:Oracle:ablv.world
dbi:Oracle:ablv_tools
dbi:Oracle:aslv
dbi:Oracle:aslv.world
dbi:Oracle:asts
dbi:Oracle:asts.world
dbi:Oracle:autolv
dbi:Oracle:axlv
dbi:Oracle:axlv.world
dbi:Oracle:axua
dbi:Oracle:axua.world
dbi:Oracle:bolv
dbi:Oracle:bolv.world
dbi:Oracle:bots
dbi:Oracle:bots.world
dbi:Oracle:boua
dbi:Oracle:boua.world
dbi:Oracle:c3ua
dbi:Oracle:c3ua.world
dbi:Oracle:c4ts
dbi:Oracle:c4ts.world
dbi:Oracle:c4ua
dbi:Oracle:c4ua.world
dbi:Oracle:cdbk
dbi:Oracle:cdbk.world
dbi:Oracle:cdlv
dbi:Oracle:cdlv.world
dbi:Oracle:cdlv_dedicated
dbi:Oracle:cdlv_dedicated.world
dbi:Oracle:cdts
dbi:Oracle:cdts.world
dbi:Oracle:cmts
dbi:Oracle:cmts.world
dbi:Oracle:crts
dbi:Oracle:crts.world
dbi:Oracle:culv
dbi:Oracle:culv.world
dbi:Oracle:dblv
dbi:Oracle:dblv.world
dbi:Oracle:dcts
dbi:Oracle:dcts.mgam.ukd.deuba.com
dbi:Oracle:dcts.world
dbi:Oracle:dits
dbi:Oracle:dits.world
dbi:Oracle:dwho
dbi:Oracle:e1ts
dbi:Oracle:e1ts.world
dbi:Oracle:e3ua
dbi:Oracle:e3ua.world
dbi:Oracle:exlv
dbi:Oracle:exlv.world
dbi:Oracle:exua
dbi:Oracle:exua.world
dbi:Oracle:exuarem
dbi:Oracle:exuarem.world
dbi:Oracle:ftlv
dbi:Oracle:ftlv.world
dbi:Oracle:ftts
dbi:Oracle:ftts.world
dbi:Oracle:g2ts
dbi:Oracle:g2ts.world
dbi:Oracle:ghlv
dbi:Oracle:ghlv.world
dbi:Oracle:ghlv_lndn
dbi:Oracle:ghlv_lndn.world
dbi:Oracle:ghlv_ny
dbi:Oracle:ghlv_ny.world
dbi:Oracle:ghts
dbi:Oracle:ghts.world
dbi:Oracle:ghua
dbi:Oracle:ghua.world
dbi:Oracle:gllv
dbi:Oracle:gllv.world
dbi:Oracle:hglv
dbi:Oracle:hglv.world
dbi:Oracle:hgts
dbi:Oracle:hgts.world
dbi:Oracle:hgua
dbi:Oracle:hgua.world
dbi:Oracle:i2ua
dbi:Oracle:i2ua.world
dbi:Oracle:i6ua
dbi:Oracle:i6ua.world
dbi:Oracle:idua
dbi:Oracle:idua.world
dbi:Oracle:infotrk.world
dbi:Oracle:iwlv
dbi:Oracle:iwlv.world
dbi:Oracle:iwts
dbi:Oracle:iwts.world
dbi:Oracle:ixlv
dbi:Oracle:ixlv.world
dbi:Oracle:ldlv
dbi:Oracle:ldlv.mgam.ukd.deuba.com
dbi:Oracle:ldlv.world
dbi:Oracle:ldts
dbi:Oracle:ldts.mgam.ukd.deuba.com
dbi:Oracle:ldts.world
dbi:Oracle:ldua
dbi:Oracle:ldua.mgam.ukd.deuba.com
dbi:Oracle:ldua.world
dbi:Oracle:lzlv
dbi:Oracle:lzlv.world
dbi:Oracle:lzts
dbi:Oracle:lzts.world
dbi:Oracle:lzua
dbi:Oracle:lzua.world
dbi:Oracle:lzuarem
dbi:Oracle:lzuarem.world
dbi:Oracle:m2ua
dbi:Oracle:m2ua.world
dbi:Oracle:mwlv
dbi:Oracle:mwlv.world
dbi:Oracle:mwts
dbi:Oracle:mwts.world
dbi:Oracle:nygdhubp
dbi:Oracle:nygdhubp.dbsun
dbi:Oracle:nygdhubp.world
dbi:Oracle:nygdhubp_ny
dbi:Oracle:nygdhubp_ny.world
dbi:Oracle:nygqep
dbi:Oracle:nygqep.world
dbi:Oracle:p2ts
dbi:Oracle:p2ts.world
dbi:Oracle:p3ts
dbi:Oracle:p3ts.world
dbi:Oracle:pclv
dbi:Oracle:pclv.world
dbi:Oracle:pcts
dbi:Oracle:pcts.world
dbi:Oracle:pcua
dbi:Oracle:pcua.world
dbi:Oracle:pflv
dbi:Oracle:pflv.world
dbi:Oracle:pxua
dbi:Oracle:pxua.world
dbi:Oracle:r1ua
dbi:Oracle:r1ua.world
dbi:Oracle:rclv
dbi:Oracle:rclv.world
dbi:Oracle:remote
dbi:Oracle:salv
dbi:Oracle:salv.world
dbi:Oracle:salv_tools
dbi:Oracle:sats
dbi:Oracle:sats.world
dbi:Oracle:saua
dbi:Oracle:saua.world
dbi:Oracle:siebeldb
dbi:Oracle:siebeldb.world
dbi:Oracle:siebeldv.world
dbi:Oracle:sklv
dbi:Oracle:sklv.world
dbi:Oracle:skua
dbi:Oracle:skua.world
dbi:Oracle:smts
dbi:Oracle:smts.world
dbi:Oracle:smts_tools
dbi:Oracle:snglv
dbi:Oracle:snglv.world
dbi:Oracle:sngts
dbi:Oracle:sngts.world
dbi:Oracle:snowdrop
dbi:Oracle:snowdrop.world
dbi:Oracle:test
dbi:Oracle:test.world
dbi:Oracle:tmts
dbi:Oracle:tmts.world
dbi:Oracle:xxts
dbi:Oracle:xxts.world
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'remote/remote' (via ORACLE_USERID env var or default - recommend
name/[EMAIL PROTECTED])
(ORACLE_SID='exua', TWO_TASK='')
Fields: 6
Names: 'NUM_T' 'DATE_T' 'CHAR_T' 'ROWID_T' 'RAW_T'
'NULL_T'
Lengths: 172 76 31 21 3 1
OraTypes: 2 12 1 104 23 1
SQLTypes: 8 93 12 -9104 -2 12
Scale: 0 0 0 0 0 0
Precision: 126 75 30 20 2 0
Nullable: 1 1 1 1 1 1
Est row width: 32
Data rows:
fetch: '7.2', '25-NOV-2004', 'REMOTE', 'AAAACtAABAAAAGkAAA', '7D', undef
ora_logoff...
lda out of scope...
Testing repetitive connect/open/close/disconnect:
If this test hangs then read the README.help file.
Expect sequence of digits, no other messages:
1 2 3 4 5
Test interaction of explicit close/logoff and implicit DESTROYs
Expect just 'done.', no other messages:
done.
Testing row cache (5).
Test completed in 0 seconds.
Test complete (0 seconds).
If the tests above have produced the 'expected' output then they have passed.
Target "test" is up to date.
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16:
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16: make
install
Installing
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBD/Oracle/Oracle.so
Files found in blib/arch: installing files in blib/lib into architecture
dependent library tree
Installing /usr/opt/perl5/man/man3/DBD::Oracle.3
Installing /usr/opt/perl5/man/man3/DBD::Oraperl.3
Writing
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBD/Oracle/.packlist
Appending installation info to
/usr/opt/perl5/lib/5.8.0/aix-thread-multi/perllocal.pod
Target "install" is up to date.
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16:
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16: find
/usr/opt/perl5/ \( -name \*DBD\* -o -name \*DBI\* \) -type f -ls
364656 20 -r--r--r-- 1 root exua 20392 Oct 2 00:15
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/DBIXS.h
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
364670 0 -r--r--r-- 1 root exua 0 Nov 25 10:14
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/DBI.bs
92375 256 -r--r--r-- 1 root exua 261628 Nov 16 12:23
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBI.pm
366593 8 -r--r--r-- 1 root exua 4532 Aug 24 2001
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/Win32/DBIODBC.pm
366595 4 -r--r--r-- 1 root exua 1197 Feb 28 2003
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/Bundle/DBI.pm
360455 108 -r--r--r-- 1 root exua 109264 Oct 6 13:54
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBI/DBD.pm
354798 48 -r--r--r-- 1 root exua 45280 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::FAQ.3
354799 12 -r--r--r-- 1 root exua 9817 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::SQL::Nano.3
354800 16 -r--r--r-- 1 root exua 12679 Nov 25 10:14
/usr/opt/perl5/man/man3/DBD::Proxy.3
354801 8 -r--r--r-- 1 root exua 4887 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::Const::GetInfo::ANSI.3
354802 32 -r--r--r-- 1 root exua 29988 Nov 25 10:14
/usr/opt/perl5/man/man3/DBD::DBM.3
354803 244 -r--r--r-- 1 root exua 246411 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI.3
354805 8 -r--r--r-- 1 root exua 4099 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::Const::GetInfoReturn.3
354806 8 -r--r--r-- 1 root exua 6177 Nov 25 10:14
/usr/opt/perl5/man/man3/DBD::Sponge.3
354807 8 -r--r--r-- 1 root exua 4314 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::Const::GetInfoType.3
354808 8 -r--r--r-- 1 root exua 4614 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::W32ODBC.3
354809 12 -r--r--r-- 1 root exua 8992 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::DBD::Metadata.3
354810 8 -r--r--r-- 1 root exua 4739 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::Const::GetInfo::ODBC.3
354811 8 -r--r--r-- 1 root exua 7395 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::ProfileDumper::Apache.3
354812 8 -r--r--r-- 1 root exua 5001 Nov 25 10:14
/usr/opt/perl5/man/man3/Bundle::DBI.3
354813 24 -r--r--r-- 1 root exua 22624 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::Profile.3
354814 12 -r--r--r-- 1 root exua 9412 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::ProfileDumper.3
354815 8 -r--r--r-- 1 root exua 8038 Nov 25 10:14
/usr/opt/perl5/man/man3/DBD::File.3
354816 28 -r--r--r-- 1 root exua 25554 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::ProxyServer.3
354817 112 -r--r--r-- 1 root exua 113372 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::DBD.3
354818 8 -r--r--r-- 1 root exua 4516 Nov 25 10:14
/usr/opt/perl5/man/man3/Win32::DBIODBC.3
354819 12 -r--r--r-- 1 root exua 9644 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::PurePerl.3
354821 12 -r--r--r-- 1 root exua 12058 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::ProfileData.3
354822 80 -r--r--r-- 1 root exua 79876 Nov 25 10:20
/usr/opt/perl5/man/man3/DBD::Oracle.3
354823 28 -r--r--r-- 1 root exua 28620 Nov 25 10:20
/usr/opt/perl5/man/man3/DBD::Oraperl.3
lonamappu1 (root) /applications/home/holtcc/ext/perlmod/DBD-Oracle-1.16:
Chris
--
This e-mail may contain confidential and/or privileged information. If you are
not the intended recipient (or have received this e-mail in error) please
notify the sender immediately and destroy this e-mail. Any unauthorized
copying, disclosure or distribution of the material in this e-mail is strictly
forbidden.
