Upgrading ArcSDE 10.8.2 in ArcGIS Pro

Upgrading ArcSDE 10.8.2 in ArcGIS Pro

Upgrading ArcSDE to the latest version is crucial for maintaining compatibility, improving performance, and accessing new features. Here’s a step-by-step guide to help you upgrade ArcSDE 10.8.2 in ArcGIS Pro:

1. Downloading the Patching File

Firstly, you need to download the patching file from My Esri to update your ArcGIS Pro. The patching files typically have names like:

• ArcGIS_Pro_311_185017
• ArcGIS_Pro_312_185016

2. Placing the Files in Your System

Once downloaded, place the patching files in your system directory. Specifically, ensure you have the file libst_shapelib.so.

3. Adjusting Cursor Settings

To optimize performance, adjust the cursor settings:

alter system set open_cursors=2000;
execute SDE.GDB_UTIL.update_open_cursors;

4. Compiling the ST_GEOMETRY ShapeLib Package

Compile the ST_GEOMETRY ShapeLib package with the following command:

alter package sde.st_geometry_shapelib_pkg compile reuse settings;

5. Verifying the Path

Check the path of the ShapeLib file with the following SQL query:

SELECT file_spec FROM user_libraries WHERE library_name = 'ST_SHAPELIB';

Ensure the path looks something like this:

example path: /u01/app/oracle/product/19/db/lib/libst_shapelib.so

6. Creating a Database Connection in ArcGIS Pro

• Open ArcGIS Pro.
• Go to the Analysis tab.
• Navigate to Data Management Tools.
• Select Geoprocessing.
• Choose Geo Dba.
• Click on Upgrade Geodatabase.

Follow the prompts to create and configure the database connection for upgrading your geodatabase.