Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Successful login via SQLPlus produces a server error

Successful login via SQLPlus produces a server error

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 25 Apr 2005 10:29:27 -0700
Message-ID: <1114450167.383225.59200@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> Received on Mon Apr 25 2005 - 12:29:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US