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
