DBD::Oracle 1.18 installation problem

------_=_NextPart_001_01C6C74C.319F947D
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi
I try to install DBD::Oracle and I got message when I do make command
like this
=20
adm1med#spsy|DBD-Oracle-1.18> perl Makefile.PL
Using DBI 1.52 (for perl 5.008004 on sun4-solaris-64int) installed in
/usr/perl5
/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/
=20
Configuring DBD::Oracle for perl 5.008004 on solaris
(sun4-solaris-64int)
=20
Remember to actually *READ* the README file! Especially if you have any
problems
..
=20
Using Oracle in /u01/app/oracle/product/8.1.7
DEFINE _SQLPLUS_RELEASE =3D "801070000" (CHAR)
Oracle version 8.1.7.0 (8.1)
Found /u01/app/oracle/product/8.1.7/rdbms/demo/demo_rdbms.mk
Found /u01/app/oracle/product/8.1.7/precomp/demo/proc/demo_proc.mk
Using /u01/app/oracle/product/8.1.7/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/local/lib:/usr/dt/lib:/usr/openwin/
lib:/home/s/lib:/opt/SUNWspro/lib:/usr/ccs/lib:.:/u01/app/or acle/product
/8.1.7/l
ib:/u01/app/oracle/product/6.0.8/lib:/u01/app/oracle/product /6.0.8/netwo
rk/jre11
/lib/sparc/native_threads'
Reading /u01/app/oracle/product/8.1.7/rdbms/demo/demo_rdbms.mk
Reading /u01/app/oracle/product/8.1.7/rdbms/lib/env_rdbms.mk
=20
Attempting to discover Oracle OCI build rules
cc -c DBD_ORA_OBJ.c
by executing: [make -f
/u01/app/oracle/product/8.1.7/rdbms/demo/demo_rdbms.mk bu
ild ECHODO=3Decho ECHO=3Decho GENCLNTSH=3D'echo genclntsh' CC=3Dtrue =
OPTIMIZE=3D
CCFLAGS=
EXE=3DDBD_ORA_EXE OBJS=3DDBD_ORA_OBJ.o]
Oracle oci build command:
[true -L/u01/app/oracle/product/8.1.7/lib/
-L/u01/app/oracle/product/8.1
..7/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh
/u01/app/oracle/product/8.1.
7/rdbms/lib/kpuadef.o `sed -e 's/-ljava//g'
/u01/app/oracle/product/8.1.7/lib/l
dflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g'
/u01/app/oracle/
product/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8
-lwtc8 =20
-lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8
`sed -e=20
's/-ljava//g' /u01/app/oracle/product/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8
-ln8 -l
nl8 -lnro8 `sed -e 's/-ljava//g'
/u01/app/oracle/product/8.1.7/lib/ldflags` -lns
gr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8
-ltrace8=20
-lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8
-lcommon8 -lge
neric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `cat
/u01/app/oracle/product/8.1
..7/lib/sysliblist` `if [ -f /usr/lib/libsched.so ] ; then echo -lsched ;
else tr
ue; fi` -R/u01/app/oracle/product/8.1.7/lib -laio -lposix4 -lkstat -lm
-lthrea
d]
=20
Found header files in /u01/app/oracle/product/8.1.7/rdbms/public
/u01/app/oracle
/product/8.1.7/rdbms/demo.
=20
Checking for functioning wait.ph

