Usernames in OEM

3 Dec 2004 12:50 AM

J Williams

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.

6 Dec 2004 3:24 PM

GQ

J Williams wrote:
Show quote

> 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.