Oracle not getting started with ora - 01092 error

[Former Member]

Dear all

when i am trying to start oracle it throws following error

ora-10192 oracle instance terminated force

when i saw oracle/SID/saptrace/usertrace file it shows

following error

ORA-00604: error occurred at recursive SQL level 1

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4193], [50], [56], [], [], [], [], []

Kindly suggest ....

[former_member661927]

Hello,

Check the alert log.

It seems to be a database started in a different version or different oracle_home that have different version or patch.

If you make a restore in a different version than the original you need to run some scripts to upgrade the catalog.

[Former Member]

dear

we are not updating oracle database software are any patch in last one year then also let me know as u suggest which catalog has to run to overcome the issue

which catalog i have to run

Regards

[former_member182657]

Hi,

Share the alert_<SID>.log file for analysis.Also check for correct permissions and ownerships for directory oracle.

Regards,

Gaurav

[Former Member]

Dear

    we are on windows 2008 how to check the permission of oracle on windows if it is an linux we can check but in windows we have logged in SIDADM user and oracle folder have all permission

elaborate which permission u r telling about

Regards

[former_member182657]

Hi Rajendra,

If possible share alert_<SID>.log file and would be easy to suggest you the solution.Also ora-01092 error can be caused by some factors like:

OS related issue,shutdown abort or rename or missing datafiles .So it would be great to share the alert log file.

Thanks,

Gaurav

[ACE-SAP]

Hi

According to Oracle support this Ora 600 error is caused by a rollback segment corruption.

Have you tried recovering the DB ? (recover database [until cancel])

Regards

ORA-600 [4193] "seq# mismatch while adding undo record" (Doc ID 39282.1)

This error may indicate a rollback segment corruption. This may require a recovery from a database backup depending on the situation.

[Former Member]

Dear

we tried that option but there is no result

with alter database recover

Regards

[Former Member]

Presuming Oracle are correct and you have to restore your database to a previous backup.

Have you given full consideration as to whether this is a good option?

Do you have good backups?

Is this your productive, QA or Dev instance?

It is down anyway. Do you have confidence in your backups? I would restore the backup to just prior to the Ora 0600. You could do this on a seperate host to maintain your existing system (if it is important).

[Reagan]

Have you done any changes to the database prior to this ?

RB

[Former Member]

Dear

No changes have done to database prior to this

Regards

[former_member185239]

Hi Rajendra,

Check and paste the alert log. Over there you will get the exact information.

With Regards

Ashutosh