Oracle Error Code 17069
error problem [message #345368] Wed, 03 September 2008 04:26 brijal_j_patel Messages: 28Registered: May 2007 Location: Surat,India Junior Member Hello Gurus, I face following problem in following pl/sql block in form 6i and Database 10g Ver 10.2.0.3.0, declare begin select sysdate into :t1 from dual; end; and error is : ORA-00600: internal error code, arguments: [17069],[18798616],[],[],[] When i use Database 9i, above code work without error. How to solve this problem, Please help me. Regards Brijal Report message to a moderator Re: ora-00600 [17069] error problem [message #345374 is a reply to message #345368] Wed, 03 September 2008 04:53 Littlefoot Messages: 20850Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator Try with:t1 := sysdate;or, if possible, modify t1's "Initial value" property to $$date$$ (or $$datetime$$ if you need date + time). Report message to a moderator Re: ora-00600 [17069] error problem [message #345391 is a reply to message #345368] Wed, 03 September 2008 06:02 brijal_j_patel Messages: 28Registered: May 2007 Location: Surat,India Junior Member Thank LittleFoot for your quick and perfect reply, It will solve my currenty problem, Now I have same problem in forms and reports. That means I have to change each and every forms and reports for this. It is not possible any solution without chaning code? Can you suggest why this error come? Regards Brijal Report message to a moderator Re: ora-00600 [17069] error problem [message #345414 is a reply to message #345391] Wed, 03 September 2008 08:06 Littlefoot Messages: 20850Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator Sorry, but workaround is the only help I can provide. Oracle ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. Action: Report as a bug - the first argument is the internal error number Therefore, if you'd like to know more about this bug, check Metalink. If you can't find anything helpful, open a TAR (Technical Assistance Request). Hopefully, you'll get the answer. Report message to a moderator
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 title. You can not post a blank message. Please type your message and try again. More discussions in General Database http://www.orafaq.com/forum/t/124341/ Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 4 Replies Latest reply on Apr 25, 2013 7:28 AM by KR10822864 ORA-600 [17069] error while running catrelod.sql to downgrade 11g database Bhavi Savla Apr 25, 2013 5:25 AM Hi, We are https://community.oracle.com/thread/2530939 downgrading our 11.2.0.2 database to 10.2.0.4. We have successfullly run catdwgrd.sql without any errors in 11g env. While running catrelod.sql in 10g env we are facing the following error: SQL> @?/rdbms/admin/catrelod.sql TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP RELOD__BGN 2013-04-24 20:15:39 2456407 72939 DOC>####################################################################### DOC>####################################################################### DOC> The following statement will cause an "ORA-01722: invalid number" DOC> error if the database server version is not 10.0.0. DOC> Shutdown ABORT and use a different script or a different server. DOC>####################################################################### DOC>####################################################################### DOC># no rows selected DOC>####################################################################### DOC>####################################################################### DOC> The following statement will cause an "ORA-01722: invalid number" DOC> error if the database has not been opened for MIGRATE. DOC> DOC> Perform a "SHUTDOWN ABORT" and DOC> restart using MIGRATE. DOC>####################################################################### DOC>####################################################################### DOC># no rows selected Session altered. Sessi
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora00600-internal-error-code-arguments-17069-2155784448-391902 and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware http://surachartopun.com/2010/02/ora-00600-internal-error-code-arguments.html Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View oracle error All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this oracle error code is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-00600: internal error code, arguments: [17069], [2155784448], , Unknown asked Jan 12, 2004 | Replies (1) hi gurus which burg is and how do i solve on oracle 8 Mon Jan 12 14:38:08 2004 ORrors in file /data/ims/imsprod/admin/udest/imsprod_ora_7277.trc: ORA-00600: internal error code, arguments: [17069], [2155784448], [], [], [], [], [], [] Mon Jan 12 14:44:22 2004 thank you Join this group Popular White Paper On This Topic A Beginner's Guide to VoIP 1Reply Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Unknown User replied Jan 12, 2004 The following document on metalink explains this error Doc ID: Note:39616.1 Subject: ORA-600 [17069] "Failed to pin a library cache object after 50 attempts" Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 04-JUL-1996 Last Revision Date: 11-DEC-2003 Top This thread has been
[17069] Found this error, after changed meta data on TABLES and recompiled many stored procedures.Errors in file /oracle/admin/db/udump/db1_ora_11420.trc:ORA-00600: internal error code, arguments: [17069], [0x08071B8D0], [], [], [], [], [], []In trace file.Oracle Database 10g Enterprise Edition Release 10.2.0.3.0With the Partitioning, Real Application Clusters, OLAP and Data Mining optionsORACLE_HOME = /oracle/10g...Unix process pid: 11420...ksedmp: internal or fatal errorORA-00600: internal error code, arguments: [17069], [0x08071B8D0], [], [], [], [], [], []Current SQL statement for this session:BEGIN :1 := PKG_TMP01.PRC_TMP01( :2 , :3 ); END;----- PL/SQL Call Stack -----Check PKG_TMP01 package on Database.SQL> select object_name,object_type, status from dba_objects where object_name='PKG_TMP01';OBJECT_NAME OBJECT_TYPE STATUS------------------------------ ------------------- -------PKG_TMP01 PACKAGE VALIDPKG_TMP01 PACKAGE BODY INVALIDSQL> alter package PKG_TMP01 compile body;Package body altered.But still Invalid...SQL> select object_name,object_type, status from dba_objects where object_name='PKG_TMP01';OBJECT_NAME OBJECT_TYPE STATUS------------------------------ ------------------- -------PKG_TMP01 PACKAGE VALIDPKG_TMP01 PACKAGE BODY INVALIDCheck Oracle Support report Bug 4587556 (10.2.0.3), Fixed in 10.2.0.4 (Server Patch Set),11.1.0.6 (Base Release)However, I can not patch yet, so checked Workaround: Compile packages which have a self referencing synonym explicitly from SQL before compiling any other dependant packages.But I didn't find synonym invalid status and made script to compile all:set lines 130set pages 0spool recompile.sqlselect 'alter '|| object_type||' '||owner||'.'||object_name ||' compile;' from dba_objects where status='INVALID' and object_type != 'PACKAGE BODY';select 'alter package '|| owner||'.'||object_name ||' compile body;' from dba_objects where status='INVALID' and object_type = 'PACKAGE BODY';select 'alter '|| object_type||' "'||owner||'"."'||object_name ||'" compile;' from dba_objects where status='INVALID' and object_type != 'PACKAGE BODY' and owner='PUBLIC';spool off;@recompile.sqlChecked again:SQL> select object_name,object_type, status from dba_objects where object_name='PKG_TMP01';OBJECT_NAME OBJECT_TYPE STATUS------------------------------ ------------------- -------PKG_TMP01 PACKAGE VALIDPKG_TMP01 PACKAGE BODY INVALIDPackage body status was invalid. Then got idea about this bug report.ERROR: ORA-600 [17069] [a]DESCRI