Database Pre-installation Tasks for Oracle

Create Locator Component for Oracle Database

By default when an Oracle database is created using DBCA or Oracle Installer Enterprise Edition with create database option, the SDO_Geometry object type will be default created as part of locator component.

If the database is created using scripts by following manual process, then the Locator component will not be created. You need to create the locator component for your Oracle database separately.

Verify if the locator component is already installed.

Run the following queries in the Oracle database used for Installer:

Select comp_name, version, status from dba_registry where upper(comp_name) like '%MEDIA';

Select username from dba_users where username = 'MDSYS'

If the above statements return zero records and MDSYS schema is not created, then follow these steps to create the MDSYS schema and install the locator component manually.

The following steps need to be executed by a SYSDBA only.

To create Locator or MDSYS schema, follow the steps mentioned in either option #1 or option #2:

• Option #1. Follow DBCA or Oracle Installer enterprise edition with create database option to create Oracle database. Use the same database during Quantum Fabric Installation.
• Option #2. Run the following scripts on the database to be used for Quantum Fabric, where Oracle locator is not installed.

  1. Connect as SYSDBA

     sqlplus "/as sysdba"

  2. Create MDSYS User if not exists:

     Create user mdsys identified by secret default tablespace sysaux

     A secret is a dummy password. Provide the password that is used during MDSYS user creation.

  3. Run the below SQL to grant the privileges:

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

  4. Connect to MDSYS user:

     Conn mdsys/secret

     A secret is dummy password. Provide the password that is used during MDSYS user creation.

  5. Run the below SQL to create the locator objects:

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

  All the specified .sql files are available as part of database software md folder.

  After performing the steps, run the following query to verify the files:

  Select * from dba_objects where owner='MDSYS' and object_name like 'SDO%';

  After the Oracle locator is installed, run the Installer to setup Quantum Fabric. The system must not throw the error: Invalid Data Type SDO_GEOMETRY

  NOTE: Based on the Oracle 12c Release 1 (12.1) documentation, Oracle Locator is available with the following editions:

  • Oracle Database Standard Edition One
  • Oracle Database Standard Edition
  • Oracle Database Enterprise Edition
  • Oracle Database Express Edition (Oracle Database XE)

  For more information about Oracle licensing, refer to Oracle Database documentation.

  IMPORTANT: SDO_GEOMETRY is part of Oracle Locator, which is free and does not need additional licensing, but this is bundled with Oracle Spatial, which is part of enterprise edition licensing.
  
  For more details, refer to the following Oracle reference document:
  Doc ID 1066837.1 :- Oracle Spatial and Oracle Locator Licensing Information.