RDS Oracle Spatial option not enabled

Question

Hello,
I have created a RDS option group with SPATIAL option and use it with my instance (reboot instance).
Followed instructions from here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Options.Spatial.html
I had no errors in the console but running the following query it returns false for the value column:
*select
   parameter, value
from
   v$option where upper(parameter) ='SPATIAL'
order by 1 desc;*

Any ideas how to check what happened?
Thanks!

Answer

Hi I did a quick test with RDS Oracle 19.0.0.0.ru-2022-10.rur-2022-10.r1 EE version.

After adding the option into the option group and running the query shared, I got TRUE for the result. Note, restart is not required.

Looks like we might need a deeper look into the instance, if you have support plan I would suggest reach support to check further. If no support plan,

I would suggest check the page: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Options.Spatial.html for 
1. prerequisites?
2. Status of the option group: is it in status "in sync"?
3. Is instance status in Available state?
4. If having another environment, can test adding option from scratch
5. for the existing instance, drop the option and re-add see if that fix issue or not.

RDS Oracle Spatial option not enabled

Relevanter Inhalt