RE: ** Oraperl question **

Hi Gerardo,

        I ran this script again another user not oracle user but it works fine when not run as crontab.

        I did setup all the environment the same as I use env command. Any suggestion

Thx
Chatsuda

> -----Original Message-----
> From: Molina, Gerardo [SMTP:Gerardo.Molina_at_schwab.com]
> Sent: Saturday, December 02, 2000 12:19 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ** Oraperl question **
>
> Are you running it as oracle user?
>
> make sure you are using "su - oracle" in your crontab entry.
>
> It's probably an environment variable problem.
>
> Gerardo
>
> -----Original Message-----
> Sent: Thursday, November 30, 2000 10:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
> When I test the oraperl program it work find but when I put into the
> crontab job I got the following error :
>
> install_driver(Oracle) failed: Can't load
> '/usr/local/pkg/perl/perl5.004_04/lib/site_perl/sun4-solaris/auto/DBD/Orac
> le
> /Oracle.so' fo
> r module DBD::Oracle: ld.so.1: /usr/local/bin/oraperl: fatal:
> libsunmath.so.1: open failed: No such file or directory at /usr/local/
> pkg/perl/perl5.004_04/lib/sun4-solaris/5.00404/DynaLoader.pm line 166.
>
> at (eval 1) line 2
>
> at /usr/local/pkg/perl/perl5.004_04/lib/site_perl/Oraperl.pm line 58
> BEGIN failed--compilation aborted at /users/fdw/chat6.pl line 10.
>
>
> Your suggestion will be appreciated
>
> Thx
> Chatsuda
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: chatsuda.watcharaku_at_amd.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Molina, Gerardo
> INET: Gerardo.Molina_at_schwab.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Mon Dec 04 2000 - 03:43:58 CST