ORA-01012: not logged on. in opo_access7.c:701 (25414)

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.