7 Replies Latest reply: Dec 16, 2005 12:55 PM by Michel SALAIS RSS

    SQLPLUS login as SYSDBA

      Hi Guys,
      When I try to login as SYS, oracle complains that I should connect as SYSDBA or SYSOPER. Fine. Now I enter the login user as SYSDBA and enter the password..it fails. However, if I login as user scott and password tiger, I can login. Then from the SQL prompt I do:
      connect SYS/<password> as SYSDBA;

      and it works. So my question is, when I use the same <password> as login prompt and user as SYSDBA or SYSOPER, why does that fail and how can I change to make that work directly without loggin in as some other user and then manually change to SYS.