ST_Geometry is not installed.

DharmenderGupta — Thu, 12 Dec 2013 01:17:20 GMT

Iam trying to Create a Geodatabase in Oracle 11g DB using "Enable Enterprise Geodatabase" tool in ArcCatalog.

1.Created sde user and table space ,also granted necessary previleges to sde user in Oracle 11g DB.

2.Also copied libst_shapelib.so to $ORACLE_HOME/lib directory in my Oracle 11g server.

3.Modified Tnsnames.oar and Listener.ora for extproc and restarted server.

4.Created library in oracle db using below command :

CREATE OR REPLACE LIBRARY sde.st_shapelib AS
'/slot/ems4881/oracle/db/tech_st/11.2.0/lib/libst_shapelib.so';

After performing above steps when I try to use "Enable Enterprise Geodatabase" log file says :

[12/11/2013 8:14:42 PM] Validated authorization file.
[12/11/2013 8:14:44 PM] User has required privileges for geodatabase setup.
[12/11/2013 8:14:44 PM] XML support is enabled for the database instance.
[12/11/2013 8:14:48 PM] Error: The version of your database server is not supported. Error:

[12/11/2013 8:14:48 PM] Error: See the setup log in the following location for additional error information:
[12/11/2013 8:14:48 PM] Error: C:\Users\lroot\AppData\Local\Temp\sde_setup.log
[12/11/2013 8:14:48 PM] Error: Could not create geodatabase tables and stored procedures.

sde_setup.log says:

Wed Dec 11 20:14:44 2013]
ST_Geometry is not installed.[Wed Dec 11 20:14:44 2013] Instance initialized for ((sde)) . . .

[Wed Dec 11 20:14:44 2013] Error:
[Wed Dec 11 20:14:44 2013] ERROR installing/upgrading ArcSDE, Error = -494

Can some one let us know what we are missing here?

Re: ST_Geometry is not installed.

ForrestJones — Thu, 12 Dec 2013 14:32:07 GMT

Hi Dharmender,

Is your oracle instance 32-bit by chance? It sounds like the database you are trying to use is not supported.

Re: ST_Geometry is not installed.

DharmenderGupta — Thu, 12 Dec 2013 18:39:35 GMT

Hi Fojo,

I just verified that our oracle 11g db is 32 bit machine.
So,is this not supported?

Re: ST_Geometry is not installed.

VinceAngelo — Thu, 12 Dec 2013 18:54:05 GMT

Effrctive ArcGIS 10.1, ArcSDE server capabilities are only supported on 64-bit architecture.
Clients can be 32-bit, but all server installations must be 64-bit.

32-bit Oracle is not supported for SDE.ST_GEOMETRY.

- V

Re: ST_Geometry is not installed.

DharmenderGupta — Thu, 12 Dec 2013 18:59:04 GMT

Thank you Angelo and Fojo.

topic Re: ST_Geometry is not installed. in Data Management Questions

ST_Geometry is not installed.

Re: ST_Geometry is not installed.

Re: ST_Geometry is not installed.

Re: ST_Geometry is not installed.

Re: ST_Geometry is not installed.