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 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

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:

Hi lefteris, How I can test that?

Baraa

...

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 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

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list