Database does not start

[Former Member]

Hi All,

I have an ECC system running on Oracle 10g and os is HP -UX , we stopped our database and when

we are trying to start it we get the following error

SQL> startup

ORACLE instance started.

Total System Global Area 4680843264 bytes

Fixed Size 1999936 bytes

Variable Size 2348813248 bytes

Database Buffers 2315255808 bytes

Redo Buffers 14774272 bytes

Database mounted.

ORA-03113: end-of-file on communication channel

*Database mounted.*

*ORA-03113: end-of-file on communication channel*

I checked the alert log and found the following error

Errors in file /oracle/SID/saptrace/background/isr_dbw0_21317.trc:

ORA-00600: internal error code, arguments: [3600], [1], [8194], [], [], [], [], []

Mon Jun 1 13:43:28 2009

DBW0: terminating instance due to error 471

Instance terminated by DBW0, pid = 21317

when i check the trace file isr_dbw0_21317.trc i get the following info error 600 detected in background process.

Has any one fix this earlier?? Any inputs would be of much use

Regards,

Ershad Ahmed .

[Former Member]

We went for a Fresh Install .

Regards,

Ershad Ahmed

[Former Member]

We went for a Fresh Install of the system.

Regards,

Ershad Ahmed

[Former Member]

Hi All,

Thanks for all who has responded to my query. The database is still down and its not coming up.

for all the datafiles i did dbverify and i did not see any corrput pages for all the datafiles i could

see this Total Pages Marked Corrupt : 0

However i tried dbverify command on control file, not sure if i can do this but when i tried it i got the

message

DBVERIFY: Release 10.2.0.1.0 - Production on Tue Jun 2 13:18:55 2009

DBV-00103: Specified BLOCKSIZE (8192) differs from actual (16384)

checked in initSID.ora and found that db_block_size is 8192 .

Not sure what else i need to check .

Regards,

Ershad Ahmed

[anindya_bose]

Hi Ershad

I believe you have control files in 3 places, i.e 3 copies of control files. Let's call them control file A,B, and C. Can you take backup of all the control files and use a single control file in all the specified location. Try with A everywhere, then B and then C. Your problem seems to be due to inconsistency in control files.

[Former Member]

Give dbverify output .For more information of dbverify see

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96652/ch13.htm

[Former Member]

Ershad,

There are a number of bugs in Oracle that causes ORA-00600 error. SAP doesnt suppost 10.2.0.1 version.

Check SAP Note 376755 - ORA-00600 - what to do?

http://www.mydatabasesupport.com/ora-00600-internal-error-code.html

https://metalink.oracle.com/CSP/ui/flash.html#tab=Dashboard(page=Dashboard&id=fv7nl98j()),(page=KBNa...

You can find a corresponding trace file in your bdump directory that will have more information. Then, you can take that ORA-600, login to Metalink (www.metalink.oracle.com), and they have an ORA-600 information tool. That can assist you.

Search Metalink for ORA-00600 error.Also check syslog and the Oracle alert<SID>.log.

Thanks,

Sushil

[Former Member]

Hi Surendra,

Thanks for the reply . Im not able to view the post of metalink . Can you please paste what was the

solution used to fix the issue?

Regards,

Ershad Ahmed

[Former Member]

Hi,

See thread which solved answer.

Surendra

[Former Member]

Hi Ersad,

Its oracle internal error.You can fix it .I faced same problem and it resolved.

see below link u can repair or skip

http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/repair.htm#8282

Also check tablespace

https://metalink.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bm...

Check thread some one raised and got solution.

Bye

SurendraJain

[lbreddemann]

> Its oracle internal error.You can fix it .I faced same problem and it resolved.

> see below link u can repair or skip

> http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/repair.htm#8282

> Also check tablespace

Hi there,

just a short note from my side.

The DBMS_REPAIR package is not supported in SAP instances.

Although the name suggests it, no repair is done with this tool. How should it do that? It does not know your data.

All the package does is skip corrupt blocks (blocks !! not rows, whole blocks!) and leaves you a table that is technically readable.

It does not:

- save all data that could be saved

- find the root cause of the corruption

- fix the application side inconsistencies caused by loosing rows

By using the package you will end up with a inconsistent data set in your main business infrastructure!

So, please do yourself a favour and do not use this package.

Open a support message and have the issue checked by the Oracle support@SAP.

regards,

Lars

[Former Member]

The DB version is 10.2.0.1.0 .

Regards,

Ershad Ahmed

[Former Member]

An ORA-00600 is an internal Oracle error, that is the original cause for your ORA-03113.

Also 10.2.0.1. is not supported by SAPjust install the patch 10.2.0.2.0 and try

Rohit

[Former Member]

10.2.0.1 is out of support .. Please upgrade to 10.2.0.2 or 10.2.0.4

[anindya_bose]

Can you please check the trace files and see whether there is any difference in SCN. You might need to stop/start the database Although the solution is little wierd but if the problem is in SCN then repeated start/stop (may be 20-25 times) of your database should solve the problem.

But if that does not solve the problem then please upgrade to 10.2.0.2 ot 10.2.0.4 as your version of database is neither recommended nor supported by SAP.

[Former Member]

Dear Anindiya

Ora-600 can be come in 10.2.0.1 ,10.2.0.2 ot 10.2.0.4 .But u can repair or fix it as given url by me.

Surendra

[anindya_bose]

Surendra

That might resolve the issue, agree. But 10.2.0.1 is not supported by SAP.

[Former Member]

Please check note : 1221326

Upgrade to patchset 9.2.0.7

or

Install patch 3030282 on top of 9.2.0.4