Ora-00600 Internal Error Code Arguments 784
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 ora 00600 error it enabled. Please turn JavaScript back on and reload
Ora-600 Lookup Tool
this page. More documents in OTN Summit Database Replay Library All PlacesOTN Summit Database ora 00600 internal error code arguments rwoirw check ret val Replay Library Currently Being Moderated How to fix ORA-00600: internal error code Version 1 Created by BCG14 on Jul 28, 2016 8:33 PM. Last ora-00600 internal error code solution modified by BCG14 on Jul 28, 2016 8:33 PM. How to fix ORA-00600: internal error code, arguments: kcratr_nab_less_than_odrError and How to troubleshoot it: ___ SQL> startup;ORACLE instance started.Total System Global Area 1603411968 bytesFixed Size 2213776 bytesVariable Size 402655344 bytesDatabase Buffers 1191182336 bytesRedo Buffers 7360512 bytesDatabase mounted.ORA-00600: internal error
Ora 00600 Internal Error Code Arguments 2141
code, arguments: [kcratr_nab_less_than_odr], [1],[8], [584], [593], [], [], [], [], [], [], []___Steps to fix. sql > startup mount;select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT';MEMBER-------------------------------------------------------------------------------- GROUP# STATUS---------- ----------------/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_bhkyvzjv_.log2 CURRENT/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_bhkyvzng_.log2 CURRENT_____recover database using backup controlfile until cancel;ORA-00279: change 1117415 generated at 03/07/2015 15:09:02 needed for thread 1ORA-00289: suggestion :/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2015_04_14/o1_mf_1_8_%u_.arcORA-00280: change 1117415 for thread 1 is in sequence #8____Specify log: {
Tue, 25 June 2002 07:37 Vladimir Grams Messages: 5Registered: June 2002 Junior Member I received a lot of messages errors with this ORA-00600 errors code, it is not in particular situation, some traces files show things like this: ora-7445 UNPINNED RECREATABLE CHUNKS (lru first): PERMANENT CHUNKS: Chunk 9663f3c sz= 4252 perm "perm " ora 00600 internal error code arguments 4194 alo=112 Chunk 947f0f0 sz= 112 perm "perm " alo=112 Chunk 947c794 sz= 4212 perm "perm " alo=4212 Chunk 9478504 sz= 112
Ora 00600 Internal Error Code Arguments Kdsgrp1
perm "perm " alo=112 Chunk 94763bc sz= 4212 perm "perm " alo=4212 Chunk 946ffe4 sz= 6492 perm "perm " alo=6492 Chunk 946fc5c sz= 752 perm "perm " alo=752 Chunk 9465518 sz= 1016 perm "perm https://community.oracle.com/docs/DOC-1003662 " alo=1000 Chunk 946de9c sz= 7616 perm "perm " alo=7616 Chunk 9464d0c sz= 2060 perm "perm " alo=2060 Permanent space = 30836 ****************************************************** Hla: 0 *** 2002-03-15 15:20:15.600 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [[17112]], [[155783964]], [[]], [[]], [[]], [[]], [[]], [[]] Current SQL information unavailable - no session. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means http://www.orafaq.com/forum/t/18437/ dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+179 ? ksedst 0 ksfdmp()+14 ? ksedmp 3 kgeriv()+216 ? ksfdmp 941E5A0 3 kgesiv()+87 ? kgeriv 941E5A0 0 42D8 1 8047358 kgesic1()+33 ? kgesiv 941E5A0 0 42D8 1 8047358 kgherror()+861 ? kgesic1 941E5A0 0 42D8 0 949131C kghfre()+442 ? kgherror 941E5A0 941E474 42D8 949131C kghfrh()+541 ? kghfre 941E5A0 941E474 9465998 72000 94659A0 psitrp()+545 ? kghfrh 941E5A0 9465978 kkxpfr()+9 ? psitrp 941E5A0 ksmdpg()+90 ? kkxpfr 0 8047568 8116715 941E614 opidcl()+520 ? ksmdpg 941E614 0 94216E0 3C opidrv()+1546 ? opidcl 94216E0 0 sou2o()+25 ? opidrv 3C 4 80477E4 main()+187 ? sou2o 80477F4 3C 4 80477E4 _start()+92 ? main 2 804795C 8047968 ----- Argument/Register Address Dump ----- ******************************************************* UNPINNED RECREATABLE CHUNKS (lru first): PERMANENT CHUNKS: Chunk 957cd8c sz= 11592 perm "perm " alo=8600 Chunk 9494f0c sz= 112 perm "perm " alo=112 Chunk 947ecb0 sz= 112 perm "perm " alo=112 Chunk 947c354 sz= 4212 perm "perm " alo=4212 Chunk 94780c4 sz= 112 perm "perm " alo=112 Chunk 9475f7c sz= 4212 perm "perm " alo=4212 Chunk 946fba4 sz= 6492 perm "perm " alo=6492 Chunk 946f81c sz= 752 perm "perm " alo=752 Chunk 9465518 sz= 1016 perm "perm " alo=1000 Chunk 946da5c sz= 7616 perm "perm " alo=7616 Chunk 9464d0c sz= 2060 perm "perm " al
浏览: 分享到:微信新浪微博腾讯微博人人网QQ空间有道云笔记豆瓣网 2008/03/14skate 相应的版本: os: (cent os)Linux movo2u 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:30:39 EST 2005 i686 i686 i386 GNU nux db: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [] 4000开头的600错误大多数都和回滚段有关 今天早晨发现应用程序无法登录,返回给前端应用程序的错误是: OERR: ORA-12519 TNS:no appropriate service handler found 这个错误前几天遇到过,推断是连接数太多, select count(*) from v$process;select * from v$process;select name,value from v$parameter where name = 'processes';select * from v$license 当我用下面的命令生成的命令: select 'alter system kill session '''||s.SID||','||s.SERIAL#||''';' from v$session s where s.USERNAME='USERNAME'; 删除用户会话,前端程序就不提示错误了.但由于程序的问题,这种删除会话只是暂时的,一会会话数量又上来了有的时候我通过sql developer都登录不上去,而我用通过ssh登录服务器, 通过sqlplus登录,依旧提示超出连接数,我于是和开发人员沟通,重启自应用服务. 我登录数据库: 我在查日志的时候发现: alter.log: Fri Mar 14 11:47:15 2008Errors in file /home/oracle/admin/omovo/udump/omovo_ora_31788.trc:ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []Fri Mar 14 11:47:23 2008Errors in file /home/oracle/admin/omovo/udump/omovo_ora_31720.trc:ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []Fri Mar 14 11:47:34 2008 /home/oracle/admin/omovo/udump/omovo_ora_31788.trc: ----------------------------------------------*** 2008-03-14 11:32:45.614ksedmp: internal or fatal errorORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []Current SQL statement fo