Calling SQL ST_GEOMETRY function with Oracle RAC hangs

Question

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

VinceAngelo · Answer

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

ModyBuchbinder · Answer

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?

VinceAngelo · Answer

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