Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Oracle Locator

Amazon RDS supports Oracle Locator through the use of the LOCATOR option. Oracle Locator provides capabilities that are typically required to support internet and wireless service-based applications and partner-based GIS solutions. Oracle Locator is a limited subset of Oracle Spatial. For more information, see Oracle Locator in the Oracle documentation.

Important

If you use Oracle Locator, Amazon RDS automatically updates your DB instance to the latest Oracle PSU if there are security vulnerabilities with a Common Vulnerability Scoring System (CVSS) score of 9+ or other announced security vulnerabilities.

Amazon RDS supports Oracle Locator for the following editions and versions of Oracle:

  • Oracle Standard Edition (SE2) or Enterprise Edition, version 12.1.0.2.v6 or later

  • Oracle Standard Edition (SE, SE1) or Enterprise Edition, version 11.2.0.4.v10 or later

Prerequisites for Oracle Locator

The following are prerequisites for using Oracle Locator:

  • Your DB instance must be inside a virtual private cloud (VPC). For more information, see Determining Whether You Are Using the EC2-VPC or EC2-Classic Platform.

  • Your DB instance must be of sufficient class. Oracle Locator is not supported for the db.m1.small, db.t2.micro, or db.t2.small DB instance classes. For more information, see DB Instance Class Support for Oracle.

  • Your DB instance must have Auto Minor Version Upgrade enabled. Amazon RDS updates your DB instance to the latest Oracle PSU if there are security vulnerabilities with a CVSS score of 9+ or other announced security vulnerabilities. For more information, see Settings for Oracle DB Instances.

  • If your DB instance is version 11.2.0.4.v10 or later, you must install the XMLDB option. For more information, see Oracle XML DB.

Best Practices for Oracle Locator

The following are best practices for using Oracle Locator:

Adding the Oracle Locator Option

The following is the general process for adding the LOCATOR option to a DB instance:

  1. Create a new option group, or copy or modify an existing option group.

  2. Add the option to the option group.

  3. Associate the option group with the DB instance.

There is a brief outage while the LOCATOR option is added. After you add the option, you don't need to restart your DB instance. As soon as the option group is active, Oracle Locator is available.

To add the LOCATOR option to a DB instance

  1. Determine the option group that you want to use. You can create a new option group or use an existing option group. If you want to use an existing option group, skip to the next step. Otherwise, create a custom DB option group with the following settings:

    1. For Engine, choose the oracle edition for your DB instance.

    2. For Major Engine Version, choose 11.2 or 12.1 for your DB instance.

    For more information, see Creating an Option Group.

  2. Add the LOCATOR option to the option group. For more information about adding options, see Adding an Option to an Option Group.

  3. Apply the option group to a new or existing DB instance:

Using Oracle Locator

After you enable the Oracle Locator option, you can begin using it. You should only use Oracle Locator features. Don't use any Oracle Spatial features unless you have a license for Oracle Spatial.

For a list of features that are supported for Oracle Locator, see Features Included with Locator in the Oracle documentation.

For a list of features that are not supported for Oracle Locator, see Features Not Included with Locator in the Oracle documentation.

Removing the Oracle Locator Option

You can remove the LOCATOR option from a DB instance. There is a brief outage while the option is removed. After you remove the LOCATOR option, you don't need to restart your DB instance.

Warning

Removing the LOCATOR option can result in data loss if the DB instance is using data types that were enabled as part of the option. Back up your data before proceeding. For more information, see Backing Up and Restoring Amazon RDS DB Instances.

To remove the LOCATOR option from a DB instance, do one of the following:

  • Remove the LOCATOR option from the option group it belongs to. This change affects all DB instances that use the option group. For more information, see Removing an Option from an Option Group.

  • Modify the DB instance and specify a different option group that doesn't include the LOCATOR option. This change affects a single DB instance. You can specify the default (empty) option group or a different custom option group. For more information, see Modifying a DB Instance Running the Oracle Database Engine.

Related Topics