Oracle configuration st_ geometry

Oracle To configure st_geometry

1 Copy st_shapelib.dll file To oracle Database installation directory ：D:\app\Administrator\product\11.2.0\dbhome_1\BIN ;
2 modify Oracle Two listening files , Respectively ：
extporc.ora （ Path is D:\app\Administrator\product\11.2.0\dbhome_1\hs\admin ） and
listener.ora （ Path is ：D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN ）;
　
3 restart oracle Service monitoring of database ;
4 Use PL/SQL Log in to the database , Execute the following statements in sequence ：
（1）create or replace library ST_SHAPELIB as ‘D:\app\Administrator\product\11.2.0\dbhome_1\BIN\st_shapelib.dll’; This path is the first step ;
（2）alter package sde.st_geometry_shapelib_pkg compile reuse settings ;
5 After executing the above two statements , To verify whether the configuration is successful ：
　　 Execute statement ：select sde.st_AsText(SDE.ST_Geometry(‘POINT(10,10)’, 0)) from dual; Successfully returned results , The configuration is successful ！