Considering that using R to connect directly to Oracle is highly convenient for reading data, try using roracle to connect.
1. Download Rtool
2. Set environment variables (be careful not to overwrite)
Set Oci_lib32 = c \instantclient_11_2Set path = c:\instantclient_11_2\sdk;d:\r-3.3.2\r\ Bin C:\Rtools\gcc-4.6.3\bin; C:\Rtools\bin;
3. Installing R_package
Install.packages ("DBI") install.packages ("Roracle")
4. Load Package- connect to database
Library (DBI) library (roracle) DRV <-dbdriver ("Oracle") Connect.tns <-"(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) ( HOST = * * *) (PORT =****)) (Connect_data = (SERVER = dedicated) (service_name = * * * *) (instance_name = * *))) "Conn <-dbco Nnect (drv,username= "* * *", password= "* * *", dbname = Connect.tns)
5. Testing
<-dbsendquery (conn, "Select 1,2,3 from <-fetch(test)
Data
The following results are available, and it seems that Oracle is connected successfully.
R Language Connection Oracle