RE: [dbi] Re: (Fwd) DBD Install

From: Martin J. Evans (martin.evans_at_easysoft.com)
Date: 01/28/05

  • Next message: csg: "Re: Problem compiling Oracle::OCI 0.06 under DBI 1.46"
    Date: Fri, 28 Jan 2005 12:37:07 -0000 (GMT)
    To: dbi-users@perl.org
    
    

    Just in case it helps anyone else I had a similar problem. I installed Oracle
    9.2.0.1.0 with the Administrator install and did not have an oci.h. I went back
    and did a custom install to find Oracle Call Interface was not installed by
    default.

    Thanks Jeff for the pointer.

    Martin

    --
    Martin J. Evans
    Easysoft Ltd, UK
    Development
    On 29-Oct-2004 Jeff Long wrote:
    > Tim Bunce wrote:
    >> ----- Forwarded message from Denesa K Shaw
    >> <denesa.shaw@CenterPointEnergy.com> -----
    >> 
    >> Delivered-To: tim.bunce@pobox.com
    >> X-SPF-Guess: pass (seems reasonable for denesa.shaw@CenterPointEnergy.com to
    >> mail through 158.81.14.31)
    >> Subject: DBD Install 
    >> To: Tim.Bunce@pobox.com
    >> From: Denesa K Shaw <denesa.shaw@CenterPointEnergy.com>
    >> Date: Thu, 28 Oct 2004 12:38:36 -0500
    >> 
    >> 
    >> 
    >> 
    >> 
    >> Hi,
    >> We have Oracle 9 Client installed on one of our servers and we are trying
    >> to install the DBD module for Oracle.
    >> After running the make command we are getting the following errors:
    >> could you give us some insight on what we need to do?
    >> 
    >> # make
    >> cp Oracle.pm blib/lib/DBD/Oracle.pm
    >> cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
    >> cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
    >> cp oraperl.ph blib/lib/oraperl.ph
    >> cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
    >> cp Oraperl.pm blib/lib/Oraperl.pm
    >> cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
    >> cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
    >>         /usr/bin/perl -e 'use ExtUtils::Mksymlists;  Mksymlists("NAME" =>
    >> "DBD::
    >> Oracle", "DL_FUNCS" => {  }, "FUNCLIST" => [], "DL_VARS" => []);'
    >>         /usr/bin/perl -p -e "s/~DRIVER~/Oracle/g"
    >> /usr/opt/perl5/lib/site_perl/5
    >> .8.0/aix-thread-multi/auto/DBI//Driver.xst > Oracle.xsi
    >>         /usr/bin/perl /usr/opt/perl5/lib/5.8.0/ExtUtils/xsubpp  -typemap
    >> /usr/op
    >> t/perl5/lib/5.8.0/ExtUtils/typemap -typemap typemap  Oracle.xs > Oracle.xsc
    >> && m
    >> v Oracle.xsc Oracle.c
    >>         gcc -c  -I. -I/u00/app/oracle/product/9.2.0/precomp/public
    >> -I/u00/app/or
    >> acle/product/9.2.0/rdbms/public -I/u00/app/oracle/product/9.2.0/rdbms/demo
    >> -I/u0
    >> 0/app/oracle/product/9.2.0/plsql/public -I/u00/app/oracle/product/9.2.0
    >> /network/
    >> public -I/u00/app/oracle/product/9.2.0/rdbms/demo
    >> -I/u00/app/oracle/product/9.2.
    >> 0/rdbms/demo -I/usr/opt/perl5/lib/site_perl/5.8.0
    >> /aix-thread-multi/auto/DBI/  -D
    >> _ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN
    >> -DNEED_PTHREAD_
    >> INIT -D_LARGE_FILES -O    -DVERSION=\"1.16\"  -DXS_VERSION=\"1.16\"
    >> "-I/usr/opt
    >> /perl5/lib/5.8.0/aix-thread-multi/CORE"  -DUTF8_SUPPORT -DNEW_OCI_INIT
    >> -DORA_OCI
    >> _VERSION=\"9.2.0.1\" Oracle.c
    >> In file included from Oracle.h:20,
    >>                  from Oracle.xs:1:
    >> dbdimp.h:44: oci.h: A file or directory in the path name does not exist.
    >> In file included from Oracle.h:20,
    >>                  from Oracle.xs:1:
    >> dbdimp.h:46: ocidfn.h: A file or directory in the path name does not exist.
    >> make: 1254-004 The error code from the last command is 1.
    > 
    > I've seen this issue on Solaris where you do an 'Administrator' client 
    > install and it leaves out some critical OCI components.  I can't 
    > remember exactly which component was missing but we fixed it by going 
    > back through the installer and choosing a custom install and finding the 
    > OCI component that it missed.
    > 
    > Checking some old email it looks like you need the Oracle9i Database / 
    > Oracle9i Development Kit / Oracle Call Interface (OCI) component.
    > 
    > Jeff Long
    

  • Next message: csg: "Re: Problem compiling Oracle::OCI 0.06 under DBI 1.46"

    Relevant Pages

    • Re: Adding RAM
      ... About Oracle, I currently use Mysql for my TM databases but I have been ... Limited to a 4GB database but that should be adequate ... The rpm is easy to install and you get a nice tutorial to ... Here's the link to the Oracle-10g + Compiere installation on SuSE ...
      (alt.os.linux.suse)
    • Re: Upgrade 8i to 9i --- multiple oracle_base !!!!!!
      ... > it's own system owning account. ... > 1) Install one copy of the latest version of SQL-Backtrack into its own ... completely separate from any Oracle directories. ... > 2) Shutdown and cold backup both databases. ...
      (comp.databases.oracle.server)
    • RE: DBD::Oracle on Oracle 11g 64 bit fedora 10
      ... I am having some worries with a new install of fedora 10. ... I also installed oracle 11.1.0.7. ... Napier University is a registered Scottish charity. ... Edinburgh Napier University is a registered Scottish charity. ...
      (perl.dbi.users)
    • RE: Problems to Install Oracle Client 10g over Red Hat AS 3.0update3
      ... Oracle 10g R1 DB go out of memory once in a while goes for a toss till it ... "General Red Hat Linux discussion list" ... Problems to Install Oracle Client 10g over Red Hat AS 3.0update3 ...
      (RedHat)
    • RE: :Oracle install problem On Solaris 8
      ... I tried to reinstall the Oracle client. ... To: Hemanth Kumar; Michael Nhan ... Subject: RE::Oracle install problem On Solaris 8 ...
      (perl.dbi.users)