Calling SQL ST_GEOMETRY function with Oracle RAC hangs

[ModyBuchbinder]

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]

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

[ModyBuchbinder]

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]

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