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

jshubo_at_yahoo.com (Jambo) wrote in message news:<cd48a5b6.0206061644.20f9b24d_at_posting.google.com>...
> 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?

OK, let me explain Oracles procedures to you, you don't seem to understand them
ORA-600 is a generic error message for an untrapped error which normally shouldn't surface. Hence, *ONLY* Oracle support can resolve them.
As your release, 8.0.6, has been desupported, Oracle won't answer the phone on your ora-600 problem, and they also won't provide you with fixes and backports. A backport: if the problem has been fixed in a subsequent release and your release is supported, depending on impact, you can request a backport. As your release is not supported you also can not request a backport. If you want to continue to use a desupported release you need to agree with Oracle on an Extended Assistance Support license or an Extended Correction Support License. Otherwise: NO ONE IN THE WHOLE WORLD is going to help you out. You either need to pay, or to upgrade to 8.1.7 If you decide to pay, you need to make sure how long the EAS or ECS will be valid

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Jun 07 2002 - 10:02:38 CEST