topic ArcSDE prerequisite check ST_Geometry-problem in Data Management Questions

ArcSDE prerequisite check ST_Geometry-problem

DenizGueclue — Fri, 03 Feb 2012 10:32:01 GMT

Hello!

I searched for my problem in the forum and found some threads about the same problem but those couldn't help me solving my problem.

I've installed Oracle and ArcSDE on the same machine (Red Hat Linux Server 64bit - Tikanga 5.4). When starting the prerequisite check I get the following error:

Checking ST_GEOMETRY configuration setup... Current instance is not correctly setup for ST_GEOMETRY configuration.  Unable to determine current version of ST_SHAPELIB.  The latest ST_GEOMETRY and dependent libraries need to be copied to the correct software location.  Checking ST_RASTER configuration setup... Current instance is not correctly setup for ST_RASTER configuration.

Although I've configured the listener.ora and tnsnames.ora and restarted the listener I get the "error".

Listener.ora:

LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =           (ADDRESS = (PROTOCOL = TCP)(HOST = atem-db)(PORT=1521))       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))     )   )  SID_LIST_LISTENER=   (SID_LIST=     (SID_DESC=       (GLOBAL_DBNAME=atem.atem.fuez)       (ORACLE_HOME=/opt/oracle/11gR1/product/11.1.0/db_2)       (SID_NAME=atem)       (PROGRAM=extproc)       (ENVS="EXTPROC_DLLS=/opt/arcsde/sdeexe100/lib/libst_shapelib.so:/opt/arcsde/sdeexe100/lib/libst_raster_ora.so")     )   )

Tnsnames.ora:

ATEM =    (DESCRIPTION =      (ADDRESS_LIST =        (ADDRESS = (PROTOCOL = TCP)(HOST=atem-db)(PORT=1521)       (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1521)     )      (CONNECT_DATA =       (SERVICE_NAME = atem) (SID = atem)       (PRESENTATION = RO)     )   )

Can anybody give me an advice?
Thanks!

Re: ArcSDE prerequisite check ST_Geometry-problem

VinceAngelo — Fri, 03 Feb 2012 11:06:23 GMT

The KnowledgeBase has a number of articles on ST_SHAPELIB configuration and
troubleshooting.

- V

Re: ArcSDE prerequisite check ST_Geometry-problem

JonDeRose — Fri, 03 Feb 2012 13:08:37 GMT

From what has been provided it appears as though your tnsnames.ora does not have the necessary entry
to use IPC to send calls to ExtProc:

EXTPROC_CONNECTION_DATA = (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1521))     )     (CONNECT_DATA =       (SID = PLSExtProc)       (PRESENTATION = RO)     ) )

Configuring the Oracle listener to access the geodatabase with SQL
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n00000091000000

Please note that there is more involved in this process than simply configuring these two files but this component is necessary to proceed.

- Jon

Re: ArcSDE prerequisite check ST_Geometry-problem

DenizGueclue — Mon, 06 Feb 2012 11:47:55 GMT

Oh i see...you're right. Thank you ver much!!!