Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: shutdown database(s) from root user

Re: shutdown database(s) from root user

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Thu, 12 Jun 2003 15:13:46 -0700
Message-ID: <3EE8FB1A.E1D80C7A@exxesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US