Setting up ORE 1.4.1 with Oracle 12c (12.1.0.1) On Windows Machine.
1、在sqlplus中执行（sqlplus / as sysdba）
Select name,con_id,open_mode from v$pdbs;
#修改 pluggable database status to READ WRITE.
Alter pluggable database PDBORCL open;
Select name,con_id,open_mode from v$pdbs;
2、下载ore-server-win-x86_64-1.4.1.zip和ore-supporting-win-x86_64-1.4.1.zip，解压后，将server、supporting和server.bat复制c:\Windows\system32下，以管理员身份运行server.bat --pdb PDBORCL --perm SYSAUX --temp TEMP --rqsys rqsys --user-perm SYSAUX --user-temp TEMP --pass rquser --user RQUSER
3、R
library(ORE)
Sys.setenv(TZ = "EDT")
ore.connect(user="system", service_name="PDBORCL", host="10.112.6.251", password="52332580", port=1521, all=F)
ore.is.connected()
ore.sync()
ore.ls()
ore.exists("MVIEW_FILTER")
ore.get("MVIEW_FILTER")
ore.disconnect()
参考：https://explorebigdataanalytics.wordpress.com/2014/12/16/setting-up-ore-1-4-1-with-oracle-12c-12-1-0-1-r-3-1-2-on-windows-machine/
https://docs.oracle.com/cd/E57012_01/doc.141/e57007/toc.htm
Select name,con_id,open_mode from v$pdbs;
#修改 pluggable database status to READ WRITE.
Alter pluggable database PDBORCL open;
Select name,con_id,open_mode from v$pdbs;
2、下载ore-server-win-x86_64-1.4.1.zip和ore-supporting-win-x86_64-1.4.1.zip，解压后，将server、supporting和server.bat复制c:\Windows\system32下，以管理员身份运行server.bat --pdb PDBORCL --perm SYSAUX --temp TEMP --rqsys rqsys --user-perm SYSAUX --user-temp TEMP --pass rquser --user RQUSER
3、R
library(ORE)
Sys.setenv(TZ = "EDT")
ore.connect(user="system", service_name="PDBORCL", host="10.112.6.251", password="52332580", port=1521, all=F)
ore.is.connected()
ore.sync()
ore.ls()
ore.exists("MVIEW_FILTER")
ore.get("MVIEW_FILTER")
ore.disconnect()
参考：https://explorebigdataanalytics.wordpress.com/2014/12/16/setting-up-ore-1-4-1-with-oracle-12c-12-1-0-1-r-3-1-2-on-windows-machine/
https://docs.oracle.com/cd/E57012_01/doc.141/e57007/toc.htm
评论
发表评论