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

[ForrestJones]

in my situation, the library was corrupted (for some reason).....

Hi Emad,

I've seen the libst_shapelib.so file get corrupted during the copy to a unix machine before if using ftp and ascii transfer mode (default mode). In order to ensure it transfers correctly I've had to set it to binary mode (bin). Then the file seems to be ok and it works. Maybe you were running into something similar? Something to check at least.

[VinceAngelo]

This is one of the many reasons why FTP isn't generally enabled anymore,
and 'scp' (which is a binary-safe utility) is used instead.  You should always
double-check file size and MD5sum after transfer.

- V

[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