Installing the ST_Raster type in a local Oracle database

If ArcSDE and Oracle are installed on the same server, follow these instructions to create the ST_Raster type in the database and configure access to it.

Steps:
  1. Install ArcSDE for Oracle.
  2. Update the listener.ora file to include the path in EXTPROC_DLLS.
  3. Run the sdesetup command with the install_st_raster operation.
    sdesetup -o install_st_raster -d ORACLE11G
    -s oserver -u sde
    
    Please enter ArcSDE DBA password:
    
    Install or update ST_Raster schema objects: Are you sure? (Y/N):
    
  4. Using an Oracle SQL editor, such as SQL*Plus, connect as any user and test the installation of the ST_Raster type.

    Successful results for this query include "No data found," if no raster data exists in the geodatabase yet, or a list of the raster columns in the database. An error message is returned if the Oracle listener is not started or the libst_raster_ora library is not accessible. The library may not be accessible if ST_Raster was not installed, the listener.ora file was not updated with the path to the libst_raster_ora library, or the libst_raster_ora library was copied to the wrong location.

    In this example, the describe utility is run to list existing ST_Raster and binary raster columns in the database. In this case, this is a new geodatabase and there are no raster columns yet in the database. Since no error message is returned, you know the installation was successful.

    SELECT sde.st_raster_util.describe() 
    FROM dual;
    
    SDE.ST_RASTER_UTIL.DESCRIBE()
    
    No data found.

    In this example, the describe utility is also run. However, in this case, the path to the libst_raster_ora library was not added to the listener.ora ENV parameter. Correct the problem and run the query again to be sure it is fixed.

    SELECT sde.st_raster_util.describe() 
    FROM dual;
    
    ERROR:
    ORA-28575: unable to open RPC connection to external procedure agent
    ORA-06512: at "SDE.ST_RASTER_UTIL", line 190
    ORA-06512: at "SDE_ST_RASTER_UTIL", line 377
    
  5. Either create an ST_RASTER configuration keyword in the DBTUNE table with the RASTER_STORAGE parameter set to ST_RASTER or set the RASTER_STORAGE parameter under the DEFAULTS keyword to ST_RASTER.
    • If you want most or all of your raster data to be created using the ST_Raster type when using ArcGIS software, set the RASTER_STORAGE parameter value under the DEFAULTS keyword to ST_RASTER.
      sdedbtune -o alter -k DEFAULTS -P RASTER_STORAGE
      -v ST_RASTER -i sde:oracle11g -s bigserve -u sde
      
      Update DBTUNE data: Are you sure? (Y/N):
    • If you only want to create some raster data with ST_Raster storage, add a keyword, ST_RASTER, to your DBTUNE table and include the RASTER_STORAGE parameter set to ST_RASTER and the UI_TEXT parameter.
      sdedbtune -o insert -k ST_RASTER -P RASTER_STORAGE 
      -v ST_RASTER -i sde:oracle11g -s bigserve -u sde
      
      sdedbtune -o insert -k ST_RASTER -P UI_TEXT -v UI_TEXT 
      -i sde:oracle11g -s bigserve -u sde

Related Topics


11/18/2013