I'm upgrading an environment from ArcGIS Enterprise 10.5 with Oracle 11.2.0.4 to ArcGIS Enteprise 10.8 with Oracle 19c (19.3.0.0) (SO: Windows) and I'm getting a problem when using the SHAPELIB library. I followed the steps to install it as the documentation below:
Configure the extproc to access ST_Geometry in Oracle—ArcMap | Documentation
Resuming the steps I did:
But when I try to use the library like a simple query like this:
select sde.st_astext(sde.st_geometry('POINT (10 10)',0)) from dual;
I get this error:
ORA-28575: 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.
Does anyone knows how to solve this problem?
Solved! Go to Solution.
What entries are present in the sqlnet.ora file ?
@João Paulo Braga
Hi, Ahmed!
These are the entries:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Could you test by changing the NTS to NONE.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
FYI - I have in my working configuration
SQLNET.AUTHENTICATION_SERVICES= (none)
Oracle 19c has a Bug when the database was installed using a virtual user. https://docs.oracle.com/cd/F19136_01/rnrdm/database-release-notes.pdf
Bug 29426320 ORA-28575 "Unable to open RPC connection to external procedure agent" error occurs when running external procedures or Oracle Database Extensions for .NET procedures with a virtual user account. Workaround#1 Restart the Oracle listener service and the OracleClrAgent service using a non-virtual user account.
Workaround#2 Reinstall Oracle Database 19c and select a non-virtual user account.
Workaround#3 If you require a virtual user account, then set sqlnet.authentication_services to NONE in SQLNET.ORA.
Therefore the above mentioned tipp by @Serguei Sokolov about setting the sqlnet.authentication_services = (NONE) helps and solved the issue for us.
Hi João!
What was your resolution to this? I am having the same issue in my environment.
please try the above suggestion in sqlnet.ora file i.e.
"Could you test by changing the NTS to NONE.
SQLNET.AUTHENTICATION_SERVICES= (NONE)"