Another problem with startup database trigger

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Wed, 1 Nov 2000 11:02:09 -0800
Message-Id: <10667.120839@fatcity.com>

Hi!

I'm getting an error message that doesn't make much sense to me...

This is the startup db trigger that I created. The trigger is owned by SYS.

  CREATE OR REPLACE TRIGGER startup_db
  after startup on database
  begin

pin Oracle supplied packages dbms_shared_pool.keep ('SYS.STANDARD','P'); dbms_shared_pool.keep ('SYS.DBMS_STANDARD','P'); dbms_shared_pool.keep ('SYS.DIUTIL','P');
pin procedures owned by VIVO dbms_shared_pool.keep ('VIVOUSER.DT_CHECKRANGEDATE','P'); dbms_shared_pool.keep ('VIVOUSER.DT_COUNTHOUR','P'); .... and some more procedures to follow here end;

But every time, I get the following error message written to a trace file:

SESSION ID:(9.1) 2000-11-01 03:45:14.613 Error in executing triggers on database startup
2000-11-01 03:45:14.613 ksedmp: internal or fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_UTILITY", line 68 ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45 ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53 ORA-06512: at line 8

Since the trigger is owned by SYS, I don't understand why there is a privilege problem... I explicitly granted ADMINISTER DATABASE TRIGGER to SYS as well. I ran the dbmspool.sql script.

This is 8.1.6 on Win2k. Received on Wed Nov 01 2000 - 13:02:09 CST