Re: shutdown database(s) from root user

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 29 May 2003 14:49:05 -0700
Message-ID: <92eeeff0.0305291349.159fd954@posting.google.com>

Jim Day <jday_at_fslso.com> wrote in message news:<jd2cdvk2hb3dhgpd0e2g63s8pp2hrepq3o_at_4ax.com>...
> Thanks to everyone for the suggestions.
>
> I guess I didn't explain well enough, but I was trying to "su -
> oracle" in the vendor supplied OS shutdown script but it kept asking
> for a password. Well after further investigation, the su is working as
> everyone suggested and the script is switched to the oracle user. But
> when this OS shutdown script gets to the part that I modified (execute
> my script to shutdown a database) I get
>
> Enter password:
> ERROR:
> ORA-01031: insufficient privileges
>
> So, it appears that the SQLPLUS is wanting a password. As I mentioned
> in my initial post, the script I use to shutdown this database (while
> logged in as oracle) is as follows (this is not the entire script, but
> just the sqlplus part):
>
> sqlplus internal <<EOF
> shutdown immediate
> exit
> EOF
>
> When I run my database shutdown script manually or from another script
> while logged in as oracle, it does not ask for a password and my
> understanding of using internal is that you didn't have to provide a
> password as long as you were running this from the oracle user. But,
> as you can see, it is asking for a password when I try running my
> database shutdown script from within the script that is used to
> shutdown the OS.
>
> So,
>
> 1) why is it asking for a password? Is there some issue with the su
> not making sqlplus happy with respect to the use of "internal", or is
> there an issue with the use of the <<EOF in the sqlplus statement?
> (this is how I learned to do things like this in shell scripts).
>
> 2) Should I be using a different username (to sqlplus) when shutting
> down the database?...and if so, is there a preferred way to specify
> the user/password in a script when starting sqlplus? -- I was taught
> not to put user/password on the sqlplus command line as that would be
> viewable by anyone on the system running a ps command.
>
> I know this may seem very elementary to many of you and I admit I may
> be overlooking something "everyone else knows", but here I am.
>
> Many thanks!
>
> Jim

Here is a sample shutdown/startup script for 9i. You can modify it.

#!/bin/sh

# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
# Script assumes you have the SID entry in /var/opt/oracle/oratab or

/etc/oratab file set to Y.

#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

ORA_HOME=/u01/app/oracle/product/9.2.0.1.0 ORA_OWNER=oracle

case "$1" in

	’start’)
	# Start the Oracle databases:
	# The following command assumes that the oracle login
	# will not prompt the user for any values

	su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
	;;

	’stop’)
	# Stop the Oracle databases:
	# The following command assumes that the oracle login
	# will not prompt the user for any values

	su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
	;;

esac

Regards
/Rauf Sarwar Received on Thu May 29 2003 - 16:49:05 CDT