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: OEM Console on XP / Connect to 10gR2 server - insufficient privileges

Re: OEM Console on XP / Connect to 10gR2 server - insufficient privileges

From: Preston <dontwantany_at_nowhere.invalid>
Date: Wed, 05 Dec 2007 11:14:34 GMT
Message-ID: <uKv5j.3588$jy3.447@newsfe7-win.ntli.net>


jeremy wrote:

> On 5 Dec, 10:32, "Preston" <dontwant..._at_nowhere.invalid> wrote:
> >
> > When you connect 'as sysdba', you're actually connecting as sys,
> > regardless of which userid you use. So there shouldn't be a need to
> > use system as sysdba. Does it work ok if you use another user with
> > dba privileges?
> >
> > As to what's causing the error, no idea, unless someone's removed
> > the dba role from system.
>
> Hi Preston
>
> The reason I was using the "as sysdba" option was to see if it would
> provide some extra options - e.g. the "locks" option doesn't appear to
> be enabled logged in as "Normal" (even under user system).
>
> E.g. click on Instance in the navigator on the left of the screen and
> to the right it displays a panel of info titled "Instance management"
> one of the options on which is "Monitor locks, sessions...." -
> clicking on the word "locks" should display (well in 9i OEM console) a
> list of the locks. The "locks" option is also not present in the
> navigator (and was in the 9i version).

The 'locks' & 'sessions' links on the Instance page don't seem to work no matter who you login as. I /think/ it shows locks on the individual session details pages, but only when there is one. I don't use the client EM though so don't quote me on that.

-- 
Preston.
Received on Wed Dec 05 2007 - 05:14:34 CST

Original text of this message

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