Return
-
Title
ORA-00018: maximum number of sessions exceeded -
Description
You get this error on source (capture process) or target (post process)
04/13/07 20:34 Notice: ORA-00604: error occurred at recursive SQL level 1.ORA-00018: maximum number of sessions exceeded. [sp_ocap(osp)/2786]
04/13/07 20:34 Error: Unexpected Oracle error: ORA-00604: error occurred at recursive SQL level 1.ORA-00018: maximum number of sessions exceeded. in rom.c:163 [sp_ocap(osp)/2786] -
Cause
The maximum number of sessions allowed in the database is exceeded. -
Resolution
Increase the number of concurrently allowed sessions in the database by increasing the value of the SESSIONS initialization parameter.If increasing sessions in init.ora is not possible, the following parameters in shareplex can be set to help to control number of session on post process in shareplex.1. SP_OPO_MAX_SESSIONS which control number of sessions post can have with Oracle.2. SP_OPO_IDLE_LOGOUT which control how long an idle session should be logged out. This session may cause shareplex to rollback long running transactions.