Introduction

I'm developing an application to caracterize workloads for the supercomputers
here and have worked on a resource management usage reporting system using
Oracle 9i with DBD::Oracle on a Solaris platform. I've recently obtained and
installed Oracle 10.2 XE on my workstation to be able to do development work
on it and am trying to get DBD::Oracle installed. I've worked in computers
(hardware maintenance,operations,programming) for over 30 years.

--
Charles D. (Chuck) Harding Voice: 925-423-8879
Senior Computer Associate ICCD Fax: 925-423-6961
Lawrence Livermore National Laboratory Computation Directorate
Livermore, CA USA http://www.llnl.gov GPG Public Key ID: B9EB6601
------------------ http://tinyurl.com/5w5ey -----------------------
-- Let's make the draft retroactive & send Clinton to Nam! --

RE: Introduction

And the question is?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Chuck Harding [mailto:charding@llnl.gov]=20
Sent: Thursday, November 10, 2005 4:21 PM
To: dbi-users@perl.org
Subject: Introduction


I'm developing an application to caracterize workloads for the
supercomputers here and have worked on a resource management usage
reporting system using Oracle 9i with DBD::Oracle on a Solaris platform.
I've recently obtained and installed Oracle 10.2 XE on my workstation to
be able to do development work on it and am trying to get DBD::Oracle
installed. I've worked in computers (hardware
maintenance,operations,programming) for over 30 years.

--=20
Charles D. (Chuck) Harding Voice: 925-423-8879
Senior Computer Associate ICCD Fax: 925-423-6961
Lawrence Livermore National Laboratory Computation Directorate
Livermore, CA USA http://www.llnl.gov GPG Public Key ID: B9EB6601
------------------ http://tinyurl.com/5w5ey -----------------------
-- Let's make the draft retroactive & send Clinton to Nam! --

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.

Re: Introduction

Perhaps he is just curious about getting DBD::Oracle working with XE? I
know I am. :)



Reidy, Ron wrote:

>And the question is?
>
>--
>Ron Reidy
>Lead DBA
>Array BioPharma, Inc.
>
>-----Original Message-----
>From: Chuck Harding [mailto:charding@llnl.gov]
>Sent: Thursday, November 10, 2005 4:21 PM
>To: dbi-users@perl.org
>Subject: Introduction
>
>
>I'm developing an application to caracterize workloads for the
>supercomputers here and have worked on a resource management usage
>reporting system using Oracle 9i with DBD::Oracle on a Solaris platform.
>I've recently obtained and installed Oracle 10.2 XE on my workstation to
>be able to do development work on it and am trying to get DBD::Oracle
>installed. I've worked in computers (hardware
>maintenance,operations,programming) for over 30 years.
>
>
>

--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
Have a nice diurnal anomaly!

RE: Introduction

On Thu, 10 Nov 2005, Reidy, Ron wrote:

> And the question is?
>
> --
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>

Glad you asked. The latest and greatest DBD::Oracle does not appear able
to be installed with Oracle 10.2 XE - it seems as though the installation
of Oracle is different enough to stump Makefile.PL - so my question is:
Will DBD::Oracle get updated to work with Oracle 10.2 XE, and if so, when?

The output from my attempt at installing DBD::Oracle is included:

Script started on Thu 10 Nov 2005 03:08:31 PM PST
]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16[root@ghos twheel DBD-Oracle-1.16]# perl Makefile.PL -v
Using DBI 1.48 (for perl 5.008005 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/ DBI/

Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!
Especially if you have any problems.

Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)

Unable to locate an oracle.mk, proc.mk or other suitable *.mk
file in your Oracle installation. (I looked in
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/li b/oracle.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/oracle.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/demo_rdbms.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/otrace/d emo/atmoci.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/precomp/ demo/proc/proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/precomp/ demo/proc/demo_proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/proc/lib /proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/proc16/l ib/proc16.mk)

The oracle.mk (or demo_rdbms.mk) file is part of the Oracle
RDBMS product. The proc.mk (or demo_proc.mk) file is part of
the Oracle Pro*C product. You need to build DBD::Oracle on a
system which has one of these Oracle components installed.
(Other *.mk files such as the env_*.mk files will not work.)

