Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: shutdown database(s) from root user
sdg wrote:
> Ya, what Bakker said. Just listen to Bakker. Do not think for your self, do
> not question! Just do what Bakker says. Keep repeating that!
>
> Sybrand Bakker wrote:
>
> > On Thu, 29 May 2003 10:02:21 -0400, Jim Day <jday_at_fslso.com> wrote:
> >
> > >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).
> >
> > The shutdown procedure SHOULD NOT BE RUN UNDER ROOT, it should be RUN
> > UNDER Oracle. If it runs under Oracle and you still get ora-1031 you
> > have an incorrectly installed version of Oracle.
> >
> > >
> > >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.
> > >
> >
> > You should READ the advice provided, trying not to be stubborn, and
> > run the script UNDER ORACLE!
> >
> > >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
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
Dear Expert:
Rather than just playing your usual game of flaming those with experience why don't you offer up a solution for the OP.
Oh and post your credentials in terms of experience and job positions so others can evaluate the value of your advice.
I can understand it when a two year old says "No" to everything. But I'd really like to know from what extensive background of experience you find yourself in a position to critique the posts of others.
And then, most likely, back into the kill file you go.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Jun 12 2003 - 17:13:46 CDT