Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: invoking SQL*PLUS
In addition to all the path statements , be sure that the environment variables regarding Oracle_Home, etc are 'known' to the cron job...The message you received usually indicate an inability to fine Oracle_Home( under which the *.msb files are)
John Kachurick <jokach_at_epix.net> wrote:
>Hi-
>
>I'm having a problem trying to invoke SQL*Plus through a cronjob on
>HP-UX (and Oracle 7.3.4).
>Here's what I'm trying to do:
>I am trying to pass parameters to the PL/SQL statement through a shell
>script. It all works fine when I run it from the operating system
>command line, but when run as a cron job, it gives me the following error:
>
>Message file sp1<lang>.msb not found.
>Error initializing SQL*Plus
>
>I made sure to put the correct path statements and all into the script
>thats invoking the sqlplus command, but it still won't work
>
>What am I doing wrong?
>
>
Received on Wed Apr 04 2001 - 14:59:01 CDT