startup failed with ora-600

Printable View

11-12-2004, 02:47 AM
yls177

startup failed with ora-600

Errors in file /oracle/SID/saptrace/background/SID_smon_12383.trc:
ORA-00600: internal error code, arguments: [2662], [1798], [4161378953], [1798], [4161379611], [1677
74185], [], []

Errors in file /oracle/SID/saptrace/usertrace/SID_ora_12391.trc:
ORA-00600: internal error code, arguments: [4194], [32], [4], [], [], [], [], []

Fatal internal error happened while SMON was doing active transaction recovery.

Errors in file /oracle/SID/saptrace/background/SID_smon_12383.trc:
ORA-00600: internal error code, arguments: [2662], [1798], [4161378953], [1798], [4161379611], [1677
74185], [], []

In the above referred smon trace files, i get the below entries

KSTDUMP: End of in-memory trace dump
error 600 detected in background process
11-12-2004, 03:11 AM
jmodic

Contact Oracle Support.
11-12-2004, 05:53 AM
waitecj

Check metalink for the ORA-00600 error lookup. Enter the first argument when prompted and it will tell you what your issue is and about a million possible solutions:

Code:

DESCRIPTION: A data block SCN is ahead of the current SCN. The ORA-600 [2662] occurs when an SCN is compared to the dependent SCN stored in a UGA variable. If the SCN is less than the dependent SCN then we signal the ORA-600 [2662] internal error.

Try some of the more obvious solutions first, and if that doesn't work, then get Oracle Support on the Dog and Bone.
11-12-2004, 08:58 AM
yls177

Quote:

Originally posted by waitecj
Check metalink for the ORA-00600 error lookup. Enter the first argument when prompted and it will tell you what your issue is and about a million possible solutions:

Code:

DESCRIPTION: A data block SCN is ahead of the current SCN. The ORA-600 [2662] occurs when an SCN is compared to the dependent SCN stored in a UGA variable. If the SCN is less than the dependent SCN then we signal the ORA-600 [2662] internal error.

Try some of the more obvious solutions first, and if that doesn't work, then get Oracle Support on the Dog and Bone.

Hi, thanks for more information about the oracle internal error. Okay, any pointers to how to rectify my oracle database?

Thanks
11-12-2004, 09:22 AM
davey23uk

yes, just like Jurij said - call support, they will help you
11-12-2004, 10:17 AM
OracleDoc

come on say it! I dare you!
11-12-2004, 10:21 AM
marist89

Quote:

Originally posted by OracleDoc
come on say it! I dare you!

I know it's coming, just wait...
11-12-2004, 11:46 AM
davey23uk

the waiting is killing me now so i will say it for you

'I dont have a metalink account, please help me'
11-14-2004, 12:51 PM
simply_dba

I f you have a registered copy of oracle ,then you must have an id if not you can create it by visiting the metalink site and by giving your registration number.

And if you don't have a registered copy then.............
11-14-2004, 02:15 PM
jmodic

Quote:

Originally posted by simply_dba
I f you have a registered copy of oracle ,then you must have an id if not you can create it by visiting the metalink site and by giving your registration number.

And if you don't have a registered copy then.............

Registered copy? What are you talking about, there is no such thing as registered copy in Oracle? Are you talking about licensed version of Oracle software? If so, then paid licence does not include Oracle support services. You must pay for support separately on a yearly basis (while license fee is usually paid only once).
11-16-2004, 01:27 AM
simply_dba

umm....well... I talked tooo much.

I have some presumptions about this oracle support systems.
Please scold me if i am wrong on these.

1) "Licenced" version can be registered through oracle.com.
2) metalink registration can be done using the registration number from above.
3) oracle support services contract means purchasing Oracle "man-hours" where oracle support services people will "physically" visit the client site and act as a consultant and it has nothing to do with metalink.

how about that.......
11-17-2004, 06:47 AM
simply_dba

Well I may not be correct..
still I would appreciate if somebody enlightens me on this .
11-17-2004, 07:30 AM
guru_heaven

Quote:

Originally posted by yls177
Hi, thanks for more information about the oracle internal error. Okay, any pointers to how to rectify my oracle database?

Thanks

yea, recreate your database (why you dont contact support, if you dont have a license let me report you to ORacle Corp.)
11-17-2004, 07:40 AM
OracleDoc

A little research does wonders

That should answer your questions :D
11-17-2004, 10:11 AM
davey23uk

Quote:

Originally posted by guru_heaven
yea, recreate your database (why you dont contact support, if you dont have a license let me report you to ORacle Corp.)

You can have a licensed copy without a support contract and therefore no access to metalink