ORACLE11G Configuration St_geometry

Installation environment: ArcGIS Desktop10.2.1, ArcSDE10.2.134940, Oracle11.2.0.1

Operating system: Windows Server 2012R2 DataCenter

The installation Arcsde,st_shapelib.dll exists in the directory C:\Program Files\arcgis\arcsde\ora11gexe\bin, which is required for the configuration to be used.

The SDE Schema was created using the desktop Direct connection, and related tables and stored procedures were created.

Log in to the database with the SDE user

Perform:

Select *  from User_libraries

The result shows that the St_shapelib.dll location is inconsistent with the actual path, so the following statement needs to be executed to reassign the path, which is generated by the installation of ArcSDE above.

SQL>Createorreplace library st_shapelib as  'C # Progra~1\arcgis\arcsde\ora11gexe\bin\st_shapelib.dll';

SQL>alter package sde.st_geometry_shapelib_pkg compile reuse settings;

Note: Installing ArcGIS desktop also installs St_shapelib.dll, with the path: C:\Program Files (x86) \arcgis\desktop10.2\databasesupport\ ORACLE\WINDOWS64, but the relevant file Pe.dll,sg.dll is missing.

Tnsnames.ora file Add:

  = = = = = IPC) (KEY             = EXTPROC)))      = = Plsextproc )               = RO)   ))

Listener.ora file Additions ( boldface ):

Sid_list_listener =(Sid_list=(Sid_desc=(Sid_name=Clrextproc) (Oracle_home= E:\app\SerOS\product\11.2.0\dbhome_1) ( Program=Extproc) (Envs="Extproc_dlls=only:e:\app\seros\product\11.2.0\dbhome_1\bin\oraclr11.dll")) (Sid_desc=(Global_dbname=ORCL) (Sid_name=ORCL)) (Sid_desc =(Sid_name= Plsextproc) (oracle_home = E:\app\SerOS\product\11.2. 0  \dbhome_1) ( program = EXTPROC) (Envs = "Extproc_dlls=c:\progra~1\arcgis\arcsde\ora11gexe\bin\st_shapel Ib.dll,path=c:\progra~1\arcgis\arcsde\ora11gexe\bin" )    )  )

ORACLE11G Configuration St_geometry