You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Kailashnath V Rampure <ka...@webcash.com> on 2000/10/26 20:52:22 UTC

Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

I had a problem connectingto DB using CGI scripts, but it was working fine 
manual connections. So we had to add line "$ORACLE_HOME/lib " in the file 
/etc/ld.so.conf and run command "ldconfig"
Here Please replace $ORACLE_HOME with absolute path.

Hope this solves the problem.

Regards
Kailas
The line is
At 12:51 AM 10/27/00 +0900, HotMail: Bill wrote:
>Oops  correction to below: should read ORA-12154
>  ORA-12154 (DBD ERROR: OCIServerAttach)
>----- Original Message -----
>From: "HotMail: Bill" <bd...@hotmail.com>
>To: <mo...@apache.org>
>Sent: Friday, October 27, 2000 12:28 AM
>Subject: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with
>Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
>OpenSSL/0.9.5a
>
>
> > I've got a system running the following:
> >
> > Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
> > OpenSSL/0.9.5a
> >
> > If I run the cgi scripts from command line they connect to the oracle
> > database just fine.
> >
> > If I run them under the webserver (apache::registry), the cannot connect
>to
> > the database.
> > ORA-12054 error.
> >
> > Has anyone seen this before or have an idea on how to track down the
> > problem?
> > All help will be very appreciated.
> >
> > Thanks,
> > Bill
> >

Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

Posted by "HotMail: Bill" <bd...@hotmail.com>.
Yup that solved... that error message.. now I get  ORA-06401 (DBD ERROR: OCIServerAttach)

-Bill
  ----- Original Message ----- 
  From: Kailashnath V Rampure 
  To: HotMail: Bill ; HotMail: Bill ; modperl@apache.org 
  Sent: Friday, October 27, 2000 3:52 AM
  Subject: Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a



  I had a problem connectingto DB using CGI scripts, but it was working fine manual connections. So we had to add line "$ORACLE_HOME/lib " in the file /etc/ld.so.conf and run command "ldconfig"
  Here Please replace $ORACLE_HOME with absolute path.

  Hope this solves the problem.

  Regards
  Kailas
  The line is 
  At 12:51 AM 10/27/00 +0900, HotMail: Bill wrote:

    Oops  correction to below: should read ORA-12154
     ORA-12154 (DBD ERROR: OCIServerAttach)
    ----- Original Message -----
    From: "HotMail: Bill" <bd...@hotmail.com>
    To: <mo...@apache.org>
    Sent: Friday, October 27, 2000 12:28 AM
    Subject: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with
    Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
    OpenSSL/0.9.5a


    > I've got a system running the following:
    >
    > Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
    > OpenSSL/0.9.5a
    >
    > If I run the cgi scripts from command line they connect to the oracle
    > database just fine.
    >
    > If I run them under the webserver (apache::registry), the cannot connect
    to
    > the database.
    > ORA-12054 error.
    >
    > Has anyone seen this before or have an idea on how to track down the
    > problem?
    > All help will be very appreciated.
    >
    > Thanks,
    > Bill
    >