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

Home -> Community -> Usenet -> c.d.o.server -> cron scripting of sql*plus

cron scripting of sql*plus

From: Matt Collins <mcollins_at_bay.csuhayward.edu>
Date: Tue, 23 Jan 2001 15:51:12 -0800
Message-ID: <3A6E18F0.6377E618@bay.csuhayward.edu>

I am wondering if anyone can help me troubleshoot a sqlplus script.

I have some sqlplus commands in a script file that is run by a cron job. I am getting an error message from the cron run as follows:

Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility
=ULMessage 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facil
ity=ULMessage 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, fa cility=ULMessage file sp1<lang>.msb not found Error 6 initializing SQL*Plus

If I run the same script from the command line (as the same user) then it works fine. Any suggestions would be helpful.

Thanks,
-Matt- Received on Tue Jan 23 2001 - 17:51:12 CST

Original text of this message

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