In the unlikely event that a suitable *.mk file is installed
somewhere non-standard you can specify where it is using the -m option:
perl Makefile.PL -m /path/to/your.mk

See README.clients for more information and some alternatives.

at Makefile.PL line 922.
]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16[root@ghos twheel DBD-Oracle-1.16]# perl -V
Summary of my perl5 (revision 5 version 8 subversion 5) configuration:
Platform:
osname=linux, osvers=2.4.21-27.0.2.elsmp, archname=i386-linux-thread-multi
uname='linux decompose.build.redhat.com 2.4.21-27.0.2.elsmp #1 smp wed jan 12 23:35:44 est 2005 i686 i686 i386 gnulinux '
config_args='-des -Doptimize=-O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -Dversion=5.8.5 -Dmyhostname=localhost -Dperladmin=root@localhost -Dcc=gcc -Dcf_by=Red Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux -Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio -Dinstallusrbinperl -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less -isr -Dinc_version_list=5.8.4 5.8.3 5.8.2 5.8.1 5.8.0'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
optimize='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -I/usr/include/gdbm'
ccversion='', gccversion='3.4.4 20050721 (Red Hat 3.4.4-2)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=/lib/libc-2.3.4.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version='2.3.4'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-rpath,/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE '
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: DEBUGGING MULTIPLICITY USE_ITHREADS USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
Built under linux
Compiled at Aug 2 2005 04:48:47
@INC:
/usr/lib/perl5/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl
.
]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16[root@ghos twheel DBD-Oracle-1.16]# exit

Script done on Thu 10 Nov 2005 03:09:55 PM PST

--
Charles D. (Chuck) Harding Voice: 925-423-8879
Senior Computer Associate ICCD Fax: 925-423-6961
Lawrence Livermore National Laboratory Computation Directorate
Livermore, CA USA http://www.llnl.gov GPG Public Key ID: B9EB6601
------------------ http://tinyurl.com/5w5ey -----------------------
-- Fer Sell Cheep: 1 Bran New Spel Chekker. Nevur Usd. --

RE: Introduction

Chuck,

Does XE not include the Pro*C components, or an "instant client" like
portion?

-----Original Message-----
From: Chuck Harding [mailto:charding@llnl.gov]=20
Sent: Thursday, November 10, 2005 4:29 PM
To: dbi-users@perl.org
Cc: Tim.Bunce@pobox.com
Subject: RE: Introduction


On Thu, 10 Nov 2005, Reidy, Ron wrote:

> And the question is?
>
> --
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>

Glad you asked. The latest and greatest DBD::Oracle does not appear able
to be installed with Oracle 10.2 XE - it seems as though the
installation of Oracle is different enough to stump Makefile.PL - so my
question is: Will DBD::Oracle get updated to work with Oracle 10.2 XE,
and if so, when?

The output from my attempt at installing DBD::Oracle is included:

Script started on Thu 10 Nov 2005 03:08:31 PM PST
=1B]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16 [root@ghostwheel
DBD-Oracle-1.16]# perl Makefile.PL -v Using DBI 1.48 (for perl 5.008005
on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/ DBI/

Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!
Especially if you have any problems.

Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE =3D "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)

Unable to locate an oracle.mk, proc.mk or other suitable *.mk
file in your Oracle installation. (I looked in
=20
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/li b/oracle.mk
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/oracle.mk
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/demo_rdbm
s.mk
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/otrace/d emo/atmoci.m
k
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/precomp/ demo/proc/pr
oc.mk
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/precomp/ demo/proc/de
mo_proc.mk
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/proc/lib /proc.mk
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/proc16/l ib/proc16.mk
)

The oracle.mk (or demo_rdbms.mk) file is part of the Oracle
RDBMS product. The proc.mk (or demo_proc.mk) file is part of
the Oracle Pro*C product. You need to build DBD::Oracle on a
system which has one of these Oracle components installed.
(Other *.mk files such as the env_*.mk files will not work.)

In the unlikely event that a suitable *.mk file is installed
somewhere non-standard you can specify where it is using the -m
option:
perl Makefile.PL -m /path/to/your.mk

See README.clients for more information and some alternatives.

