I am having issue with DBD-Oracle-1.14 on an AIX system with Oracle 8.0.6. I can get DBD-Oracle-1.09 to build with no error but .14 can not find some needed header file defines. I get similar errors with .12. Did support for version 8.0.X stop at .09? Has anyone send this issue before?
Before is the output from the perl Makefile.PL -v, perl -V, and my Oracle setup. Thanks Marty Everett IKON Office Solutions Data Center. -----Original Message----- From: ei3701 [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 1:16 PM To: [EMAIL PROTECTED] Subject: Script command is started on Wed Jul 16 13:09:06 EDT [EMAIL PROTECTED] /tmp/perl/DBD-Oracle-1.14 # echo $ORACLE_HOME /opt301/app/oracle/dev3ora/8.0.6 [EMAIL PROTECTED] /tmp/perl/DBD-Oracle-1.14 # echo $ORACLE_SID DEV3 [EMAIL PROTECTED] /tmp/perl/DBD-Oracle-1.14 # echo $TWO_TASK DEV3 [EMAIL PROTECTED] /tmp/perl/DBD-Oracle-1.14 # echo $PATH /usr/lpp/ssp/bin:/usr/lpp/ssp/install/bin:/usr/lpp/ssp/rcmd/bin:/usr/lpp/ssp /kerberos/bin:/usr/lpp/csd/bin:/usr/local/bin:/usr/lpp/ssp/bin:/usr/lpp/ssp/ install/bin:/usr/lpp/ssp/rcmd/bin:/usr/lpp/ssp/kerberos/bin:/usr/lpp/csd/bin :/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/opt /ifor/ls/os/aix/bin:.:/opt/freeware/bin:/opt301/app/oracle/dev3ora/8.0.6/bin :/opt301/app/oracle/dev3ora/8.0.6/bin:.:/opt/freeware/bin [EMAIL PROTECTED] /tmp/perl/DBD-Oracle-1.14 # echo $LIBPATH /opt301/app/oracle/dev3ora/8.0.6/lib [EMAIL PROTECTED] /tmp/perl/DBD-Oracle-1.14 # perl Makefile.PL -v Using DBI 1.37 installed in /usr/opt/perl5/lib/site_perl/5.6.0/aix/auto/DBI Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /opt301/app/oracle/dev3ora/8.0.6 4.0.3.0 Oracle Unix Installer 1.0.1.0.0 Oracle On-Line Text Viewer 8.0.6.0.0 Client Software 8.0.6.0.0 Ordts Common Libraries 8.0.6.0.0 ORACLE NLS Libraries and Utilities 8.0.6.0.0 ORACLE Core Libraries 8.0.6.0.0 ORACLE Common RDBMS Libraries and Utilities 8.0.6.0.0 ORACLE PL/SQL Libraries 8.0.6.0.0 ORACLE Common Libraries 8.0.6.0.0 ORACLE Common Precomp Libraries 8.0.6.3.0 ORACLE Common Network Libraries and Utilities 8.0.6.0.0 ORACLE Common Trace Libraries 8.0.6.0.0 ORACLE Common Utilities 8.0.6.0.0 ORACLE Common Agent Libraries 8.0.6.0.0 ORACLE Common Libraries and Utilities 8.0.6.0.0 Platform specific Libraries and Utilities 8.0.6.3.0 Net8 (SQL*Net and Names) 8.0.6.0.0 TCP/IP Protocol Adapter 3.0.2.0.0 Remote Operations .... Oracle Names 6.0.5.34.1 ToolKit 6.0 Base 8.0.6.3.0 PL/SQL 3.0.6.0.0 Oracle Server Manager 8.0.6.3.0 Oracle8 (RDBMS & PLSQL) 1.0.0.0.1 <Database Startup> Load Files 8.0.6.0.1 Oracle Intelligent Agent 4.0.0 Oracle Trace 8.0.6.3.0 Precomp 8.0.6.3.0 Pro*C/C++ 8.0.6.0.0 SQL*Plus 6.0.5.34.1 ToolKit 6.0 Extension 6.0.5.33.0 Multimedia APIs 6.0.5.32.0 Tools Common Area 6.0.5.34.1 PL/SQL Procedure Builder 6.0.5.32.0 Integration Services 6.0.8.3.2 Oracle SQL Manager Library 6.0.5.34.0 Virtual Graphics System 6.0.5.33.0 Oracle Charting Library 6.0.5.39.0 Oracle Graphics 6.0.8.8.0 Oracle Forms Server and Forms Developer 6.0.8.8.3 Oracle Reports Server and Reports Developer 6.0.8.3.5 ZRC Library 6.0.5.31.0 GE Libraries Oracle Jinitiator (Domestic) Oracle JDK Appletviewer (Domestic) 6.0.5.32.0 Oracle Browser 2.1 Oracle Wallet Manager 2.0.0.0 Common documentation resources 8.0.6.0 Oracle for AIX-Based Systems Documentation 6.0.5.0.0 Resource Object Store 6.0.5.33.1 Toolkit Utility Library 6.0.5.33.1 Toolkit Automation Library 6.0.4.0.0 Oracle Information Navigator 6.0.8.6.8 Online Documentation Library Oracle version 8.0.6 Found header files in rdbms/demo. Found /opt301/app/oracle/dev3ora/8.0.6/rdbms/demo/demo_rdbms.mk Found /opt301/app/oracle/dev3ora/8.0.6/otrace/demo/atmoci.mk Found /opt301/app/oracle/dev3ora/8.0.6/precomp/demo/proc/demo_proc.mk Using /opt301/app/oracle/dev3ora/8.0.6/rdbms/demo/demo_rdbms.mk Reading /opt301/app/oracle/dev3ora/8.0.6/rdbms/demo/demo_rdbms.mk Reading /opt301/app/oracle/dev3ora/8.0.6/rdbms/lib/env_rdbms.mk Read a total of 617 lines from /opt301/app/oracle/dev3ora/8.0.6/rdbms/lib/env_rdbms.mk (including inclusions) Read a total of 805 lines from /opt301/app/oracle/dev3ora/8.0.6/rdbms/demo/demo_rdbms.mk (including inclusions) Deleted SHELL definition: SHELL=/bin/sh Deleted LIB_EXT definition: LIB_EXT=a Deleted OBJ_EXT definition: OBJ_EXT=o Deleted AR definition: AR=ar Deleted AS definition: AS=as Deleted CC definition: CC=cc Deleted CHMOD definition: CHMOD=chmod Deleted CPP definition: CPP=cpp Deleted ECHO definition: ECHO=echo Deleted LD definition: LD=ld Deleted PERL definition: PERL=perl Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) Deleted LDFLAGS definition: LDFLAGS=-o $@ -L$(PRODLIBHOME) -L$(LIBHOME) Deleted OPTIMIZE definition: OPTIMIZE=-O # With XLC, -O == -O2 Deleted AR definition: AR=/bin/ar Deleted AS definition: AS=/bin/as Deleted CPP definition: CPP=/lib/cpp Deleted CC definition: CC=$(ORACLE_HOME)/bin/oraxlc $(ORAXLCFLAGS) Deleted CHMOD definition: CHMOD=/bin/chmod Deleted ASFLAGS definition: ASFLAGS= Deleted CCFLAGS definition: CCFLAGS= 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. Deleted ORA_NLS definition: ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ 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. Deleted ORA_NLS33 definition: ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ Deleted LDFLAGS definition: LDFLAGS=-L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib Attempting to discover Oracle OCI build rules cc -O -c DBD_ORA_OBJ.c by executing: (make -f /opt301/app/oracle/dev3ora/8.0.6/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) returned: [ echo echo -L/opt301/app/oracle/dev3ora/8.0.6/lib/ -L/opt301/app/oracle/dev3ora/8.0.6/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh [echo -L/opt301/app/oracle/dev3ora/8.0.6/lib/ -L/opt301/app/oracle/dev3ora/8.0.6/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh ] reduced to: [-L/opt301/app/oracle/dev3ora/8.0.6/lib/ -L/opt301/app/oracle/dev3ora/8.0.6/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh ] Oracle oci build command: + -L/opt301/app/oracle/dev3ora/8.0.6/lib/ -L/opt301/app/oracle/dev3ora/8.0.6/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh System: perl5.006 aix shaq 1 5 006044854c00 Compiler: cc -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -q32 -D_LARGE_FILES -qlonglong Linker: /usr/bin/ld Sysliblist: /lib/crt0_r.o -lsvld -lc_r -lpthreads -lodm -lm 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) -O $(CDEBUG) $(QACCFLAGS) -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/public -I/opt301/app/oracle/dev3ora/8.0.6/plsql/public -I/opt301/app/oracle/dev3ora/8.0.6/network/public -DSLXMX_ENABLE -DSLTS_ENABLE $(LPFLAGS) $(USRFLAGS)] LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib [-L$(LIBHOME) -L/opt301/app/oracle/dev3ora/8.0.6/rdbms/lib] Linking with OTHERLDFLAGS = -L/opt301/app/oracle/dev3ora/8.0.6/lib/ -L/opt301/app/oracle/dev3ora/8.0.6/rdbms/lib -lclntsh [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 MakeMaker (v5.45) Checking if your kit is complete... Looks good ABSTRACT_FROM => q[Oracle.pm] AUTHOR => q[Tim Bunce ([EMAIL PROTECTED])] DEFINE => q[ -DUTF8_SUPPORT] DIR => [] EXE_FILES => [q[ora_explain]] INC => q[-I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/public -I/opt301/app/oracle/dev3ora/8.0.6/plsql/public -I/opt301/app/oracle/dev3ora/8.0.6/network/public -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/usr/opt/perl5/lib/site_perl/5.6.0/aix/auto/DBI] NAME => q[DBD::Oracle] OBJECT => q[$(O_FILES)] PREREQ_PM => { DBI=>q[0] } VERSION_FROM => q[Oracle.pm] clean => { FILES=>q[Oracle.xsi dll.base dll.exp sqlnet.log libOracle.def ora_explain mk.pm] } dist => { DIST_DEFAULT=>q[clean distcheck disttest ci tardist], PREOP=>q[$(MAKE) -f Makefile.old distdir], COMPRESS=>q[gzip -v9], SUFFIX=>q[gz] } dynamic_lib => { OTHERLDFLAGS=>q[ -L/opt301/app/oracle/dev3ora/8.0.6/lib/ -L/opt301/app/oracle/dev3ora/8.0.6/rdbms/lib -lclntsh ] } Using PERL=/usr/bin/perl LD_RUN_PATH=/opt301/app/oracle/dev3ora/8.0.6/lib:/opt301/app/oracle/dev3ora/ 8.0.6/rdbms/lib Using DBD::Oracle 1.14. Using DBI 1.37 installed in /usr/opt/perl5/lib/site_perl/5.6.0/aix/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?) [EMAIL PROTECTED] /tmp/perl/DBD-Oracle-1.14 # make mkdir blib mkdir blib/lib mkdir blib/lib/DBD cp Oracle.pm blib/lib/DBD/Oracle.pm cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h cp oraperl.ph blib/lib/oraperl.ph cp Oraperl.pm blib/lib/Oraperl.pm /usr/bin/perl "-I/usr/opt/perl5/lib/5.6.0/aix" "-I/usr/opt/perl5/lib/5.6.0" -e 'use ExtUtils::Mksymlists; Mksymlists("NAME" => "DBD::Oracle", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_VARS" => []);' /bin/sh -c true /bin/sh -c true /usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" < /usr/opt/perl5/lib/site_perl/5.6.0/aix/auto/DBI/Driver.xst > Oracle.xsi /usr/bin/perl -I/usr/opt/perl5/lib/5.6.0/aix -I/usr/opt/perl5/lib/5.6.0 /usr/opt/perl5/lib/5.6.0/ExtUtils/xsubpp -typemap /usr/opt/perl5/lib/5.6.0/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c cc -c -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/public -I/opt301/app/oracle/dev3ora/8.0.6/plsql/public -I/opt301/app/oracle/dev3ora/8.0.6/network/public -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/usr/opt/perl5/lib/site_perl/5.6.0/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -I/usr/opt/perl5/lib/5.6.0/aix/CORE -DUTF8_SUPPORT Oracle.c cc -c -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/public -I/opt301/app/oracle/dev3ora/8.0.6/plsql/public -I/opt301/app/oracle/dev3ora/8.0.6/network/public -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/usr/opt/perl5/lib/site_perl/5.6.0/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -I/usr/opt/perl5/lib/5.6.0/aix/CORE -DUTF8_SUPPORT dbdimp.c cc -c -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/public -I/opt301/app/oracle/dev3ora/8.0.6/plsql/public -I/opt301/app/oracle/dev3ora/8.0.6/network/public -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/usr/opt/perl5/lib/site_perl/5.6.0/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -I/usr/opt/perl5/lib/5.6.0/aix/CORE -DUTF8_SUPPORT oci7.c cc -c -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/public -I/opt301/app/oracle/dev3ora/8.0.6/plsql/public -I/opt301/app/oracle/dev3ora/8.0.6/network/public -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/opt301/app/oracle/dev3ora/8.0.6/rdbms/demo -I/usr/opt/perl5/lib/site_perl/5.6.0/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -I/usr/opt/perl5/lib/5.6.0/aix/CORE -DUTF8_SUPPORT oci8.c "oci8.c", line 1643.41: 1506-045 (S) Undeclared identifier OCI_ATTR_OBJ_NAME. make: 1254-004 The error code from the last command is 1. Stop. Script command is complete on Wed Jul 16 13:12:58 EDT 2003.
