ST_Geometry is not installed.

Discussion created by dharmendergupta on Dec 11, 2013
Latest reply on Dec 12, 2013 by dharmendergupta
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 :


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?