Ksedmp Internal Or Fatal Error Ora-00604
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a ora-00604 error occurred at recursive sql level 1 title. You can not post a blank message. Please type your message ora-604: error occurred at recursive sql level %s and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 6 Replies ora 00604 solution Latest reply on Dec 12, 2005 5:08 PM by 274340 Database startup error message 274340 Dec 9, 2005 9:07 PM Hi Guys, When I startup my Database, I always see ora-00604 error occurred at recursive sql level 3 this error message printed in the trace file: Error in executing triggers on database startup *** 2005-12-09 11:12:42.817 ksedmp: internal or fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-12663: Services required by client not available on the server ORA-36961: Oracle OLAP is not available. ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1 ORA-06512: at line 15 Error in executing triggers on database
Ora-01882
startup *** 2005-12-09 11:12:42.869 ksedmp: internal or fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 4 I have a few questions about the above message: 1. How can I see which database startup trigger is having this error? Is there a way to determine that? 2. Is there a way I can disable all triggers that fire on database startup? (just like we can disable triggers on a table) 3. Any idea what ORA-36961: Oracle OLAP is not available. means? Thanks 12287Views Tags: none (add) This content has been marked as final. Show 6 replies 1. Re: Database startup error message 176447 Dec 9, 2005 9:22 PM (in response to 274340) You may check the dba_triggers - trigger_body for the similar contents in the error message. You also look for triggering_event for identifying startup triggers. Yes. You can disable the trigger. OLAP is an optional product for analytical processing. Ashok Like Show 0 Likes(0) Actions 2. Re: Database startup error message 274340 Dec 12, 2005 3:00 PM (
relating to ORACLE DATABASE Oracle Application Express 3.2 Oracle VirtualBox Oracle10gR2 Admin Admin Scripts Clone or Duplicate Data Guard and https://hendrydasan.wordpress.com/2011/01/24/ora-06512-at-sys-olapihistoryretention-line-1/ DR DATABASE AUDIT Datapump10g FLASHBACK Password RMAN10G Upgrade and Patching Oracle11gR2 Clone11g DB or Duplicate Database Admin Database11g Install and Configure OCM for Oracle 11GR2 Oracle Utilities Oracle11gR2 http://ora12c.blogspot.com/2012/04/dropping-user-results-in-ora-942.html Tuning RMAN11G Oracle11gR2 GRID INFRA and ASM Oracle9i SQL SERVER DATABASE SQL SERVER 2008 R2 Welcome Archives July 2013 September 2012 June 2012 February 2012 January 2012 error occurred December 2011 November 2011 September 2011 August 2011 June 2011 May 2011 April 2011 March 2011 February 2011 January 2011 December 2010 October 2010 August 2010 July 2010 June 2010 May 2010 January 2010 APEX Apex from Oracle APEX OBE Inside Oracle Apex Blogroll WordPress.com WordPress.org Christian Amazing Facts Andrew Wommack Bill Johnson Insights of error occurred at God JGLM JGLM Forum Joshua Mills KOJ KOJ BLOG KOJ YOUTUBE Mark Hankins Online Parallel Bible Sid Roth XPMEDIA GENERAL Bankwest Centrelink Citibank Australia Dept of Immigration and Citizenship E-wire usage E-wire webmail GOOGLE Google Maps Mercer Wealth Soultions - Super oziCall Paypal Pennytel - Voip Transperth Vero Insurance NEWS ABC News Australian Australian-IT BOM - Weather Reuters SMH Business Oracle Websites My Oracle Support Online Demos Oracle 12c Oracle Downloads Oracle E-Delivery Oracle Technology Network oracle-database-11g-top-features Oracle10g Online Doc Oracle11g OBE Oracle11g Online Doc Oracle10g from Oracle RMAN10g Commands Oracle11g from Oracle Oracle11g ASM SQL SERVER Websites MSSQL Tips Meta Register Log in Subscribe Entries (RSS) Comments (RSS) « ORA-38754: FLASHBACK DATABASE not started; required redo log is notavailable Move Oracle10gR2 - 10.2.0.4.0 Database from Veritas File System toJFS2 » ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line1 Posted by Hendry chinnapparaj on January 24, 2011 problem ----------- SQL> startup pfile=initTEST.ora ORACLE instance started. Total System Global Area 314572800 bytes Fixed Size 2083760 bytes Variable Size 100664
Release: 9.2 to 10.2Information in this document applies to any platform.***Checked for relevance on 13-Jan-2011*** Symptoms When attempting to drop a user, the following error may be generated SQL> DROP USER sysman CASCADE
*
ERROR at line 1:
ORA-00604: erroroccurred at recursive SQL level 1
ORA-00942: table or view does notexist
ORA-06512: at line 7 The user being dropped should notown any Oracle Spatial objects. Oracle Spatial may or may not be installed Running the "drop user" command with following trace: alter session set events '942 trace name ERRORSTACK level 3'; will show which statement is generating the error. There can be two possible SQL statements that could generate the error: ksedmp: internal or fatal error
ORA-00942: table or view does not exist
Current SQL statement for this session:
DELETE FROM SDO_GEOM_METADATA_TABLE WHERE '"'||SDO_OWNER||'"' = '"SYSMAN"' or select rowid from XDB.XDB$SCHEMA s where s.xmldata.schema_url = :1 Cause Regardless of the SQL statement generating the error, the cause is still the same. The Spatial objects were installed incorrectly and SYS or another user, other than MDSYS, owns the Spatial objects. Specifically, the Spatialtrigger,SDO_DROP_USERis causing the problem. When a user is dropped, the trigger will fire to determine if any Spatial objects are owned by that user. If the tables that the trigger needs to query are owned by the wrong user, the trigger will fail and the user will not be dropped. Solution To implement the solution, please execute the following statement: