Hi,

 

I am trying to use ROracle installed on a Solaris (i386 platform) with
Oracle client 10.2. The installation took quite some troubleshooting,
but eventually I could load ROracle library from R, but here is the
trace and error:

 

> library(ROracle)

Loading required package: DBI

> drv<-dbDriver("Oracle")

> con<-dbConnect(drv,"username/password@dbname")

Error in oraNewConnection(drv, ...) :

 RS-DBI driver: (ORA-12154: TNS:could not resolve the connect identifier
specified)

 

However, when I try to connect to oracle thru sqlplus, I have no
problem:

 

sqlplus username/password@dbname 

 

would work, I could retrieve data from the database.

 

By google this error, I was trying everything in TNSNAMES.ORA file, I
tried a numeric ip, tried directly copy the connection string from
TNSNAMES.ORA, none seems to work.

 

Also, error messages will be recorded in sqlnet.log if I use sqlplus and
intentionally use a wrong connection string. But with the ROracle error
message above, it is not recoded in sqlnet.log.

 

Can some guru help?

 

Thanks I advance.

 

Shuping Zhang 


	[[alternative HTML version deleted]]


