- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
Hi,
The Spatial option can be added to a DB instance by following the below steps.
- Create a new option group, or copy or modify an existing option group.
- Add the option to the option group.
- 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.
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
Is the spatial functionality present in the RDS by default or do we need to add anything additional for configuring it.?