| ERROR 476: Instance Shutdown [message #59714] |
Thu, 18 December 2003 02:58  |
Vinny75
Messages: 44
Registered: October 2003
|
Member |
|
|
Folks,
My dev instance shutdown automatically due to error 476. I looked up on the error details and found this:
ORA-00476 RECO process terminated with error
Cause: The distributed transaction (two-phase commit) recovery process terminated abnormally.
Action: Restart the instance
Can someone please explain what caused this? After starting the instance, I notice this in the trace file:
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (1) of rollback segment (9))
ORA-01594: attempt to wrap into rollback segment (9) extent (1) which is being freed
More details on the alert log as follows:
Errors in file /bdump/dev_smon_23740.trc:
ORA-01595: error freeing extent (1) of rollback segment (9))
ORA-01594: attempt to wrap into rollback segment (9) extent (1) which is being freed
Thu Dec 18 07:45:41 2003
DISTRIB TRAN DEV.WORLD.516d23ac.3.8.74999
is local tran 3.8.74999 (hex=03.08.124f7))
delete pending collecting tran, scn=2207516131198 (hex=201.fa36ff7e)
I never encountered this before. Any help appreciated.
Thanks
V
|
|
|
|
| Re: ERROR 476: Instance Shutdown [message #59716 is a reply to message #59714] |
Thu, 18 December 2003 03:20  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
You might want to identify the offending transactions in DBA_2PC_PENDING and get rid of them:
SQL> COMMIT FORCE 'rransaction_id';
SQL> ROLLBACK FORCE 'transaction_id';
More info on how to manage Distributed Transactions, see chapter 32 of the "Oracle9i Database Administrator's Guide".
Best regards.
Frank
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
