Error "unable to logon to oracle 60 sec" (4328606)

Event log has following error

Notice 2008-12-16 10:14:34.656804 11436 3 Poster: Session 94 unable to logon to oracle 60 sec (posting from source_hostname, queue name, to target_hostname) [module opo]

Post exits and re launches itself.

The SP_OPO_THREADS_MAX  is  set to 128.
Post normally assigns each subque (session) with each thread and if it has128 threads and 128 sub-queues then post can potentially have 128 concurrent sessions logon to oracle, so when there are 128 threads, some of the shareplex sessions are not able to logon. This could be an issue with OS or Oracle.

Set the parameter SP_OPO_THREADS_MAX to 64.
Normally SP_OPO_THREADS_MAX should be kept at 64. Unless there is MTP deadlock and the sessions within one thread are blocking each other, the parameter should not be changed.

There is an oracle bug related to HP and oracle 10g where oracle only allows 300 OCI bequeath connections or 500 sqlnet connections per process. This is the oracle bug number 6959351, check on metalink for details.

Â

Sometimes the changed settings for SP_OPO_THREADS_MAX may not help or take too long to resolve the issue. If on Shareplex 5.3 or lower, try setting the Post to single-threaded (if the issue occured in MTP) and vice versa. To do this (shown here for setting Post to single-threaded mode):

1. sp_ctrl>stop post

2. sp_ctrl>set post single [queue <queue_name>]

3. sp_ctrl>start post

This may resolve the issue.

Â

Â