"Connected RDBMS instance is not setup for ST_GEOMETRY configuration"

[HarryBoswell]

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

[VinceAngelo]

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

[HarryBoswell]

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