topic Calling SQL ST_GEOMETRY function with Oracle RAC hangs in Data Management Questions

Calling SQL ST_GEOMETRY function with Oracle RAC hangs

ModyBuchbinder — Tue, 02 Feb 2016 06:02:03 GMT

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

Re: Calling SQL ST_GEOMETRY function with Oracle RAC hangs

VinceAngelo — Tue, 02 Feb 2016 16:15:55 GMT

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

Re: Calling SQL ST_GEOMETRY function with Oracle RAC hangs

ModyBuchbinder — Thu, 04 Feb 2016 06:58:49 GMT

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?

Re: Calling SQL ST_GEOMETRY function with Oracle RAC hangs

VinceAngelo — Thu, 04 Feb 2016 14:17:37 GMT

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