at Makefile.PL line 922.
=1B]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16 [root@ghostwheel
DBD-Oracle-1.16]# perl -V Summary of my perl5 (revision 5 version 8
subversion 5) configuration:
Platform:
osname=3Dlinux, osvers=3D2.4.21-27.0.2.elsmp,
archname=3Di386-linux-thread-multi
uname=3D'linux decompose.build.redhat.com 2.4.21-27.0.2.elsmp #1 =
smp
wed jan 12 23:35:44 est 2005 i686 i686 i386 gnulinux '
config_args=3D'-des -Doptimize=3D-O2 -g -pipe -m32 -march=3Di386
-mtune=3Dpentium4 -Dversion=3D5.8.5 -Dmyhostname=3Dlocalhost
-Dperladmin=3Droot@localhost -Dcc=3Dgcc -Dcf_by=3DRed Hat, Inc.
-Dinstallprefix=3D/usr -Dprefix=3D/usr -Darchname=3Di386-linux
-Dvendorprefix=3D/usr -Dsiteprefix=3D/usr -Duseshrplib -Dusethreads
-Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db
-Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3D3pm -Duseperlio
-Dinstallusrbinperl -Ubincompat5005 -Uversiononly =
-Dpager=3D/usr/bin/less
-isr -Dinc_version_list=3D5.8.4 5.8.3 5.8.2 5.8.1 5.8.0'
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Ddefine use5005threads=3Dundef useithreads=3Ddefine
usemultiplicity=3Ddefine
useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
use64bitint=3Dundef use64bitall=3Dundef uselongdouble=3Dundef
usemymalloc=3Dn, bincompat5005=3Dundef
Compiler:
cc=3D'gcc', ccflags =3D'-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64 -I/usr/include/gdbm',
optimize=3D'-O2 -g -pipe -m32 -march=3Di386 -mtune=3Dpentium4',
cppflags=3D'-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
-fno-strict-aliasing -pipe -I/usr/local/include -I/usr/include/gdbm'
ccversion=3D'', gccversion=3D'3.4.4 20050721 (Red Hat 3.4.4-2)',
gccosandvers=3D''
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D1234
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D12
ivtype=3D'long', ivsize=3D4, nvtype=3D'double', nvsize=3D8, =
Off_t=3D'off_t',
lseeksize=3D8
alignbytes=3D4, prototype=3Ddefine
Linker and Libraries:
ld=3D'gcc', ldflags =3D' -L/usr/local/lib'
libpth=3D/usr/local/lib /lib /usr/lib
libs=3D-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
perllibs=3D-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=3D/lib/libc-2.3.4.so, so=3Dso, useshrplib=3Dtrue, =
libperl=3Dlibperl.so
gnulibc_version=3D'2.3.4'
Dynamic Linking:
dlsrc=3Ddl_dlopen.xs, dlext=3Dso, d_dlsymun=3Dundef, =
ccdlflags=3D'-Wl,-E
-Wl,-rpath,/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE '
cccdlflags=3D'-fPIC', lddlflags=3D'-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: DEBUGGING MULTIPLICITY USE_ITHREADS
USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
Built under linux
Compiled at Aug 2 2005 04:48:47
@INC:
/usr/lib/perl5/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl
.
=1B]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16 [root@ghostwheel
DBD-Oracle-1.16]# exit

Script done on Thu 10 Nov 2005 03:09:55 PM PST

--=20
Charles D. (Chuck) Harding Voice: 925-423-8879
Senior Computer Associate ICCD Fax: 925-423-6961
Lawrence Livermore National Laboratory Computation Directorate
Livermore, CA USA http://www.llnl.gov GPG Public Key ID: B9EB6601
------------------ http://tinyurl.com/5w5ey -----------------------
-- Fer Sell Cheep: 1 Bran New Spel Chekker. Nevur Usd. --

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.

RE: Introduction

I don't know - how would I find out? What should I be looking for?

On Thu, 10 Nov 2005, Reidy, Ron wrote:

> Chuck,
>
> Does XE not include the Pro*C components, or an "instant client" like
> portion?
>

--
Charles D. (Chuck) Harding Voice: 925-423-8879
Senior Computer Associate ICCD Fax: 925-423-6961
Lawrence Livermore National Laboratory Computation Directorate
Livermore, CA USA http://www.llnl.gov GPG Public Key ID: B9EB6601
------------------ http://tinyurl.com/5w5ey -----------------------
-- Nothing is impossible for anyone impervious to reason --

