Re: Oracle Internal Error(ORA-0600, ORA-07445)

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0206060556.481f9ff2_at_posting.google.com>...
> jshubo_at_yahoo.com (Jambo) wrote in message news:<cd48a5b6.0206052301.33c14838_at_posting.google.com>...
> > 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

Yet what is not supported in 8.0.6 causing this problem? Received on Fri Jun 07 2002 - 02:44:10 CEST