> Date: Sat, 26 Oct 2013 09:48:44 +0200
> Subject: Re: Accessing MonetDB form Oracle DB
> From: lsidir@gmail.com
> To: users-list@monetdb.org
>
> Hi Baraa,
>
> are you able to connect to monetdb with ODBC but without using oracle?
> at this point, for me at least, it is unclear if the problem is in
> monetdb connectivity or in oracle.
>
> lefteris
>
> On Sat, Oct 26, 2013 at 9:33 AM, baraa Mohamad <bem85@hotmail.com> wrote:
> > Here are more informations, I really need a help please,
> >
> > I have oracle 11g installed on machine1 (ubuntu 64bit) , and I have MonetDB
> > installed on machine2 (ubuntu 64bit, ip= 192.168.56.101)
> >
> > I need to access MonetDB database from oracle.
> >
> >
> >
> > I followed the configurations steps but I get always the following error:
> >
> >
> >
> > select "id" from "test"@monetdb;
> >
> >
> >
> > ORA-28500: connection from ORACLE to a non-Oracle system returned this
> > message:
> >
> > [unixODBC][MonetDB][ODBC Driver 11.11.11]Client unable to establish
> > connection
> >
> > {08001}
> >
> > ORA-02063: preceding 2 lines from MONETDB
> >
> >
> >
> > I installed unixODBC on the machine1 and I used MonetDB ODBC driver which
> > generates the following odbc.ini file
> >
> >
> >
> > [monetdb]
> >
> > Description = MonetDB
> >
> > Driver = /usr/lib64/libMonetODBC.so
> >
> > Host = 192.168.56.101
> >
> > Port = 50000
> >
> > Database = demo
> >
> > User = monetdb
> >
> > Password = monetdb
> >
> > Debug =
> >
> >
> >
> >
> >
> > Here are my configurations:
> >
> >
> >
> > tnsnames.ora:
> >
> > monetdb =
> >
> > (DESCRIPTION =
> >
> > (ADDRESS =
> >
> > (PROTOCOL = TCP)
> >
> > (HOST =localhost)
> >
> > (PORT =1521)
> >
> > )
> >
> > (CONNECT_DATA =
> >
> > (SID=monetdb))
> >
> > (HS = OK))
> >
> >
> >
> > Listner.ora
> >
> > SID_LIST_LISTENER=
> >
> > (SID_LIST=
> >
> > (SID_DESC=
> >
> > (SID_NAME=monetdb)
> >
> > (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
> >
> > (PROGRAM=dg4odbc)
> >
> > (ENVS=LD_LIBRARY_PATH=/usr/lib64:$ORACLE_HOME/lib)
> >
> > )
> >
> > )
> >
> >
> >
> > In $ORACLE_HOME/hs/admin I created the file initmonetdb.ora
> >
> > HS_FDS_CONNECT_INFO=monetdb
> >
> > HS_FDS_TRACE_LEVEL=OFF
> >
> > HS_FDS_SUPPORT_STATISTICS=FALSE
> >
> > HS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.so
> >
> > HS_LANGUAGE=american_america.we8iso8859p1
> >
> > set ODBCINI=/etc/odbc.ini
> >
> >
> >
> > when I do lsnrctl start i get the following
> >
> >
> >
> > Log messages written to
> > /u01/app/oracle/diag/tnslsnr/OracleUbuntu/listener/alert/log.xml
> >
> > Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
> >
> > Listening on:
> > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
> >
> >
> >
> >
> >
> > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
> >
> > STATUS of the LISTENER
> >
> > ------------------------
> >
> > Alias LISTENER
> >
> > Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
> >
> > Start Date 26-OCT-2013 01:32:37
> >
> > Uptime 0 days 0 hr. 0 min. 0 sec
> >
> > Trace Level off
> >
> > Security ON: Local OS Authentication
> >
> > SNMP OFF
> >
> > Listener Parameter File
> > /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
> >
> > Listener Log File
> > /u01/app/oracle/diag/tnslsnr/OracleUbuntu/listener/alert/log.xml
> >
> > Listening Endpoints Summary...
> >
> > (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
> >
> > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
> >
> > Services Summary...
> >
> > Service "monetdb" has 1 instance(s).
> >
> > Instance "monetdb", status UNKNOWN, has 1 handler(s) for this service...
> >
> > The command completed successfully
> >
> >
> >
> > any ideas why I get this error??
> >
> >
> >
> > Regards
> >
> > Baraa
> >
> >
> > ________________________________
> > From: bem85@hotmail.com
> > To: users-list@monetdb.org
> > Subject: Accessing MonetDB form Oracle DB
> > Date: Fri, 25 Oct 2013 11:13:37 +0000
> >
> >
> > Dear MonetDB users,
> >
> > I have a question about accessing MonetDB via Oracle using ODBC.
> > I have oracle on machine1 (ubuntu 64bit) and MonetDB on machine2(ubuntu
> > 64bit)
> > I installed Monetdb odbc driver using
> >
> > apt-get install libmonetdb-client-odbc
> >
> > I have done all the needed configurations for the listner, tnsnames, sqlnet,
> > initservice.ora and I used UnixODBC.
> > After creating the database link, I get this error when I try to connect
> > MonetDB:
> >
> > ORA-28500: connection from ORACLE to a non-Oracle system returned this
> > message:
> > [unixODBC][MonetDB][ODBC Driver 11.11.11]Client unable to establish
> > connection
> > {08001}
> > ORA-02063: preceding 2 lines from MONETDB
> >
> > I don't know if the use of (64bit) needs some special configurations?? or
> > its du to something else.
> >
> > So I need your help to figure out what is the problem....
> >
> > Best regards,
> > Baraa
> >
> > _______________________________________________ users-list mailing list
> > users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
> >
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org
> > https://www.monetdb.org/mailman/listinfo/users-list
> >
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list