LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 03-18-2010, 03:16 AM   #1
inaki
Member
 
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
catkin
LQ 5k Club
 
Registered: Dec 2008
Location: Tamil Nadu, India
Distribution: Debian
Posts: 8,576
Blog Entries: 31

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

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


Reply


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


All times are GMT -5. The time now is 06:19 AM.

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