By using AWS re:Post, you agree to the Terms of Use

Oracle RDS upgrade to 12.2 not supported

0

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

Topics
Tags
asked 4 years ago46 views
3 Answers
0

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

answered 4 years ago
0

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

answered 4 years ago
0

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

answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions