Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Successful login via SQLPlus produces a server error
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