Re: Usernames in OEM
Date: 6 Dec 2004 07:24:36 -0800
J Williams wrote:
> I would appreciate an explanation of what I'm doing wrong and any
> misunderstandings for the following.
> In OEM I connect to a database as SYSDBA, open SQL scratchpad and
> SELECT USERNAME FROM ALL_USERS and the results contain an expected
> However, if I open a SQL*Plus worksheet and execute CONNECT / AS
> then SELECT USERNAME FROM ALL_USERS the expected username is missing.
> And why is the CONNECT / AS SYSDBA command necessary (I get a
> connected' error otherwise) if I have already connected to the
> the OEM connect login window?
> Thanks for any help.
Just to confirm your environment setting, could you do a 'Select * from v$database;' and a 'show user' in both instances. Received on Mon Dec 06 2004 - 16:24:36 CET