oracle 9 upgrade caused soap service to fail

From: Nitish Bezzala (nitish_b_at_lgsoftindia.com)
Date: 05/21/04

  • Next message: Perldiscuss - Perl Newsgroups And Mailing Lists: "Re: proxying DBI connection"
    To: dbi-users@perl.org
    Date: Fri, 21 May 2004 17:12:45 +0530
    
    

    Hi,

    I have written a perl script, which is called by a soap service. It used to
    run fine, until we upgraded from Oracle 8i to Oracle 9i. The same program
    runs fine when called from the command line.
    I think it may be because some new environment variable has not been set.
    Please let me know if you have any ideas.

    The error is in this line,
     $dbh = DBI->connect($DSN, $DBUSER , $DBPASSWORD)

    The apache error logs give me this :
    [Fri May 21 05:07:41 2004] [error] [client localhost] install_driver(Oracle)
    failed: Can't load
    '/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/auto/DBD/Oracle/Oracle.so
    ' for module DBD::Oracle: ld.so.1: /usr/local/bin/perl5.8.3: fatal:
    /app/oracle/lib/libclntsh.so.9.0: wrong ELF class: ELFCLASS64 at
    /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 229.
    [Fri May 21 05:07:41 2004] [error] [client localhost] at (eval 1) line 3
    [Fri May 21 05:07:41 2004] [error] [client localhost] Compilation failed in
    require at (eval 1) line 3.
    [Fri May 21 05:07:41 2004] [error] [client localhost] Perhaps a required
    shared library or dll isn't installed where expected
    [Fri May 21 05:07:41 2004] [error] [client localhost] at
    /vol/devel4/offshore/Workspaces/nbezzala_ws/scripts/FTUPA/Engine.perl line
    733

    Thanks,
    Nitish


  • Next message: Perldiscuss - Perl Newsgroups And Mailing Lists: "Re: proxying DBI connection"

    Relevant Pages

    • Re: Problem with fetching LONGs and LONG RAWs (ORA-01062)
      ... This perl script illustrates a strange problem while fetching ... LONGs and LONG RAWs. ... What is the full version of Oracle? ... What is the version of the DBI? ...
      (comp.databases.oracle.misc)
    • Re: DBI with ORACLE encryption
      ... perl script to pull data out of the interface and dump the same to the ... All we do with oracle is to take an database connection ... other ways of connecting to database using dbi. ...
      (perl.dbi.users)
    • Re: ORA-24315 error on DBD-Oracle installation.
      ... I try to connect to the Oracle 9.2 server from my simple Perl script: ... of header files were missing, and we brought them over from the DB ...
      (perl.dbi.users)
    • Problem with fetching LONGs and LONG RAWs (ORA-01062)
      ... This perl script illustrates a strange problem while fetching ... LONGs and LONG RAWs. ... Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod ... PL/SQL Release 10.2.0.3.0 - Production ...
      (perl.dbi.users)
    • Re: Oracle connection woes... any ideas?
      ... During the install has cured this issue. ... a perl script which is intended to run as a daemon ... store some log messages in an Oracle database. ... runs some stored procedures to log messages in a message table. ...
      (perl.dbi.users)