Message-ID: <3ACB83C6.4090708@epix.net> From: John Kachurick Organization: Commonwealth Telephone Enterprises, Inc User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; m18) Gecko/20010131 Netscape6/6.01 X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: invoking SQL*PLUS References: <3ACB6F2B.8060805@epix.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 33 Date: Wed, 04 Apr 2001 20:27:56 GMT NNTP-Posting-Host: 209.74.63.70 X-Complaints-To: abuse@epix.net X-Trace: news1.epix.net 986416076 209.74.63.70 (Wed, 04 Apr 2001 16:27:56 EDT) NNTP-Posting-Date: Wed, 04 Apr 2001 16:27:56 EDT I failed to add the Oracle_home to the script, now that I added it, it works perfectly ... Thanks for your help!!!! TurkBear wrote: > 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 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.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? >> >>