English

Bug: ST_SHAPELIB library location and name not created correctly on AIX and HP_UX

Description

When running Spatial Type for Oracle functions on AIX and HP, the following error message is displayed:

"ORA-06522: Unable to find library libst_shapelib.so"

Cause

The ArcSDE for Oracle ST_SHAPELIB library file is used for SQL access to ST_Geometry data. The ST_SHAPELIB library file name is not being correctly created on AIX and HP during the post-installation stage of ArcSDE. The default library file name is being created under location and name:

%SDEHOME%/lib/libst_shapelib.sl.

On AIX, the correct file name is libst_shapelib_64.so. On HP, the correct file name is st_shapelib.sl.

Workaround

Re-create the ST_SHAPELIB library in Oracle as the 'sde' schema user.

  1. Log into Oracle as the sde user, for example:
    sqlplus sde/sde
  2. Re-create the library.

    On HP_UX:

    Code:
    SQL> create or replace library SDE.ST_SHAPELIB AS
    SQL> '<path to library file>/libst_shapelib.sl';

    On AIX

    Code:
    SQL> create or replace library SDE.ST_SHAPELIB AS
    SQL> '<path to library file>/libst_shapelib_64.so';