Re: Successful login via SQLPlus produces a server error

On 25 Apr 2005 11:26:05 -0700, "g3000" <carlton_gregory_at_yahoo.com> wrote:

>this is the result
>SQL> select object_name, object_type from dba_objects where
>status='INVALID';
>
>OBJECT_NAME
>------------------------------------------------------------------------------
>OBJECT_TYPE
>------------------
>MY_ALL_OBJECTS_AGGS
>MATERIALIZED VIEW
>
>SI_LIB_XML
>PACKAGE BODY
>
>
>SQL>
>
>did not have a patchset fail

The original error messages are quite clear. You are calling the procedure sams.sam_user_lib.

The procedure tries to set roles by means of the dbms_session package.
However the roles sam_user and sam_security don't exist. You need to create them and possibly grant privileges to them. The package sams is third party code, not Oracles

--
Sybrand Bakker, Senior Oracle DBA