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.
|
1 2 3 4 5 6 7 8 |
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.
|
1 |
SQL> select username from dba_users where username like 'MD%'; |
Step 4:
Execute scripts to install Oracle Spatial.
|
1 2 3 4 |
SQL> spool /tmp/spatial_install.log; SQL> @/u01/app/oracle/product/11.2.0.4/dbhome_1/md/admin/mdprivs.sql; SQL> @/u01/app/oracle/product/11.2.0.4/dbhome_1/md/admin/mdinst.sql; SQL> spool off; |
Step 5:
Verify Oracle Spatial is installed correctly. There should not be any invalid objects in MDSYS account.
|
1 2 3 4 5 6 7 8 9 10 |
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 11.2.0.4.0 VALID Spatial 1 row selected. |
Check invalid objects.
|
1 2 3 4 5 6 |
SQL> SELECT object_name, object_type, status FROM dba_objects WHERE owner = 'MDSYS' AND status <> 'VALID' ORDER BY 1; no rows selected |
Check database options.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SQL> select comp_name from dba_registry where status = 'VALID' order by comp_name; COMP_NAME -------------------------------------------------------------------------------- JServer JAVA Virtual Machine Oracle Database Catalog Views Oracle Database Java Packages Oracle Database Packages and Types Oracle Expression Filter Oracle Multimedia Oracle Real Application Clusters Oracle Rules Manager Oracle Text Oracle Workspace Manager Oracle XDK Oracle XML Database |
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
One Response to “Installation of Oracle Spatial 11.2.0.4”
JThomas
Excellent article !