Database get disconnected again and again in SAP BI server

[Former Member]

Hi All

While doing any work in SAP BI Prd server message comes database got disconnected.Plz help me out.

Thanx

[Former Member]

Hi,

Some of the error reports for ORA-00600 with kcbnew_3 mention that you can do an ALTER SYSTEM FLUSH BUFFER CACHE in sqlplus as a workaround. Apart from a short-term performance hit because the Oracle data cache is reset, this is free to try, so why not do it? Besides this I recommend you also follow Markus's advice and open an OSS message.

Regards,

Mark

[stefan_koehler]

Hello Pranav,

unfortunately you don't tell us anything about your oracle version, but the ORA-00600 error tells you with the first argument where the error is raised.

Please check the metalink note #204512.1 (with the users from sapnote #758563) .. it describes several cases with an explanation for different oracle versions.

If you want more general information about ORA-00600 errors .. so please start with metalink note #146580.1 and go on with the references.

Regards

Stefan

[Former Member]

Hi stefan,

I m really srry my oracle datbase version is 10.2.0.2.0.plz help me out.

[markus_doehr2]

Do you have the latest interim patch installed?

Markus

[Former Member]

Hi Marcus,

Yes we have installed latest interim patches.

[markus_doehr2]

If you still see those ORA-00600 errors in your alert.log I'd create an OSS call. Those are internal error codes only Oracle can check and propose a solution.

Markus

[Former Member]

Hi

What is your oracle patch level.

Was there any patch done recently (Support packs/kernel patch upgrade)

Regards

Uday

[Former Member]

Hi,

Please help me out.

please see the logs of st22 and same error is showing in alerside.log.

Database error text........: "ORA-00600: internal error code, arguments:

[kcbnew_3], [0], [34], [4294967295], [], [], [], []"

Database error code........: 600

Triggering SQL statement...: "delete from soramon where category = ? or

category = ? "

Internal call code.........: "[DBDS/NEW DSQL]"

Regards,

Pranav.

[Former Member]

Hi pranav,

ora-6000 oracle internal error give alert<sid>.log

Run dbverify for more information see

SurendraJain

[Former Member]

Also take a look at trace files in the background_dump_dest or user_dump_dest for additional information.

[Former Member]

Hi

Check in sm21 for logs

Is there any load in the system when database is getting disconnected can you check alert_<sid>.log file to analyze it better what happening in the database

Regards

Uday