[R] 64-bit Oracle interface

[Michael Mader]

Hi,

this is clearly not a problem of ROracle but very likely one of the
client configuration/connection stuff.

Is TNS on the client configured correctly (looks like the client cannot
map the server and, hence, does not find the listener; very common
Oracle mistake)?

Regards

Michael
Joerg Schaber wrote:
> 
[...]
> I can instantiate a driver using  drv <- Oracle(). But when I try to
> connect to my database using dbConnect (dbConnect(drv, dbname="xxx",
> username="xxx", password="xxx")) I get the message:
> Error in oraNewConnection(drv, ...) : RS-DBI driver: (ORA-12154:
> TNS:could not resolve service name)
> 
> When I use oraNewConnection (oraNewConnection(drv,username="xxx",
> password="xxx")) I get the message:
> Error in oraNewConnection(drv, username = "pheno", password = "pheno") :
>         RS-DBI driver: (ORA-12541: TNS:no listener)
> 


-- 
Michael T. Mader
Institute for Bioinformatics/MIPS, GSF
Ingolstaedter Landstrasse 1
D-80937 Neuherberg
0049-89-3187-3576
 
In statistics, some people worry about not seeing the forest for the
trees.
I like to look at the bark. (C. R. Blyth, 1967)