From: postbus@sybrandb.demon.nl (Sybrand Bakker) Newsgroups: comp.databases.oracle Subject: Re: Oracle Internal Error(ORA-0600, ORA-07445) Date: 6 Jun 2002 06:56:38 -0700 Organization: http://groups.google.com/ Lines: 69 Message-ID: References: NNTP-Posting-Host: 145.13.42.4 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1023371800 11084 127.0.0.1 (6 Jun 2002 13:56:40 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 6 Jun 2002 13:56:40 GMT jshubo@yahoo.com (Jambo) wrote in message news:... > I have a problem as below and Metalink doesn't help since their advice > is just to upgrade Oracle or OS and this is not always the solution. > > At some unexpected time(not always), the application written by Pro*C > have the ORA-3114 problem and alert.log shows the error is ORA-07445 > or ORA-0600. After this problem happen, application will end up with > ORA-3114, the temporary fix is just to restart the application. But > after some time, say 2 weeks, it happens again and I need to restart > the application again. > > Just want to ask why this happens and what is the final solution to > it. > > > Details is: > > alert.log > > ...... > > Sun Jun 2 22:59:22 2002 > Errors in file /export/home/app/oracle/admin/zeus/udump/zeus_ora_29827.trc: > ORA-00600: internal error code, arguments: [17281], [600], > [2313677088], [], [], [], [], [] > ORA-00600: internal error code, arguments: [17182], [17355112], [], > [], [], [], [], [] > Sun Jun 2 22:59:23 2002 > Errors in file /export/home/app/oracle/admin/zeus/udump/zeus_ora_29776.trc: > ORA-00600: internal error code, arguments: [17281], [600], > [2309345208], [], [], [], [], [] > ORA-00600: internal error code, arguments: [17182], [17356036], [], > [], [], [], [], [] > ....... > > Sun Jun 2 23:03:21 2002 > Errors in file /export/home/app/oracle/admin/zeus/udump/zeus_ora_29813.trc: > ORA-07445: exception encountered: core dump [kgidmp()+696] [SIGBUS] > [Invalid address alignment] [590857] [] [] > ORA-07445: exception encountered: core dump [kgidmp()+696] [SIGBUS] > [Invalid address alignment] [590857] [] [] > ORA-07445: exception encountered: core dump [kgicli()+76] [SIGBUS] > [Invalid address alignment] [590861] [] [] > Sun Jun 2 23:03:22 2002 > Errors in file /export/home/app/oracle/admin/zeus/udump/zeus_ora_29805.trc: > ORA-07445: exception encountered: core dump [kgidmp()+696] [SIGBUS] > [Invalid address alignment] [590857] [] [] > ORA-07445: exception encountered: core dump [kgidmp()+696] [SIGBUS] > [Invalid address alignment] [590857] [] [] > ORA-07445: exception encountered: core dump [kgicli()+76] [SIGBUS] > [Invalid address alignment] [590861] [] [] > ....... > > system: > Oracle: 8.0.6 > OS: SunOS 5.6 Generic_105181-22 sun4u sparc SUNW,Ultra-1 > > > > Thanks a lot! The final solution is to upgrade to something support, ie 8.1.7 Regards Sybrand Bakker Senior Oracle DBA