[SOLVED] two funtions are not working together

charithsrng · 02-21-2013, 12:06 AM

in my shell script i have below code.

apps_down()
{
. /ebiz1/QAL/apps/apps_st/appl/QALNEW_ct-eagorasvr1.env
su - applclone -c "
echo -e \"\t\t\t INFO : Shutting the apps as whoami .\"
whoami
echo -e \"\t\t\t INFO : check the logfile /home/applclone/error_log.txt for more information.....\"
$ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps > /home/applclone/error_log.txt"
}

stop_dbs()
{
su - oraclone -c "
echo -e \"\t\t\t INFO :dbs are shutting.....\"
echo -e \"\t\t\t INFO : check the logfile /home/oraclone/error_log.txt for more information.....\"
/Installation/QAL/db/tech_st/11.1.0/appsutil/scripts/QALNEW_ct-eagorasvr1/addbctl.sh stop immediate > /home/oraclone/error_log.txt"
}
main(){
apps_down
stop_dbs
}

am able to run above two stop_apps and stop_dbs separately.But when running main funtion it hangs on stop_dbs funtion with message

"SQL*Plus: Release 11.1.0.7.0 - Production on Thu Feb 21 10:47:59 2013

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected."

Please advice

shivaa · 02-21-2013, 12:28 AM

Can you once add set -xv in your script, just below shebang, and invoke the script again? Then share the snippet of error.

Also once make following change in stop_dbs function as:

Code:

stop_dbs()
{
su - oraclone -c "
echo -e \"\t\t\t INFO :dbs are shutting.....\"
echo -e \"\t\t\t INFO : check the logfile /home/oraclone/error_log.txt for more information.....\"
/Installation/QAL/db/tech_st/11.1.0/appsutil/scripts/QALNEW_ct-eagorasvr1/addbctl.sh stop immediate > /home/oraclone/error_log.txt 2>/dev/null

}

Note: I removed ( " ) after /home/oraclone/error_log.txt

charithsrng · 02-21-2013, 01:35 AM

Quote:

Originally Posted by shivaa

Can you once add set -xv in your script, just below shebang, and invoke the script again? Then share the snippet of error.

Also once make following change in stop_dbs function as:

Code:

stop_dbs()
{
su - oraclone -c "
echo -e \"\t\t\t INFO :dbs are shutting.....\"
echo -e \"\t\t\t INFO : check the logfile /home/oraclone/error_log.txt for more information.....\"
/Installation/QAL/db/tech_st/11.1.0/appsutil/scripts/QALNEW_ct-eagorasvr1/addbctl.sh stop immediate > /home/oraclone/error_log.txt 2>/dev/null

}

Note: I removed ( " ) after /home/oraclone/error_log.txt

Thanks for your timely Rply.
I Have done below modification for my code as you mentioned and Its working fine now
may i know the reason for this issue?

/home/oraclone/error_log.txt 2>/dev/null"

shivaa · 02-21-2013, 04:42 AM

Quote:

Originally Posted by charithsrng

I Have done below modification for my code as you mentioned and Its working fine now
may i know the reason for this issue?

Glad to hear that.

It was just a problem with std. error redirection as well as echo statements. You were not quoting the echo statements properly.

However, if it has solved, please the thread as solved.