Hello Monks,

I am using Perl scripts on Apache web server to access Oracle DB.

DB connection simply fails with the following error on the apache error_log: 

DBI connect('','www',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)
+ at /usr/local/apache/cgi-bin/itrack_basic_search/test.pl line 19

[download]

Line19: test.pl: 

my $dbh= DBI-> connect('dbi:Oracle:','www','www') or die "Database con
+nection cannot be established";

[download]

I feel this is a miss configuration Apache web server, since the script runs on the command line without any problem.

I saw a similar posting @ Perl, DBI, Oracle, Apache, but I did not have a luck with this. I have already configured following Env variables on httpd.conf: 

SetEnv ORACLE_HOME /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
+/
SetEnv ORACLE_SID XE
SetEnv NLS_LANG `$ORACLE_HOME/bin/nls_lang.sh`
SetEnv PATH $ORACLE_HOME/bin:$PATH
SetEnv LD_LIBRARY_PATH /usr/lib/oracle/xe/app/oracle/product/10.2.0/se
+rver/lib/

[download]

Any clues please?

Sumith

In reply to Perl, DBI, Oracle, Apache: Followup by banduwgs

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.