0 Replies Latest reply on Dec 2, 2005 6:15 PM by 274340

    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.