System: perl5.008004 sunos localhost 5.10 sun4u sparc SUNW,Ultra-2
Compiler: cc -xO3 -xspace -xildoff -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64=20
-xarch=3Dv8 -D_TS_ERRNO
Linker: /usr/ccs/bin/ld
Sysliblist: -lnsl -lsocket -lgen -ldl -lsched=20
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS)
$(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO2 $(CDEBUG) -Xa $(PROFILE) -xstrconst -xF $(XS)
-mr -xar
ch=3Dv8 -xcache=3D16/32/1:1024/64/1 -xchip=3Dultra -D_REENTRANT -K PIC
$(QACCFLAGS) -I
/u01/app/oracle/product/8.1.7/rdbms/demo
-I/u01/app/oracle/product/8.1.7/rdbms/p
ublic -I/u01/app/oracle/product/8.1.7/plsql/public
-I/u01/app/oracle/product/8.1
..7/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD
$(LPFLAGS) $(USRF
LAGS)]
LDFLAGS: -L$(LIBHOME) -L$(RDBMSLIB)
[-L$(LIBHOME) -L/u01/app/oracle/product/8.1.7/rdbms/lib/]
Linking with OTHERLDFLAGS =3D -L/u01/app/oracle/product/8.1.7/lib/
-L/u01/app/orac
le/product/8.1.7/rdbms/lib/ -lclntsh
/u01/app/oracle/product/8.1.7/rdbms/lib/k
puadef.o `sed -e 's/-ljava//g'
/u01/app/oracle/product/8.1.7/lib/ldflags` -lnsg
r8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g'
/u01/app/oracle/product/8.1.7
/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8
-lcommon8 -lg
eneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e
's/-ljava//g'
/u01/app/oracle/product/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8
-lnro8 `s
ed -e 's/-ljava//g' /u01/app/oracle/product/8.1.7/lib/ldflags` -lnsgr8
-lnzjs8 -
ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8
-lnls8 -lcor
e8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8
-lgeneric8 -lnls8
-lcore8 -lnls8 -lcore8 -lnls8 `cat
/u01/app/oracle/product/8.1.7/lib/syslib
list` `if [ -f /usr/lib/libsched.so ] ; then echo -lsched ; else true;
fi` -R/u0
1/app/oracle/product/8.1.7/lib -laio -lposix4 -lkstat -lm -lthread
[from 'buil
d' rule]
=20

WARNING: If you have problems you may need to rebuild perl with
threading enabled.
Checking if your kit is complete...
Warning: the following files are missing in your kit:
META.yml
Please inform the author.
Ignoring
LD_RUN_PATH=3D'/usr/local/lib:/usr/dt/lib:/usr/openwin/lib:/ home/s/lib:/o=

pt/SUNWspro/lib:/usr/ccs/lib:.:/u01/app/oracle/product/8.1.7 /lib:/u01/ap
p/oracle
/product/6.0.8/lib:/u01/app/oracle/product/6.0.8/network/jre 11/lib/sparc
/native_
threads' in environment
LD_RUN_PATH=3D/u01/app/oracle/product/8.1.7/lib:/u01/app/ora cle/product/8=
..
1.7/rdbm
s/lib
Using DBD::Oracle 1.18.
Using DBD::Oracle 1.18.
Using DBI 1.52 (for perl 5.008004 on sun4-solaris-64int) installed in
/usr/perl5
/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/
Writing Makefile for DBD::Oracle
=20
*** 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?)

=20
Do the make command:
make
=20
adm1med#spsy|DBD-Oracle-1.18> make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/usr/perl5/site_perl/5.8.4/sun4-
solaris-64int/auto/DBI/Driver.xst > Oracle.xsi
/usr/local/bin/perl /usr/perl5/5.8.4/lib/ExtUtils/xsubpp -typemap
/usr/perl5/5.
8.4/lib/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv
Oracle.x
sc Oracle.c
cc -c -I/u01/app/oracle/product/8.1.7/rdbms/public
-I/u01/app/oracle/product/8.
1.7/rdbms/demo -I/u01/app/oracle/product/8.1.7/rdbms/demo
-I/u01/app/oracle/prod
uct/8.1.7/rdbms/public -I/u01/app/oracle/product/8.1.7/plsql/public
-I/u01/app/o
racle/product/8.1.7/network/public
-I/usr/perl5/site_perl/5.8.4/sun4-solaris-64i
nt/auto/DBI -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 -xarch=3Dv8
-D_TS_ERRNO -x
O3 -xspace -xildoff -DVERSION=3D\"1.18\" -DXS_VERSION=3D\"1.18\" =
-KPIC
"-I/usr/p
erl5/5.8.4/lib/sun4-solaris-64int/CORE" -DUTF8_SUPPORT
-DORA_OCI_VERSION=3D\"8.1.
7.0\" Oracle.c
"Oracle.xs", line 269: undefined symbol: startp
"Oracle.xs", line 269: warning: argument #4 is incompatible with
prototype:
prototype: pointer to unsigned int :
"/u01/app/oracle/product/8.1.7/rdbm
s/demo/ociap.h", line 5838
argument : pointer to int
cc: acomp failed for Oracle.c
*** Error code 2
make: Fatal error: Command failed for target `Oracle.o'
=20
I use perl 5.6.1 bundled with Solaris 10 and I got this error message
Do anyone can help me ?
=20
regards
AEL

------_=_NextPart_001_01C6C74C.319F947D--

Re: DBD::Oracle 1.18 installation problem

------=_Part_47920_26840569.1156442128494
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 8/24/06, Lampang, Arman Elianto wrote:
>
>
> *** Error code 2
> make: Fatal error: Command failed for target `Oracle.o'
>
> I use perl 5.6.1 bundled with Solaris 10 and I got this error message
> Do anyone can help me ?



