zabbix_server 1.8 - Oracle

[coop]

Just as an add-on, we're running on the instantclient libs as well.

[mvrk]

Well, it's a weird behaviour working with the instantclient libs and not with the full client libs that comes with the oracle server.

I've got a few programs in c/c++ writen by me using the oci libs to connect to oracle and all of them connect using either instantclient libs of full client libs.

[coop]

I double checked with our Oracle guy and he says we're running the full client libs. I can provide info on the install and / or files if anyone wants them.

I really shouldn't respond to any forum stuff before I wake up. Sorry!

[mvrk]

Can you check if its the full client or the server libs?

Because i think i don't have the client installed, only have the server libs :

/u01/app/oracle/product/10.2.0/db_1/lib

normaly the client would be something like

/u01/app/oracle/product/10.2.0/client/lib


I don't know what are the differences of the server, full client and instant client libs.

[coop]

Yeah, sorry about that. I should have just posted the info!

I've got the full 10.2.0.4 32bit client installed to $oracle_home/lib32

Here is the file list from that path:

agtsh.exp               libnmarl.so             libowm2.so
clntsh.exp              libnmarl.so.0           libplc10.a
clntsh.map              libnmasf.so             libplp10.a
ctxhx.o                 libnmasf.so.0           libpls10.a
hsdb_odbc.so            libnmastk.so            libsc_fmt.a
hsdb_ora.so             libnmastk.so.0          libskgxn2.a
hsdb_syb.so             libnmcfhc.so            libskgxn2.so
ldflags                 libnmcfsga.so           libskgxnr.a
ldflagsO                libnmefos.so            libskgxnr.so
libOsUtils.so           libnmefos.so.0          libskgxns.a
libagent10.a            libnmefsql.so           libskgxns.so
libagtsh.a              libnmefsql.so.0         libskgxp10.a
libclient10.a           libnmefud.so            libslax10.a
libclntsh.a             libnmefud.so.0          libsnls10.a
libclntsh.so            libnmefut.so            libsql10.a
libclntsh.so.10.1       libnmefut.so.0          libsqlplus.a
libclntsh.so.10.1.ship  libnmefvr.so            libsqlplus.so
libclntst10.a           libnmefvr.so.0          libsrvm.so
libclntst10.a.ship      libnmefw.so             libsrvm10.so
libclsra10.a            libnmefw.so.0           libsrvm10.so0
libclsra10.so           libnmemso.so            libsrvmhas.so
libcommon10.a           libnmemso.so.0          libsrvmhas10.so
libcore10.a             libnmeoci.so            libsrvmhas10.so0
libcorejava.so          libnmeoci.so.0          libsrvmocr.so
libctx10.a              libnmevq.so             libsrvmocr10.so
libctxhx.a              libnmevq.so.0           libsrvmocr10.so0
libdbcfg10.a            libnmuc.so              libstdbcfg10.a
libdbcfg10.so           libnmuc.so.0            libsthasgen10.a
libgeneric10.a          libnmuk.so              libstocr10.a
libhasgen10.a           libnmuk.so.0            libstocrb10.a
libhasgen10.so          libnnet10.a             libstocrutl10.a
libheteroxa10.so        libnnetd10.a            libstskgxn2.a
libheteroxa10_g.so      libnnis10.a             libstskgxnr.a
libhsbase.so            libnnz10.a              libstskgxns.a
libhsnav.so             libnnz10.so             libstuini10.a
libisqlplus.so          libnnzentr10.so         libttsh10.a
libjmisc.so             libnoname10.a           libunls10.a
libldapclnt10.a         libnro10.a              libvppdc.so
libldapjclnt10.a        libnsgr10.a             libvpxdba.so
libldapjclnt10.so       libnsslb10.a            libvpxeap.so
libmgwagent.so          libntcp10.a             libvpxoafnd.so
libmm.a                 libntcps10.a            libvpxos.so
libn10.a                libntns10.a             libvsn10.a
libnavhoa.a             libnus10.a              libxdb.so
libnavhoasup.a          libnzjs10.a             libxml10.a
libnbeq10.a             libocci.a.10.1          libxsd10.a
libncrypt10.a           libocci.so.10.1         naect.o
libnhost10.a            libocci10.a             naedhs.o
libnjni10.so            libocijdbc10.so         naeet.o
libnjssl10.so           libocijdbc10_g.so       nautab.o
libnl10.a               libocr.so               nigcon.o
libnldap10.a            libocr10.a              nigtab.o
libnls10.a              libocr10.so             nnfgt.o
libnmadbg.so            libocrb10.a             ntcontab.o
libnmadbg.so.0          libocrb10.so            osntabst.o
libnmadm.so             libocrbackend.so        scorept.o
libnmadm.so.0           libocrutl10.a           sscoreed.o
libnmalk.so             libocrutl10.so          sysliblist
libnmalk.so.0           libons.so

Here are the variables we're using:
LIBPATH=$ORACLE_HOME/lib:$JAVA_HOME/lib:$LIBPATH:$ORACLE_HOME/lib32
LD_LIBRARY_PATH=/oracle/app/oracle/10.2/lib32:/oracle/app/oracle/10.2/lib:/oracle/app/oracle/10.2/instantclient:
ORACLE_HOME=/oracle/app/oracle/10.2
ORACLE_SID=zabbix
TNS_ADMIN=/oracle/app/oracle/10.2/network/admin