Re: Usernames in OEM

From: GQ <dbaguy_ott_at_yahoo.com>
Date: 6 Dec 2004 07:24:36 -0800
Message-ID: <1102346676.854801.96230_at_z14g2000cwz.googlegroups.com>


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
execute
> SELECT USERNAME FROM ALL_USERS and the results contain an expected
username.
>
> However, if I open a SQL*Plus worksheet and execute CONNECT / AS
SYSDBA and
> then SELECT USERNAME FROM ALL_USERS the expected username is missing.
Why?
>
> 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