Re: Help requested : Compile/build requirements for DBI - 1.37 and DBD-Oracle- 1.14 - Double message

Please read: http://www.catb.org/~esr/faqs/smart-questions.html (especially
http://www.catb.org/~esr/faqs/smart-questions.html#urgent)

Please do not blind copy mailing lists. (Actually, I'm not certain whether
you bcc'd us or Tim bounced it here - you might not be guilty of this, in
which case, I apologize.)

On 6/25/07, Deepa.Nag@xxxxxxx <Deepa.Nag@xxxxxxx> wrote:

I installed DBI-1.37 and DBD-Oracle-1.14 under a customized
directory(not under /usr/perl5 which is the default directory) and I see
the following files installed. I would like to know the minimum list of
files that will be required for DBI and DBD so that we can have only the
required files while bundling them in our product. For example, we are
not using oraperl, hence we need not bundle oraperl.pm in our product.


That's a pretty old version of DBI - 20 releases out of date.

So, run on Solaris 10 and monitor which files gets used by your product.

Are you sure you are space-constrained enough to warrant worrying about it?
Won't it be easier for customers to do field upgrades if the installation is
of complete modules?

Kindly help us as we need to finalise on this quickly.

(1) DBD Files:

/opt/SUNWsymon/lib/DBD/bin/ora_explain
/opt/SUNWsymon/lib/DBD/man/man1/ora_explain.1
/opt/SUNWsymon/lib/DBD/man/man3/DBD::Oracle.3
/opt/SUNWsymon/lib/DBD/man/man3/DBD::Oraperl.3
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/DBD/Oracle.pm
/opt/SUNWsymon/lib/DBD/bin/ora_explain
/opt/SUNWsymon/lib/DBD/man/man1/ora_explain.1
/opt/SUNWsymon/lib/DBD/man/man3/DBD::Oracle.3
/opt/SUNWsymon/lib/DBD/man/man3/DBD::Oraperl.3
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/DBD/Oracle.pm
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/DBD/Oracle/GetInfo.pm
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/Oraperl.pm
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/auto/DBD/Oracle/Oracle.bs
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/auto/DBD/Oracle/Oracle.h
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/auto/DBD/Oracle/Oracle.so
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/auto/DBD/Oracle/dbdimp.h
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/auto/DBD/Oracle/mk.pm
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/auto/DBD/Oracle/ocitrace.h
/opt/SUNWsymon/lib/DBD/site_perl/sun4-solaris/oraperl.ph

(2) DBI Files:

/opt/SUNWsymon/lib/DBI/bin/dbiprof
/opt/SUNWsymon/lib/DBI/bin/dbiproxy
/opt/SUNWsymon/lib/DBI/man/man1/dbiprof.1
/opt/SUNWsymon/lib/DBI/man/man1/dbiproxy.1
/opt/SUNWsymon/lib/DBI/man/man3/Bundle::DBI.3
/opt/SUNWsymon/lib/DBI/man/man3/DBD::Proxy.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::Const::GetInfo::ANSI.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::Const::GetInfo::ODBC.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::Const::GetInfoReturn.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::Const::GetInfoType.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::DBD.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::DBD::Metadata.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::FAQ.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::Profile.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::ProfileData.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::ProfileDumper.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::ProfileDumper::Apache.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::ProxyServer.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::PurePerl.3
/opt/SUNWsymon/lib/DBI/man/man3/DBI::W32ODBC.3
/opt/SUNWsymon/lib/DBI/man/man3/Win32::DBIODBC.3
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/Bundle/DBI.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBD/ExampleP.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBD/NullP.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBD/Proxy.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBD/Sponge.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/Changes.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/Const/GetInfo/ANSI.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/Const/GetInfo/ODBC.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/Const/GetInfoReturn.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/Const/GetInfoType.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/DBD.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/DBD/Metadata.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/FAQ.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/Profile.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/ProfileData.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/ProfileDumper.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/ProfileDumper/Apache.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/ProxyServer.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/PurePerl.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/DBI/W32ODBC.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/Win32/DBIODBC.pm
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/auto/DBI/DBI.bs
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/auto/DBI/DBI.so
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/auto/DBI/DBIXS.h
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/auto/DBI/Driver.xst
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/auto/DBI/Driver_xst.h
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/auto/DBI/dbd_xsh.h
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/auto/DBI/dbi_sql.h
/opt/SUNWsymon/lib/DBI/site_perl/sun4-solaris/auto/DBI/dbipport.h




You might not need the Win32 stuff; you might not need the DBI headers (but
then again, you might if you ever needed to upgrade in the field). You
might not need ... but I think you're being penny-wise and pound-foolish.




-------- Original Message --------
Subject: URGENT help required : Compile/build requirements for DBI
-
1.37 and DBD-Oracle- 1.14
Date: Mon, 25 Jun 2007 16:36:42 +0530
From: Deepa.Nag@xxxxxxx
To: Tim Bunce <Tim.Bunce@xxxxxxxxx>


We need to bundle DBI -1.37 and DBD-Oracle-1.14 in our product. Our
product is supported on Solaris 8, 9 and 10 (sparc architecture). Are
there any architecture specific or OS specific source code in DBI or
DBD-Oracle that we have to build them on every OS or architecture? We
are assuming that if we compile DBI and DBD-Oracle source on Solaris 8,
it should work fine with Solaris 9 and 10 as well. Is our assumption
correct? Please help.



Most probably, if the Perl works and the Oracle works on all three (and Perl
will; Oracle I won't answer for), then DBI and DBD::Oracle will too.

Will the Oracle database be installed in a fixed location on all machines?


--
Jonathan Leffler <jonathan.leffler@xxxxxxxxx> #include <disclaimer.h>
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

Relevant Pages

  • Re: New dbi.perl.org - and help purging links to old DBI sites
    ... google for "DBI". ... As an extra bonus, google now adds: ... > DBI Mailing Lists ... > style' and new maintainance tools) it contains all the key links to ...
    (perl.dbi.users)
  • RE: oracle win2k ORA-1222 problems
    ... AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com. ... Oracle is listed as "failed" if I recall correctly. ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • RE: DBI problem
    ... I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from ... DBD 1.16 and DBI 1.48. ... Did you install DBD::Oracle? ...
    (perl.dbi.users)
  • RE: (Fwd) DBD:: Oracle Problems
    ... The error is being thrown inside the pl/sql procedure itself not the DBI! ... Subject: DBD:: Oracle Problems ... are receiving the following error when we execute any stored procedures. ... This email has been scanned by the MessageLabs Email Security System. ...
    (perl.dbi.users)
  • Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin
    ... If not: you could reinstall DBI and DBD::Oracle and make sure that your Oracle environment is set correctly. ... If you have multiple Oracle installations: set your $ENVusing the ORACLE_HOME with which you compiled your DBD::Oracle. ... If you have multiple perl installations (with DBI, DBD::Oracle) you may have to set the correct path to perl (first line of your script). ...
    (perl.dbi.users)