orabbix-1.2.3 on Zabbix 2.4.1 (ERROR on main - Connections is empty)

[izn0g00d]

Hello All,

I have downloaded the suse vm for zabbix and it works great. However, I am facing issues trying to install orabbix-1.2.3 on Zabbix 2.4.1. I have placed the orabbix on the same server as the zabbix server.

My java version is :
java version "1.7.0_75"
Java(TM) SE Runtime Environment (build 1.7.0_75-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.75-b04, mixed mode)

executing run.sh error -->
./run.sh
linux-qvvt:/opt/orabbix # Stopping
java.lang.Exception: ERROR on main - Connections is empty
at com.smartmarmot.orabbix.Orabbixmon.run(Orabbixmon. java:101)
at com.smartmarmot.orabbix.bootstrap.main(bootstrap.j ava:50)

errors in the error log -- >
cat orabbix.log
2015-03-12 23:04:43,569 [main] INFO Orabbix - Starting Orabbix Version 1.2.3
2015-03-12 23:04:44,281 [main] INFO Orabbix - Orabbix started with pid:20444
2015-03-12 23:04:44,281 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2015-03-12 23:04:44,475 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@59887d29
2015-03-12 23:04:44,475 [main] INFO Orabbix - URL=jdbcracle:thin:@192.168.1.26:1521rcl
2015-03-12 23:04:44,475 [main] INFO Orabbix - maxPoolSize=10
2015-03-12 23:04:44,475 [main] INFO Orabbix - maxIdleSize=1
2015-03-12 23:04:44,475 [main] INFO Orabbix - maxIdleTime=1800000ms
2015-03-12 23:04:44,475 [main] INFO Orabbix - poolTimeout=100
2015-03-12 23:04:44,475 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2015-03-12 23:04:44,475 [main] INFO Orabbix - numTestsPerEvictionRun=3
2015-03-12 23:04:44,578 [main] ERROR Orabbix - Error on Configurator for database orcl -->IO Error: The Network Adapter could not establish the connection
2015-03-12 23:04:44,579 [main] INFO Orabbix - This Database orcl removed
2015-03-12 23:04:44,579 [main] ERROR Orabbix - ERROR on main - Connections is empty

config.props -->
#comma separed list of Zabbix servers
ZabbixServerList=linux-qvvt
ZabbixServer1.Address=192.168.1.6
ZabbixServer1.Port=10051
#pidFile
OrabbixDaemon.PidFile=./logs/orabbix.pid
#frequency of item's refresh
OrabbixDaemon.Sleep=300
#MaxThreadNumber should be >= than the number of your databases
OrabbixDaemon.MaxThreadNumber=100
#put here your databases in a comma separated list
DatabaseList = orcl
#Configuration of Connection pool
#if not specified Orabbis is going to use default values (hardcoded)
#Maximum number of active connection inside pool
DatabaseList.MaxActive=10
#The maximum number of milliseconds that the pool will wait
#(when there are no available connections) for a connection to be returned
#before throwing an exception, or <= 0 to wait indefinitely.
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1
#define here your connection string for each database
orcl.Url=jdbcracle:thin:@192.168.1.26:1521rcl
orcl.User=zabbix
orcl.Password=zabbix
#Those values are optionals if not specified Orabbix is going to use the general values
orcl.MaxActive=10
orcl.MaxWait=100
orcl.MaxIdle=1
orcl.QueryListFile=./conf/query.props


I have tried on Ubuntu, suse and windows and they all produce the same error.

zabbix-server(OS)| Agent(OS) |Database Version
---------------------------------------------------------------------------
Ubuntu | solaris 10 | 9i
---------------------------------------------------------------------------
Suse | windows 7 | 11g


The steps i have followed are from the orabbix website.

Kindly extend your help.

Regards,
izn0g00d

[izn0g00d]

anyone encountered this issue?

[izn0g00d]

trying to keep this thread on top....

[OriginNG]

I don't know how good you knowledge about oracle is but I think you're having problems with a firewall between you orabix install and the server.
Try is you can install an oracle client on you suse/orabix server (instantclient is the easiest), then try to connect from sqlplus to your database server. I think this won't work either because of the firewall. The problem with oracle is that the client connects to port 1521 on the database server (listener) which will validate the servicename/sid and the client will get back a random high numbered port which it will use to do its work. The last step is where most firewalls will block your client because you can't know on beforehand what port the client is going to use. For that to work you'll need a firewall with app support.

Regards,

Joop

[izn0g00d]

Hello OriginNG,

I have tested with sqlplus:

sqlplus "zabbix/zabbix@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1 72.17.58.220)(PORT=1521))(CONNECT_DATA=(SID=XXX))) "

and am able to get a connection....

but still same error when i execute ./run.sh

[OriginNG]

Hello OriginNG,

I have tested with sqlplus:

sqlplus "zabbix/zabbix@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1 72.17.58.220)(PORT=1521))(CONNECT_DATA=(SID=XXX))) "

and am able to get a connection....

but still same error when i execute ./run.sh

You're connecting to database server @ 172.17.58.220 but in you're config for orabix you're having a 192 address.

[izn0g00d]

I was trying to obfuscate my post with the 192 address..

Good news the problem is solve with the connection. There was a space at the end of the database name(SID ) ...


Now am strugling with the empty graphs..

loving the trouble shooting

[alusvedejs]

how did you solve the connection problem?

Hi everyone

i am hitting similar problem
i have zabbix server 2.4.0 with orabbix 1.2.3
when i try to start orabbix it cannot connect to my databases.

and when this happens database throw ORA-3136 in alert log:
TNS-12535: TNSperation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=35281) )
WARNING: inbound connection timed out (ORA-3136)


how to work this around?
the problem is with orabbix because i try to connect to 3 different databases on different servers. even different database versions and platforms.
all of them write ORA-3136 in alert log when i try to start orabbix.

and the orabbix shuts down with

java.lang.Exception: ERROR on main - Connections is empty
at com.smartmarmot.orabbix.Orabbixmon.run(Orabbixmon. java:101)
at com.smartmarmot.orabbix.bootstrap.main(bootstrap.j ava:50)



i am wondering about (PORT=35281) in alert log. where do that comes from because database is listening and i am connecting to port 1521?

[izn0g00d]

My issue was due to the fact that the SID had a space at the end [ORCL _ ] which i couldnt see

[alusvedejs]

any other suggestions?
anyone?

[alusvedejs]

forget it

i found the solution.

i lost 3 days becauce "hostname" returned different value than was in my "/etc/hosts" on zabbix/orabbix server

[izn0g00d]

I would suggest you try with the suze vm first

[syman888]

forget it

i found the solution.

i lost 3 days becauce "hostname" returned different value than was in my "/etc/hosts" on zabbix/orabbix server

Excuse me
Can you please explain the solution in detail? I also met the same problem, thank you.