Re: Out of memory error with DBI - DBD::Oracle



Hello Rich,

i checked one of my Solaris Sparc boxes. There is a much more current DBI version installed:

> perl -MDBI -e 'DBI->installed_versions'
Perl : 5.008005 (sun4-solaris)
OS : solaris (2.9)
DBI : 1.48
DBD::Sponge : 11.10
DBD::Proxy : install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC
DBD::Oracle : 1.16

Could this be a problem?

On Solaris 10 (i.e. 2.10) lots of changes took place. Especially in the oracle installation. Did you follow the installation guide?

CU, Christian Merz


Rich White schrieb, am 19.06.2008 23:19:
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
rlwhite@xxxxxxxx

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


.



Relevant Pages

  • status on DBI installation on AIX 5.2
    ... I have compiled successfully the DBI by following your suggestion. ... when I re-built Perl 5.8.7 from source code, ... I tried Perl 5.8.6 installation from source code, ... Onderwerp: RE: DBI installation failure on AIX 5.2, ...
    (perl.dbi.users)
  • RE: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
    ... on the system of the dbd to build a new one. ... perl is running without the recommended perl -w option ... Subject: DBI and DBD::Oracle throw error Had to create ... identical installation on some new quad core servers the script fails ...
    (perl.dbi.users)
  • Re: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
    ... on the system of the dbd to build a new one. ... perl is running without the recommended perl -w option ... Subject: DBI and DBD::Oracle throw error Had to create ... identical installation on some new quad core servers the script fails ...
    (perl.dbi.users)
  • RE: :Oracle - with ora10g oci.dll
    ... I agree it's not a DBD or DBI error. ... your connection descriptor seems suspect: ... how to get to our nameservers. ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)
  • RE: :Oracle - with ora10g oci.dll
    ... This is most likely not a DBD::Oracle nor DBI error. ... your connection descriptor seems suspect: ... TNS:could not resolve the connect identifier specified (DBD ERROR: ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)