I am executing a script as root user which needs to do something as oracle user.
So I have following in my script:
#!/bin/sh
..........
..........
su - oracle -c "export ORACLE_SID=MYSID; cd /global/home/orasql/$ORACLE_SID; ./doSomething.sh"
if [ $? -ne 0 ]; then
echo "Error running doSomething.sh"
fi
If doSomething.sh returns an error, my echo stmt does not execute (maybe because su succeeds). How do I make it execute? Thanks.