Re: ORA-28009

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 15 Oct 2001 18:40:20 +0200
Message-ID: <tsmksop6jptl0f@corp.supernews.com>

"Stan Brown" <stanb_at_panix.com> wrote in message news:9qeums$gne$1_at_panix3.panix.com...
> I installed 9i on a Linux box this weekend, and I thought I had everything
> right. However when I tryied to log in as "SYS" this morning, I got:
>
> ORA-28009: Conection to sys should be as sysdba or sysoper
>
> I can log in as "system" with no proble.
>
> Have I got a groups problem? Doesnit matter?
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin

Your user SYS doesn't have SYSDBA or SYSOPER privilege. Please verify either
a) whether you are a member of the dba group on Unix or the OSDBA group on NT
b) the remote_login_passwordfile parameter is either none or shared.

You connected using SYSTEM *without* SYSDBA or SYSOPER privilege.

Hth,

Sybrand Bakker,

Senior Oracle DBA Received on Mon Oct 15 2001 - 11:40:20 CDT