hi,
i´ve installed the new beta version (1.9.8) on my test systems. Redhat system with Oracle Database as Backend. After a few days (and many config changes) i got a error message: [Z3001] connection to database '//<hostname>:1521/<database>' failed: [-1] ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
i have 50 connections configured on the oracle database for zabbix. After i decreased the Poller / Trapper / Syncer count this error wasn´t there.
After a little lookup on the database, it seems that every thread (process) has his own connection (sounds fine, because only one connection start is needed) and many httpd connections also. But nearly all of them are inactive.
Now my question: in production i need to use nearly 50 poller and 50 trapper. is the only solution to increase the connection count in oracle to 200? Or is there another solution for this problem?
br matthias
i´ve installed the new beta version (1.9.8) on my test systems. Redhat system with Oracle Database as Backend. After a few days (and many config changes) i got a error message: [Z3001] connection to database '//<hostname>:1521/<database>' failed: [-1] ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
i have 50 connections configured on the oracle database for zabbix. After i decreased the Poller / Trapper / Syncer count this error wasn´t there.
After a little lookup on the database, it seems that every thread (process) has his own connection (sounds fine, because only one connection start is needed) and many httpd connections also. But nearly all of them are inactive.
Now my question: in production i need to use nearly 50 poller and 50 trapper. is the only solution to increase the connection count in oracle to 200? Or is there another solution for this problem?
br matthias