Spatial
Oracle Spatial is an integrated set of functions and procedures that enables spatial data to be stored, accessed, and analyzed quickly and efficiently in an Oracle database.
Spatial data represents the essential location characteristics of real or conceptual objects as those objects relate to the real or conceptual space in which they exist.
What Is Oracle Spatial?
Oracle Spatial, often referred to as Spatial, provides a SQL
schema and functions that facilitate the storage, retrieval, update, and query
of collections of spatial features in an Oracle database. Spatial consists of
the following:
·
A schema (MDSYS)
that prescribes the storage, syntax, and semantics of supported geometric data
types
·
A spatial indexing
mechanism
·
Operators,
functions, and procedures for performing area-of-interest queries, spatial join
queries, and other spatial analysis operations
·
Functions and
procedures for utility and tuning operations
·
Topology data model
for working with data about nodes, edges, and faces in a
·
Network data model
for representing capabilities or objects that are modeled as nodes and links in
a network.
·
GeoRaster, a
feature that lets you store, index, query, analyze, and deliver GeoRaster data,
that is, raster image and gridded data and its associated.
The spatial component of a spatial feature is the geometric
representation of its shape in some coordinate space. This is referred to as
its geometry.
Below are the step to install spatial manually.
Scenario.
--We
have upgraded database from oracle 9i (9.2.0.8) to 11GR1 (11.1.0.7).
--The
Spatial INVALID prior to upgrade only.
--Even
after executing utlrp.sql many times Spatial was still INVALID.
--We
ignored it and updated the database.
--As
the Spatial was INVALID prior to upgrade we have to drop the MDSYS user and
re-create it (else not required all the other steps remains same)
Implementation.
oracle 9i
**********
SQL> select COMP_NAME, VERSION,STATUS
from dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- --------------- ----------
Oracle Database Catalog Views 11.1.0.7.0 VALID
Oracle Database Packages and Types 11.1.0.7.0 VALID
JServer JAVA Virtual Machine 11.1.0.7.0 VALID
Oracle Database Java Packages 11.1.0.7.0 VALID
Oracle XDK 11.1.0.7.0 VALID
Spatial
11.1.0.7.0 INVALID
Oracle XML Database 11.1.0.7.0 VALID
Oracle Multimedia 11.1.0.7.0 VALID
oracle 11gR1
*************
SQL> select COMP_NAME, VERSION,STATUS
from dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- --------------- ----------
Oracle Database Catalog Views 11.1.0.7.0 VALID
Oracle Database Packages and Types 11.1.0.7.0 VALID
JServer JAVA Virtual Machine 11.1.0.7.0 VALID
Oracle Database Java Packages 11.1.0.7.0 VALID
Oracle XDK 11.1.0.7.0 VALID
Spatial
11.1.0.7.0 INVALID
Oracle XML Database 11.1.0.7.0 VALID
Oracle Multimedia 11.1.0.7.0 VALID
Steps to be followed to solve the issue
*****************************************
1) Remove Spatial
SQL> drop user MDSYS cascade;
2) Re-install Spatial
create the user
MDSYS by running following command:
SQL> create user MDSYS identified by
MDSYS default tablespace SYSAUX account lock;
grant the
required privileges to MDSYS by running:
SQL> @?/md/admin/mdprivs.sql
Install Spatial
by executing the steps shown below. Note you need to run this as a SYSDBA user!
SQL> connect / as sysdba
SQL> spool
spatial_installation_14jan2016.lst
SQL> @?/md/admin/mdinst.sql
SQL> spool off
Check whether is has installed and status is valid.
column comp_name format a35
column comp_id format a8
column version format a12
column status format a10
Select comp_name, comp_id, version, status
from dba_registry;
COMP_NAME COMP_ID VERSION STATUS
----------------------------------- -------- ------------ ----------
Oracle Database Catalog Views CATALOG 11.1.0.7.0 VALID
Oracle Database Packages and Types CATPROC 11.1.0.7.0 VALID
JServer JAVA Virtual Machine JAVAVM 11.1.0.7.0 VALID
Oracle Database Java Packages CATJAVA 11.1.0.7.0 VALID
Oracle XDK XML 11.1.0.7.0 VALID
Oracle XML Database XDB 11.1.0.7.0 VALID
Oracle Multimedia ORDIM 11.1.0.7.0 VALID
Spatial SDO
11.1.0.7.0 VALID.
There you good to go.................................................
Please subscribe for latest updates.
Please subscribe for latest updates.
