Hi,
I am using ORE 1.3 in latest Sample App v309 for last couple of weeks. It was working fine until now. But from today morning when I tried to connect to the database using ore.connect, I am getting the following error
> ore.connect("rquser","orcl","localhost","rquser",all=TRUE)
Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, :
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "RQSYS.RQEVALIMPL", line 17
ORA-06512: at "RQSYS.RQEVALIMPL", line 14
ORA-06512: at line 4
I can connect to the database fine using Oracle SQL developer or using only ROracle package (dbConnect) in R. But can not connect using ore. I have found the following related discussion in the archive ORE1.3-ore-server-win-x86_64-1.3,error ORA-28575: unable to open RPC connec
I am facing exactly the same problem. In that discussion it was mentioned that older database bug is probably causing the issue. But in my case, it is Oracle database 12c. Moreover, it was working fine till yesterday evening even for embedded R scripts from both R and SQL interface. But now this strange issue is coming up. I do not think I have changed anything in the system since yesterday for causing this problem.
I have restarted listener, started the whole system fresh, restored old virtual machine snapshot, nothing solved the issue. I am copy-pasting the details of my listener.ora and tnsnames.ora file content in case it helps anyone to solve the issue.
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = obieesample.us.oracle.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = obieesample.us.oracle.com)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = obieesample.us.oracle.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.us.oracle.com)
)
)
If anyone can help me out, that will be great.