Oracle RDS upgrade to 12.2 not supported

Question

Hi,  
  
I need to upgrade our development database to 12.2 (to make use of new json functionality).  
  
**Attribute                   Current value                                      New value**  
DB engine version	12.1.0.2.v14 (Oracle 12.1.0.2.v14)	12.2.0.1.ru-2019-01.rur-2019-01.r1   
                                                                                        (Oracle 12.2.0.1.ru-2019-01.rur-2019-01.r1)  
  
This is a t2.micro instance. With an option group including Apex (v5.14), Apex_dev and utl_mail. When I attempt the modification I get this message:  
  
RDS does not support creating a DB instance with the following combination: DBInstanceClass=db.t2.micro, Engine=oracle-se2, EngineVersion=12.2.0.1.ru-2019-01.rur-2019-01.r1, LicenseModel=license-included. For supported combinations of instance class and database engine version, see the documentation. (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination; Request ID: 36639790-1ee2-4907-8368-4fadc8f1fef5)  
  
Please advise  
  
Thanks  
  
Ralph

Answer

Howdy Ralph!  
  
The "micro" instance types are no longer supported with RDS Oracle as of Oracle Database 12.2. You will need to scale to a db.t2.small or similar before you will be able to upgrade. To see a full list of supported instance classes please refer to our documentation.  
  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Oracle.html#Oracle.Concepts.InstanceClasses  
  
Hope this helps. Thanks!  
Michael

Answer

Turns out micro instances are not supported with v12.2. You need minimum small. This is a shame as they cost much more.

Answer

Unfortunately. But not a huge surprise. I believe Micro instances were always documented as not meeting Oracle's configuration requirements and only for use for limited testing. 12.2 probably had just enough increase in resource requirements to cause performance to fall off a cliff on the memory constrained Micros.  
  
Edited by: HalTemp on Mar 22, 2019 5:07 AM

Oracle RDS upgrade to 12.2 not supported

関連するコンテンツ