Hi, I am in root user running a script, this script need to execute some commands in oracle user, eg: #Start of script ... (commands run in root user) ... su - oracle #change to oracle user (commands need to run in oracle user) ... ... #end of script My problem is when this script execute till the "su - oracle" it will pause at there point, when I enter "exit" then it continue to execute the next command after the "su - oracle" in root user, so how can I execute those commands in oracle user? Thanks for any help.

Remove all the commands that need to be run as oracle and place them in a different script, say called ora_commands.sh In your main script, when you get to the point where you need to run these commands, try : su oracle -c ora_commands.sh You might have to call .profile (in Korn shell) for oracle in ora_commands.sh to set the environment variables,etc

Hi cislord, Thanks, it works.

Or you can exec the application as oracle within your root script as follows: root stuff su oracle -c "xxxxxxx" su oracle -c "yyyyyyy" root stuff

Hi James, What do you means this "xxxxxxx" and "yyyyyyy" ? Can you give an example?