For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Dear sir , When I attached query report on the button the error is appearing. Please give solution as requested. Email shr_kam007@hotmail.com
Hi Penny,
The trace files don't provide the root cause for the problem in this case. This error is often a Database restriction or OML4R configuration problem. It is most often happens when:
To narrow the problem, log into sqlplus as your ORE_USER and execute these commands, which execute along the same code paths but remove the R layer to simplify troubleshooting
1. Test OML4R's extproc:
SQL> select rqGamma(0.1) from dual;
2. Test OMl4R's embedded R:
SQL> select rqBesselI(1,1,1) bes1, rqBesselI(1,1,0) bes2 from dual;
Post the output here and I'll take a look.
Sherry
Hi Sherry
Both of those given me the same error.
So I obviously have a config error .
I might try a clean install on a new Windows10 VM and see how far I get. The box does have other Oracle installs on it (although I have removed them from the paths)
ORA-28575: unable to open RPC connection to external procedure agent
28575. 00000 - "unable to open RPC connection to external procedure agent"
*Cause: Initialization of a network connection to the extproc agent did
not succeed. This problem can be caused by network problems,
incorrect listener configuration, or incorrect transfer code.
*Action: Check listener configuration in LISTENER.ORA and TNSNAMES.ORA, or
check Oracle Names Server.
Thank you for looking
Penny
I have had a question from one of my clients who has just installed on Linux 7 and is getting a similar issue.
I don't have their files etc but I asked them to try the statements you gave me and they have the following result:
1. Test OML4Rs extproc
select rqGamma(0.1) from dual
successfully returns
9.51350769866873
select rqBesseli(1,1,1) bes1, rqBesseli(1,1,0) from dual
ORA-28578: protocol error during callback from an external procedure
28578. 00000 - "protocol error during callback from an external procedure"
*Cause: An internal protocol error occurred while trying to execute a
callback to the Oracle server from the user's 3GL routine.
*Action: Contact Oracle customer support.
Could you give me an idea what this tells you, and as a result where we should be looking for the issue.
Thanks
Is it possible for us to set up a live troubleshooting session for the issues mentioned in this post? We can follow-up with the solution here.
Let me know what is convenient for you.
Thanks,
I have given up on my installation on Windows and am using a Linux VM (that's my learning /play environment) and that is working fine so no issues there.
My client is evaluating this and has a small POC going. We have managed to resolve most of the issues (libpng issue followed by Wallet issue)
We have one outstanding issue which is a Cairo library error. I found another response from you re setting GRAPHICS = FALSE and that works for us so I am assuming maybe a Cairo library version or an X11 issue. They are not prepared to make any more changes on the box since they have a lot of other 18c DBs on the same VM and this is just a POC, and their only 19c database.
So at this stage I am happy that we can evaluate with the GRAPHICS = FALSE workaround. If they go with Enterprise R as a solution, and I think they will, then they will deploy a separate VM just for their AA/ML and we will be able to configure how we like. If they still have issues when we get to that stage then I will definitely be calling on you again. Thank you for you always prompt responses in the meantime. In the meantime I will mark this as answered.
Regards
Thanks for the update. The Cairo issues are likely due to missing OS dependencies. We can run some diagnostic tests when you are ready. I'll be alerted when this thread is updated in the future, so let me know if additional help his needed.
Best,