Re: Successful login via SQLPlus produces a server error

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 26 Apr 2005 08:38:18 +0200
Message-ID: <d4knkr$3ik$1@news.BelWue.DE>

g3000 wrote:
> 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>
>

Does this *only* happen when using SQL*PLUS, or does this also occur when using something like TOAD, PL/SQL Developer, etc.?

If this is only happening with SQL*PLUS, then maybe you have something in your login.sql/glogin.sql that calls the procedure SAMS.SAMS_USER_LIB.

HTH
Holger Received on Tue Apr 26 2005 - 01:38:18 CDT