Hi Support,
DBI has been successfully installed after the instaltion of XLC trail
version..Now I am facing issue with DBD-oracle..
I was trying to install DBD module but I receve the errors
bash-3.2# perl Makefile.PL
Using DBI 1.625 (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.
Trying to find an ORACLE_HOME
Your LIBPATH env var is set to ''
The ORACLE_HOME environment variable is not set and I couldn't guess it.
It must be set to hold the path to an Oracle installation directory
on this machine (or a machine with a compatible architecture).
See the appropriate README file for your OS for more information.
ABORTED!
================================================
After this I set the path
export ORACLE_BASE=/u01/app/oracle/product
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export SHLIB_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export
PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/bin/x11:/usr/local/bin:/usr/vacpp/bin:$PATH
export ORACLE_SID=
Then I receive these errors
==================================================================
bash-3.2# perl Makefile.PL
Using DBI 1.625 (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 /u01/app/oracle/product/11.2.0/dbhome_1
DEFINE _SQLPLUS_RELEASE = "1102000300" (CHAR)
Oracle version 11.2.0.3 (11.2)
Found /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Using /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Your LIBPATH env var is set to ''
WARNING: Your LIBPATH env var doesn't include
'/u01/app/oracle/product/11.2.0/dbhome_1/lib' but probably needs to.
Reading /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Reading /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk
Deleting -b64 from COMPOBJS because -b64 doesn't exist.
WARNING: Oracle
/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk doesn't define a
'build' rule.
WARNING: I will now try to guess how to build and link DBD::Oracle for
you.
This kind of guess work is very error prone and Oracle-version
sensitive.
It is possible that it won't be supported in future versions
of DBD::Oracle.
*PLEASE* notify dbi-users about exactly _why_ you had to build
it this way.
Found header files in
/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public.
client_version=11.2
DEFINE= -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.3\" -DORA_OCI_102
-DORA_OCI_112
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=extended -I/usr/local/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 -qflag=s:s
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/demo
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/plsql/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/network/public -DLDAP_CM $(LPFLAGS)
$(PLSQLNCGFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/
-L$(LIBHOME)]
Linking with /lib/crt0_64.o -lclntsh -brtl -lld -lm -ldl -lc -lm
-lpthreads -lodm -lbsd_r -lld -lperfstat -lm -lpthreads [from $(OCISHAREDLIBS)]
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
Unrecognized argument in LIBS ignored: '-brtl'
LD_RUN_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib
Using DBD::Oracle 1.62.
Using DBD::Oracle 1.62.
Using DBI 1.625 (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?)
bash-3.2#
Thanks for the replay ,I think we don't have xlc.. but in software listing its
showing ..but I cannot find the binaries for it.
I have already gcc but it says most of the option are not available with gcc..
Anoop Kumar Paramesweran | Expert - Unix and Storage Systems
e anoop.ku...@nawras.om | m +96895103659 twitter/nawras_oman | facebook/nawras
-----Original Message-----
From: Martin J. Evans [mailto:boh...@ntlworld.com]
Sent: Wednesday, May 01, 2013 11:07 PM
To: dbi-users@perl.org
Cc: Anoop Kumar Paramesweran
Subject: Re: DBI Module installtion
On 29/04/2013 14:55, Anoop Kumar Paramesweran wrote:
> Hi Support,
>
> I am receiving below error while installing (make ) DBI module in my
> AIX box. As I am new to Perl installations could you please help me to
> solve this..
>
> xlc_r -q32 -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT
> -qlanglvl=extended -I/usr/local/include -q32 -D_LARGE_FILES -qlonglong
> -O -DVERSION=\"1.625\" -DXS_VERSION=\"1.625\"
> "-I/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE" Perl.c
> /bin/sh: xlc_r: not found.
> make: 1254-004 The error code from the last command is 127.
>
>
> Stop.
The Perl you are using was compiled with the AIX C compiler and it is either a)
not installed or b) it is not on your path.
You can either:
a) add the AIX compiler xlc_r to your path if you have it installed (you
usually have to pay IBM for this compiler)
b) install the IBM compiler and add it to your PATH.
c) install another compiler such as gcc (which is free), build Perl yourself
into some dir you can point your PATH at and then install DBI.
You might find perlbrew useful if you end up here.
Mostly when people report the issue you have they have installed Perl from a
package provided by IBM that they built with their compiler and you don't have
this compiler. When Perl is built is records the compiler and options used and
generally you cannot compile Perl itself with one compiler and then modules
which require a C compiler with another compiler.
Martin
--
Martin J. Evans
Wetherby, UK
This e-mail including any attachment is intended only for the recipient(s)
named. It may contain confidential information and should not be read, copied
or otherwise used by any other person. If you are not a named recipient, please
contact the sender and delete the e-mail from your system. The sender does not
accept any liability for errors or omissions in the content of this message or
for viruses, or any damage due to the e-mail. The recipient is advised to have
appropriate virus check software
