Which Versions of Oracle

[bailecm2]

I was wondering who out there is using Oracle as the backend database. if so what versions of Oracle have you been successful using? Thanks in advance.

[antonels]

I am looking at using oracle as the backend of Zabbix latest version on linux (suse 10.1) using Oracle 10g release 2, but no luck with the Zabbix install. Any tips on installing Zabbix using oracle backend?

[Alexei]

We used Oracle 9.2.0.4 under RedHat AS3 as a development platform. I remember that we also ran succesfully ZABBIX with Oracle 10.x on RedHat AS3. No problems.

What specific information you're looking for?

[antonels]

I have installed Oracle client as well a the instant client, but get the following

I use: ./configure --enable-server --enable-agent --with-oracle

output
..
..
..
checking for Oracle support... no
configure: error: Invalid Oracle directory - unable to find sqlora.h

thank you.

[Mark]

sqlora.h is a header from libsqlora. You'll need to have libsqlora built and installed before attempting the zabbix build.

[antonels]

thank you for the reply. Can you please give more information on getting libsqlora build and installed. I configured both 10g DB, Client and even instant client, but no libsqlora.

[antonels]

Any help with this will be greatly appreciated. In summary i need to get the following working.
Zabbix using Oracle 10g DB running on Suse 10.1
I tried a few different options, but no luck and I cannot find any information on libsqlora and how to create it or where to find it. I have installed the full Oracle 10g release 2 client, and even tried using the instant client, but no luck yet.
Thank you in advance
Anton

[Alexei]

I have updated section 4 of http://www.zabbix.com/manual/v1.1/install_server.php to include some details about Oracle support. Let me know if something is still unclear.

[antonels]

Thank you!! will try it out and let you know. Your help with this is much appreciated.

[stellino]

hello
I installed libsqlora8 (2.3.3) from homepage linked in manual (http://www.poitschke.de/libsqlora8/)
no error during its compiling (RHEL3 AS update7)



after that I always get the same error configuring zabbix
cmd line

$ ./configure --enable-server --with-oracle=/usr/local/lib --with-net-snmp

answers

configure: error: Invalid Oracle directory - unable to find sqlora.h under /usr/local/lib

I've found sqlora.h in here

# find / | grep sqlora.h
/usr/local/include/sqlora.h
/oracle/setup/libsqlora8-2.3.3/sqlora.h

if I try with any other location

--with-oracle=/usr/local/include
--with-oracle=/usr/local/lib/libsqlora8/
--with-oracle=/usr/local/lib/libsqlora8/include/

always get the same error ("... under each_new_path")
($ORACLE_HOME setting is right)
any suggestion?





these are the file after libsqlora building
(sorry for too many lines, I hope someone could find these useful)

thank you very much
best regards





$ ls /usr/local/lib -R
/usr/local/lib:
total 260
drwxr-xr-x 4 root root 4096 May 25 10:29 .
drwxr-xr-x 12 root root 4096 Aug 24 2005 ..
drwxr-xr-x 3 root root 4096 May 25 10:29 libsqlora8
lrwxrwxrwx 1 root root 23 May 25 10:29 libsqlora8-2.3.so.0 -> libsqlora8-2.3.so.0.2.1
-rwxr-xr-x 1 root root 110722 May 25 10:29 libsqlora8-2.3.so.0.2.1
-rw-r--r-- 1 root root 120980 May 25 10:29 libsqlora8.a
-rwxr-xr-x 1 root root 891 May 25 10:29 libsqlora8.la
lrwxrwxrwx 1 root root 23 May 25 10:29 libsqlora8.so -> libsqlora8-2.3.so.0.2.1
drwxr-xr-x 2 root root 4096 May 25 10:29 pkgconfig

/usr/local/lib/libsqlora8:
total 12
drwxr-xr-x 3 root root 4096 May 25 10:29 .
drwxr-xr-x 4 root root 4096 May 25 10:29 ..
drwxr-xr-x 2 root root 4096 May 25 10:29 include

/usr/local/lib/libsqlora8/include:
total 12
drwxr-xr-x 2 root root 4096 May 25 10:29 .
drwxr-xr-x 3 root root 4096 May 25 10:29 ..
-rw-r--r-- 1 root root 684 May 25 10:29 libsqlora8-config.h

/usr/local/lib/pkgconfig:
total 12
drwxr-xr-x 2 root root 4096 May 25 10:29 .
drwxr-xr-x 4 root root 4096 May 25 10:29 ..
-rw-r--r-- 1 root root 733 May 25 10:29 libsqlora8.pc

[stellino]

ashklerkjiweijfayucyewizlzswjyrinfw######@@@@@@@!! !!!!!!

# cd /usr/local/lib/libsqlora8/include
# ln -sf /usr/local/include/sqlora.h .

and it works!
thank you and sorry for "spam"

[stellino]

unfortunately, after configure worked find, make exit with the following error
something in the environment?



gcc -g -O2 -o zabbix_server -L/usr/local/lib/libsqlora8/lib -L/usr/lib evalfunc.o expression.o actions.o zlog.o functions.o server.o../libs/zbxsysinfo/libzbxsysinfo.a ../libs/zbxsysinfo/linux/libzbxsysinfo2.a ../libs/zbxlog/libzbxlog.a ../libs/zbxpid/libzbxpid.a ../libs/zbxconf/libzbxconf.a ../libs/zbxcrypto/libzbxcrypto.a ../libs/zbxnet/libzbxnet.a pinger/libzbxpinger.a poller/libzbxpoller.a housekeeper/libzbxhousekeeper.a alerter/libzbxalerter.a timer/libzbxtimer.a trapper/libzbxtrapper.a ../libs/zbxemail/libzbxemail.a ../libs/zbxsms/libzbxsms.a ../libs/zbxdbhigh/libzbxdbhigh.a ../libs/zbxcommon/libzbxcommon.a -lsqlora8 -lnetsnmp -lresolv -lnsl
/usr/bin/ld: skipping incompatible /usr/local/lib/libsqlora8.so when searching for -lsqlora8
/usr/bin/ld: skipping incompatible /usr/local/lib/libsqlora8.a when searching for -lsqlora8
/usr/bin/ld: cannot find -lsqlora8
make[3]: *** [zabbix_server] Error 1



thank you very much
and sorry again
best regards