Using dbMetrix with Oracle RDBMS notes.
To work with Oracle RDBMS in dbMetrix you must to run ./configure with parameters described below and recompile dbMetrix after that.
First parameter (required):
--with-oracle[=ARG] - add Oracle RDBMS support to dbMetrix, has optional argument - path to ORACLE_HOME, default value is value of the ORACLE_HOME environment variable
Second parameter (optional):
--with-oracle-includes=ARG - define compile flags, has required argument ARG, which would be appended to CFLAGS, default value is "-I$ORACLE_HOME/rdbms/demo"
Third parameter (optional):
--with-oracle-libs=ARG - define link flags, has required argument ARG, which would be appended to LFLAGS, default values are:
- Linux
- "-L$ORACLE_HOME/lib -lclntsh -lcommon -lcore4 -lnlsrtl3 SYSLIBLIST"
Other platforms:
"-L$ORACLE_HOME/lib -lclntsh -lclient SYSLIBLIST"
where SYSLIBLIST is
for Oracle8 `cat $ORACLE_HOME/lib/sysliblist`
or for Oracle7 `cat $ORACLE_HOME/rdbms/lib/sysliblist`
Easest way to determine flags, which needed for your platform and Oracle version, is compile any OCI demo program (you can find these demos at $ORACLE_HOME/rdbms/demo) and see flags used during compiling and linking. If you known way automatically to determine these flags (especially for Oracle 7.3 & 8) write me by email.
For example:
cd $ORACLE_HOME/rdbms/demo
make -f demo_rdbms.mk build EXE=cdemo2 OBJS=cdemo2.o
Was tested and work Ok on:
- Red-Hat Linux 5.1 / GCC 2.7.2.3 / Oracle8 Release 8.0.5.0.0 Was compiled with default settings
- HP-UX 10.20, s800 / GCC 2.8.1 / Oracle7 Server Release 7.3.3.0.0 Was compiled with default settings
- HP-UX 10.20, s800 / GCC 2.8.1 / Oracle8 Enterprise Edition Release 8.0.3.2.0
Was compiled with settings:
./configure --with-oracle --with-oracle-libs="-L$ORACLE_HOME/lib/ \
-L$ORACLE_HOME/rdbms/lib -lclntsh $ORACLE_HOME/lib/nautab.o \ $ORACLE_HOME/lib/naeet.o $ORACLE_HOME/lib/naect.o \ $ORACLE_HOME/lib/naedhs.o -lnetwork -lsns -lnauk5 -lnaus -lnetwork \ -lsns -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork \ -lclient -lcommon -lgeneric -lminiserver -lmm -lnlsrtl3 -lcore4 \ -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 \ -lnttcp -lnetwork -lclient -lcommon -lgeneric -lminiserver -lepc \ -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lcommon \ -lgeneric -lminiserver -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 \ -l:libcma.sl -lcl -lm -lnsl_s -lm"
- SCO Open Server 5.0.4 / SCO Dev.Sys. 5.0.4 / Oracle7 Server Release 7.3.3.0.0
Was compiled static version only with settings:
CC="cc -dy" ./configure --with-oracle --with-oracle-libs="-L$ORACLE_HOME/lib \
-lsql -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric -lsqlnet -lncr \ -lsqlnet -lclient -lcommon -lgeneric -lepc -lnlsrtl3 -lc3v6 -lcore3 \ -lnlsrtl3 -lcore3 -lnlsrtl3 `cat $ORACLE_HOME/rdbms/lib/sysliblist` -lm"
Stace A. Zacharov <stace@commed.ru>
COMMED Corp, Omsk, Russia