R help - Sep 2003 - 64-bit Oracle interface

Hi,

I am running the 64bit version of R on a AIX RS6000 cluster on which is 
also running the ' SQL*Plus: Release 9.2.0.2.0' in the 
'ORACLE-environment Version 64 bit AIX 5.1'.
I have problems setting up an Oralce database connection.

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)

However, sqlplus works well and the listener is also running.

Any idea what could be the problem here?

joerg

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)