Oracle Spatial on RDS

Question

Hi,

I am currently working with spatial data in oracle which we are using for geospatial analysis. we use a lot of functions which are inbuilt with the oracle DB engine for our spatial data processing. I would like to know if Amazon RDS supports Oracle Spatial data. Also if yes what all versions of DB engines and editions are supported on this? Also I would like to know some best practices on working with spatial data in RDS.

Nice Kurian · Accepted Answer

Hi Jin,

Amazon RDS supports Oracle Spatial through the use of the SPATIAL option. Oracle Spatial provides a SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial data in an Oracle database. One thing to note is that If you use Oracle Spatial, Amazon RDS automatically updates your DB instance to the latest Oracle PSU when any of the following exist:

*  Security vulnerabilities with a Common Vulnerability Scoring System (CVSS) score of 9+
*  Other announced security vulnerabilities

Regarding the engine versions, Amazon RDS supports Oracle Spatial only in Oracle Enterprise Edition (EE) and Oracle Standard Edition 2 (SE2) for 19c and 21c DB versions. You can obtain more details in the link below.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Options.Spatial.html

The following are best practices for using Oracle Spatial:

For maximum security, use the SPATIAL option with Secure Sockets Layer (SSL). For more information, see Oracle Secure Sockets Layer. [https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html]

•  Configure your DB instance to restrict access to your DB instance. For more information, see Scenarios for accessing a DB instance in a VPC [https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html]

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquirers in Repost, thank you.

Nice Kurian · Answer

Hi,

The Spatial option can be added to a DB instance by following the below steps.

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.

If Oracle Java Virtual Machine (JVM) is not installed on the DB instance, there is a brief outage while the SPATIAL option is added. There is no outage if Oracle Java Virtual Machine (JVM) is already installed on the DB instance. After you add the option, you don't need to restart your DB instance. As soon as the option group is active, Oracle Spatial is available.

Detailed steps are available in the below link. Please let me know if you have any further queries on this.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Options.Spatial.html#Oracle.Options.Spatial.Add

Oracle Spatial on RDS

Relevant content