Manual Installation of Spatial 10g

Steps for Manual Installation of Spatial 10g


Oracle Spatial is designed to make spatial data management easier and more natural to users of location-enabled applications and geographic information system (GIS) applications. When spatial data is stored in an Oracle database, it can be easily manipulated, retrieved, and related to all other data stored in the database.


To be able to do a successful Spatial 10g installation you need to have the following products already installed:

JServer JAVA Virtual Machine
Oracle interMedia
Oracle XML Database

SQL> select comp_id,version,status from dba_registry where comp_id in ('JAVAVM','ORDIM','XDB');


If the MDSYS user does NOT exist:

create the user MDSYS by running following command:

SQL> create user MDSYS identified by xxxxx default tablespace SYSAUX account lock;

grant the required privileges to MDSYS by running:

SQL> @?/md/admin/mdprivs.sql

If the MDSYS user already exists then you are advised to verify if the installation has been done correctly and de-install Spatial first in case of re-installation.

See the verification checks at the bottom of this note and a link to de-installation note.

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.lst
SQL> @?/md/admin/mdinst.sql
SQL> spool off

SQL> alter user MDSYS account lock;


Execute the following steps to verify if Spatial is installed correctly:

SQL> connect / as sysdba
SQL> set serveroutput on
SQL> execute validate_sdo;
SQL> select comp_id, control, schema, version, status, comp_name from dba_registry
where comp_id='SDO';
SQL> select object_name, object_type, status from dba_objects
where owner='MDSYS' and status <> 'VALID'
order by object_name;

A sample valid 10.2.0.4.0 installation shows the following output:

SQL> execute validate_sdo;

PL/SQL procedure successfully completed.

SQL> select comp_id, control, schema, version, status, comp_name from dba_registry
where comp_id='SDO';

COMP_ID CONTROL
------------------------------ ------------------------------
SCHEMA VERSION STATUS
------------------------------ ------------------------------ -----------
COMP_NAME
--------------------------------------------------------------------------------
SDO SYS
MDSYS 10.2.0.4.0 VALID
Spatial


no rows selected