Re: [gnome-db] oracle9i

[Steve Fosdick <fozzy pelvoux demon co uk>]

On 25 Mar 2003 14:23:19 -0500
James Leigh <james2002 canada com> wrote:

> Hi,
> 
> Trying to use libgda with for oracle9i in RedHat8.  Here is what I have
> so far.
> 
> My questions:
> 1) Whats a tnsname?

It is the name used by the Oracle networking software to refer to the database.  It enables the networking software to lookup the other information it needs to connect to the database such as the host name/address, protocol, port and the service name of SID of the database.

> 2) How do I setup a tnsname?

These are defined in the tnsnames.ora file (usually $ORACLE_HOME/network/admin/tnsnames.ora) which you can set up with a GUI called netca (Net Configuration Assistant).

> 3) Is libgda-0.10.0 going to work with the oracle-provider from 0.11.0?

I don't know, I haven't tried it.

> 4) Has anyone else used oracle 9i with gnomedb before?

I added the Oracle 9i support to the Oracle provider and having been using it with Oracle 9i sucessfully for a few weeks now.  The Oracle provider is not quite complete at the moment because the interface between the provider and the rest of libgda changes some while back and the Oracle provider wasn't being maintained.  I am trying to bring it up to date but have been very busy these last few weeks.

Steve.

> 
> 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
> 
> 
> _______________________________________________
> gnome-db-list mailing list
> gnome-db-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnome-db-list