Shell Programming and Scripting

hi all,

have no experience with cronjob at solaris,
i have create script like below:

#!/bin/sh

DAY=`/export/home/oracle/bin/lastdate | nawk '{print $1}'`

/export/home/orahome/bin/sqlplus -s abc/abc<<eof
set heading off;
set linesize 100;
set feedback off;

spool /export/home/temip/$DAY.log

select ip,host_id from omc_ip ;

spool off;

EXIT;
eof

sed '/^$/d' /export/home/temip/$DAY.log > /export/home/temip/host$DAY
rm -rf /export/home/temip/$DAY.log

let's say the filename is "abc.sh"

the file i put in the oracle user environment but i have change the owner to user abc that i want to execute the file from cronjob.

the problem is the cronjob cannot running properly if i run manually from the abc user environment i got this error messages:

Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus

please advices

how to fix it?

thank you so much

Regards,

bucci

It seems more like Oracle error try connecting to oracle manually.

Make sure the necessary Oracle environment variables are part of your script.

Variables like:
ORACLE_HOME
ORAENV
ORACLE_SID
LD_LIBRARY_PATH

Which ones needed in this particular case I cannot tell.

I believe the error is due to - unable to locate the message property file. As said by others it should most probably be solved by the ORACLE specific ENV variables.

If not you need to export to the env through the script that is run

hi sb008,

the script is running in other user environment lets say user "abc". i have try to put oracle variable but cannot run.

please advices

thank you

Regards,

bucci