Re: DBD::Oracle 1.15 linking path problems with Oracle9i

From: Charles Jardine (cj10_at_cam.ac.uk)
Date: 05/26/04

  • Next message: Leegold: "DBI sql and pagination for a flat-file"
    Date: Wed, 26 May 2004 09:56:26 +0100
    To:  dbi-users@perl.org
    
    

    Marko Asplund wrote:
    > hi
    >
    > i'm compiling DBD::Oracle on Red Hat Linux 8.0 and HP-UX 11.00 against
    > Oracle9iR2 client libraries. the compilation process goes without
    > problems but the resulting DBD::Oracle library gets linked against
    > libraries in the wrong path. Oracle9i libraries are installed under
    > /opt/oracle9i but linked in /opt/kronodoc and the ORACLE_HOME is set to
    > /opt/kronodoc/oracle9i/u01/app/oracle/product/9.2.0 during DBD::Oracle
    > compilation. the resulting DBD::Oracle library is linked against the
    > libwtc9.so library in the wrong path according to ldd:
     
     [snip]

    > how can i link DBD::Oracle against the Oracle libraries in
    > /opt/kronodoc/oracle9i, not /opt/oracle9i?

    In short, you can't. This is not a problem specific to DBD::Oracle.
    It applies to all programs linked to Oracle 9i client libraries.

    What has happened is that the name /opt/oracle9i has been bound
    into the run-time path of the Oracle libraries themselves. This
    binding took place at install time. (This is why some Oracle
    documentation says that soft links to ORACLE_HOME directories
    are not supported).

    This may be better with the Oracle 10g "Instant Client", but I
    haven't checked yet.

    -- 
    Charles Jardine - Computing Service, University of Cambridge
    cj10@cam.ac.uk    Tel: +44 1223 334506, Fax: +44 1223 334679
    

  • Next message: Leegold: "DBI sql and pagination for a flat-file"

    Relevant Pages

    • Remote Compromise in Oracle 9i Database Server
      ... A large part of Oracle database functionality is provided by PL/SQL ... operating system libraries or Dynamic Link Libraries. ... An attack would probably call systemand pass ... external procedure the oracle process connects to the Listener and requests ...
      (Bugtraq)
    • [NEWS] Vulnerability in Oracle 9i Database Server Leads to Remote Compromise
      ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Oracle version 9 ... functions exported by operating system libraries or Dynamic Link ... requests that the Listener load the relevant library, ...
      (Securiteam)
    • Fixing the dreaded "wrong ELF class: ELFCLASS64" error with DBD::Oracle on Solaris
      ... I was able to download, build and install the DBD::Oracle module, as ... The problem stems from having a 32-bit version of Perl, and Oracle ... using 64-bit libraries in the .../lib path. ...
      (perl.dbi.users)
    • RE: Oracle make test failing on HP/UX
      ... Note the libraries. ... Oracle make test failing on HP/UX ... When I go to install the Oracle stuff I get this during a "make test": ... I did *not* build a threaded Perl because that gives a harsh warning ...
      (perl.dbi.users)
    • ANNOUNCE: DBD::Oracle 1.16 release candidate 7 - request for testing
      ... Unresolved symbol for OCILobIsTemporary and OCILobFreeTemporary. ... because OCILobWriteAppend_log_stat does also not exists for Oracle 8.0.6. ... If you have problems you may need to rebuild perl with threading enabled. ... Failed to load Oracle extension and/or shared libraries: ...
      (perl.dbi.users)