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.
Due to the Oracle bug
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
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy