Re: Usernames in OEM

From: GQ <>
Date: 6 Dec 2004 07:24:36 -0800
Message-ID: <>

J Williams wrote:
> Hi,
> 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
'SP2-0640: Not
> connected' error otherwise) if I have already connected to the
database via
> 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

Original text of this message