ST_Geometry is not installed.

3290
4
12-11-2013 05:17 PM
DharmenderGupta
New Contributor
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?
0 Kudos
4 Replies
ForrestJones
Esri Contributor
Hi Dharmender,

Is your oracle instance 32-bit by chance? It sounds like the database you are trying to use is not supported.
0 Kudos
DharmenderGupta
New Contributor
Hi Fojo,

I just verified that our oracle 11g db is 32 bit machine.
So,is this not supported?
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
DharmenderGupta
New Contributor
Thank you Angelo and Fojo.
0 Kudos