Re: Generic DBI question about backups

[listmail]

Or at least keep a complete oracle export on hand in case your final 
plans fall through and you need to

play hero by recreating the old database.

Jeffrey Seger wrote:

Is this a business critical database?  If so, I would go back to the
business and make an argument that the current database not be allowed to go
away till the new database is in place, migrated and tested.  Regardless of
the tool you use to migrate it, you will run the risk of data loss if the
old database is allowed to be completely deleted prior to a new one being
installed.

On Thu, Jun 19, 2008 at 2:08 PM, Curtis Leach <[EMAIL PROTECTED]> wrote:

  

Does anyone know of a module that would backup an Oracle database in a
database independent way?

We are decommissioning our only Oracle database & we would like to be
able to preserve it's contents so that it can be reloaded into another
database at a later date.  Such as Windows SQL Server or Informix.

But all Oracle backup tools use proprietary formats.


Curtis






  

RE: Generic DBI question about backups

[Rutherdale, Will]

Maybe I'm missing something here, but isn't this simply a matter of
using DBD::CSV?  You could open two dbi handles, one to your existing
Oracle db and the other to a csv db.  Read from the one, write to the
other.  When you get the new schema set up on the new platform, do the
same thing in the reverse direction.

Of course you would have to review your schema to make sure all your
column definitions are simple universal data types supported by all
platforms.  If not then there would be a risk of information loss in
some cases.  You could treat such columns as special cases if necessary
and review your CSV data carefully before chucking the oracle version.

Then again you probably wouldn't want to chuck the Oracle db for a while
anyway just as a precaution, until you are convinced your app still
runs.  That might in fact make the intermediate CSV representation
unnecessary, but as usual there's more than one way to do it.

-Will


> -Original Message-
> From: Curtis Leach [mailto:[EMAIL PROTECTED]
> Sent: Thursday 19 June 2008 14:54
> To: [EMAIL PROTECTED]
> Cc: dbi-users@perl.org
> Subject: RE: Generic DBI question about backups
>
> My big problem is that the new database hasn't been selected yet & the
> our only Oracle database will be gone by the time one is selected.
> Which was the reason for the need of a database independent
> solution.  I
> won't be able to load it back into Oracle again for a 2nd attempt.
>
> Curtis




 - - - - -  Cisco- 
- - - -
This e-mail and any attachments may contain information which is confidential,
proprietary, privileged or otherwise protected by law. The information is solely
intended for the named addressee (or a person responsible for delivering it to
the addressee). If you are not the intended recipient of this message, you are
not authorized to read, print, retain, copy or disseminate this message or any
part of it. If you have received this e-mail in error, please notify the sender
immediately by return e-mail and delete it from your computer.

Out of memory error with DBI - DBD::Oracle

[Rich White]

I’m having a problem with a DBI script on our Solaris systems.  The scripts run 
fine on my Linux workstation.  The script will return the correct data and then 
displays the error. I have found many places discussing this error, but none of 
them has a solution.  If you need more information about the environment, tell 
me what you want to see and how to get it.

Thanks
Rich White -- University of Illinois CITES/DS
[EMAIL PROTECTED]

Here is the minimum code that generated the error:
#!/usr/bin/perl
use DBI;
$dbh = DBI->connect("dbi:Oracle:host=dbserver;sid=SID","user","password");
$dbh->disconnect;

This is the error I get:
Out of memory!
Callback called exit.
END failed--call queue aborted.

This is the information about our environment:
0> perl -MDBI -e 'DBI->installed_versions'
  Perl: 5.008004(sun4-solaris-64int)
  OS  : solaris (2.10)
  DBI : 1.43
  DBD::Sponge : 11.10
  DBD::Proxy  : install_driver(Proxy) failed: Can't locate RPC/PlClient.pm 
in @INC
  DBD::Pg : 1.22
  DBD::Oracle : 1.19
  DBD::File   : 0.31
  DBD::ExampleP   : 11.12
  DBD::DBM: 0.02

Sqlplus -version
SQL*Plus: Release 10.2.0.3.0 - Production

Re: Generic DBI question about backups

[Ron Savage]

Hi Curtis

> export to CSV and use DBD::CSV?

Or, as a last resort, use Perl :-) 

http://search.cpan.org/~rsavage/DBIx-Admin-BackupRestore-1.10/

