ArcSDE10.1 Configuring an Oracle listener to use SQL operations St_geometry (personal churn)

Two days to solve the configuration of configuring the Oracle listener to use SQL operations St_geometry, search a large web, the results really found only methods available, below this method I personally in the summary.

ArcSDE10.1 Configuring the Oracle Listener to use SQL Operations St_geometry and other versions of the configuration difference or there are a lot of different, but unlike the network said configuration is so complex and do not need to configure monitoring, I follow the steps to configure the method:

First, configure the User_libraries library

Locate the path to the library below Arcgssde, for example my path is in D:\Program Files\arcgis\arcsde\ora11gexe\bin\st_shapelib.dll, After difficult to use Plsql or other client tools to open the SDE user in the SQL window input

Create or replace library st_shapelib as ' D:\Program files\arcgis\arcsde\ora11gexe\bin\st_shapelib.dll ' command, This modifies the corresponding path.

Enter SELECT * FROM User_libraries under the SDE user to find the path

Second, the configuration Extproc.ora

Find Extproc.ora file For example my path is in D:\app\jinzhiming\product\11.2.0\dbhome_1\hs\admin\extproc.ora

Open the file set extproc_dlls= Modify to set extproc_dlls= any

Third, use any, you need to copy the relevant DLLs and so files into the $oracle_home/bin or $oracle_home/lib inside

For example, my LIB folder path is D:\app\jinzhiming\product\11.2.0\dbhome_1\LIB

After the difficult will ' D:\Program Files\arcgis\arcsde\ora11gexe\bin under the

St_shapelib.dll,libst_raster_ora.dll Copy to D:\app\jinzhiming\product\11.2.0\dbhome_1\LIB file

Four, restart Oralc service

Test pass!

Reference Link: http://blog.csdn.net/linghe301/article/details/7822638