Configuration of DB Oracle server

 Print Previous page Top page Next page

To enable external clients to access geo databases ArcSDE, external stored procedures must be supported at the level of server for database Oracle. In particular, it is necessary to mark up the library ST_SHAPELIB.DLL on the server where DBMS Oracle is installed and to perform the appropriate settings in the configuration files of DBMS Oracle. To do this, it is necessary to consistently perform the following steps.

1)  Place the library ST_SHAPELIB.DLL on the server where DBMS Oracle is installed. This library will be located in the subdirectory DatabaseSupport\Oracle\XXXXX in the directory where ArcGIS Desktop (ArcMap) was installed. Where XXXXX is the name of the subdirectory corresponding to the operating system on which DBMS Oracle is installed, and the bit depth of the DBMS itself. For example, for Oracle 12 x64 in the Microsoft Windows Server 2012 operating system, the specified subdirectory will be called «Windows64», and the entire path to the location of the library ST_SHAPELIB.DLL might look something like this:

c:\Program Files(x86)\ArcGIS\Desktop10.1\DatabaseSupport\Oracle\Windows64\st_shapelib.dll

2)  Since the installation of DBMS Oracle and ArcGIS Desktop does not necessarily run on the same computer, you need to copy the library ST_SHAPELIB.DLL to the server where DBMS Oracle is installed, for example, by placing it in the directory C:\ArcGIS\(or \user\arcgis\ – for OS of Linux).

3) If you use Oracle version 11g and higher, configure the configuration file of DBMS Oracle extproc.ora (the file extproc.ora is located in the directory ORACLE_HOME\hs\admin). In extproc.ora, it is necessary to specify the location of the library st_shapelib, for this, add the following line on the server under the operating Windows system:

EXTPROC_DLLS=ONLY:C:\\ArcGIS\\st_shapelib.dll

or, if the server is running OS Linux or UNIX:

SET EXTPROC_DLLS=ONLY:/user/arcgis/libst_shapelib.so

4)  If DBMS Oracle 10g is used, the corresponding settings must be made in the files tnsnames.ora and listener.ora. For a detailed description of the configuration process EXTPROC in DBMS Database 10g, see section «Configuring Oracle extproc for accessing the geo database, using SQL» online help for ArcGIS (http://resources.arcgis.com). In this document, settings of DBMS Oracle 10g will not be considered.

5)  Copy the folder pedata from the directory of installation ArcGIS (the approximate source path is c:\ Program Files (x86)\ ArcGIS\Desktop10.1\pedata), place it on the server DBMS Oracle and to set the PEDATAHOME environment variable on the server that points to this location (for example, C:\ArcGIS\pedata).

 

You can verify that DBMS Oracle server settings are correct after you perform the necessary operations with the geo database.