Linux Oracle SDE External package Installation ora-28595 Solution

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.