Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-00600: internal error code,....

Status
Not open for further replies.

stormman

Technical User
Apr 19, 2003
1
US
Hi all,

This is my first thread in this forum so if this is not the correct forum, please let me know.

I've configured in a system with Solaris 8 the SunMC3.0 software.

This software uses Oracle 8.1.6.0 to keep all its data, and when the program try to start the Oracle DB, I get a core and I get this trace:

/opt/SUNWsymon/SunMCDB01/app/oracle/product/8.1.6/admin/SunMC30/udump/sunmc30_ora_12072.trc
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /opt/SUNWsymon/SunMCDB01/app/oracle/product/8.1.6
System name: SunOS
Node name: oasv086
Release: 5.8
Version: Generic_108528-16
Machine: sun4u
Instance name: SunMC30
Redo thread mounted by this instance: 1
Oracle process number: 16
Unix process pid: 12072, image: oracle@oasv086 (TNS V1-V3)

*** SESSION ID:(15.1287) 2003-04-16 13:55:55.402
*** 2003-04-16 13:55:55.402
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktsgsp5], [4835], [4577], [], [], [], [], []
Current SQL statement for this session:
INSERT INTO report.stage_report_data_log_hour
(hostname,port,module,module_instance,property,property_instance,units,date_created,trend_max_value,trend_min_value,tr
end_avg_value,tz_offset)
VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+168 CALL ksedst()+0 498 ? 1 ? FFBEAC7C ?
FFBEA720 ? FFBEA704 ? 0 ?
kgerinv()+184 PTR_CALL 00000000 3 ? 0 ? 0 ? 15E3398 ? 2 ?
FFBEB22C ?
kgeasnmierr()+28 CALL kgerinv()+0 16F39EC ? 173FB4C ? 137EB38


I think that the basic problem is I've a DB corruption problem, but I'm not sure.

Is there some way to verify this possibility?

Any idea will be really welcome.

Thanks in advance.

Best Regards.
 
Seems you are having freelist corruption. Try to rebuild the freelists. Note that these ORA-600 errors do not mean you have hit this particular problem - these errors can have other root causes.

You can find which objects are using freelist groups by

SELECT * FROM dba_segments WHERE freelist_groups>1;

Then rebuild the free lists with execute dbms_repair.rebuild_freelists().


Hope that helps,

clio_usa

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top