Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 03-18-2010, 03:16 AM   #1
Registered: Mar 2005
Posts: 94

Rep: Reputation: 15
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.
Old 03-18-2010, 03:33 AM   #2
LQ 5k Club
Registered: Dec 2008
Location: Tamil Nadu, India
Distribution: Debian
Posts: 8,578
Blog Entries: 31

Rep: Reputation: 1198Reputation: 1198Reputation: 1198Reputation: 1198Reputation: 1198Reputation: 1198Reputation: 1198Reputation: 1198Reputation: 1198
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
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
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.

Last edited by catkin; 03-18-2010 at 03:34 AM. Reason: is -> in


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run control script for Oracle pyroman59 Linux - Newbie 4 01-19-2010 11:28 PM
execute a unix shell script from a database trigger(oracle 10g) nayant.m Linux - Newbie 1 03-28-2008 08:54 AM
Shell script to load data to oracle database divyahm Linux - Newbie 2 11-08-2007 10:15 AM
need a script to run oracle service shipon_97 Linux - Enterprise 5 03-02-2007 08:43 AM
Auto Start Script for Oracle sikandar Linux - Software 0 09-12-2003 11:43 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:55 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration