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]]