1 Answer
- Newest
- Most votes
- Most comments
0
Hello.
Yes, as you know, option groups created by default cannot be edited.
Therefore, if you want to edit an option group, you need to create an option group that is compatible with the RDS engine yourself.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithOptionGroups.html
Amazon RDS provides an empty default option group for each new DB instance. You can't modify or delete this default option group, but any new option group that you create derives its settings from the default option group. To apply an option to a DB instance, you must do the following:
- Create a new option group, or copy or modify an existing option group.
- Add one or more options to the option group.
- Associate the option group with the DB instance. To associate an option group with a DB instance, modify the DB instance. For more information, see Modifying an Amazon RDS DB instance.
The Oracle DB option group includes Amazon S3 integration.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.Options.html
Relevant content
- Accepted Answerasked 5 years ago
- asked a year ago
AWS OFFICIALUpdated 2 months ago- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 9 months ago
There are many default option groups you can select. For example for oracle there is Oracle EE and oracle SE, etc.
If I create a new option group using the Console how does it know which one to use to copy the default one? Can I use AWS console to copy the default one to a new one or I need to use CLI?
The contents that can be set in an option group are the same as the default option group, so please create a new custom option group. For now, if you create a new option group, it will have the same settings as the default option group. It is also possible to copy option groups via the AWS CLI. https://docs.aws.amazon.com/cli/latest/reference/rds/copy-option-group.html
I did test creating a new option group. The screen asks for "Major DB Engine" and "Release". I assume what you mean is that if I select "Oracle" and "19c" the new option group will include all the options from oracle-19c-ee option group?
I could not also see anything listed under the default option group. Do you know what options are actually installed with default? It seems when you add a new option like "APEX'" or "JVM", the RDS instance automatically install the additional software you select to the oracle instance.
By default, no options are set and nothing is added. So we need to create a custom option group to set the options. In the option group, you can set the following URL options. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.Options.html
Excellent Link and answer! One last thing, based on your last answer the new option group will have nothing to inherit from default option group. Correct? If I added a new option with APEX, JVM, S3_INTEGRATION does AWS immediately install/configure the new software into the RDS instance or there is a time lag and it happens in next patching or maintenance window?