Use a current version of Perl.

I don't know if that is the exact problem here, but that is where I would
start.

Current versions are 5.8.x.

Many folks consider it best practice to install a separate version of Perl
for use with database work.

Modifying (such as adding modules) the version used by the OS is not
generally a good idea.


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

------=_Part_47920_26840569.1156442128494--

Re: DBD::Oracle 1.18 installation problem

Lampang, Arman Elianto wrote:

> erl5/5.8.4/lib/sun4-solaris-64int/CORE" -DUTF8_SUPPORT
> -DORA_OCI_VERSION=\"8.1.
> 7.0\" Oracle.c
> "Oracle.xs", line 269: undefined symbol: startp
> "Oracle.xs", line 269: warning: argument #4 is incompatible with
> prototype:
> prototype: pointer to unsigned int :
> "/u01/app/oracle/product/8.1.7/rdbm
> s/demo/ociap.h", line 5838
> argument : pointer to int
> cc: acomp failed for Oracle.c
> *** Error code 2
> make: Fatal error: Command failed for target `Oracle.o'
>
> I use perl 5.6.1 bundled with Solaris 10 and I got this error message
> Do anyone can help me ?
>
> regards
> AEL
Edit Oracle.xs and a little before line 269 you will see startp
definition commented out - uncomment it and try again.

Martin

RE: DBD::Oracle 1.18 installation problem

>On 8/24/06, Lampang, Arman Elianto wrote:
>>
>>
>> *** Error code 2
>> make: Fatal error: Command failed for target `Oracle.o'
>>
>> I use perl 5.6.1 bundled with Solaris 10 and I got this error message
>> Do anyone can help me ?

>Use a current version of Perl.
>
>I don't know if that is the exact problem here, but that is where I
would
>start.
>
>Current versions are 5.8.x.
>
>Many folks consider it best practice to install a separate version of
Perl
>for use with database work.
>
>Modifying (such as adding modules) the version used by the OS is not
>generally a good idea.

It's not really just because it is not generally a good idea, as far as
I remember=0D
In order for it to work at all you have to compile any additional
modules (or DBI and DBDs anyway) with the same compiler that perl was
built with. Generally that is not available or practical.
Get your own perl but make sure you don't install it over the one that
is there that is generally a bad thing.

Ken.


************************************************************ ***************=
************************************************************ *************
This e-mail and any accompanying documents contain confidential information=
intended for a specific individual which is private and protected by law.
If you are not the intended recipient, any disclosure, copying,=
distribution or other use of this information is strictly prohibited.
You are also requested to advise us immediately if you receive information=
which is not addressed to you.
beCogent is Authorised and Regulated by the Financial Services Authority.
************************************************************ ***************=
************************************************************ **************

Re: DBD::Oracle 1.18 installation problem

Gaul, Ken wrote:
[snip]

>
> It's not really just because it is not generally a good idea, as far as
> I remember
> In order for it to work at all you have to compile any additional
> modules (or DBI and DBDs anyway) with the same compiler that perl was
> built with. Generally that is not available or practical.
> Get your own perl but make sure you don't install it over the one that
> is there that is generally a bad thing.

Dunno if this is relavant but when I installed the Linux version of the
Oracle 10gR2 client, it included Perl 5.8.3 with the DBI and DBD::Oracle
modules alreday compiled and ready to go.

--
Stephen Carville
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602