1. Connect to the database as SYS AS SYSDBA.
2. Enter the following statement:

   EXECUTE MDSYS.enableGeoRaster;
   

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 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

If you upgrade Spatial and Graph to Release 12.2, you might need to alter the SDO_GEORASTER type if any user tablespaces containing SDO_GEORASTER objects were read-only during the upgrade.

During the upgrade, the SDO_GEORASTER type is automatically altered (to permit longer RDT names) as part of the upgrade unless any user tablespaces containing SDO_GEORASTER objects are read-only; and in that case, the type is not altered, and you must take steps to alter it.

You can check whether the SDO_GEORASTER type needs to be altered by entering the following SQL statement and checking the RASTERDATATABLE length is 128 or 32:

SQL> DESCRIBE sdo_georaster
 Name                            Null?    Type
 ------------------------------- -------- ----------------------------
 RASTERTYPE                               NUMBER
 SPATIALEXTENT                            MDSYS.SDO_GEOMETRY
 RASTERDATATABLE                          VARCHAR2(128)
 RASTERID                                 NUMBER
 METADATA                                 XMLTYPE

• If the RASTERDATATABLE column type is VARCHAR2(128), then the SDO_GEORASTER type was successfully altered, and you do not need to alter it.

• If the RASTERDATATABLE column type is VARCHAR2(32), then the SDO_GEORASTER type was not successfully altered, and you must alter it by following the instructions in the rest of this topic.

If you need to alter the SDO_GEORASTER type, follow these steps.

1. Enter the following statements to find a list of read-only tablespaces that contain SDO_GEORASTER objects:

   SQL> connect / as sysdba
   Connected.
   SQL> select distinct TABLESPACE_NAME from dba_tables a, mdsys.sdo_geor_sysdata_table b where a.owner=b.SDO_OWNER and a.TABLE_NAME=b.GEORASTER_TABLE_NAME;
   
   TABLESPACE_NAME
   ------------------------------
   TBS_3
   

2. For each read-only tablespace found in the preceding step, manually change it to read/write. For example (and do similarly for each tablespace):

   SQL> alter tablespace tbs_3 read write;
   

3. Alter the SDO_GEORASTER type by entering the following statements::

   SQL> connect / as sysdba
   
   Connected.
   
   SQL> alter session set current_schema=MDSYS;
   
   Session altered.
   
   SQL> alter type SDO_GEORASTER modify attribute ( rasterDataTable VARCHAR2(128) ) cascade including table data;
   
   Type altered.

4. For each tablespace that you changed to read/write in step 2, change it back to read-only. For example (and do similarly for each tablespace):

   SQL> alter tablespace tbs_3 read only;