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

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 Received on Thu Jun 06 2002 - 15:56:38 CEST