ST_SHAPELIB + Oracle 19c + ArcGIS Enterprise 10.8 = ORA-28575 error

6938
16
Jump to solution
08-07-2020 06:46 AM
João_PauloBraga
New Contributor II

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:

  • modified the extproc.ora file to accept ANY DLL (initially just the specific DLL, because of the problem, until solve it I leave it with ANY value);
  • restarted the oracle listerner;
  • installed the "Microsoft Visual C++ Redistributable Package (x64)";
  • copied the Windows 64 DLL from the ArcGIS Server folder "Database Support" to the "oracle home\lib" folder;
  • ran the "create or replace library as 'oracle home\lib\st_geometry.dll';";
  • disconnected from database and connected again;\


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?

0 Kudos
16 Replies
Ahmed_AltafTambe
New Contributor III

What entries are present in the sqlnet.ora file ?
@João Paulo Braga

0 Kudos
João_PauloBraga
New Contributor II

Hi, Ahmed! 

These are the entries:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

0 Kudos
Ahmed_AltafTambe
New Contributor III

Could you test by changing the NTS to NONE. 


SQLNET.AUTHENTICATION_SERVICES= (NONE)

SergueiSokolov
New Contributor III

FYI - I have in my working configuration

 SQLNET.AUTHENTICATION_SERVICES= (none)

0 Kudos
PhilippSimmler
New Contributor

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.

by Anonymous User
Not applicable

Hi João! 

What was your resolution to this? I am having the same issue in my environment.

0 Kudos
AhmedAltafTambe
New Contributor

please try the above suggestion in sqlnet.ora file  i.e. 

"Could you test by changing the NTS to NONE. 


SQLNET.AUTHENTICATION_SERVICES= (NONE)

0 Kudos