Re: oracle 9i (9.2.0.1.0) - sql analyze login error

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 27 Feb 2004 15:30:02 +0100
Message-ID: <403f53cd$0$24924$626a14ce@news.free.fr>

"Hubert Mayr" <huma1_at_gmx.net> a écrit dans le message de news:1077876364.992762_at_news.liwest.at...
> Hi!
>
> I have a standalone oracle 9.2.0.1.0 database. Then I start sql analyze in
> oracle enterprise manager console.
> In the login box I select 'standalone repository'.
> User: sys, Password: is okay, Service: is okay.
>
> I get the following :
>
> ORA-28009: connection to sys should be as sysdba or sysoper.
>
> Who can help me?
>
> Thanks!
>
>

ORA-28009 connection to sys should be as sysdba or sysoper Cause: Connect sys/password is no longer a valid syntax. Action: Try connect sys/password as sysdba or connect sys/password as sysoper.

Starting with 9.0, sys cannot connect anymore as a normal user, it can only connect as sysdba or sysoper.

Regards
Michel Cadot Received on Fri Feb 27 2004 - 08:30:02 CST