shell script giving an error

[mmalefho]

i have the following shell script and it gives me errors

"mainbrain:/home/bscs6/scripts>sh LMS_PROFILE.sh
LMS_PROFILE.sh: ORACLE_SID=SEGODI: is not an identifier
mainbrain:/home/bscs6/scripts>^[ "## Heading ##


the script is as follows:


. /home/bscs6/.kshrc
set -x
monthy=`date +%m`
daty=`date +%d`
yeary=`date +%Y`
cd /home/bscs6/scripts
sqlplus sysadm/sysadm@SEGODI @lms_profile.sql
mv /home/bscs6/scripts/lmsprofile.log /home/bscs6/scripts/LMS_PROFILE_DUMP_$daty$monthy$yeary.txt
done
EOF'

 

[SamBones]

By typing '[tt]sh[/tt]' in front of the shell script name, you are running it in the Bourne Shell, but your first command is sourcing a Korn Shell resource script. There may be Korn Shell commands in "[tt]/home/bscs6/.kshrc[/tt]" that don't work in the Bourne Shell.

I would add this as the first line of your script...

#!/bin/ksh

...so it forces it to use the Korn Shell. Then run it like this...

./LMS_PROFILE.sh

 

[SamBones]

If that doesn't fix it, we'd need to see what's in '[tt]/home/bscs6/.kshrc[/tt]'.