Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Error when running sqplus script in a crontab

Re: Error when running sqplus script in a crontab

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Fri, 28 Jan 2000 12:16:33 -0000
Message-ID: <86s1dt$oeq$1@kermit.esat.net>


Also, make sure that your shell script file includes the oracle profile.

Sybrand Bakker wrote in message
<949011089.22296.0.pluto.d4ee154e_at_news.demon.nl>...
>And you are missing the NLS_LANG env var.
>
>Hth,
>
>--
>Sybrand Bakker, Oracle DBA
>Joe Condle <condle_at_mars-systems.com> wrote in message
>news:3890B6A3.42FDD9E4_at_mars-systems.com...
>> I am trying to run a sqlplus script in a crontab. The script run
>> perfectly in my unix environment. I thoght all the environmental
>> variable were declared but I must be missing something. I am running
>> /bin/sh . The error I am getting is:
>> Message file spl<lang>.msb not found
>> Error 6 initalizing SQL*Plus
>>
>> I have the path to sqlplus declared.
>>
>> Any ideas
>>
>> --
>> Joseph P. Condle Jr. condle_at_mars-systems.com Office 412-473-6542
>> Senior Systems Engineer Fax 412-473-6538
>> Medical ARchival Systems, Inc. (MARS) Pager 412-572-9490
>> 1310 Beulah Road Pgh. Pa. 15235 USA
>
>
Received on Fri Jan 28 2000 - 06:16:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US