Database Error 604 D
Contents |
on OracleWhere is this place located?All Places SAP on Oracle 13 Replies Latest reply: Jan 20, 2010 8:35 AM by Sek Yao Ooi Tweet Database error 604 at INS when accessing table ALCLASTOOL Sek Yao ora-604 error occurred at recursive sql level %s Ooi Nov 3, 2009 3:04 AM Currently Being Moderated Hi all,Recently, I've
Ora-00604 Error Occurred At Recursive Sql Level
been getting this error message in my (DEV) SAP's system log (interval of 30min).Database error 604 at INS access
Ora-00604 Error Occurred At Recursive Sql Level 3
to table ALCLASTOOL> ORA-00604: error occurred at recursive SQL level 1#ORA-01013> user requested cancel of current operationRun-time error "DBIF_RSQL_SQL_ERROR" occurred> Short dump "091103 094439 sapdev_D EV_00 " generatedI'm not sure how to
Ora-00604 Solution
trace the table ALCASTOOL or how to solve this problem. The solution I've tried so far:1. check dataspace and extend files that has reach >90% usage.2. check if any background job running that have failed.3. restarted the Oracle Database and Operation system (windows 2003)Anyone have any idea on this issue or how I can debug deeper to the problem I'm facing?Thank you 6275Views ora-01882 Re: Database error 604 at INS when accessing table ALCLASTOOL Anindya Bose Nov 3, 2009 3:31 AM (in response to Sek Yao Ooi) Currently Being Moderated Hi SekWhat is the value of parameter rdisp/max_wprun_time ? 30 minutes? If yes , can you please increase the value?Please also check https://service.sap.com/sap/support/notes/618861 if you havent already.RegardsAnindya Alert Moderator Like (0) Re: Database error 604 at INS when accessing table ALCLASTOOL Sek Yao Ooi Nov 3, 2009 3:39 AM (in response to Anindya Bose) Currently Being Moderated Hi Anindya,Forgot to mention, I've made changes to the parameter "rdisp/max_wprun_time" from 600sec (ori) to 1200secJust to be save, I've increase it again from 1200sec to 6000sec Thanks Edited by: Sek Yao Ooi on Nov 3, 2009 3:38 AM Alert Moderator Like (0) Re: Database error 604 at INS when accessing table ALCLASTOOL Anindya Bose Nov 3, 2009 3:43 AM (in response to Sek Yao Ooi) Currently Being Moderated Ok..Let's wait for the results then. By the way, how many instances you have?What is your oracle and OS version?can you also provide details of the runtime error from ST22? Alert Moderator Like (0)
Topic Database design Database Admin View All Cloud infrastructure Availability Backup and recovery Export, import and migration Installation, upgrades and patches Oracle performance ora-00604: error occurred at recursive sql level 1 ora-00942: table or view does not exist problems and tuning Oracle security Oracle DBA tools ora 00604 error occurred at recursive sql level 1 ora 01000 maximum open cursors exceeded Error messages MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business ora 00604 oracle sql developer performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data https://scn.sap.com/thread/1519823 Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL http://searchoracle.techtarget.com/answer/Getting-ORA-00604-error-when-connecting-to-database-user database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applicati
Control Data Guard Grid Control Performance RAC RMAN Security UKOUG VLDB War Stories Perl Public Appearances RAC Book solaris Uncategorized Archives September 2016 August 2016 July 2016 June 2016 May 2016 November https://martincarstenbach.wordpress.com/2010/04/28/ora-604-when-starting-the-database/ 2015 October 2015 August 2015 July 2015 June 2015 May 2015 April 2015 March 2015 https://forums.netiq.com/archive/index.php/t-51057.html February 2015 January 2015 December 2014 November 2014 October 2014 September 2014 August 2014 July 2014 June 2014 May 2014 April 2014 March 2014 February 2014 January 2014 December 2013 November 2013 September 2013 August 2013 July 2013 June 2013 May 2013 April 2013 March 2013 January 2013 December 2012 August 2012 July 2012 June 2012 May 2012 April error occurred 2012 March 2012 February 2012 January 2012 December 2011 November 2011 October 2011 September 2011 August 2011 July 2011 June 2011 May 2011 April 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October 2010 September 2010 August 2010 June 2010 May 2010 April 2010 March 2010 February 2010 January 2010 December 2009 November 2009 October 2009 September 2009 Blogroll Andy Colvin Cary Millsap Christian Antognini Craig Shallahamer Frits Hoogland James Morle Jason error occurred at Arneil Jonathan Lewis Kerry Osborne Kevin Closson Luca Canali Oracle's Optimiser blog Richard Foote Roger MacNicol Tanel Poder I am speaking… Email Subscription Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 3,398 other followers Copyright All content is © Martin Bach and "Martin's Blog", 2009-2016. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Martin Bach and "Martin's Blog" with appropriate and specific direction to the original content. Content is provided "as-is" without guarantee or warranty that it works-if you find an article useful, test first! Subscribe Entries (RSS) Comments (RSS) « Applying PSU 11.2.0.1.1 to RDBMShome Applying PSU 11.2.0.1.1 to Grid Infrastructure &RDBMS » ORA-604 when starting thedatabase Posted by Martin Bach on April 28, 2010 Interesting scenario this morning with a development database. There is no specific monitoring in place for development systems so a user phoned us up stating that the database was inaccessible. The last lines in the alert.log showed a problem with a datafile not readable: Wed Apr 28 10:18:08 2010 Errors in file /u01/app/oracle/admin/devone/bdump/devone_pmon_3416.trc: ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2:
to the DB ronaldteng10-Jun-2014, 04:02Hi All, I'm currently experiencing a connectivity issue whereby the Oracle driver is unable to connect to the DB. The error that I got is: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: invalid or unknown NLS parameter value specified Some information on the DB is as below: Oracle DB Version: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production NLS_LANGUAGE: AMERICAN NLS_TERRITORY: AMERICA NLS_CHARACTERSET: US7ASCII The driver trace is as below: [06/10/14 10:54:25.789]:ORACLE_TO_IDV-IDV PT:Connecting to database... [06/10/14 10:54:25.790]:ORACLE_TO_IDV-IDV PT:BEGIN Open connection 'dedicated0'. [06/10/14 10:54:25.791]:ORACLE_TO_IDV-IDV PT: BEGIN Instantiate connection. [06/10/14 10:54:25.792]:ORACLE_TO_IDV-IDV PT: CALLING DriverManager.getConnection(String, String, String) [06/10/14 10:54:25.794]:ORACLE_TO_IDV-IDV PT: WITH PARAM 1: jdbc:oracle:thin:@192.168.1.1:1521:HRMSDEVT [06/10/14 10:54:25.796]:ORACLE_TO_IDV-IDV PT: WITH PARAM 2: IDM [06/10/14 10:54:25.797]:ORACLE_TO_IDV-IDV PT: WITH PARAM 3: [06/10/14 10:54:25.855]:ORACLE_TO_IDV-IDV PT:END Open connection. [06/10/14 10:54:25.856]:ORACLE_TO_IDV-IDV PT:BEGIN Close connection 'dedicated0'. [06/10/14 10:54:25.857]:ORACLE_TO_IDV-IDV PT: Connection implementation already closed. [06/10/14 10:54:25.859]:ORACLE_TO_IDV-IDV PT:END Close connection. [06/10/14 10:54:25.860]:ORACLE_TO_IDV-IDV PT:Receiving DOM document from application. [06/10/14 10:54:25.862]:ORACLE_TO_IDV-IDV PT: