[gnome-db] oracle9i

[James Leigh <james2002 canada com>]

Hi,

Trying to use libgda with for oracle9i in RedHat8.  Here is what I have
so far.

My questions:
1) Whats a tnsname?
2) How do I setup a tnsname?
3) Is libgda-0.10.0 going to work with the oracle-provider from 0.11.0?
4) Has anyone else used oracle 9i with gnomedb before?

see below for install details.

james


$ rpm -q libgda mergeant libgnomedb
libgda-0.10.0-1
mergeant-0.10.0-1
libgnomedb-0.10.0-1
$ cd /usr/local/src/libgda-0.11.0
$ ./configure --with-oracle=/opt/oracle/product/9.2.0/
...
$ make
...
gda-freetds-provider.c:31:17: tds.h: No such file or directory
...
$ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds
...
$ make
...
gda-odbc.h:32:17: sql.h: No such file or directory
...
$ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds --without-odbc
...
 Configuration summary
   Installation prefix = /usr/local
   Providers
      Default (XML) = yes
      FireBird = no
      FreeTDS = no
      IBM DB2 = no
      MDB (MS Access) = yes
      MySQL = no
      ODBC = no
      Oracle = yes
      PostgreSQL = no
      SQLite = yes
      Sybase = no
      xBase (dBase, Clipper, FoxPro) = no
      LDAP = yes

$ make
...
In file included from gda-oracle.h:39,
                 from gda-oracle-provider.c:28:
gda-oracle-provider.h:27:17: oci.h: No such file or directory
...
make[2]: *** [gda-oracle-provider.lo] Error 1
make[2]: Leaving directory `/usr/local/src/libgda-0.11.0/providers/oracle'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/libgda-0.11.0/providers'
make: *** [all-recursive] Error 1
$ find /opt/oracle/ -name oci.h
/opt/oracle/product/9.2.0/rdbms/demo/oci.h
...
$ export ORACLE_HOME=/opt/oracle/product/9.2.0/
$ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds --without-odbc
...
$ make
...
$ make install
...
# ln -s /usr/local/lib/libgda/providers/libgda-oracle.so /usr/lib/libgda/providers/
$ ls -l /usr/lib/libgda/providers/
total 284
-rwxr-xr-x    1 root     root        23598 Jan 28 13:19 libgda-default.so
-rwxr-xr-x    1 root     root        56078 Jan 28 13:18 libgda-freetds.so
-rwxr-xr-x    1 root     root        49499 Jan 28 13:18 libgda-mysql.so
-rwxr-xr-x    1 root     root        38286 Jan 28 13:19 libgda-odbc.so
lrwxrwxrwx    1 root     root           48 Mar 14 16:24 libgda-oracle.so -> /usr/local/lib/libgda/providers/libgda-oracle.so
-rwxr-xr-x    1 root     root        62268 Jan 28 13:19 libgda-postgres.so
-rwxr-xr-x    1 root     root        33725 Jan 28 13:19 libgda-sqlite.so
$ mergeant
## add an oracle connect as PASSWORD=XXXX;USER=XXXX;TNSNAME=192.168.10.8
## then test connection
(gnome-database-properties:16693): GLib-GObject-WARNING **: invalid cast from (NULL) pointer to `GObject'

(gnome-database-properties:16693): GLib-GObject-CRITICAL **: file gobject.c: line 1307 (g_object_unref): assertion `G_IS_OBJECT (object)' failed

(gnome-database-properties:16693): GModule-CRITICAL **: file gmodule.c: line 454 (g_module_close): assertion `module != NULL' failed
## and I have to xkill gnome-database-properties