Usernames in OEM

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

[GQ]

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.