RE: make problem

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 05/26/04 

Date: Tue, 25 May 2004 16:15:04 -0600
To: "Hom, Soo" <syhom@ucsd.edu>, <dbi-users@perl.org>

Comments below ...
 
And, did you read and follow the suggestions in the README* files?
 

-----------------
Ron Reidy
Senior DBA
Array BioPharma, Inc.

 -----Original Message-----
From: Hom, Soo [mailto:syhom@ucsd.edu]
Sent: Tuesday, May 25, 2004 4:05 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: make problem

 

 

OK.

 

1. What version of Solaris?

pascal# uname -a

SunOS pascal 5.8 Generic_108528-16 sun4u sparc SUNW,Ultra-80

 

2. What is the output of 'perl -V' (is Perl built as 64 bit)?

 

How do I check if it is 64bit? I did the default install from source.

 

pascal# /usr/local/perl5/bin/perl -V

Summary of my perl5 (revision 5 version 8 subversion 4) configuration:

  Platform:

    osname=solaris, osvers=2.8, archname=sun4-solaris

    uname='sunos pascal 5.8 generic_108528-16 sun4u sparc sunw,ultra-80 '

    config_args=''

    hint=recommended, useposix=true, d_sigaction=define

    usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef

    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef

    use64bitint=undef use64bitall=undef uselongdouble=undef

    usemymalloc=n, bincompat5005=undef

  Compiler:

    cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',

    optimize='-O',

    cppflags='-fno-strict-aliasing -I/usr/local/include'

    ccversion='', gccversion='3.4.0', gccosandvers='solaris2.8'

    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321

    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16

    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8

    alignbytes=8, prototype=define

  Linker and Libraries:

    ld='gcc', ldflags =' -L/usr/local/lib '

    libpth=/usr/local/lib /usr/lib /usr/ccs/lib

    libs=-lsocket -lnsl -ldl -lm -lc

    perllibs=-lsocket -lnsl -ldl -lm -lc

    libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a

    gnulibc_version=''

  Dynamic Linking:

    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '

    cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'

 

 

Characteristics of this binary (from libperl):

  Compile-time options: USE_LARGE_FILES

  Built under solaris

  Compiled at May 14 2004 11:16:19

  @INC:

    /usr/local/perl5/lib/5.8.4/sun4-solaris

    /usr/local/perl5/lib/5.8.4

    /usr/local/perl5/lib/site_perl/5.8.4/sun4-solaris

    /usr/local/perl5/lib/site_perl/5.8.4

    /usr/local/perl5/lib/site_perl

    /opt2/perl5.005/lib/site_perl/5.005/sun4-solaris

    /opt2/perl5.005/lib/site_perl/5.005/sun4-solaris

    /opt2/perl5.005/lib/site_perl/5.005

    .

 

3. What version **exactly** of Oracle (Hint: select banner from v$version)?

 

Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production - Whoa! This could be the problem (not too sure about this though)

PL/SQL Release 9.2.0.2.0 - Production

CORE 9.2.0.2.0 Production

TNS for Solaris: Version 9.2.0.2.0 - Production

NLSRTL Version 9.2.0.2.0 - Production

 

4. What is your Oracle environment (env | grep ORA)?

 

pascal# env | grep ORA

ORACLE_HOME=/export/home/oracle
[Reidy, Ronald] This is all of your environment? Looks suspiciously small. Did you set your environment with the oraenv shell script (i.e '. oraenv' and then answer the question about which ORACLE_SID to use (Hint: you will need to be using the file /etc/oratab for oraenv to work correctly)). Additionally, oraenv will set your PATH var to include $ORACLE_HOME/bin. For more info on oraenv, read the DBA docs from Oracle.

 

-----------------
Ron Reidy
Senior DBA
Array BioPharma, Inc.

-----Original Message-----
From: Hom, Soo [mailto:syhom@ucsd.edu]
Sent: Tuesday, May 25, 2004 3:36 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: make problem

I am running oracle 9i.

 

Soo

 

-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
Sent: Tuesday, May 25, 2004 2:31 PM
To: Hom, Soo; dbi-users@perl.org
Subject: RE: make problem

 

What version of Oracle are you using?

 

-----------------
Ron Reidy
Senior DBA
Array BioPharma, Inc.
303.386.1480

-----Original Message-----
From: Hom, Soo [mailto:syhom@ucsd.edu]
Sent: Tuesday, May 25, 2004 3:29 PM
To: dbi-users@perl.org
Subject: make problem

 

 

Hello,

 

 

I am attempting to run make on DBD-Oracle-1.15 and I get this fatal error:

gcc -c -I/export/home/oracle/rdbms/demo -I/export/home/oracle/rdbms/public -I/export/home/oracle/plsql/public -I/export/home/oracle/network/public -I/export/home/oracle/rdbms/demo -I/export/home/oracle/rdbms/public -I/export/home/oracle/rdbms/demo -I/usr/local/perl5/lib/site_perl/5.8.4/sun4-solaris/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I/usr/local/perl5/lib/5.8.4/sun4-solaris/CORE" -DUTF8_SUPPORT xstmp.c

Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_write':

Oracle.c:874: error: syntax error before '*' token

Oracle.xs:126: error: `data' undeclared (first use in this function)

Oracle.xs:126: error: (Each undeclared identifier is reported only once

Oracle.xs:126: error: for each function it appears in.)

Oracle.xs:131: error: `offset' undeclared (first use in this function)

Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_read':

Oracle.c:971: error: syntax error at '#' token

Oracle.c:971: error: syntax error before "line"

Oracle.xs:193: error: `length' undeclared (first use in this function)

Oracle.xs:202: error: `imp_dbh' undeclared (first use in this function)

Oracle.xs:202: error: `offset' undeclared (first use in this function)

Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_trim':

Oracle.c:1025: error: syntax error at '#' token

Oracle.c:1025: error: syntax error before numeric constant

Oracle.xs:229: error: `imp_dbh' undeclared (first use in this function)

Oracle.xs:229: error: `length' undeclared (first use in this function)

make: *** [xstmp.o] Error 1

 

 

any ideas how to fix this? I have attached the full output.

 

 

 

# /usr/local/perl5/bin/perl -v

 

This is perl, v5.8.4 built for sun4-solaris

 

Copyright 1987-2004, Larry Wall

 

Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5 source kit.

 

Complete documentation for Perl, including FAQ lists, should be found on

this system using `man perl' or `perldoc perl'. If you have access to the

Internet, point your browser at http://www.perl.com/, the Perl Home Page.

 

 

 

 

Soo

  _____

This electronic message transmission is a PRIVATE communication which contains information
which may be confidential or privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, please be aware that any disclosure,
copying, distribution or use of the contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),
and then delete it from your system.

  _____

This electronic message transmission is a PRIVATE communication which contains information
which may be confidential or privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, please be aware that any disclosure,
copying, distribution or use of the contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),
and then delete it from your system.

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.