Error In Executing Triggers On Database Startup
Contents |
doesn't make much sense to me...This is the startup db trigger that I created. The trigger olap startup trigger is owned by SYS.CREATE OR REPLACE TRIGGER startup_dbafter startup on
Error In Executing Triggers On Connect Internal
databasebeginpin Oracle supplied packagesdbms_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 VIVOdbms_shared_pool.keep ('VIVOUSER.DT_CHECKRANGEDATE','P');dbms_shared_pool.keep ('VIVOUSER.DT_COUNTHOUR','P');.... and some more procedures to follow hereend;But every time, I get the following error message written to a trace file:SESSION ID:(9.1) 2000-11-01 03:45:14.613Error in executing triggers on database startup2000-11-01 03:45:14.613ksedmp: internal or fatal errorORA-00604: error occurred at recursive SQL level 1ORA-01031: insufficient privilegesORA-06512: at "SYS.DBMS_UTILITY", line 68ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53ORA-06512: at line 8Since the trigger is owned by SYS, I don't understand why there is aprivilege problem... I explicitly granted ADMINISTER DATABASE TRIGGER to SYSas well. I ran the dbmspool.sql script.This is 8.1.6 on Win2k. reply Tweet Search Discussions Search All Groups oracle-l 1 response Oldest Nested Paquette stephane The owner of the trigger must have the execute right on the procedures/functions that are called from the trigger. The vivouser must grant execute on the 2 procdures to sys. Helmut Daiminger a écrit : > Hi! Stephane Paquette DBA Oracle stephane_paquette_at_yahoo.com Paquette stephane at Nov 2, 2000 at 8:25 am ⇧ The owner of the trigger must have the execute righton the procedures/functions that are called from thetrigger. The vivouser must grant execute on the 2procdures to sys.Helmut Daiminger aécrit: > Hi!I'm getting an error message that doesn't make muchsense to me...This is the startup db trigger that I created. Thetrigger is owned by SYS.CREATE OR REPLACE TRIGGER startup_dbafter startup on databasebegin-- pin Oracle supplied packagesdbms_shared_pool.keep ('SYS.STANDARD','P');dbms_shared_pool.keep('SYS.
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > ORA-00604 error while opening the database Want to Advertise Here? Solved ORA-00604 error while opening the database Posted on 2004-10-13 Oracle Database 2 Verified Solutions 15 Comments 11,144 http://grokbase.com/t/freelists.org/oracle-l/00b19msc79/another-problem-with-startup-database-trigger Views Last Modified: 2011-08-18 Hi, When i try to start a database, system throws the ORA-00604 error but still it opens the database and iam able to work on that database only for few minutes , after that the iam getting the following message ORA-12500: TNS:listener failed to start a dedicated server process and when i checked the alert log and trace https://www.experts-exchange.com/questions/21166274/ORA-00604-error-while-opening-the-database.html file, it shows ORA-00604 error. Find below the contents of alert log and the trace file. Server process System parameters with non-default values: processes = 59 shared_pool_size = 262144000 large_pool_size = 614400 control_files = e:\ORANEW\oradata\FCIS45\control01.ctl, e:\ORANEW\oradata\FCIS45\control02.ctl, e:\ORANEW\oradata\FCIS45\control03.ctl db_block_buffers = 25600 db_block_size = 8192 compatible = 8.1.0 log_buffer = 10485760 log_checkpoint_interval = 10000 log_checkpoint_timeout = 1800 db_files = 1024 db_file_multiblock_read_count= 8 rollback_segments = RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 max_enabled_roles = 30 remote_login_passwordfile= EXCLUSIVE global_names = FALSE distributed_transactions = 10 instance_name = FCIS45 service_names = FCIS45 open_links
is not pinning http://www.orafaq.com/maillist/oracle-l/2001/02/07/0793.htm all packages From: Elliott, Patrick