RE: Introduction

I don't think it does ... I took a look a the files in the RPM and it
only included one make file (oracle_oe.mk IIRC). I also didn't see
many .lib files

On Thu, 2005-11-10 at 16:45 -0700, Reidy, Ron wrote:
> Chuck,
>
> Does XE not include the Pro*C components, or an "instant client" like
> portion?
>
> -----Original Message-----
> From: Chuck Harding [mailto:charding@llnl.gov]
> Sent: Thursday, November 10, 2005 4:29 PM
> To: dbi-users@perl.org
> Cc: Tim.Bunce@pobox.com
> Subject: RE: Introduction
>
>
> On Thu, 10 Nov 2005, Reidy, Ron wrote:
>
> > And the question is?
> >
> > --
> > Ron Reidy
> > Lead DBA
> > Array BioPharma, Inc.
> >
>
> Glad you asked. The latest and greatest DBD::Oracle does not appear able
> to be installed with Oracle 10.2 XE - it seems as though the
> installation of Oracle is different enough to stump Makefile.PL - so my
> question is: Will DBD::Oracle get updated to work with Oracle 10.2 XE,
> and if so, when?
>
> The output from my attempt at installing DBD::Oracle is included:
>
> Script started on Thu 10 Nov 2005 03:08:31 PM PST
> ]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16 [root@ghostwheel
> DBD-Oracle-1.16]# perl Makefile.PL -v Using DBI 1.48 (for perl 5.008005
> on i386-linux-thread-multi) installed in
> /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/ DBI/
>
> Configuring DBD::Oracle ...
>
> >>> Remember to actually *READ* the README file!
> Especially if you have any problems.
>
> Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
> DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
> Oracle version 10.2.0.1 (10.2)
>
> Unable to locate an oracle.mk, proc.mk or other suitable *.mk
> file in your Oracle installation. (I looked in
>
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/li b/oracle.mk
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/oracle.mk
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/demo_rdbm
> s.mk
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/otrace/d emo/atmoci.m
> k
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/precomp/ demo/proc/pr
> oc.mk
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/precomp/ demo/proc/de
> mo_proc.mk
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/proc/lib /proc.mk
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/proc16/l ib/proc16.mk
> )
>
> The oracle.mk (or demo_rdbms.mk) file is part of the Oracle
> RDBMS product. The proc.mk (or demo_proc.mk) file is part of
> the Oracle Pro*C product. You need to build DBD::Oracle on a
> system which has one of these Oracle components installed.
> (Other *.mk files such as the env_*.mk files will not work.)
>
> In the unlikely event that a suitable *.mk file is installed
> somewhere non-standard you can specify where it is using the -m
> option:
> perl Makefile.PL -m /path/to/your.mk
>
> See README.clients for more information and some alternatives.
>
> at Makefile.PL line 922.
> ]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16 [root@ghostwheel
> DBD-Oracle-1.16]# perl -V Summary of my perl5 (revision 5 version 8
> subversion 5) configuration:
> Platform:
> osname=linux, osvers=2.4.21-27.0.2.elsmp,
> archname=i386-linux-thread-multi
> uname='linux decompose.build.redhat.com 2.4.21-27.0.2.elsmp #1 smp
> wed jan 12 23:35:44 est 2005 i686 i686 i386 gnulinux '
> config_args='-des -Doptimize=-O2 -g -pipe -m32 -march=i386
> -mtune=pentium4 -Dversion=5.8.5 -Dmyhostname=localhost
> -Dperladmin=root@localhost -Dcc=gcc -Dcf_by=Red Hat, Inc.
> -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux
> -Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads
> -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db
> -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio
> -Dinstallusrbinperl -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less
> -isr -Dinc_version_list=5.8.4 5.8.3 5.8.2 5.8.1 5.8.0'
> hint=recommended, useposix=true, d_sigaction=define
> usethreads=define use5005threads=undef useithreads=define
> usemultiplicity=define
> useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=undef
> usemymalloc=n, bincompat5005=undef
> Compiler:
> cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
> -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
> optimize='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4',
> cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
> -fno-strict-aliasing -pipe -I/usr/local/include -I/usr/include/gdbm'
> ccversion='', gccversion='3.4.4 20050721 (Red Hat 3.4.4-2)',
> gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksize=8
> alignbytes=4, prototype=define
> Linker and Libraries:
> ld='gcc', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib
> libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
> perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
> libc=/lib/libc-2.3.4.so, so=so, useshrplib=true, libperl=libperl.so
> gnulibc_version='2.3.4'
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
> -Wl,-rpath,/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE '
> cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: DEBUGGING MULTIPLICITY USE_ITHREADS
> USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
> Built under linux
> Compiled at Aug 2 2005 04:48:47
> @INC:
> /usr/lib/perl5/5.8.5/i386-linux-thread-multi
> /usr/lib/perl5/5.8.5
> /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.5
> /usr/lib/perl5/site_perl/5.8.4
> /usr/lib/perl5/site_perl/5.8.3
> /usr/lib/perl5/site_perl/5.8.2
> /usr/lib/perl5/site_perl/5.8.1
> /usr/lib/perl5/site_perl/5.8.0
> /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.5
> /usr/lib/perl5/vendor_perl/5.8.4
> /usr/lib/perl5/vendor_perl/5.8.3
> /usr/lib/perl5/vendor_perl/5.8.2
> /usr/lib/perl5/vendor_perl/5.8.1
> /usr/lib/perl5/vendor_perl/5.8.0
> /usr/lib/perl5/vendor_perl
> .
> ]0;root@ghostwheel:~/.cpan/build/DBD-Oracle-1.16 [root@ghostwheel
> DBD-Oracle-1.16]# exit
>
> Script done on Thu 10 Nov 2005 03:09:55 PM PST
>
--
------------------------------------------------------------ --------------
Cliff Nadler Collective Technologies, LLC
cnadler@colltech.com (512)-263-5500
------------------------------------------------------------ --------------
To win, you must treat a pressure situation as an opportunity to
succeed,
not an opportunity to fail Gardner Dickinson

