Hi Shelly.
I'm Tony and I'm ORACLE DBA for a research center. We want to install in our Oracle database: ORACLE R enterprise to use for our advanced statistical analisys.
I had Oracle RDBMS enterprise 11.2.0.2 installed on Oracle REDHAT Linux 6.1.
I migrated to 11.2.0.3 respecting Oracle R enterprise requirements.
select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
I also installed Oracle R distribution 2.15.3 and Oracle R enterprise server 1.3.1
After I installed supporting and client packages with ORE R CMD INSTALL syntax.
At ORE prompt I tried connection to db trough ore.connect but I reiceved this error:
ore.connect: Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch ORA-00904: "Version": invalid identifier
Have you suggestions about some workaround to solve this problem ?
Thanks,
Tony