Calling SQL ST_GEOMETRY function with Oracle RAC hangs

2442
3
02-01-2016 10:02 PM
ModyBuchbinder
Esri Regular Contributor

Hello all

We installed ArcSDE on Oracle11g with RAC on Linux.

If we try to use any ST_GEOMETRY function for SQL (for example ST_BUFFER) it just hangs.

It is working fine without the RAC.

If we change the library name (for checking) we get an error in the SQL (library not found) so I think the library is defined fine.

Anybody have a clue?

Thanks

0 Kudos
3 Replies
VinceAngelo
Esri Esteemed Contributor

You've left out important details from your  problem statement:

  • Which mechanism did you use to configure the instance with the libst_shapelib.so DLL?
  • Is the full path to that library present on each node in the cluster?

- V

0 Kudos
ModyBuchbinder
Esri Regular Contributor

Hi V

Sorry for the delay.

Oracle is running on Linux. The library was copied to both machines and the listner was updated.

The path is absolute.

As I wrote, if we change the library name on disk we get error message that the file does not exists.

I think it prove that the installation is fine.

Any idea?

0 Kudos
VinceAngelo
Esri Esteemed Contributor

If you've altered the Listener, you probably used the wrong procedure.  Since 11gR2, the correct library registration procedure involves the hs/extproc.ora file.

- V

0 Kudos