Linux Oracle SDE External package Installation ora-28595 Solution

When using SQL to manipulate the spatial table in Oracle, the error is entered below:

The above hints indicate that the dependent SDE package reference is invalid, the SDE package is configured for the Oracle database by querying the official website, and the setup process is logged here:

1. Login SDE User Execution

   SELECT * from user_libraries where library_name = ' st_shapelib ';

   The results are as follows: the obvious corresponding path is that the st_shapelib.dll file that is introduced in does not exist

2. Create a new folder on Linux and find it from the installation directory of arcdesktop. \databasesupport\oracle\linux64 copy libst_shapelib.so past and granted permissions

mkdir sde_linux mkdir Oracle chmod 777 libst_shapelib.so

3. Change the external library to the specified so file location, log in to the SDE user, execute

Create or replace library st_shapelib as '/oracle/sde_linux/oracle/libst_shapelib.so ';

The path above is the path of your own libst_shapelib.so file

4. Configure Environment variables

Lstener.ora file Additions (Modify the Oracle_home and Envs paths as appropriate) Sid_list_listener = (Sid_list = (Sid_desc =                (Oracle_home =/home/oracle/app/oracle/product/11.2.0/dbhome_1)  (Sid_name = Plsextproc)                    (program = Extproc)        (envs= "extproc_dlls=/oracle/sde_linux/oracle/libst_shapelib.so")) )

Tnsnames.ora Add the following content Extproc_connection_data = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = IPC) (Key = EXT PROC1521))) (Connect_data = (SID = plsextproc) (PRESENTATION = RO)))

Note: The SID, sid_name of the two files are equal, and the key in the Tnsnames.ora is equal to the key in the Listener.ora.

5. Restart Monitoring and service

Su-oracle lsnrctl Stop lsnrctl start Sqlplus/nolog conn/as sysdba shutdown immediate Startup

Once you have done this, you can update the ArcGIS Space table with SQL statements in Oracle.

Perform:

SELECT registration_id from sde.table_registry WHERE table_name = ' txt_test01 ' and owner = ' ARCGIS '; INSERT into txt_test01 (objectid,field_0,shape) VALUES (sde.version_user_ddl.next_row_id (' ARCGIS ', 121), ' tranquil ', Sde. St_geometry (' Point (119.001824881 25.436934541) ', 300000));

Add success! End

Attached website Link: http://resources.arcgis.com/en/help/main/10.2/#/Configuring_the_Oracle_listener_to_use_ST_Geometry_and_ St_raster/006z0000001w000000/

Linux Oracle SDE External package Installation ora-28595 Solution