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:

SQL> SELECT comp_id, version, status FROM dba_registry
WHERE comp_id IN ('JAVAVM','ORDIM','XDB')

COMP_ID VERSION STATUS

ORDIM 11.2.0.4.0 VALID
XDB 11.2.0.4.0 VALID
JAVAVM 11.2.0.4.0 VALID

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

select username from dba_users where username like 'MD%'

USERNAME

MDSYS
MDDATA

-------------------------------------------------------------------------
Step 4: Execute scripts to install Oracle Spatial:

SQL> spool D:\temp\spatial_install.txt

SQL> @D:\app\Oracle\product\11.2.0.4.0\dbhome_1\md\admin\mdprivs.sql

SQL> @D:\app\Oracle\product\11.2.0.4.0\dbhome_1\md\admin\mdinst.sql

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

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                        11.2.0.4.0 VALID   Spatial                
                                                                     
                                                                               
1 row selected.
------------------------------------------------------------------

SQL> SELECT object_name, object_type, status FROM dba_objects
 WHERE  owner = 'MDSYS'
 AND    status <> 'VALID'
ORDER BY 1


no rows selected