Re: Insufficient Privileges (svrmgrl)

From: Ale¹ Køenek <ljocha_at_hiram.ics.muni.cz>
Date: Fri, 4 Sep 1998 09:50:37 GMT
Message-ID: <Eyr7CD.5Do@news.muni.cz>

|>
|> > In article <uogua3wm0.fsf_at_bigfoot.com>,
|> > roarp_at_bigfoot.com (Roar Pettersen) wrote:
|> > > We've got a couple of instances running Oracle 7.3.4 on
|> > > an SGI/IRIX workstation. Today one of the databases
|> > > had stopped (unknown for what reason), and when we tried
|> > > starting it again using svrmgrl and "connect internal",
|> > > it asked for a password. It's never done that before!?!
|> > > After trying two times, it gives the following message:
|> > >
|> > > ORA-01031: insufficient privileges
|> > >
|> >

i'm not sure whether i got exactly the same error but sometimes after a crash of oracle but not the system there are shared memory segments and semaphore sets left orphaned (at least on SGI). this seams to confuse oracle totally. just get rid of them with ipcrm unix command; instance recovery works fine then.

ales krenek Received on Fri Sep 04 1998 - 04:50:37 CDT