"Connected RDBMS instance is not setup for ST_GEOMETRY configuration"

HarryBoswell — Thu, 20 Oct 2011 14:27:04 GMT

I've been trying to resolve this for a couple of weeks now. ArcGIS 10 on a Windows server, connecting to Oracle 10g on Linux. I think I have the Oracle net config correctly done (I tested extproc with a non-SDE call, without the ENVS parameter, and it worked):

listener.ora:

[INDENT](SID_DESC = (SID_NAME = PLSExtProc)
            (ORACLE_HOME= /ora00/oracle10g)
            (PROGRAM = extproc)
            (ENVS="EXTPROC_DLLS=/ora00/oracle10g/bin/libst_shapelib.so;/ora00/oracle10g/bin/libst_raster_ora.so,LD_LIBRARY_PATH=/ora00/oracle10g/lib")
     )
[/INDENT]

tnsnames.ora:

[INDENT]EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
    )
    (CONNECT_DATA =
      (SID = PLSextproc)
    )
)

[/INDENT]

libst_raster_ora.so and libst_shapelib.so are nestled in $ORACLE_HOME/bin. The libraries are defined in the sde schema:

[INDENT]CREATE OR REPLACE LIBRARY ST_SHAPELIB
IS '/ora00/oracle10g/bin/libst_shapelib.so'[/INDENT]

[INDENT]CREATE OR REPLACE LIBRARY LIBST_RASTER
IS '/ora00/oracle10g/bin/libst_raster_ora.so'[/INDENT]

Obviously I'm missing something, but I'm reading the docs over and over and not seeing it. Help, anyone?

Thanks,
Harry

Re: "Connected RDBMS instance is not setup for ST_GEOMETRY configuration"

VinceAngelo — Thu, 20 Oct 2011 14:52:26 GMT

DLLs live in 'bin' on Windows hosts; they belong in 'lib' on Unix hosts. Specifying an LD_LIBRARY_PATH
to 'lib' with the DLLs in 'bin' isn't going to work. You'll need to change the Oracle libraries to point to
the 'lib' directory as well.

- V

Re: "Connected RDBMS instance is not setup for ST_GEOMETRY configuration"

HarryBoswell — Thu, 20 Oct 2011 19:08:49 GMT

I read the "Installing Oracle and ArcSDE on separate servers" document many times and misread that line every time. Hopefully that will resolve the issue.

Thanks,
Harry

topic Re: "Connected RDBMS instance is not setup for ST_GEOMETRY configuration" in Data Management Questions

"Connected RDBMS instance is not setup for ST_GEOMETRY configuration"

Re: "Connected RDBMS instance is not setup for ST_GEOMETRY configuration"

Re: "Connected RDBMS instance is not setup for ST_GEOMETRY configuration"