Re: SHUTDOWN insufficient priviledges

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 7 Dec 2000 22:55:03 +0100
Message-ID: <90p7k2$2059v$3@ID-62141.news.dfncis.de>

"Matt Gross" <m_gross_at_NOSPAMhotmail.com> wrote in message news:t2vhgebpfqtnef_at_corp.supernews.com...
> what exactly does CONNECT INTERNAL do? Will I have to type this everytime
> that I want to shutdown?
>
> thanks,
>
> Matt
> "Roger Lussi" <rlussi_at_a-f.ch> wrote in message
> news:3A2F3EB4.38979C85_at_a-f.ch...
> > Before you type SHUTDOWN IMMEDIATE, try
> >
> > CONNECT INTERNAL;
> >
> > greetings roger
> >
> > Matt Gross schrieb:
> >
> > > Hi,
> > >
> > > I'm having trouble shutting down a database. I can log in as the
oracle
> > > user (with oinstall, sysdba, and sysoper usergroup) to a particular
> > > database, but cannot shut the thing down. When I type
> > >
> > > SHUTDOWN IMMEDIATE;
> > >
> > > I get:
> > >
> > > ORA-01031: insufficient privileges
> > >
> > > does anyone know why?
> > >
> > > THanks,
> > >
> > > Matt
> >
>
>

Connect internal connects to the instance without requiring the database to be up.
If typing those 16 keystrokes (the ; is unnecessary) is too much trouble, use the dbshut script, or develop a korn shell function and include it in your .profile.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Dec 07 2000 - 15:55:03 CST