Accessing MonetDB form Oracle DB

baraa Mohamad

25 Oct 2013 25 Oct '13

11:13 a.m.

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

Attachments:

attachment.html (text/html — 1.3 KB)

Show replies by date

baraa Mohamad

26 Oct 26 Oct

7:33 a.m.

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

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

Lefteris

7:48 a.m.

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

baraa Mohamad

8 a.m.

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

Martin Kersten

10:52 a.m.

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

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

3846

Age (days ago)

3847

Last active (days ago)

List overview

Download

4 comments

3 participants

tags (0)

participants (3)

baraa Mohamad
Lefteris
Martin Kersten