Re: shutdown database(s) from root user

On Wed, 28 May 2003 18:43:23 -0400, Jim Day <jday_at_fslso.com> wrote:

>I'm running Oracle 8.1.7 on Solaris 8.
>
>I have a UPS vendor supplied script that can be used to shutdown the
>system. This script can be customized, but currently it is setup to
>just send a message to everyone and then perform an "/etc/shutdown". I
>want to shutdown my databases before it starts the OS shutdown, but
>the daemon that is watching to see if it gets a message from the UPS
>is running under root. My database is normally shutdown using scripts
>I wrote running from the oracle user. This database shutdown script
>just runs like this:
>
>sqlplus internal <<EOF
>shutdown immediate
>exit
>EOF
>
>Since I normally run these from the oracle user, this script does not
>prompt me for a password when it uses the user internal. But, since
>this UPS shutdown script is executed from the daemon running under
>root, these database shutdown scripts don't work. I've tried to su to
>oracle but that doesn't work either (prompts me for a password).
>
>I must be missing something "obvious" here, but can't seem to get this
>to work. Does anyone know how I can run sqlplus from root, login with
>a username and then run the -shutdown immediate- command to shutdown
>my database?
>
>Thank-you for your help.
>
>Jim Day
>jday_at_fslso.com

Just stop hacking and use
su - oracle -c <name of the shutdown script of the oracle user>

Geeezzz

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu May 29 2003 - 00:14:58 CDT