-- 
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html

RE: Generic DBI question about backups

[Rutherdale, Will]

Very well put, Jeffrey.  That was exactly the thought bothering me after
I posted my reply.  Is it really written in stone that the original
database will be destroyed after their one attempt at making a backup?

Such a decision would be highly suspect.  Surely they could find one
spare PC to keep the old database alive while they port the application.
Not only risk of data loss but risk of application loss.  There's no
guarantee the replacement app will be written as rapidly as they
originally expect.

-Will


> -Original Message-
> From: Jeffrey Seger [mailto:[EMAIL PROTECTED]
> Sent: Thursday 19 June 2008 17:11
> To: Curtis Leach
> Cc: dbi-users@perl.org
> Subject: Re: Generic DBI question about backups
>
> Is this a business critical database?  If so, I would go back to the
> business and make an argument that the current database not
> be allowed to go
> away till the new database is in place, migrated and tested.
> Regardless of
> the tool you use to migrate it, you will run the risk of data
> loss if the
> old database is allowed to be completely deleted prior to a
> new one being
> installed.
>
> On Thu, Jun 19, 2008 at 2:08 PM, Curtis Leach
> <[EMAIL PROTECTED]> wrote:
>
> > Does anyone know of a module that would backup an Oracle
> database in a
> > database independent way?
> >
> > We are decommissioning our only Oracle database & we would
> like to be
> > able to preserve it's contents so that it can be reloaded
> into another
> > database at a later date.  Such as Windows SQL Server or Informix.
> >
> > But all Oracle backup tools use proprietary formats.
> >
> >
> > Curtis
> >
> >



 - - - - -  Cisco- 
- - - -
This e-mail and any attachments may contain information which is confidential,
proprietary, privileged or otherwise protected by law. The information is solely
intended for the named addressee (or a person responsible for delivering it to
the addressee). If you are not the intended recipient of this message, you are
not authorized to read, print, retain, copy or disseminate this message or any
part of it. If you have received this e-mail in error, please notify the sender
immediately by return e-mail and delete it from your computer.

Re: No line number with RaiseError in DBD::Sybase

[Douglas Wilson]

On Thu, Jun 19, 2008 at 1:53 PM, Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Wed, Jun 18, 2008 at 02:14:06PM -0700, Douglas Wilson wrote:
>> With RaiseError or PrintError set, if DBD::Sybase throws an error, the
>> error message does not indicate what line number of the program that the
>> error was on ... or what program/module that the error was in.
>
> I'd guess that that's because sybase error messages tend to end with a
> newline character.
>
> Hopefully that's a simple fix for Michael to get into the next release.
> You could always send a patch to help out...

Once I found the magic spot, this is the simplest thing I can think of (there
is a lot of conditional concatenating in that function, and some of the
concatenations include newlines):

*** ../DBD-Sybase-1.08/dbdimp.c Thu Apr 19 11:31:19 2007
--- dbdimp.cThu Jun 19 14:09:45 2008
***
*** 545,550 
--- 545,551 
else
retcode = CS_SUCCEED;

+   sv_catpv(DBIc_ERRSTR(imp_dbh), " ");
return retcode;
  } else {
if(srvmsg->msgnumber) {

Re: Generic DBI question about backups

[Jeffrey Seger]

Is this a business critical database?  If so, I would go back to the
business and make an argument that the current database not be allowed to go
away till the new database is in place, migrated and tested.  Regardless of
the tool you use to migrate it, you will run the risk of data loss if the
old database is allowed to be completely deleted prior to a new one being
installed.

On Thu, Jun 19, 2008 at 2:08 PM, Curtis Leach <[EMAIL PROTECTED]> wrote:

> Does anyone know of a module that would backup an Oracle database in a
> database independent way?
>
> We are decommissioning our only Oracle database & we would like to be
> able to preserve it's contents so that it can be reloaded into another
> database at a later date.  Such as Windows SQL Server or Informix.
>
> But all Oracle backup tools use proprietary formats.
>
>
> Curtis
>
>


-- 
They who would give up an essential liberty for temporary security, deserve
neither liberty or security.
Benjamin Franklin

Our lives begin to end the day we become silent about things that matter.
Martin Luther King

The right of the people to be secure in their persons, houses, papers, and
effects, against unreasonable searches and seizures, shall not be violated,
and no warrants shall issue, but upon probable cause, supported by oath or
affirmation, and particularly describing the place to be searched, and the
persons or things to be seized.

Amendment IV to the Constitution of the United States

"I am not going to answer any questions as to my association, my
philosophical or religious beliefs or my political beliefs, or how I voted
in any election, or any of these private affairs. I think these are very
improper questions for any American to be asked, especially under such
compulsion as this."
Pete Seeger before the House Un-American Activities Comittee

Re: No line number with RaiseError in DBD::Sybase

[Tim Bunce]

On Wed, Jun 18, 2008 at 02:14:06PM -0700, Douglas Wilson wrote:
> With RaiseError or PrintError set, if DBD::Sybase throws an error, the
> error message does not indicate what line number of the program that the
> error was on ... or what program/module that the error was in.

I'd guess that that's because sybase error messages tend to end with a
newline character.

Hopefully that's a simple fix for Michael to get into the next release.
You could always send a patch to help out...

Tim.

Re: Generic DBI question about backups

[Jonathan Leffler]

On Thu, Jun 19, 2008 at 11:54 AM, Curtis Leach <[EMAIL PROTECTED]> wrote:

> My big problem is that the new database hasn't been selected yet & the
> our only Oracle database will be gone by the time one is selected.
> Which was the reason for the need of a database independent solution.  I
> won't be able to load it back into Oracle again for a 2nd attempt.
>

I would recommend using a consistent text backup format.

For example, you might use a delimited format (each field printed as text,
separated by a delimiter such as '|', with an escape scheme for handling
newlines, pipe symbols and escapes (eg, backslash-backslash for a single
backslash; backslash-pipe for a single pipe, backslash-newline for a
newline).  Or you could go with the CSV format that others have suggested -
bearing in mind that CSV is not all that well defined (there are multiple
possible variants, and even different MS products handle the odd-ball cases
differently).

At the same time, dump the schema in text - presumably Oracle has tools to
assist in that, but failing that, you can either use the DBI and DBD::Oracle
metadata facilities, or learn how to interrogate the Oracle system catalog
for the information.

With the schema and plain text data files, you can get the data into any
other DBMS.

Informix provides standard tools DB-Export and DB-Import that use the
Informix UNLOAD format (basically, pipe-delimited, backslash-escaped data
files) for the data and an SQL file (actually created by the code from
another utility, DB-Schema) for the SQL.  The output from DB-Export is
stylized and comprehensible to DB-Import.

With Informix, you can also use the same format for ad hoc unload and load
commands too - transferring single tables rather than whole databases.



>
> Curtis
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2008 1:33 PM
> To: Curtis Leach
> Cc: dbi-users@perl.org
> Subject: Re: Generic DBI question about backups
>
> I guess I'd be more concerned initially with ensuring the datatype
> mappings are identical or in the 'to-be' database, the ingress is valid.
>
> Has that been considered yet?
>
> On Thu, 19 Jun 2008, Curtis Leach wrote:
>
> > Does anyone know of a module that would backup an Oracle database in a
>
> > database independent way?
> >
> > We are decommissioning our only Oracle database & we would like to be
> > able to preserve it's contents so that it can be reloaded into another
>
> > database at a later date.  Such as Windows SQL Server or Informix.
> >
> > But all Oracle backup tools use proprietary formats.
> >
> >
> > Curtis
> >
> >
>
> --
> Louis Gonzales
> [EMAIL PROTECTED]
> http://www.linuxlouis.net
>
>
>
>


-- 
Jonathan Leffler <[EMAIL PROTECTED]> #include 
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

RE: Generic DBI question about backups

[Greg Sabino Mullane]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160


> My big problem is that the new database hasn't been selected yet & the
> our only Oracle database will be gone by the time one is selected.
> Which was the reason for the need of a database independent solution.  I
> won't be able to load it back into Oracle again for a 2nd attempt.

You could look into DBI-Link and move your data from Oracle to Postgres.
Postgres won't expire or have any licensing issues, and can output
to a plain old text file in standard formats (including CSV), so you can
easily move it from there to anywhere you need to later on.

http://pgfoundry.org/projects/dbi-link/

- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200806191541
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-

iEYEAREDAAYFAkhatzwACgkQvJuQZxSWSshC3gCgll0oLnj49dN+h2F5u0o3D4QK
riAAnjhV9FyIQ5zhiuTznsjbjw1NiMap
=8HFv
-END PGP SIGNATURE-

Re: Generic DBI question about backups

[Jacqui Caren]

Curtis Leach wrote:

My big problem is that the new database hasn't been selected yet & the
our only Oracle database will be gone by the time one is selected.
Which was the reason for the need of a database independent solution.  I
won't be able to load it back into Oracle again for a 2nd attempt.


Dump the data - as long as the ora dump is not compressed you
can extract the SQL pretty easily.

The second thing I would recommend would be to use a tool such s erWIN
to migrate from Oracle as you can save the database schema and
automatically migrate the schema and fine tune its logical
to physical mappings.

I have done this with ~100 table schemas but have manually
rewritten the triggers and sprocs/functions
as the coding is impacted by the database.

Jacqui

Re: Generic DBI question about backups

[John Scoles]

export to CSV and use DBD::CSV?

Curtis Leach wrote:

My big problem is that the new database hasn't been selected yet & the
our only Oracle database will be gone by the time one is selected.
Which was the reason for the need of a database independent solution.  I
won't be able to load it back into Oracle again for a 2nd attempt.

Curtis

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 19, 2008 1:33 PM

To: Curtis Leach
Cc: dbi-users@perl.org
Subject: Re: Generic DBI question about backups

I guess I'd be more concerned initially with ensuring the datatype
mappings are identical or in the 'to-be' database, the ingress is valid.

Has that been considered yet?

On Thu, 19 Jun 2008, Curtis Leach wrote:

  

Does anyone know of a module that would backup an Oracle database in a



  

database independent way?

We are decommissioning our only Oracle database & we would like to be 
able to preserve it's contents so that it can be reloaded into another



  

database at a later date.  Such as Windows SQL Server or Informix.

But all Oracle backup tools use proprietary formats.


Curtis





--
Louis Gonzales
[EMAIL PROTECTED]
http://www.linuxlouis.net



  

RE: Generic DBI question about backups

[Curtis Leach]

My big problem is that the new database hasn't been selected yet & the
our only Oracle database will be gone by the time one is selected.
Which was the reason for the need of a database independent solution.  I
won't be able to load it back into Oracle again for a 2nd attempt.

Curtis

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 19, 2008 1:33 PM
To: Curtis Leach
Cc: dbi-users@perl.org
Subject: Re: Generic DBI question about backups

I guess I'd be more concerned initially with ensuring the datatype
mappings are identical or in the 'to-be' database, the ingress is valid.

Has that been considered yet?

On Thu, 19 Jun 2008, Curtis Leach wrote:

> Does anyone know of a module that would backup an Oracle database in a

> database independent way?
>
> We are decommissioning our only Oracle database & we would like to be 
> able to preserve it's contents so that it can be reloaded into another

> database at a later date.  Such as Windows SQL Server or Informix.
>
> But all Oracle backup tools use proprietary formats.
>
>
> Curtis
>
>

--
Louis Gonzales
[EMAIL PROTECTED]
http://www.linuxlouis.net

Re: Generic DBI question about backups

[gonzales]

I guess I'd be more concerned initially with ensuring the datatype 
mappings are identical or in the 'to-be' database, the ingress is valid.


Has that been considered yet?

On Thu, 19 Jun 2008, Curtis Leach wrote:


Does anyone know of a module that would backup an Oracle database in a
database independent way?

We are decommissioning our only Oracle database & we would like to be
able to preserve it's contents so that it can be reloaded into another
database at a later date.  Such as Windows SQL Server or Informix.

But all Oracle backup tools use proprietary formats.


Curtis




--
Louis Gonzales
[EMAIL PROTECTED]
http://www.linuxlouis.net

Generic DBI question about backups

[Curtis Leach]

Does anyone know of a module that would backup an Oracle database in a
database independent way?

We are decommissioning our only Oracle database & we would like to be
able to preserve it's contents so that it can be reloaded into another
database at a later date.  Such as Windows SQL Server or Informix.

But all Oracle backup tools use proprietary formats.


Curtis

No line number with RaiseError in DBD::Sybase

[Douglas Wilson]

With RaiseError or PrintError set, if DBD::Sybase throws an error, the
error message does not indicate what line number of the program that the
error was on ... or what program/module that the error was in.

DBD::Oracle and DBD::ODBC both have program/module line numbers at the
end of the error message (That's all I can refer to at the
momentThere should be some standard among DBD's).

TIA,
Douglas Wilson

Re: FW: DBD::Oracle on Darwin 8.11

[John Scoles]

Me thinks your Perl was compiled using one flavour of C compiler and you 
are trying to compile DBD::Oracle with another flavour or C compiler.


I have seen this a number of times with HP systems. 

Basically it meas you have to recompile your Perl with the same C 
compiler you are going to use to compile DBD::ORacle and your other perl 
mods.


Do a Google search for

Oracle.c: In function `XS_DBD__Oracle_constant':

you will find a number of other hits in the list that are similar.

Unfortunately that is all the help I can offer as I have never had to do 
this myself




Stewart Anderson wrote:
Thanks for  the response John.  

I just tried  the same thing  on perl 5.10  and had the same results.  

Perl Makefile.PL   and make  output shown below.  


Perl Makefile.PL  looks   ok to me - but I am far from expert,
clearly!! 


I can see a problem  with the includes in the make  output but do not
know how  to correct this,  I thought  the   Makefile  looked at  the
INCLUDE env var, which I tried to  set with  paths to  the  stdarg.h
but that did not help at all.

I appreciate your  help  :)

Regards

Stu



Perl Makefile.PL Output

=
perl Makefile.PL
Using DBI 1.601 (for perl 5.01 on darwin-thread-multi-2level)
installed in /usr/local/ActivePerl-5.10/lib/auto/DBI/
Argument "6.42_01" isn't numeric in numeric ge (>=) at Makefile.PL line
59.

Configuring DBD::Oracle for perl 5.01 on darwin
(darwin-thread-multi-2level)

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

Using Oracle in /usr/local/oracle/instantclient10_1
DEFINE _SQLPLUS_RELEASE = "1001000300" (CHAR)
Oracle version 10.1.0.3 (10.1)
Looks like an Instant Client installation, okay
Your DYLD_LIBRARY_PATH env var is set to
'/usr/local/oracle/instantclient10_1:'
Oracle sysliblist:
Found header files in /usr/local/oracle/instantclient10_1/sdk/include.

Checking for functioning wait.ph


System: perl5.01 darwin sphinx 8.11.0 darwin kernel version 8.11.0:
wed oct 10 18:26:00 pdt 2007; root:xnu-792.24.17~1release_ppc power
macintosh powerpc
Compiler:   gcc -O3 -fno-common -DPERL_DARWIN -no-cpp-precomp -arch ppc
-arch i386 -nostdinc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc
-isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include
-F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks
-mmacosx-version-min=10.3 -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC
-fno-strict-aliasing -pipe
Linker: /usr/bin/ld
Sysliblist:
Linking with -lclntsh.

LD_RUN_PATH=/usr/local/oracle/instantclient10_1
Using DBD::Oracle 1.21.
Using DBD::Oracle 1.21.
Using DBI 1.601 (for perl 5.01 on darwin-thread-multi-2level)
installed in /usr/local/ActivePerl-5.10/lib/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?)




Make  output 


Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c  -I/usr/local/oracle/instantclient10_1/sdk/include
-I/usr/local/ActivePerl-5.10/lib/auto/DBI -fno-common -DPERL_DARWIN
-no-cpp-precomp -arch ppc -arch i386 -nostdinc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc
-isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include
-F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks
-mmacosx-version-min=10.3 -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC
-fno-strict-aliasing -pipe -O3   -DVERSION=\"1.21\"
-DXS_VERSION=\"1.21\"  "-I/usr/local/ActivePerl-5.10/lib/CORE"  -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"10.1.0.3\" Oracle.c
In file included from
/usr/local/oracle/instantclient10_1/sdk/include/ociap.h:197,
 from
/usr/local/oracle/instantclient10_1/sdk/include/oci.h:2351,
 from Oracle.h:37,
 from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/stdarg.h:4:25: no include
path in which to find stdarg.h
In file included from
/usr/local/oracle/instantclient10_1/sdk/include/oci.h:2351,
 from Oracle.h:37,
 from Oracle.xs:1:
/usr/local/oracle/instantclient10_1/sdk/include/ociap.h:6267: error:
parse error before "va_list"
In file included from /usr/local/ActivePerl-5.10/lib/CORE/perl.h:598,
 from
/usr/local/ActivePerl-5.10/lib/auto/DBI/DBIXS.h:19,
 from Oracle.h:51,
 from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/stdarg.h:4:25: no include
path in which to find 

FW: DBD::Oracle on Darwin 8.11

[Stewart Anderson]

Thanks for  the response John.  

I just tried  the same thing  on perl 5.10  and had the same results.  

Perl Makefile.PL   and make  output shown below.  

Perl Makefile.PL  looks   ok to me - but I am far from expert,
clearly!! 

I can see a problem  with the includes in the make  output but do not
know how  to correct this,  I thought  the   Makefile  looked at  the
INCLUDE env var, which I tried to  set with  paths to  the  stdarg.h
but that did not help at all.

I appreciate your  help  :)

Regards

Stu



Perl Makefile.PL Output

=
perl Makefile.PL
Using DBI 1.601 (for perl 5.01 on darwin-thread-multi-2level)
installed in /usr/local/ActivePerl-5.10/lib/auto/DBI/
Argument "6.42_01" isn't numeric in numeric ge (>=) at Makefile.PL line
59.

Configuring DBD::Oracle for perl 5.01 on darwin
(darwin-thread-multi-2level)

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

Using Oracle in /usr/local/oracle/instantclient10_1
DEFINE _SQLPLUS_RELEASE = "1001000300" (CHAR)
Oracle version 10.1.0.3 (10.1)
Looks like an Instant Client installation, okay
Your DYLD_LIBRARY_PATH env var is set to
'/usr/local/oracle/instantclient10_1:'
Oracle sysliblist:
Found header files in /usr/local/oracle/instantclient10_1/sdk/include.

Checking for functioning wait.ph


System: perl5.01 darwin sphinx 8.11.0 darwin kernel version 8.11.0:
wed oct 10 18:26:00 pdt 2007; root:xnu-792.24.17~1release_ppc power
macintosh powerpc
Compiler:   gcc -O3 -fno-common -DPERL_DARWIN -no-cpp-precomp -arch ppc
-arch i386 -nostdinc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc
-isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include
-F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks
-mmacosx-version-min=10.3 -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC
-fno-strict-aliasing -pipe
Linker: /usr/bin/ld
Sysliblist:
Linking with -lclntsh.

LD_RUN_PATH=/usr/local/oracle/instantclient10_1
Using DBD::Oracle 1.21.
Using DBD::Oracle 1.21.
Using DBI 1.601 (for perl 5.01 on darwin-thread-multi-2level)
installed in /usr/local/ActivePerl-5.10/lib/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?)




Make  output 

Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c  -I/usr/local/oracle/instantclient10_1/sdk/include
-I/usr/local/ActivePerl-5.10/lib/auto/DBI -fno-common -DPERL_DARWIN
-no-cpp-precomp -arch ppc -arch i386 -nostdinc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc
-isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include
-F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks
-mmacosx-version-min=10.3 -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC
-fno-strict-aliasing -pipe -O3   -DVERSION=\"1.21\"
-DXS_VERSION=\"1.21\"  "-I/usr/local/ActivePerl-5.10/lib/CORE"  -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"10.1.0.3\" Oracle.c
In file included from
/usr/local/oracle/instantclient10_1/sdk/include/ociap.h:197,
 from
/usr/local/oracle/instantclient10_1/sdk/include/oci.h:2351,
 from Oracle.h:37,
 from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/stdarg.h:4:25: no include
path in which to find stdarg.h
In file included from
/usr/local/oracle/instantclient10_1/sdk/include/oci.h:2351,
 from Oracle.h:37,
 from Oracle.xs:1:
/usr/local/oracle/instantclient10_1/sdk/include/ociap.h:6267: error:
parse error before "va_list"
In file included from /usr/local/ActivePerl-5.10/lib/CORE/perl.h:598,
 from
/usr/local/ActivePerl-5.10/lib/auto/DBI/DBIXS.h:19,
 from Oracle.h:51,
 from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/stdarg.h:4:25: no include
path in which to find stdarg.h
In file included from /usr/local/ActivePerl-5.10/lib/CORE/perl.h:1776,
 from
/usr/local/ActivePerl-5.10/lib/auto/DBI/DBIXS.h:19,
 from Oracle.h:51,
 from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/float.h:8:24: no include
path in which to find float.h
In file included from /usr/local/ActivePerl-5.10/lib/CORE/perl.h:1798,
 from
/usr/local/ActivePerl-5.10/lib/auto/DBI/DBIXS.h:19,
 from Oracle.h:51,
 from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/float.h:8:24: no include

Re: DBD::Oracle on Darwin 8.11

[John Scoles]

To start you should post the output of your perl Makefil.PL  as that 
will give the other here on the list a good deal of what we need to go on.


Also you should have a look at the readmes they might help

Cheers John Scoles

Stewart Anderson wrote:

Hi,

I'm   having real probs  getting DBD::Oracle  onto  a sphinx  version of
MAC OS ppc.

I have  tried numerous repositories but can't find pre-compiled modules.
If they exist somewhere please can you point me in the right direction.

I have also tried to complie the module myself but am  getting  problems
with  finding libraries  and linking I think (not a C  dev).

I have  DBD 1.21 which I think  is targeted at MAC 10.x ?   Is there a
suitable version I should use for  my version of MAC OS?.

Oracle  instant client is installed and seems to be working fine,   in
that I can  use sqlplus quite happily to get  to   the DB I need to.

This is the first time I have tried to use the list so not sure how much
gumf to include  with  this request,   nay plea  for help :)

Regards

Stu



Information in this email including any attachments may be privileged, 
confidential and is intended exclusively for the addressee. The views expressed 
may not be official policy, but the personal views of the originator. If you 
have received it in error, please notify the sender by return e-mail and delete 
it from your system. You should not reproduce, distribute, store, retransmit, 
use or disclose its contents to anyone. Please note we reserve the right to 
monitor all e-mail communication through our internal and external networks. 
SKY and the SKY marks are trade marks of British Sky Broadcasting Group plc and 
are used under licence. British Sky Broadcasting Limited (Registration No. 
2906991), Sky Interactive Limited (Registration No. 3554332), Sky-In-Home 
Service Limited (Registration No. 2067075) and Sky Subscribers Services Limited 
(Registration No. 2340150) are direct or indirect subsidiaries of British Sky 
Broadcasting Group plc (Registration No. 2247735). All of the companies 
mentioned in this paragraph are incorporated in England and Wales and share the 
same registered office at Grant Way, Isleworth, Middlesex TW7 5QD.
  

DBD::Oracle on Darwin 8.11

[Stewart Anderson]

Hi,

I'm   having real probs  getting DBD::Oracle  onto  a sphinx  version of
MAC OS ppc.

I have  tried numerous repositories but can't find pre-compiled modules.
If they exist somewhere please can you point me in the right direction.

I have also tried to complie the module myself but am  getting  problems
with  finding libraries  and linking I think (not a C  dev).

I have  DBD 1.21 which I think  is targeted at MAC 10.x ?   Is there a
suitable version I should use for  my version of MAC OS?.

Oracle  instant client is installed and seems to be working fine,   in
that I can  use sqlplus quite happily to get  to   the DB I need to.

This is the first time I have tried to use the list so not sure how much
gumf to include  with  this request,   nay plea  for help :)

Regards

Stu



Information in this email including any attachments may be privileged, 
confidential and is intended exclusively for the addressee. The views expressed 
may not be official policy, but the personal views of the originator. If you 
have received it in error, please notify the sender by return e-mail and delete 
it from your system. You should not reproduce, distribute, store, retransmit, 
use or disclose its contents to anyone. Please note we reserve the right to 
monitor all e-mail communication through our internal and external networks. 
SKY and the SKY marks are trade marks of British Sky Broadcasting Group plc and 
are used under licence. British Sky Broadcasting Limited (Registration No. 
2906991), Sky Interactive Limited (Registration No. 3554332), Sky-In-Home 
Service Limited (Registration No. 2067075) and Sky Subscribers Services Limited 
(Registration No. 2340150) are direct or indirect subsidiaries of British Sky 
Broadcasting Group plc (Registration No. 2247735). All of the companies 
mentioned in this paragraph are incorporated in England and Wales and share the 
same registered office at Grant Way, Isleworth, Middlesex TW7 5QD.