Event Log:
[104] 11/30/06 18:54 Notice: ORA-01012: not logged on. [sp_opst_mt(osp)/18603]
[104] 11/30/06 18:54 Error: Unexpected Oracle error: ORA-01012: not logged on. in opo_access7.c:701 [sp_opst_mt(osp)/18603]
11/30/06 18:54 Process exited sp_opst_mt (for o.tpd-o.tbk queue mspap10u) [pid = 18603] - exit(1)
11/30/06 18:54 Process launched: sp_opst_mt (for o.tpd-o.tbk queue mspap10u) [pid = 27308]
[1] 11/30/06 18:54 Notice: Oracle env - tbk:/home/oracle/product/9.2.0 [sp_opst_mt(pdb)/27308]
This occurs when MTP threads sees no messages in post subqueue for a while. The thread is trying to logoff and at that moment there is a new message coming in for the subqueue.
This causes Poster to exit and restart. If you are seeing a lot of these messages in the event log then implement the workaround below.
WORKAROUND:
Increase the logout idle setting to 1800 second.
sp_ctrl> set param SP_OPO_IDLE_LOGOUT 1800 (default 60)
This takes affect immediately.
STATUS:
Waiting for fix in a future release of Shareplex for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy