Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Comment on

( #3333=superdoc: print w/ replies, xml ) Need Help??

Hi Monks

I need to install DBD::Oracle module in the Linux RedHat server, and this box is having the oracle client (Oracle version is: 11.2.0.3.0), for that i set the below environment variables

export PATH=$PATH:/u01/app/oracle/product/11.2.0/client_1/bin export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/oracle/product/11.2.0 +/client_1/lib export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1 export ORACLE_DSN='dbi:Oracle:DB_Name' export ORACLE_USERID='USERID/PASSWORD'

While i am trying manually to connect database via terminal using sqlplus, i can able to connect the database with the above credential
But While i am trying to install i got the below error

# # Generated by Dist::Zilla::Plugin::ReportVersions::Tiny v1.08 # perl: 5.008008 (wanted 5.006) on linux from /usr/bin/perl # # Carp => 1.04 (want an +y version) # Config => <undef> (want an +y version) # DBI => 1.627 (want 1. +51) # Data::Dumper => 2.121_08 (want an +y version) # Devel::Peek => 1.03 (want an +y version) # DynaLoader => 1.05 (want an +y version) # Encode => 2.51 (want an +y version) # Exporter => 5.58 (want an +y version) # ExtUtils::MakeMaker => 6.30 (want 6. +30) # Math::BigInt => 1.77 (want an +y version) # Test::More => 0.98 (want 0. +88) # Thread::Semaphore => 2.01 (want an +y version) # strict => 1.03 (want an +y version) # utf8 => 1.06 (want an +y version) # vars => 1.01 (want an +y version) # version => 0.9902 (want 0. +9901) # warnings => 1.05 (want an +y version) # # Thanks for using my code. I hope it works for you. # If not, please try and include this output in the bug report. # That will help me reproduce the issue and solve your problem. # t/000-report-versions-tiny.t .. ok t/00versions.t ................ # OCI client library version: 11.2.0.3 t/00versions.t ................ 1/2 # database version: Oracle Databas +e 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production t/00versions.t ................ ok t/01base.t .................... ok t/10general.t ................. ok t/12impdata.t ................. ok t/14threads.t ................. ok t/15nls.t ..................... ok t/20select.t .................. ok t/21nchar.t ................... ok t/22nchar_al32utf8.t .......... ok t/22nchar_utf8.t .............. ok t/23wide_db.t ................. skipped: Database character set is not + Unicode t/23wide_db_8bit.t ............ skipped: Database character set is not + Unicode t/23wide_db_al32utf8.t ........ skipped: Database character set is not + Unicode t/24implicit_utf8.t ........... skipped: database character set is not + Unicode t/25plsql.t ................... ok t/26exe_array.t ............... ok t/28array_bind.t .............. ok t/30long.t .................... ok t/31lob.t ..................... 1/12 DBI::db=HASH(0x9b6c6d0)->disconne +ct invalidates 1 active statement handle (either destroy statement ha +ndles or call finish on them before disconnecting) at t/31lob.t line +216. t/31lob.t ..................... ok t/31lob_extended.t ............ ok t/32xmltype.t ................. ok t/34pres_lobs.t ............... ok t/36lob_leak.t ................ ok t/38taf.t ..................... ok t/39attr.t .................... # Oracle version: 11.2.0.3.0 # client version: 11.2.0.3 t/39attr.t .................... ok t/40ph_type.t ................. ok t/50cursor.t .................. Can't determine open_cursors from v$pa +rameter, so using default t/50cursor.t .................. ok t/51scroll.t .................. ok t/55nested.t .................. ok t/56embbeded.t ................ 1/4 DBD::Oracle::db do failed: ORA-010 +31: insufficient privileges (DBD ERROR: OCIStmtExecute) [for Statemen +t "CREATE or replace TYPE table_embeda_type as varray(10) of varchar +(30) "] at t/56embbeded.t line 50. # Looks like you planned 4 tests but ran 1. # Looks like your test exited with 2 just after 1. t/56embbeded.t ................ Dubious, test returned 2 (wstat 512, 0 +x200) Failed 3/4 subtests t/58object.t .................. ok t/60reauth.t .................. skipped: ORACLE_USERID_2 not defined. t/70meta.t .................... ok t/80ora_charset.t ............. skipped: Database is set up as US7ASCI +I t/rt13865.t ................... ok t/rt74753-utf8-encoded.t ...... skipped: database character set is not + Unicode Test Summary Report ------------------- t/31lob.t (Wstat: 0 Tests: 12 Failed: 0) TODO passed: 9-11 t/56embbeded.t (Wstat: 512 Tests: 1 Failed: 0) Non-zero exit status: 2 Parse errors: Bad plan. You planned 4 tests but ran 1. Files=37, Tests=1637, 27 wallclock secs ( 0.52 usr 0.06 sys + 5.50 c +usr 0.94 csys = 7.02 CPU) Result: FAIL Failed 1/37 test programs. 0/1637 subtests failed. make: *** [test_dynamic] Error 255 PYTHIAN/DBD-Oracle-1.64.tar.gz /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, t +ry: reports PYTHIAN/DBD-Oracle-1.64.tar.gz Running make install make test had returned bad status, won't install without force Failed during this command: PYTHIAN/DBD-Oracle-1.64.tar.gz : make_test NO

Do i need to set any other environment variable or i missed any other.
I would appreciate any kind of help or ideas to resolve this issue

Thanks in Advance

Shanmugam A.


In reply to DBD::Oracle module installation by shan_emails

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!
  • 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, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            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.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others about the Monastery: (7)
    As of 2014-12-18 02:49 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      Is guessing a good strategy for surviving in the IT business?





      Results (41 votes), past polls