Installation of Oracle Spatial 11.2.0.4

This manual describes the ‘Installation of Oracle Spatial 11.2.0.4’.

Prereq
  • Installation of Oracle Enterprise Linux or other.
  • Installation of Oracle Database Server 11.2.0.4.
Software

The necessary software can be downloaded by clicking on the link(s) below.

  • n.a.

Installing Oracle Spatial 11.2.0.4

 

Step 1:

Connect to the database where you want to install Oracle Spatial using SYSDBA privileges (use the SYS or SYSTEM accounts). For my install I used SQL*Plus to connect to the database.

Step 2:

Verify prerequisites. To install Oracle Spatial, we need to have JAVA virtual machine, Oracle intermedia and Oracle XML database products already installed. Verify if the products are installed by executing the following SQL.

Step 3:

The install scripts also require a MDSYS user account. Ensure MDSYS user exists or create one before installing Oracle Spatial.

Step 4:

Execute scripts to install Oracle Spatial.

Step 5:

Verify Oracle Spatial is installed correctly. There should not be any invalid objects in MDSYS account.

Check invalid objects.

Check database options.

Information
  • n.a.

Please let me know if this manual ‘Installation of Oracle Spatial 11.2.0.4’ was usefull to you. If there are faults or you have suggestions regarding this manual, please let me know. No rights can be derived from this manual.

Regards,

Maarten

Maarten Schoonus

One Response to “Installation of Oracle Spatial 11.2.0.4”

  1. JThomas

    Excellent article !

    Beantwoorden

Leave a Reply