ST_GEOMETRY problem on Oracle RDBMS 11g R2 11.2.0.3

irishadar

We've installed ARCSDE 10.1 on Oracle RDBMS 11g R2 11.2.0.3 in Solaris 10 box.

Unfortunately we can't get the ST_GEOMETRY to work.



We keep getting the following error even though every thing configured by the book.

Error starting at line 2 in command:

select st_point(0,0,0) from dual

Error report:

SQL Error: ORA-28595: Extproc agent : Invalid DLL Path

ORA-06512: "SDE.ST_GEOMETRY_SHAPELIB_PKG",line12

ORA-06512: "SDE.ST_POINT",line176

28595. 00000 - "Extproc agent : Invalid DLL Path"


I've enclose my DBA notes as well.

has any one got st_geometry working on oracle 11.2.0.3 on unix ?

help would be much appriciated

iris hadar
IAA

iaa.zip

appsapps

Thank you very much for your posting;
Faced same ST_GEOMETRY problem on Oracle RAC 11g R2
Your posting solved the problem;

Thanks for the information.

ESRI - to look into the documentations how to overcome problems like this;
As i followed exactly the same procedure ArcSDE 10.1 documentation, everything went good except ST_GEOMETRY ;
Now mange to fix it as birdface and working fine;

Thanks

Hi,

We eventually went down to oracle 11.2.0.1 but we also made the following changes , so maybe this will help you:

1.Take the shape.so lib from the arcsde installation for unix and not from arc catalog as describe in the documentation ( we have tested it twice to be sure , the file from windows arc catalog is not working ).
  
2.Make sure that the path is ok , using these syntax,
   �?�SELECT * FROM USER_LIBRARIES

3.We've followed these steps provided by our local distributer , step by step :

     a.Modify your extproc.ora as follows: SET EXTPROC_DLLS=ONLY:�?�.�?�(path)�?�.�?� libst_shapelib.so

     b.Re-create the libraries: $sqlplus sde/sde SQL> create or replace library ST_SHAPELIB as '�?�.�?�(path)�?�.�?� libst_shapelib.so '; Library created.

    c.Make sure that the dlls are valid. SQL>select * from user_libraries; Make sure it is pointing to the correct path and is valid.

    d.Compile st_geometry_shapelib_pkg SQL> alter package sde.st_geometry_shapelib_pkg compile reuse settings; Package altered.

    e.Creating the library causes dependent object to become invalid. Execute the following command as the SDE user (you may need to grant the execute privilege on sys.utl_recomp to user SDE):
          i.As sys user, grant execute on SYS.UTL_RECOMP TO SDE. SQL> GRANT EXECUTE ON SYS.UTL_RECOMP TO SDE;
          ii.As SDE user, recompile. SQL> EXECUTE sys.utl_recomp.recomp_serial('SDE');

    f. Verify all objects are valid as SDE user. SQL> select object_name, object_type from user_objects where status = 'INVALID'

     g.Remove for now the "tnsnames+listener" config and see if it works

hope this will work for you

iris hadar