Found a clumsy solution, if anyone can come up with better one will be nice

As mje suspected (thanks) there was something fishy with those two "harmless" missing lib-links... here 

Warning: -L../../ changed to -L/root/.cpan/build/DBD-Oracle-1.28-enbAG
+6/../../
Note (probably harmless): No library found for -locci
Note (probably harmless): No library found for -lclntsh

[download]

I used brute force i.e. created two symlinks in "/root/.cpan"

/root/.cpan/libclntsh.so -> /usr/lib64/oracle/11.2.0.2/client/lib/libc
+lntsh.so.11.1
/root/.cpan/libocci.so -> /usr/lib64/oracle/11.2.0.2/client/lib/libocc
+i.so.11.1

[download]
Now when I compile : 
/root/.cpan/build/DBD-Oracle-1.28-enbAG6/blib/arch/auto/DBD/Oracle
# ldd Oracle.so 
    linux-vdso.so.1 =>  (0x00007fff821f7000)
    libclntsh.so.11.1 => /usr/lib/oracle/11.2.0.2/client/lib/libclntsh
+.so.11.1 (0x00007f0a3c222000)
    libpthread.so.0 => /lib/libpthread.so.0 (0x00007f0a3bfd7000)
    libc.so.6 => /lib/libc.so.6 (0x00007f0a3bc81000)
    libnnz11.so => /usr/lib/oracle/11.2.0.2/client/lib/libnnz11.so (0x
+00007f0a3b8b9000)
    libdl.so.2 => /lib/libdl.so.2 (0x00007f0a3b6b4000)
    libm.so.6 => /lib/libm.so.6 (0x00007f0a3b432000)
    libnsl.so.1 => /lib/libnsl.so.1 (0x00007f0a3b21a000)
    libaio.so.1 => /usr/lib/libaio.so.1 (0x00007f0a3b017000)
    /lib64/ld-linux-x86-64.so.2 (0x00007f0a3ecaa000)
    librt.so.1 => /lib/librt.so.1 (0x00007f0a3ae0e000)

[download]

make test goes well as well

--------------------------------------------------------------------------------

Trying to install DBD::Oracle

export ORACLE_HOME=/usr/lib/oracle/11.2.0.2/client
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

C_INCLUDE_PATH=/usr/lib/oracle/11.2.0.2/client/include cpan -i DBD::Or
+acle

[download]

It compiles OK.. but make test fails at :

undefined symbol: OCITypeByRef i.e. 
......
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl5.12.3 "-MExtUtils::Command::MM" "-e" "
+test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base.t .............. # Test loading DBI, DBD::Oracle and version
t/01base.t .............. 1/6
#   Failed test 'install_driver'
#   at t/01base.t line 22.
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load '/root/.cpan/build/DBD-Oracl
+e-1.28-EfF3QS/blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Or
+acle: /root/.cpan/build/DBD-Oracle-1.28-EfF3QS/blib/arch/auto/DBD/Ora
+cle/Oracle.so: undefined symbol: OCITypeByRef at /usr/lib64/perl5/5.1
+2.3/x86_64-linux-thread-multi/DynaLoader.pm line 200.
 at (eval 8) line 3
Compilation failed in require at (eval 8) line 3.
Perhaps a required shared library or dll isn't installed where expecte
+d
 at t/01base.t line 19

[download]
any ideas, why that could be ...

In reply to DBD::Oracle installation by rootcho

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.