I'd like to use deegree for its WFS capacities connected to an Oracle 12 database where some geo information are available: stations location (latitude, longitude, altitude) + realtime information (parameters changing each 15 min).

In addition to licence costs for Oracle spatial, it seems to me useless to install it, since all necessary information can be extracted through SQL queries.

How can I use deegree with Oracle DB?

  • You need spatial features (support for SDO_GEOMETRY data type and spatial indexes) but you get them with the free Locator option. You do not need to acquire the expensive Spatial license. – user30184 35
    – user30184
    Apr 13 '18 at 9:12
  • Please Edit your Question to contain a question.
    – Vince
    Apr 13 '18 at 10:31

As mentioned, all Oracle databases in all versions and variants include the Oracle Locator feature at no extra licensing costs.

It is the subset of Oracle Spatial that provides full and unlimited support for 2D vector geometries (points, lines, polygons) for querying and processing (topology and distance-based selections, measurements, overlays, buffers etc).

It is most likely installed in the database you are using - unless the DBA who created that database explicitly went through a custom creation and explicitly unchecked the box that includes it.

You can verify that it is installed by going to SQL*Plus and doing:


If this succeeds then you have locator installed.

  • unfortunately, it is not installed. It was indeed a limited installation
    – Alex
    Apr 25 '18 at 10:10
  • So did you get your DBA to install Locator in your database ? Apr 25 '18 at 11:58
  • Unfortunately not. Each try to adapt the database ends with many errors like ORA-04031: cannot assign 4096 bytes of shared memory We are using this page oracle-geospatial-features-spatial-vs-locator
    – Alex
    Apr 26 '18 at 13:39
  • Well that indicates that the database is misconfigured in terms of memory parameters. Typically memory is best left to be managed automatically by the database. And adding missing features is best done using the Database Configuration Assistant. If you are still not successful, you can always just log a call with Oracle support. Apr 27 '18 at 14:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.