Zabbix over Oracle: TNS-12516

[zabbix_zen]

Hi.

I'm having trouble in a new Zabbix installation over Oracle XE (10G).

From my zabbix_server.conf

ListenPort=10051
# zabbix host dnsname
DBHost=dev-zabbix02
# DB service name as defined in $TNS_ADMIN/tnsnames.ora
DBName=XE
DBUser=zabbix
# All DB, schema and credentials were successfully tested using sqlplus
DBPassword=zabbixpasswd
DBPort=1521
# host IP
ListenIP=10.110.15.10

The DB is up and running, zabbix schema is correctly populated and frontend successfully connects and allows for normal operation,
but as soon as I /etc/init.d/zabbix_server start

my listener gets flooded with messages similar to, (port numbers always increasing)

15-MAR-2011 12:16:39 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=zabbix_server)(HOST=dev-zabbix02)(USER=zabbix))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.110.15.10)([B]PORT=44634[/B])) * establish * XE * 12516
TNS-12516: TNS:listener could not find available handler with matching protocol stack
15-MAR-2011 12:16:50 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=zabbix_server)(HOST=dev-zabbix02(USER=zabbix))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.110.15.10)([B]PORT=44635[/B])) * establish * XE * 12516
TNS-12516: TNS:listener could not find available handler with matching protocol stack

Why is zabbix_server spamming so many sessions/services and how to solve it?

[zabbix_zen]

Oracle sees the current number of sessions

SELECT COUNT(*)
  FROM v$session

as 20

And the configured max session number

SELECT name, value 
  FROM v$parameter
 WHERE name = 'sessions'

is 49

I've changed init.ora from

processes = 50                                                        # SMALL

to

processes = 200                                                     # LARGE

but the error continues..
Does anyone running ORACLE ever run into this ?

[zabbix_zen]

Well.. I just had a 'Dooooooh' moment remembering that when spfile exists
init.ora definitions get overwritten.

I solved it as sysdba,

Alter system set processes=200 scope=spfile;
shutdown immediate;
startup;