RE: Introduction

Well, in order to compile DBD::Oracle, one needs to install either the
Oracle client or the instant client. The README* files here
http://search.cpan.org/~timb/DBD-Oracle-1.16/ might help.

Do you have the program proc and/or oracle.mk somewhere under
$ORACLE_HOME?

-----Original Message-----
From: Chuck Harding [mailto:charding@llnl.gov]=20
Sent: Thursday, November 10, 2005 4:54 PM
To: dbi-users@perl.org
Cc: Tim.Bunce@pobox.com
Subject: RE: Introduction


I don't know - how would I find out? What should I be looking for?

On Thu, 10 Nov 2005, Reidy, Ron wrote:

> Chuck,
>
> Does XE not include the Pro*C components, or an "instant client" like=20
> portion?
>

--=20
Charles D. (Chuck) Harding Voice: 925-423-8879
Senior Computer Associate ICCD Fax: 925-423-6961
Lawrence Livermore National Laboratory Computation Directorate
Livermore, CA USA http://www.llnl.gov GPG Public Key ID: B9EB6601
------------------ http://tinyurl.com/5w5ey -----------------------
-- Nothing is impossible for anyone impervious to reason --

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.

RE: Introduction

Neither. The referenced README* files only seem to be up to date to
Oracle 7.3 so my original questions still stand: Is DBD::Oracle going
to be updated to XE and if so, when? Thanks.

On Thu, 10 Nov 2005, Reidy, Ron wrote:

> Well, in order to compile DBD::Oracle, one needs to install either the
> Oracle client or the instant client. The README* files here
> http://search.cpan.org/~timb/DBD-Oracle-1.16/ might help.
>
> Do you have the program proc and/or oracle.mk somewhere under
> $ORACLE_HOME?
>

--
Charles D. (Chuck) Harding Voice: 925-423-8879
Senior Computer Associate ICCD Fax: 925-423-6961
Lawrence Livermore National Laboratory Computation Directorate
Livermore, CA USA http://www.llnl.gov GPG Public Key ID: B9EB6601
------------------ http://tinyurl.com/5w5ey -----------------------
-- This tagline is slithy and gyres and gimbels in the wabe. --