A.2 Ensuring That GeoRaster Works Properly After an Installation or Upgrade

To use the GeoRaster feature of Oracle Spatial and Graph, you must enable it and ensure that Oracle XML DB Repository is properly installed, as explained in these topics:

A.2.1 Enabling GeoRaster

By default the GeoRaster feature is disabled after the Oracle Spatial and Graph is initially installed. To enable GeoRaster, follow these steps:

  1. Connect to the database as SYS AS SYSDBA.
  2. Enter the following statement: 
    EXECUTE MDSYS.enableGeoRaster;

After GeoRaster is enabled, if you later upgrade the database, you do not need to re-enable GeoRaster.

A.2.2 Ensuring Oracle XML DB Repository is Installed

For more information, see the installation and upgrade notes near the start of Chapter 1 in Oracle Spatial and Graph GeoRaster Developer's Guide.

To use the GeoRaster feature of Oracle Spatial and Graph, Oracle XML DB Repository must be installed properly. (In general, you should ensure that Oracle XML DB Repository is installed before you install Oracle Spatial and Graph.)

If Oracle Spatial and Graph has been installed (such as during an upgrade) but Oracle XML DB Repository is not installed, you need to install the Oracle XML DB Repository and reload related GeoRaster PL/SQL packages. In this case, follow these steps

  1. Install Oracle XML DB Repository.

    For information about installing and uninstalling Oracle XML DB Repository, see Oracle XML DB Developer's Guide.

  2. Go to the $ORACLE_HOME/md/admin directory.

  3. Connect to the database as SYS AS SYSDBA.

  4. Enter the following SQL statements:

    ALTER SESSION SET CURRENT_SCHEMA=MDSYS;
@prvtgrs.plb
@sdogrxml.sql