how to find infinite loop?
422088May 12 2005 — edited May 25 2005Dear Oracle Gurus,
I have one (some?) problem and no idea what to do.
Our platform is IBM xSeries 234, RHEL3, 10g (version ...0.2). Database has only Oracle Application Repository shemas.
Here is output from OS:
#ps aux
... oracleandja (LOCAL=NO) -More then 200 lines
... /d2/oradb/andja/bin/emagent
... oracleandja (LOCAL=NO)
... ora_pmon_andja
... ora_mman_andja
... ora_dbw0_andja
... ora_lgwr_andja
... ora_ckpt_andja
... ora_smon_andja
... ora_reco_andja
... ora_cjq0_andja
... ora_d000_andja
... ora_s000_andja
... ora_qmnc_andja
... ora_mmnl_andja
#top
216 processes: 214 sleeping, 2 running, 0 zombie, 0 stopped
1st CPU: 100%
2nd CPU: 25%
When I try to shutdown DB from SQL+, I got this:
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-00020: maximum number of processes (%s) exceeded
The most interesting error has written in .trc file:
ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [], [], [], [], [], [], []
Can you give me some advice how to find this infinite loop? And how to deal with this?
Is there anything that I can do to solve this without reinstalling whole DB and AS?
Regards