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