Return
-
Title
Post hanging using Oracle 9.2.0.8 and Sun -
Description
Post hangs and won't stop cleanly,
Database sessions won't go away, session takes for ever to complete the rollback in the database.
Eventually ends up as a hung session.
Restarting Shareplex will still result in a hung situation as the database sessions were not cleared. -
Cause
Due to the Oracle bug
-
Resolution
WORKAROUND:
Database bounce will get rid of the hung Oracle sessions.
Please contact Oracle support and refer the below Oracle patch
Platform Patch for : Solaris Operating System (SPARC 64-bit)
Product Version # : 9.2.0.8
Patch Number : 6279479
Patch Description :INDEX ROLLBACK TAKING TOO LONG TO COMPLETE/HANGING