Internal Heap Error 17147
FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: need help Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-02-08,19:33 #1 mnor View Profile View Forum Posts Registered User Join Date Sep 2008 Posts 10 Unanswered: need help I have a problem with my oracle database. suddenly shutdown immediate.. when i go through alert_database.log, then i got errors which is mentioned in financial_s000_27287.trc and financial_pmon_11637.trc..The error in file financial_s000_27287.trc as below Redo thread mounted by this instance: 1 Oracle process number: 10 Unix process pid: 27287, image: financial@esaga (S000) *** 2008-12-02 13:30:44.303 *** SESSION ID429.41202) 2008-12-02 13:30:44.302 Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf *** 2008-12-02 13:31:05.158 Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf *** SESSION ID563.16228) 2008-12-02 13:31:11.618 Internal Error 3113 occured in qmf *** SESSION ID429.41202) 2008-12-02 13:31:11.630 Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf *** SESSION ID563.16228) 2008-12-02 13:31:16.269 Internal Error 3113 occured in qmf Internal Error 3113 occured in qmf *** SESSION ID429.41202) 2008-12-02 13:31:16.306 ********** Internal heap ERROR 17114 addr=3c9fee5f8 ********* ***** Dump of memory around addr 3c9fee5f8: 3C9FEE3F0 58585858 58585858 [XXXXXXXX] . . . word xsoqsqlusebindvariables_ [10374A270, 10374A274) = 00000350 word xsoqsql
Fundamentals Oracle Errors Performance Tuning ASM Datafiles & Tablespaces Exadata ORA-00600: internal error code, arguments: [17074] Bug 9795214 - Library Cache Memory Corruption / OERI[17074] may result in Instance crash [ID 9795214.8] I have Oracle 11.2.0.1 Enterprise Edition Installed on Red Hat Enterprise Linux Server release 5.4 (Tikanga) 64 bit machine. It's my production environment. Suddenly Database goes down, In alert log files "ORA-00600: internal error code, arguments: [17074]" message was written. Error message is like: Errors in file /test01/diag/rdbms/test01/test01/trace/test01_mman_27018.trc (incident=211313): http://www.dbforums.com/showthread.php?1636069-need-help ORA-00600: internal error code, arguments: [17074], [0x75F3F9FD0], [0x7AC0E9C80], [6], [], [], [], [], [], [], [], [] Incident details in: /test01/diag/rdbms/test01/test01/incident/incdir_211313/test01_mman_27018_i211313.trc Errors in file /test01/diag/rdbms/test01/test01/trace/test01_mman_27018.trc: ORA-00600: internal error code, arguments: [17074], [0x75F3F9FD0], [0x7AC0E9C80], [6], [], [], [], [], [], [], [], [] MMAN (ospid: 27018): terminating the instance due to error 822 Instance terminated by MMAN, pid http://www.dbas-oracle.com/2011/06/ora-00600-internal-error-code-arguments.html = 27018 On investigation i found this bug ........ This note gives a brief overview of bug 9795214. Affects: Product (Component)Oracle Server (Rdbms) Range of versions believed to be affected Versions >= 11.1 but BELOW 12.1 Versions confirmed as being affected 11.2.0.2 11.2.0.1 11.1.0.7 Platforms affectedGeneric (all / most platforms affected) Fixed: This issue is fixed in 12.1 (Future Release) 11.1.0.7.7 Patch Set Update 11.2.0.1 Patch 8 on Windows Platforms 11.1.0.7 Patch 38 on Windows Platforms Symptoms: Related To: Instance May Crash Memory Corruption Mutex Contention ORA-822 ORA-600 [17074] ORA-600 [kglhpd-bad-free] Dump in or under KGHISPIR (None Specified) Description ORA-600 [17074] may occur in some rare circumstances, potentially causing an instance crash From 11g onwards library cache latches are replaced by the mutex (short for mutual exclusion) concurrent programming algorithm. This issue is a mutex race condition where conflicting updates on a library cache memory chunk result in ORA-600 [17074]. This issue is intermittent and rare due to the precise timing required for the contending memory chunk access. Th
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 https://community.oracle.com/thread/2483470?start=15&tstart=0 a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 26 Replies Latest reply on Jan 3, 2013 7:37 AM by 982598 Go to original post This content has been marked as final. Show 26 replies 15. Re: memory optimization question JohnWatson Jan 2, 2013 9:32 AM (in response internal heap to 979666) With errors such as this, the most likely solution is to apply a patch. As you are using 9.2.0.6, at the very least you should apply the 9.2.0.8 patchset. But you can't do that unless you have paid for some sort of extended support contract. Otherwise, there is probably no solution - unless you can find out whatever workaround your DBA was using. Like Show internal heap error 0 Likes(0) Actions 16. Re: memory optimization question moreajays Jan 2, 2013 9:42 AM (in response to 979666) Hi, Unfortunately it can not be downloadable or support in you 9i DB. AWR is newly added feature in 10g(Onwards) To know more about stats pack memory advisories refer http://www.pafumi.net/Statspack_Analysis.html Thanks, Ajay More http://moreajays.blogspot.com Like Show 0 Likes(0) Actions 17. Re: memory optimization question 979666 Jan 2, 2013 9:55 AM (in response to JohnWatson) Hi JohnWatson, So does that mean error like these are definitely not caused by any unsuitable parameters settings in the system, such as short of memory in the SGA etc? Thanks Like Show 0 Likes(0) Actions 18. Re: memory optimization question 979666 Jan 2, 2013 9:57 AM (in response to moreajays) Hi Ajay, I see. ok. Like Show 0 Likes(0) Actions 19. Re: memory optimization question JohnWatson Jan 2, 2013 10:02 AM (in response to 979666) 976663 wrote: Hi JohnWatson, So does that mean error like these are definitely not caused by any unsuitable parameters settings in the system, such as short of memory in the SGA etc? ThanksThat would be my opinion. You need to tell your boss to buy a support contract and then you c