Re: Successful login via SQLPlus produces a server error

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Mon, 25 Apr 2005 19:40:52 +0200
Message-ID: <426d2ba5$0$24161$ba620e4c@news.skynet.be>

"g3000" <carlton_gregory_at_yahoo.com> wrote in message news:1114450167.383225.59200_at_f14g2000cwb.googlegroups.com...
> When I logon to my database via SQLPlus I get an error about a PL/SQL
> package.
> I dont have a when logon trigger either.
>
> I do have a on db startup trigger ( which I dont think applies ).
>
> Any ideas? I understand what the error is just dont know why. Im loggin
> in as SYS ( DBA ).
>
> SQL*Plus: Release 9.2.0.6.0 - Production on Mon Apr 25 13:20:57 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.6.0 - Production
>
> DECLARE
> *
> ERROR at line 1:
> ORA-01924: role 'SAMS_BASE' not granted or does not exist
> ORA-06512: at "SYS.DBMS_SESSION", line 120
> ORA-06512: at "SAMS.SAMS_USER_LIB", line 66
> ORA-01924: role 'SAMS_SECURITY' not granted or does not exist
> ORA-06512: at "SAMS.SAMS_USER_LIB", line 219
> ORA-06512: at line 4
>
>
> SQL>
>

Did you try to install a patchset and did it fail (for example because SYSTEM tablespace was full) ?
What's the result of : SELECT count(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID'; ? Matthias Received on Mon Apr 25 2005 - 12:40:52 CDT