Script not executing as root.

[Chirag Parekh]

I am getting this error message while trying to execute a script from within another script as root.

ksh: /usr/local/bin/alltohold.ksh: cannot execute

The alltohold.ksh is owned by root and below are the permissions. The root's default shell is /sbin/sh

-rwx------ 1 root sys 3560 Apr 22 01:10 alltohold.ksh

Any idea why this is not executing. Also this was working fine in the past.

Thanks.

[Geoff Wild]

Are both scripts ksh?

#!/bin/ksh

How are you calling it?

Rgds...Geoff

[Chirag Parekh]

both scripts are ksh and the script is called from another script as follows:

su oracle -c $BIN/alltohold.ksh

Thanks.

[Denver Osborn · Accepted solution]

"su oracle -c $BIN/alltohold.ksh"

The script is running as the oracle user not as root. Give oracle execute permission to resolve.

-denver

[Geoff Wild]

There's your answer - oracle does NOT have access to the file.

Rgds...Geoff

[Paul_481]

Hi,

By running your script like this:

su oracle -c $BIN/alltohold.ksh

The user oracle is the one that execute the script, give the user oracle the permission to run the script or change the script ownership to oracle.

Regards,
Paul

[Cem Tugrul]

Hi,
try to give oracle user permision to execute
this script.
good luck,

[Geoff Wild]

BTW - don't know if it was intentional or not - but if you

su oracle
- you won't source oracle's profile - to do so, you need to

su - oracle

Rgds..Geoff

[Chirag Parekh]

Thanks for all the responses. I have changed the permission on the file so that Oracle can execute it.

[Chirag Parekh]

Changed the permission on the script so that Oracle can execute it.