LinuxQuestions.org - [SOLVED] nothing happens when I execute a script

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - nothing happens when I execute a script (https://www.linuxquestions.org/questions/linux-newbie-8/nothing-happens-when-i-execute-a-script-4175500668/)

nothing happens when I execute a script

Linux 2.6.32-400.21.1.el5uek #1 SMP Wed Feb 20 01:35:01 PST 2013 x86_64 x86_64 x86_64 GNU/Linux

the script starts with a
#!/bin/sh
and then exports the PATH also
the permissions are 777
But nothing actually happens when I execute it using
sh scriptname.sh
I have written scripts earlier but am not able to figure out what I am missing

Please help
Thanks

Please show the actual script as thus far it is impossible to tell if anything should actually happen?

Also, what do you expect to happen?

Code:

#!/bin/sh

#########      Oracle Environment Variables  ####################

ORACLE_BASE=/u01/app/oracle/product;

ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1;

ORACLE_SID=asdf

PATH=/usr/local/bin:/bin:/usr/bin:/u01/app/oracle/product/11.2.0.3/dbhome_1/bin

export ORACLE_SID ORACLE_BASE ORACLE_HOME

export PATH



#################################################################

PWD_DIR=$HOME/PWD_FILE

DIR=$HOME/cronscripts

PWD_FILE=$PWD_DIR/abc_system.sgn

SCRIPTS_DIR=$DIR/scripts

SCR_BASE=$HOME/cronscripts

SCR_LOC=$SCR_BASE/batchjobs

LOG_LOC=/$HOME/cronscripts/logs

LOG_FILE=$LOG_LOC/mno_mail.log

#################################################################

#

# password file check

#

#################################################################

if [ -f "$PWD_FILE" ]

then

        USER_PASSWD=` cat "$PWD_FILE" `

else

        echo "Password file '$PWD_FILE' is required." > $LOG_LOC/password_not_found_file.out

        echo $ORACLE_SID >> $LOG_LOC/password_not_found_file.out

        LOG_NAME=$LOG_LOC/password_not_found_file.out

        mail -s "Exporting abc.mno - Password not found!" "abc@xyz.com" > /dev/null <${LOG_NAME}

        exit

fi





echo ' **************************************************************************************************** ' >$LOG_FILE

echo ' **************************************************************************************************** ' >>$LOG_FILE

echo ' starting process... ' >> $LOG_FILE

echo ' Time : ' `date` >> $LOG_FILE

starttime=`date`

echo ' **************************************************************************************************** ' >>$LOG_FILE

echo "Executing ${0} ..." >> $LOG_FILE



$ORACLE_HOME/bin/sqlplus -s << EOF >> $LOG_FILE

$USER_PASSWD

@$SCRIPTS_DIR/mnopq.sql;



EOF

EXP_LOG=mno

DATE_VAR=`date +"%Y%m"`

EXP_LOG=$EXP_LOG{$DATE_VAR}

cat /u02/EXP_DUMP/{$EXP_LOG}.log >> $LOG_FILE

end_time=`date`



echo " " >> $LOG_FILE

echo "---------------" >> $LOG_FILE

echo "Start Time:" $start_time >> $LOG_FILE

echo "End  Time:" $end_time >> $LOG_FILE

echo "---------------" >> $LOG_FILE

Ok ... so firstly, please use [code][/code] tags when displaying code or data.

You have provided your script ... cheers, but you did not answer my question ... what do you expect to see happen?

On a brief look at that script I cannot see that it will display anything to the screen unless an error happens.

So please advise what the problem is more specifically?

My apologies, thanks for being patient.
This exports a table (80 Gig) and this takes time
when I execute the script using sh scriptname.sh I cannot see the script as a process when I do a ps -ef|grep scriptname
when I try to run it using nohup sh scriptname.sh & the screen immediately outputs

Code:

"Done scriptname.sh"

This is all that I can explain as this is all I see.

What does the log file say?

no log file gets created.

Why are you using both nohup and &? What happens if you don't add the &? The duplication might be part of the problem.

when I execute the script using sh scriptname.sh I cannot see the script as a process if I do a ps -ef|grep scriptname

can you show us the output of:

Code:

cat -A your-script-name.ksh

i suspect you are editing this in windows and it is adding cr-lf's to the end of each line.

also try putting the line set -xv as the second line in the script.

Yes I was editing in windows based notepad ++
there is a dollar sign at the end of each line
not sure if it is abnormal
I see that in other files as well
when I run your command

Code:

echo "Executing ${0} ..." >> $LOG_FILE$

$

$ORACLE_HOME/bin/sqlplus -s << EOF >> $LOG_FILE$

$USER_PASSWD$

@$SCRIPTS_DIR/sitecatalyst_session.sql;$

$

EOF$

EXP_LOG=CXD_SITECATALYST_SESSION$

DATE_VAR=`date +"%Y%m"`$

EXP_LOG=$EXP_LOG{$DATE_VAR}$

cat /u02/EXP_DUMP/{$EXP_LOG}.log >> $LOG_FILE$

end_time=`date`$

$

echo " " >> $LOG_FILE$

echo "---------------" >> $LOG_FILE$

echo "Start Time:" $start_time >> $LOG_FILE$

echo "End  Time:" $end_time >> $LOG_FILE$

echo "---------------" >> $LOG_FILE$

$

Just to confirm ... all the paths to files used for the script exist?

Quote:

Originally Posted by oraenthu@live.com (Post 5147168)

Yes I was editing in windows based notepad ++
there is a dollar sign at the end of each line
not sure if it is abnormal
I see that in other files as well
when I run your command
...

i think thats fine as long as there are no ^m's.

try running it with set -xv enabled. or debug it with echo's placed before and after each if.

I place an echo and the echo executes
its only the echo that is executing, nothing else

Update:
okay the password file was missing, when I checked my mail for that subject line, I had about 20 or so mails
there is an exit after that if clause, so if password file is not found, the script exits.

That was fixed and now it works fine.

Thanks so much for your involvement.