LinuxQuestions.org - Cannot run auto shutdown script for oracle database

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

- - Cannot run auto shutdown script for oracle database (https://www.linuxquestions.org/questions/linux-newbie-8/cannot-run-auto-shutdown-script-for-oracle-database-796216/)

Cannot run auto shutdown script for oracle database

Dear all,
The situation is like this, in order to do full backup system, i have to shutdown the oracle database. My backup software can stop the services by running the shutdown script.

But in order to shutdown the oracle database, the script must be run under oracle privilege. The conflict is our backup system which is reside under root privilege cannot run the oracle shutdown script which is needed to triggered by oracle privilege.

Then how does the oracle shutdown work during server shutdown when the shutdown script is run as root?

root can su without supplying a password so the general technique in boot/shutdown scripts is

Code:

su <appropriate user name> <service/daemon control command>

In the case of oracle, the oracle user's login customisation is required to set envars so "su -" is used and the general command becomes

Code:

su - $ORA_OWNR -c <some oracle command>

This is illustrated in the many sample oracle boot/shutdown scripts posted on the net, for example here.