FAQ
Hi! I'm getting some hard time with DBD::Oracle.


My setup:

SunOS 5.8
isainfo -v
64-bit sparcv9 applications
32-bit sparc applications

Perl 5.8.2
DBI-1.38
Apache-DBI-0.92
DBD-Oracle-1.14
Apache-1.3.28
mod_perl-1.29
Oracle 8.1.7

I have everything compiled and installed allright, but when I try to run a
script, I got a "Internal Server Error". In Apache's error_log I got:

[Fri Nov 14 16:08:15 2003] [error] PerlRun: `install_driver(Oracle)
failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC
contains: /usr/local/lib/perl5/5.8.2/sun4-solaris
/usr/local/lib/perl5/5.8.2
/usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.2 /usr/local/lib/perl5/site_perl .
/webhelp/apache-1.3.28/ /webhelp/apache-1.3.28/lib/perl
/usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/) at
(eval 22) line 3
Compilation failed in require at (eval 22) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed
at oracle_env.pl line 37
Compilation failed in require at
/webhelp/apache/webhelp//texto_mensagem.cgi line 5.



I don't know what object it is looking for. Someone can help me? I had
fighting with this problem since yesterday (tried others perl/DBD/DBI
versions also).



Thanks!

Search Discussions

  • Ronald J Kimball at Nov 14, 2003 at 6:25 pm

    On Fri, Nov 14, 2003 at 04:18:51PM -0200, Jair Valmor Basso Júnior wrote:

    I have everything compiled and installed allright, but when I try to run a
    script, I got a "Internal Server Error". In Apache's error_log I got:

    [Fri Nov 14 16:08:15 2003] [error] PerlRun: `install_driver(Oracle)
    failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC
    contains: ...) at
    (eval 22) line 3
    Compilation failed in require at (eval 22) line 3.
    Perhaps a module that DBD::Oracle requires hasn't been fully installed
    at oracle_env.pl line 37
    Compilation failed in require at
    /webhelp/apache/webhelp//texto_mensagem.cgi line 5.


    I don't know what object it is looking for. Someone can help me? I had
    fighting with this problem since yesterday (tried others perl/DBD/DBI
    versions also).
    It is looking for the compiled DBD::Oracle object file.

    Are you sure DBD::Oracle is installed properly? Did you build it with
    make?

    Ronald
  • Jair Valmor Basso Júnior at Nov 14, 2003 at 6:36 pm
    Yes, I'm sure I did "make" "make install" without errors.

    It even created the Oracle.so in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so


    Jair,
    On Fri, 14 Nov 2003, Ronald J Kimball wrote:

    It is looking for the compiled DBD::Oracle object file.

    Are you sure DBD::Oracle is installed properly? Did you build it with
    make?

    Ronald
  • Ronald J Kimball at Nov 14, 2003 at 7:42 pm

    On Fri, Nov 14, 2003 at 04:41:19PM -0200, Jair Valmor Basso Júnior wrote:
    Yes, I'm sure I did "make" "make install" without errors.

    It even created the Oracle.so in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so
    Okay, the next thing I would check is the permissions on that file and the
    directories leading up to it. Can the user account running the script
    access the file?

    Ronald
  • Jair Valmor Basso Júnior at Nov 14, 2003 at 8:06 pm
    Yes, it was a permission problem. A weird one.

    Oracle/Oracle.so was 755

    but .../sun4-solaris/auto was 750

    I changed all to 755 (chmod -R 755) and now it works like a charm.


    I would like to congratulate all you guys who helped me. You are fast and
    really helpfull, thank you!


    Jair,

    On Fri, 14 Nov 2003, Ronald J Kimball wrote:
    On Fri, Nov 14, 2003 at 04:41:19PM -0200, Jair Valmor Basso Júnior wrote:
    Yes, I'm sure I did "make" "make install" without errors.

    It even created the Oracle.so in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so
    Okay, the next thing I would check is the permissions on that file and the
    directories leading up to it. Can the user account running the script
    access the file?

    Ronald
  • Hardy Merrill at Nov 14, 2003 at 8:28 pm
    Why would that permissions problem

    .../sun4-solaris/auto was 750

    in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so


    exist like that? I've never seen that before - has anyone
    else? Is that a problem that only happens on Sun? Does your
    root user have a strange umask or something? Or is that a
    problem that would have been created by the compile/install
    of Perl on the Sun machine? Just curious.

    Thanks.
    --
    Hardy Merrill
    Red Hat, Inc.

    Jair Valmor Basso Júnior [jair@sega-brasil.com.br] wrote:
    Yes, it was a permission problem. A weird one.

    Oracle/Oracle.so was 755

    but .../sun4-solaris/auto was 750

    I changed all to 755 (chmod -R 755) and now it works like a charm.


    I would like to congratulate all you guys who helped me. You are fast and
    really helpfull, thank you!


    Jair,

    On Fri, 14 Nov 2003, Ronald J Kimball wrote:
    On Fri, Nov 14, 2003 at 04:41:19PM -0200, Jair Valmor Basso Júnior wrote:
    Yes, I'm sure I did "make" "make install" without errors.

    It even created the Oracle.so in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so
    Okay, the next thing I would check is the permissions on that file and the
    directories leading up to it. Can the user account running the script
    access the file?

    Ronald
  • Jair Valmor Basso Júnior at Nov 14, 2003 at 9:47 pm
    I also wonder why...

    I don't know...

    # umask
    027


    Jair,
    On Fri, 14 Nov 2003, Hardy Merrill wrote:

    Why would that permissions problem

    .../sun4-solaris/auto was 750

    in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so


    exist like that? I've never seen that before - has anyone
    else? Is that a problem that only happens on Sun? Does your
    root user have a strange umask or something? Or is that a
    problem that would have been created by the compile/install
    of Perl on the Sun machine? Just curious.

    Thanks.
    --
    Hardy Merrill
    Red Hat, Inc.

    Jair Valmor Basso Júnior [jair@sega-brasil.com.br] wrote:
    Yes, it was a permission problem. A weird one.

    Oracle/Oracle.so was 755

    but .../sun4-solaris/auto was 750

    I changed all to 755 (chmod -R 755) and now it works like a charm.


    I would like to congratulate all you guys who helped me. You are fast and
    really helpfull, thank you!


    Jair,

    On Fri, 14 Nov 2003, Ronald J Kimball wrote:
    On Fri, Nov 14, 2003 at 04:41:19PM -0200, Jair Valmor Basso Júnior wrote:
    Yes, I'm sure I did "make" "make install" without errors.

    It even created the Oracle.so in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so
    Okay, the next thing I would check is the permissions on that file and the
    directories leading up to it. Can the user account running the script
    access the file?

    Ronald
  • Hardy Merrill at Nov 14, 2003 at 10:26 pm

    Jair Valmor Basso Júnior [jair@sega-brasil.com.br] wrote:
    I also wonder why...

    I don't know...

    # umask
    027
    That must be it - my root user has a umask of 0022 (or 022),
    so directories installed by root get 755. So with your root
    umask of 027, root installs directories as 750, which is just
    what you saw for the auto directory.

    Did you change your root umask to 750? Not sure why you
    would want to do that, since if I understand it correctly
    that would mean that only root, or users in the root group,
    could run anything installed by the root user. Am I missing
    something?

    Thanks.

    Hardy

    Jair,
    On Fri, 14 Nov 2003, Hardy Merrill wrote:

    Why would that permissions problem

    .../sun4-solaris/auto was 750

    in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so


    exist like that? I've never seen that before - has anyone
    else? Is that a problem that only happens on Sun? Does your
    root user have a strange umask or something? Or is that a
    problem that would have been created by the compile/install
    of Perl on the Sun machine? Just curious.

    Thanks.
    --
    Hardy Merrill
    Red Hat, Inc.

    Jair Valmor Basso Júnior [jair@sega-brasil.com.br] wrote:
    Yes, it was a permission problem. A weird one.

    Oracle/Oracle.so was 755

    but .../sun4-solaris/auto was 750

    I changed all to 755 (chmod -R 755) and now it works like a charm.


    I would like to congratulate all you guys who helped me. You are fast and
    really helpfull, thank you!


    Jair,

    On Fri, 14 Nov 2003, Ronald J Kimball wrote:
    On Fri, Nov 14, 2003 at 04:41:19PM -0200, Jair Valmor Basso Júnior wrote:
    Yes, I'm sure I did "make" "make install" without errors.

    It even created the Oracle.so in

    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so
    Okay, the next thing I would check is the permissions on that file and the
    directories leading up to it. Can the user account running the script
    access the file?

    Ronald
    --
    Hardy Merrill
    Red Hat, Inc.
  • Jeffrey Seger at Nov 14, 2003 at 6:27 pm
    First thing to check is if your $ORACLE_HOME is in your environment when
    running the script.



    ____________________________
    Jeff Seger
    Fairchild Semiconductor
    jeffrey.seger@fairchildsemi.com
    ____________________________





    Jair Valmor Basso Júnior <jair@sega-brasil.com.br>
    11/14/2003 01:18 PM


    To: <dbi-users@perl.org>
    cc:
    Subject: Help on DBD::Oracle



    Hi! I'm getting some hard time with DBD::Oracle.


    My setup:

    SunOS 5.8
    isainfo -v
    64-bit sparcv9 applications
    32-bit sparc applications

    Perl 5.8.2
    DBI-1.38
    Apache-DBI-0.92
    DBD-Oracle-1.14
    Apache-1.3.28
    mod_perl-1.29
    Oracle 8.1.7

    I have everything compiled and installed allright, but when I try to run a
    script, I got a "Internal Server Error". In Apache's error_log I got:

    [Fri Nov 14 16:08:15 2003] [error] PerlRun: `install_driver(Oracle)
    failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC
    contains: /usr/local/lib/perl5/5.8.2/sun4-solaris
    /usr/local/lib/perl5/5.8.2
    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris
    /usr/local/lib/perl5/site_perl/5.8.2 /usr/local/lib/perl5/site_perl .
    /webhelp/apache-1.3.28/ /webhelp/apache-1.3.28/lib/perl
    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/) at
    (eval 22) line 3
    Compilation failed in require at (eval 22) line 3.
    Perhaps a module that DBD::Oracle requires hasn't been fully installed
    at oracle_env.pl line 37
    Compilation failed in require at
    /webhelp/apache/webhelp//texto_mensagem.cgi line 5.



    I don't know what object it is looking for. Someone can help me? I had
    fighting with this problem since yesterday (tried others perl/DBD/DBI
    versions also).



    Thanks!
  • Jair Valmor Basso Júnior at Nov 14, 2003 at 6:43 pm
    Yes, I think the environment is ok.

    I have:

    ORACLE_HOME=/orahome/app/oracle/product/8.1.7
    TWO_TASK=/orahome/app/oracle/product/8.1.7/lib
    LD_LIBRARY_PATH=/orahome/app/oracle/product/8.1.7/lib

    and in my script:

    $ENV{ORACLE_HOME}="/orahome/app/oracle/product/8.1.7";
    $ENV{TWO_TASK}="/orahome/app/oracle/product/8.1.7/lib";
    $ENV{LD_LIBRARY_PATH}="/orahome/app/oracle/product/8.1.7/lib";


    I really don't understand what's going on...


    Jair,
    On Fri, 14 Nov 2003 Jeffrey.Seger@fairchildsemi.com wrote:

    First thing to check is if your $ORACLE_HOME is in your environment when
    running the script.



    ____________________________
    Jeff Seger
    Fairchild Semiconductor
    jeffrey.seger@fairchildsemi.com
    ____________________________





    Jair Valmor Basso Júnior <jair@sega-brasil.com.br>
    11/14/2003 01:18 PM


    To: <dbi-users@perl.org>
    cc:
    Subject: Help on DBD::Oracle



    Hi! I'm getting some hard time with DBD::Oracle.


    My setup:

    SunOS 5.8
    isainfo -v
    64-bit sparcv9 applications
    32-bit sparc applications

    Perl 5.8.2
    DBI-1.38
    Apache-DBI-0.92
    DBD-Oracle-1.14
    Apache-1.3.28
    mod_perl-1.29
    Oracle 8.1.7

    I have everything compiled and installed allright, but when I try to run a
    script, I got a "Internal Server Error". In Apache's error_log I got:

    [Fri Nov 14 16:08:15 2003] [error] PerlRun: `install_driver(Oracle)
    failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC
    contains: /usr/local/lib/perl5/5.8.2/sun4-solaris
    /usr/local/lib/perl5/5.8.2
    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris
    /usr/local/lib/perl5/site_perl/5.8.2 /usr/local/lib/perl5/site_perl .
    /webhelp/apache-1.3.28/ /webhelp/apache-1.3.28/lib/perl
    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/) at
    (eval 22) line 3
    Compilation failed in require at (eval 22) line 3.
    Perhaps a module that DBD::Oracle requires hasn't been fully installed
    at oracle_env.pl line 37
    Compilation failed in require at
    /webhelp/apache/webhelp//texto_mensagem.cgi line 5.



    I don't know what object it is looking for. Someone can help me? I had
    fighting with this problem since yesterday (tried others perl/DBD/DBI
    versions also).



    Thanks!



  • Jeffrey Seger at Nov 14, 2003 at 6:51 pm
    Better to add:

    SetEnv ORACLE_HOME /orahome/app/oracle/product/8.1.7

    to httpd.conf than to have it in the script. IIRC, that error is a
    compile-time error and setting Environment Variables in the script takes
    place at run-time (unless maybe they are set in a BEGIN block and even
    then I'm not sure).




    ____________________________
    Jeff Seger
    Fairchild Semiconductor
    jeffrey.seger@fairchildsemi.com
    ____________________________





    Jair Valmor Basso Júnior <jair@sega-brasil.com.br>
    11/14/2003 01:47 PM


    To: Jeffrey Seger/Corporate/FSC@Fairchild
    cc: <dbi-users@perl.org>
    Subject: Re: [inbox] Re: Help on DBD::Oracle



    Yes, I think the environment is ok.

    I have:

    ORACLE_HOME=/orahome/app/oracle/product/8.1.7
    TWO_TASK=/orahome/app/oracle/product/8.1.7/lib
    LD_LIBRARY_PATH=/orahome/app/oracle/product/8.1.7/lib

    and in my script:

    $ENV{ORACLE_HOME}="/orahome/app/oracle/product/8.1.7";
    $ENV{TWO_TASK}="/orahome/app/oracle/product/8.1.7/lib";
    $ENV{LD_LIBRARY_PATH}="/orahome/app/oracle/product/8.1.7/lib";


    I really don't understand what's going on...


    Jair,
    On Fri, 14 Nov 2003 Jeffrey.Seger@fairchildsemi.com wrote:

    First thing to check is if your $ORACLE_HOME is in your environment when
    running the script.



    ____________________________
    Jeff Seger
    Fairchild Semiconductor
    jeffrey.seger@fairchildsemi.com
    ____________________________





    Jair Valmor Basso Júnior <jair@sega-brasil.com.br>
    11/14/2003 01:18 PM


    To: <dbi-users@perl.org>
    cc:
    Subject: Help on DBD::Oracle



    Hi! I'm getting some hard time with DBD::Oracle.


    My setup:

    SunOS 5.8
    isainfo -v
    64-bit sparcv9 applications
    32-bit sparc applications

    Perl 5.8.2
    DBI-1.38
    Apache-DBI-0.92
    DBD-Oracle-1.14
    Apache-1.3.28
    mod_perl-1.29
    Oracle 8.1.7

    I have everything compiled and installed allright, but when I try to run a
    script, I got a "Internal Server Error". In Apache's error_log I got:

    [Fri Nov 14 16:08:15 2003] [error] PerlRun: `install_driver(Oracle)
    failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC
    contains: /usr/local/lib/perl5/5.8.2/sun4-solaris
    /usr/local/lib/perl5/5.8.2
    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris
    /usr/local/lib/perl5/site_perl/5.8.2 /usr/local/lib/perl5/site_perl .
    /webhelp/apache-1.3.28/ /webhelp/apache-1.3.28/lib/perl
    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/) at
    (eval 22) line 3
    Compilation failed in require at (eval 22) line 3.
    Perhaps a module that DBD::Oracle requires hasn't been fully installed
    at oracle_env.pl line 37
    Compilation failed in require at
    /webhelp/apache/webhelp//texto_mensagem.cgi line 5.



    I don't know what object it is looking for. Someone can help me? I had
    fighting with this problem since yesterday (tried others perl/DBD/DBI
    versions also).



    Thanks!



  • Jair Valmor Basso Júnior at Nov 14, 2003 at 7:11 pm
    I tried it but no luck :(



    Jair,
    On Fri, 14 Nov 2003 Jeffrey.Seger@fairchildsemi.com wrote:

    Better to add:

    SetEnv ORACLE_HOME /orahome/app/oracle/product/8.1.7

    to httpd.conf than to have it in the script. IIRC, that error is a
    compile-time error and setting Environment Variables in the script takes
    place at run-time (unless maybe they are set in a BEGIN block and even
    then I'm not sure).




    ____________________________
    Jeff Seger
    Fairchild Semiconductor
    jeffrey.seger@fairchildsemi.com
    ____________________________





    Jair Valmor Basso Júnior <jair@sega-brasil.com.br>
    11/14/2003 01:47 PM


    To: Jeffrey Seger/Corporate/FSC@Fairchild
    cc: <dbi-users@perl.org>
    Subject: Re: [inbox] Re: Help on DBD::Oracle



    Yes, I think the environment is ok.

    I have:

    ORACLE_HOME=/orahome/app/oracle/product/8.1.7
    TWO_TASK=/orahome/app/oracle/product/8.1.7/lib
    LD_LIBRARY_PATH=/orahome/app/oracle/product/8.1.7/lib

    and in my script:

    $ENV{ORACLE_HOME}="/orahome/app/oracle/product/8.1.7";
    $ENV{TWO_TASK}="/orahome/app/oracle/product/8.1.7/lib";
    $ENV{LD_LIBRARY_PATH}="/orahome/app/oracle/product/8.1.7/lib";


    I really don't understand what's going on...


    Jair,
    On Fri, 14 Nov 2003 Jeffrey.Seger@fairchildsemi.com wrote:

    First thing to check is if your $ORACLE_HOME is in your environment when
    running the script.



    ____________________________
    Jeff Seger
    Fairchild Semiconductor
    jeffrey.seger@fairchildsemi.com
    ____________________________





    Jair Valmor Basso Júnior <jair@sega-brasil.com.br>
    11/14/2003 01:18 PM


    To: <dbi-users@perl.org>
    cc:
    Subject: Help on DBD::Oracle



    Hi! I'm getting some hard time with DBD::Oracle.


    My setup:

    SunOS 5.8
    isainfo -v
    64-bit sparcv9 applications
    32-bit sparc applications

    Perl 5.8.2
    DBI-1.38
    Apache-DBI-0.92
    DBD-Oracle-1.14
    Apache-1.3.28
    mod_perl-1.29
    Oracle 8.1.7

    I have everything compiled and installed allright, but when I try to run a
    script, I got a "Internal Server Error". In Apache's error_log I got:

    [Fri Nov 14 16:08:15 2003] [error] PerlRun: `install_driver(Oracle)
    failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC
    contains: /usr/local/lib/perl5/5.8.2/sun4-solaris
    /usr/local/lib/perl5/5.8.2
    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris
    /usr/local/lib/perl5/site_perl/5.8.2 /usr/local/lib/perl5/site_perl .
    /webhelp/apache-1.3.28/ /webhelp/apache-1.3.28/lib/perl
    /usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/) at
    (eval 22) line 3
    Compilation failed in require at (eval 22) line 3.
    Perhaps a module that DBD::Oracle requires hasn't been fully installed
    at oracle_env.pl line 37
    Compilation failed in require at
    /webhelp/apache/webhelp//texto_mensagem.cgi line 5.



    I don't know what object it is looking for. Someone can help me? I had
    fighting with this problem since yesterday (tried others perl/DBD/DBI
    versions also).



    Thanks!





Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedNov 14, '03 at 6:14p
activeNov 14, '03 at 10:26p
posts12
users4
websitedbi.perl.org

People

Translate

site design / logo © 2022 Grokbase