Hi, Can you please help me, how to fix the issue and install Perl DBD::Oracle module.
Thanks & Regards, Ramakrishna Jillapelli, Global Services, Operations and Engineering, XEROX Business Services, 9th Floor, Explorer Block, White Field Road, ITPL, Bangalore - 560066, India. E-Mail: ramakrishna.jillape...@xerox.com<mailto:ramakrishna.jillape...@xerox.com>, Ph: +1-214-530-2222, Ext 3208, Mob: +91-9008177255 (Off), +91-9880678154 (Per). From: Jillapelli, Ramakrishna Sent: Saturday, April 05, 2014 12:15 AM To: 't...@cpan.org'; 'byter...@cpan.org'; 'yan...@cpan.org'; 'mjev...@cpan.org' Subject: Perl module DBD::Oracle installation failing Hi, While installing Perl module DBD::Oracle getting errors. Recently AIX upgraded on couple of servers that installed Perl version 5.10.1. We are using couple of Perl modules in our perl scripts, those are not working after AIX upgradation to 7.1 Used the following two methods installing the Perl module "DBD::Oracle". /usr/bin/perl MakeFile.PL and /usr/bin/perl -MCPAN -e 'install DBD::Oracle' We are able to install all required Perl modules except "DBD::Oracle" module on our servers. Please help me, how to fix this issue and install the Oracle module. Please help me to fix. Thanks & Regards, Ramakrishna Jillapelli, Global Services, Operations and Engineering, XEROX Business Services, 9th Floor, Explorer Block, White Field Road, ITPL, Bangalore - 560066, India. E-Mail: ramakrishna.jillape...@xerox.com<mailto:ramakrishna.jillape...@xerox.com>, Ph: +1-214-530-2222, Ext 3208, Mob: +91-9008177255 (Off), +91-9880678154 (Per).
Perl-DBD-Oracle-errors.docx
Description: Perl-DBD-Oracle-errors.docx
# /usr/bin/perl Makefile.PL
Using DBI 1.631 (for perl 5.010001 on aix-thread-multi) installed in
/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.010001 on aix (aix-thread-multi)
Remember to actually *READ* the README file! Especially if you have any
problems.
Installing on a aix, Ver#5.3
Using Oracle in /oracle/product/v102/fullclnt
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /oracle/product/v102/fullclnt/rdbms/demo/demo_rdbms32.mk
Found /oracle/product/v102/fullclnt/rdbms/demo/demo_rdbms.mk
Found /oracle/product/v102/fullclnt/rdbms/lib/ins_rdbms.mk
Using /oracle/product/v102/fullclnt/rdbms/demo/demo_rdbms32.mk
Your LIBPATH env var is set to
'/usr/local/Tivoli/lib/aix4-r1:/usr/lib:/opt/netcool/platform/aix5/lib:/opt/netcool/omnibus/platform/aix5/lib'
WARNING: Your LIBPATH env var doesn't include
'/oracle/product/v102/fullclnt/lib32' but probably needs to.
Reading /oracle/product/v102/fullclnt/rdbms/demo/demo_rdbms32.mk
Reading /oracle/product/v102/fullclnt/rdbms/lib/env_rdbms.mk
Deleting -b64 from COMPOBJS because -b64 doesn't exist.
Attempting to discover Oracle OCI build rules
xlc_r -q32 -O -c DBD_ORA_OBJ.c
by executing: [make -f /oracle/product/v102/fullclnt/rdbms/demo/demo_rdbms32.mk
build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE=
CCFLD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
[ true -q32 -L/oracle/product/v102/fullclnt/lib32/
-L/oracle/product/v102/fullclnt/rdbms//lib32/ -o DBD_ORA_EXE DBD_ORA_OBJ.o
-lclntsh -lld -lcle/product/v102/fullclnt/lib32/sysliblist` -lm -lpthreads]
Found header files in /oracle/product/v102/fullclnt/rdbms/public.
client_version=10.2
DEFINE= -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102
Checking for functioning wait.ph
System: perl5.010001 aix dennis01 3 5 00c72e9a4c00
Compiler: xlc_r -q32 -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT
-qlanglvl=extendedal/include -q32 -D_LARGE_FILES -qlonglong
Linker: /usr/bin/ld
Sysliblist: /lib/crt0_64.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 -DSS_64BIT_SERVER -qwarn64 -qinfo=uni
-DAIXRIOS -qtocmerge -bimport:/oracle/product/v102/fullclnt/lib/ksms.imp
-I/ora/v102/fullclnt/rdbms/demo -I/oracle/product/v102/fullclnt/rdbms/public
-I/oracle/product/v102/fullclnt/plsql/public
-I/oracle/product/v102/fullclnt/network/pLAGS) $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/oracle/product/v102/fullclnt/rdbms/lib/ -L$(LIBHOME)]
Linking with OTHERLDFLAGS = -q32 -L/oracle/product/v102/fullclnt/lib32/
-L/oracle/product/v102/fullclnt/rdbms//lib32/ -lclntsh -lld -lm `cat
/oracle/produlclnt/lib32/sysliblist` -lm -lpthreads [from 'build' rule]
WARNING: You will may need to rebuild perl using the xlc_r compiler.
The important thing is that perl and DBD::Oracle be built with the
same compiler.
You may also need to: ORACCENV='cc=xlc_r'; export ORACCENV
Also see README.aix for gcc instructions and read about the -p option.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/oracle/product/v102/fullclnt/lib32:/oracle/product/v102/fullclnt/rdbms/lib32
Using DBD::Oracle 1.70.
Using DBD::Oracle 1.70.
Using DBI 1.631 (for perl 5.010001 on aix-thread-multi) installed in
/usr/opt/perl5/lib/site_perl/5.10.1/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.txt files.
(Of course, you have read README by now anyway, haven't you?)
[root@ews-pgh1-esmd2] /home/rj46/DBD-Oracle-1.70
# make
cp lib/DBD/Oracle/Troubleshooting/Cygwin.pod
blib/lib/DBD/Oracle/Troubleshooting/Cygwin.pod
cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/Troubleshooting/Vms.pod
blib/lib/DBD/Oracle/Troubleshooting/Vms.pod
cp lib/DBD/Oracle/Troubleshooting/Hpux.pod
blib/lib/DBD/Oracle/Troubleshooting/Hpux.pod
cp lib/DBD/Oracle/Troubleshooting/Linux.pod
blib/lib/DBD/Oracle/Troubleshooting/Linux.pod
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp lib/DBD/Oracle/Troubleshooting.pod blib/lib/DBD/Oracle/Troubleshooting.pod
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp lib/DBD/Oracle/Troubleshooting/Sun.pod
blib/lib/DBD/Oracle/Troubleshooting/Sun.pod
cp lib/DBD/Oracle/Troubleshooting/Macos.pod
blib/lib/DBD/Oracle/Troubleshooting/Macos.pod
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
cp lib/DBD/Oracle/Troubleshooting/Aix.pod
blib/lib/DBD/Oracle/Troubleshooting/Aix.pod
cp lib/DBD/Oracle/Troubleshooting/Win64.pod
blib/lib/DBD/Oracle/Troubleshooting/Win64.pod
cp lib/DBD/Oracle/Troubleshooting/Win32.pod
blib/lib/DBD/Oracle/Troubleshooting/Win32.pod
cp mk.pm blib/arch/auto/DBD/Oracle/mk.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.10.1/aix-thread-multi/auto/DBI/Driver.xst >
Oracle.xsi
/usr/bin/perl /usr/opt/perl5/lib/5.10.1/ExtUtils/xsubpp -typemap
/usr/opt/perl5/lib/5.10.1/ExtUtils/typemap -typemap typemap Oracle.xs >
Oracle.xscle.xsc Oracle.c
xlc_r -q32 -c -I/oracle/product/v102/fullclnt/rdbms/public
-I/oracle/product/v102/fullclnt/rdbms/demo
-I/oracle/product/v102/fullclnt/rdbms/public -oduct/v102/fullclnt/plsql/public
-I/oracle/product/v102/fullclnt/network/public
-I/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI
-D_ALL_SOURC_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
-DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -qlanglvl=extended -I/usr/local/include
-q32 -D_LARGE_FILES -qlonglDVERSION=\"1.70\" -DXS_VERSION=\"1.70\"
"-I/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE" -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 Or
xlc_r -q32 -c -I/oracle/product/v102/fullclnt/rdbms/public
-I/oracle/product/v102/fullclnt/rdbms/demo
-I/oracle/product/v102/fullclnt/rdbms/public -oduct/v102/fullclnt/plsql/public
-I/oracle/product/v102/fullclnt/network/public
-I/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI
-D_ALL_SOURC_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
-DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -qlanglvl=extended -I/usr/local/include
-q32 -D_LARGE_FILES -qlonglDVERSION=\"1.70\" -DXS_VERSION=\"1.70\"
"-I/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE" -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 db
xlc_r -q32 -c -I/oracle/product/v102/fullclnt/rdbms/public
-I/oracle/product/v102/fullclnt/rdbms/demo
-I/oracle/product/v102/fullclnt/rdbms/public -oduct/v102/fullclnt/plsql/public
-I/oracle/product/v102/fullclnt/network/public
-I/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI
-D_ALL_SOURC_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
-DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -qlanglvl=extended -I/usr/local/include
-q32 -D_LARGE_FILES -qlonglDVERSION=\"1.70\" -DXS_VERSION=\"1.70\"
"-I/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE" -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 oc
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/oracle/product/v102/fullclnt/lib32:/oracle/product/v102/fullclnt/rdbms/lib32"
ld -bhalt:4 -G -bI:/usr/opt/perl5/lib/5.10.1/aix-thread-perl.exp
-bE:Oracle.exp -bnoentry -lpthreads -lc -lm -L/usr/local/lib Oracle.o dbdimp.o
oci8.o -q32 -L/oracle/product/v102/fullclnt/lib32/
-L/oracle/producclnt/rdbms//lib32/ -lclntsh -lld -lm `cat
/oracle/product/v102/fullclnt/lib32/sysliblist` -lm -lpthreads -o
blib/arch/auto/DBD/Oracle/Oracle.so
ld: 0706-012 The -q flag is not recognized.
ld: 0706-012 The -3 flag is not recognized.
ld: 0706-012 The -2 flag is not recognized.
make: The error code from the last command is 255.
Stop.
[root@ews-pgh1-esmd2] /home/rj46/DBD-Oracle-1.70
