Accessing MonetDB form Oracle DB
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
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 = MonetDBDriver = /usr/lib64/libMonetODBC.soHost = 192.168.56.101Port = 50000Database = demoUser = monetdbPassword = monetdbDebug = Here are my configurations: tnsnames.ora:monetdb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST =localhost) (PORT =1521) ) (CONNECT_DATA = (SID=monetdb)) (HS = OK)) Listner.oraSID_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.oraHS_FDS_CONNECT_INFO=monetdbHS_FDS_TRACE_LEVEL=OFFHS_FDS_SUPPORT_STATISTICS=FALSEHS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.soHS_LANGUAGE=american_america.we8iso8859p1set 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.xmlListening 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 LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 26-OCT-2013 01:32:37Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/OracleUbuntu/listener/alert/log.xmlListening 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?? RegardsBaraa 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
Hi Perhaps you stumbled upon the follow issue in the clients/ODBC/driver/SQLconnect.c /* connect to a server on host via port */ /* FIXME: use dbname/catalog from ODBC connect string/options here */ mid = mapi_connect(host, port, uid, pwd, "sql", catalog); if (mid == NULL || mapi_error(mid)) { /* Client unable to establish connection */ addDbcError(dbc, "08001", NULL, 0); i.e. an open-end in the implementation. Martin On 10/26/13 10:00 AM, baraa Mohamad wrote:
participants (3)
-
baraa Mohamad -
Lefteris -
Martin Kersten