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
apt-get install libmonetdb-client-odbc