oracle11g the configuration of spatial database St_geometry class library based on ArcGIS10.2

Recently, I used the space database, in accordance with the online has been a tutorial on the configuration and construction of the library after some of the problems of the St_geometry class library, in the lookup data toss after the deployment finally resolved, hence for the purposes of this article only for exchange reference.

First, use the "Create Enterprise Geodatabase" feature under the Data management tool in Arctoolbox to build a library, as shown in Figure 1

Figure 1

The parameter is then configured, as shown in Figure 2

Figure 2

Then determine, according to the online reference tutorial completed this part of the work and wait for processing completed to establish its spatial database and can add a variety of types of spatial data, such as Figure 3. There are only three elements established for a common database rather than a spatial database, as shown in Figure 4

Figure 3 Figure 4

However, the result remains as shown in Figure 4, so open geo-processing to see if there are errors in the process, and then find an error message under the result message: The St_geometry shape library path may be invalid, or the Extproc is not properly configured in the Oracle instance. [(Unable to determine current version of St_shapelib.) Please check the St_geometry shape library path on the Oracle server, which are set to "C:\progra~2\arcgis\desktop10.2\data Basesupport\oracle\windows64\st_shapelib.dll ". Refer to the ArcGIS Help topics for more details. As shown in Figure 5

Figure 5

According to the content, the problem is that the St_geometry class library is not configured properly and the system cannot find the St_shapelib.dll file under the "C:\Progra ..." path. Found the problem can proceed to solve, we can have two solutions: 1, copy the St_shapelib file to the appropriate folder. 2, the Oracle database can be modified to the library path, modified to the computer installation ArcSDE folder, find the DLL package location for the path assignment. The message prompts Extproc to be configured incorrectly, so we also need to configure Extproc. First stop the LSNRCTL service, open the Oracle Database installation directory and find the Lisener.ora file open, which reads as follows:

# Listener.ora Network Configuration File:d:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.


Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = D:\app\product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "Extproc_dlls=only:d:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)


LISTENER =
(Description_list =
(DESCRIPTION =
(address = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(address = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
)

You need to add the St_shapelib.dll path to the following line (program = Extproc) and modify it to: (Envs = "Extproc_dlls=only:c:\program files\arcgis\arcsde\ Ora11gexe\bin\st_shapelib.dll ").

Second, configure the Extproc.ora file in the Hs/admin under the installation directory, as in this instance, the path is D:\app\product\11.2.0\dbhome_1\hs\admin\extproc.ora the last line in the file "set Extproc_dlls= "to SET extproc_dlls=any".

After configuring Extproc, you also configure the Reference class library in the database to query the current user for a corresponding class library reference definition with SQL statements

      Select Library_name from User_libraries;

The result is as shown in Figure 6

Figure 6

After you view the definition of a class library reference without a st_shapelib name, you need to define a reference, SQL statement:

    Create or replace library St_shapelib  
  2 as  ' C:\Program files\arcgis\arcsde\ora11gexe\bin\st_shapelib.dll ';  
  3  /  

After completing the configuration restart Oracle instance and Lsnrctl service, try to build the library according to the above steps, and still prompt the corresponding problem after the establishment, then find out the problem by analysis. ArcGIS generates a new user when building a space database, the username is the optional defined table space name in Figure 2, and ArcGIS automatically generates a St_geometry class library reference path for user initialization on the Oracle server when a new user is generated, with the value "C:\ Progra~2\arcgis\desktop10.2\databasesupport\oracle\windows64\st_shapelib.dll ". So even if you define the St_shapelib class library reference under the SYS user as well as the SYS user, the newly generated user will invoke the St_geometry method by default according to the ArcGIS initialization path, and there will still be an error while the library is being built. So if this happens. You should first review the ST_SHAPELIB definition in Oracle's entire system, as follows:

      Sql> SELECT * from dba_libraries where library_name= ' st_shapelib ';

If the St_shapelib path value under the newly created spatial database user is the ArcGIS default initialization value, then after the same process under the secondary user and then adding the database connection of the new spatial database user in ArcGIS, the problem can be solved after the connection. The content of the space method in the St_geometry library can be called and the spatial database is successfully established. (Note: ArcGIS default Next Oracle instance can only create a spatial database, if the original data to see problems need to use SQL statements for user and table space all content and data files Delete

     sql> sql> drop user SDE cascade;

     sql> sql> drop tablespace sde including contents and datafiles;

）

End

by Cobramonkey