Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Only able to login as sysdba?

970992Oct 26 2012 — edited Oct 26 2012

I just installed 11g2 on Redhat 5. I logged in using sqlplus as follows:

$sqlplus sys/abcabc as sysdba

I created a user as follows:

sqlplus> create user "xyz"
profile "DEFAULT"
identified by "abcabc"
default tablespace "MYTAB"
temporary tablespace "TEMP"
account unlock;

sqlplus> grant dba to "xyz"

sqlplus> commit;

sqlplus reported user created and dba granted. No errors were repored by sqlplus.

Now when I try to login as follows:

$sqlplus xyz/abcabc

I get a login prompt again and after 3 retries, I'm kicked out.

BUT, if I login as follows:

$sqlplus xyz/abcabc as sysdba

I get logged in.

What could be the problem? I've followed the exact same procedure for creating a user many times before and it always worked. What is different this time that I need to login as sysdba?

Thanks