| ORA-00600[4097] error code [message #52575] |
Tue, 30 July 2002 07:59  |
Pam
Messages: 20
Registered: October 2000
|
Junior Member |
|
|
Running Oracle version 8.0.5 on Unix Solaris 2.6 machine. Took the machine down gracefully prior to a power outage. When it came back up the database appears to start ok, but when trying to connect with sqlplus I'm getting the following error...
ORA-00600: internal error code, arguments: [[4097]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
From the trace file...
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [[4097]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
Current SQL statement for this session:
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9 where obj#=:1
Any ideas?
Pam
|
|
|
|
| Re: ORA-00600[4097] error code [message #52580 is a reply to message #52575] |
Tue, 30 July 2002 11:30  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Select segment_name, segment_id from dba_rollback_segs;
Drop all Rollback Segments except for SYSTEM.
Recreate dummy (small) rollback segments with the same names in their place.
Then, recreate additional rollback segments you want to keep with their
permanent storage parameters.
Now drop the dummy ones. This should ensure that the segment_ids are not
reused.
If you ever want to add a rollback segment you have to use the workaround steps
again. If you do not fill the dummy slots you may see the problem re-appear.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
