Oracle是非常受欢迎的Relational DB，它在亚马逊RDS服务中具有企业版功能.几乎Oracle的每个功能都可以在RDS平台中使用.以下是RDS平台中MYSQL主要功能的简要说明.
版本11.2和12.1是RDS支持的主要版本平台.如果在创建数据库期间未提及任何版本，则默认为该时间点的最新版本.下面是如何在python SDK程序中使用AWS API获取受支持的数据库引擎版本的示例.
import boto3
client = boto3.client('rds')
response = client.describe_db_engine_versions(
DBParameterGroupFamily='oracle-ee-12.1',
DefaultOnly=True,
Engine='',
EngineVersion='',
ListSupportedCharacterSets=False, #True,
)
print(response)当我们运行上面的程序时，我们得到以下输出和减号;
{
"ResponseMetadata": {
"RetryAttempts": 0,
"HTTPStatusCode": 200,
"RequestId": "f6805635-3e16-4014-83cd-dfdaf3f17950",
"HTTPHeaders": {
"x-amzn-requestid": "f6805635-3e16-4014-83cd-dfdaf3f17950",
"date": "Fri, 14 Sep 2018 03:46:38 GMT",
"content-length": "1455",
"content-type": "text/xml"
}
},
"u'DBEngineVersions'": [
{
"u'Engine'": "oracle-ee",
"u'DBParameterGroupFamily'": "oracle-ee-12.1",
"u'SupportsLogExportsToCloudwatchLogs'": true,
"u'SupportsReadReplica'": false,
"u'DefaultCharacterSet'": {
"u'CharacterSetName'": "AL32UTF8",
"u'CharacterSetDescription'": "Unicode 5.0 UTF-8 Universal character set"
},
"u'DBEngineDescription'": "Oracle Database Enterprise Edition",
"u'EngineVersion'": "12.1.0.2.v12",
"u'DBEngineVersionDescription'": "Oracle 12.1.0.2.v12",
"u'ExportableLogTypes'": [
"alert",
"audit",
"listener",
"trace"
],
"u'ValidUpgradeTarget'": []
}
]
}在RDS中使用oracle许可有两种选择.它们是许可证并带有您自己的许可证.
在此模型中，亚马逊拥有您将要使用的软件的许可. AWS本身也通过其支持计划为AWS和Oracle软件提供支持.因此用户不购买任何单独的许可证.平台定价包括用户支付的许可费用.此型号支持的两个版本是Standard Edition One和Standard Edition Two.
在此模型中用户将她持有的许可证带入RDS平台.用户有责任维护许可证，数据库实例类和数据库版本之间的兼容性.用户可以直接联系Oracle支持渠道以满足任何需求.在此模型中，受支持的版本是企业版(EE)，标准版(SE)，标准版1(SE1)和标准版2(SE2).
对于多AZ部署，用户应拥有主数据库实例和辅助数据库实例的许可.
oracle数据库涉及要为数据库的各种功能和性能需求配置许多数据库参数. Aws通过CLI命令使这些参数可见，用户可以使用这些命令查询参数值.下面是CLI命令和示例输出.
aws rds describe-engine-default-parameters --db-parameter-group-family oracle-ee-12.1
以下是上述CLI命令获得的一些重要参数.
{
"EngineDefaults": {
"Parameters": [
{
"AllowedValues": "TRUE,FALSE",
"ParameterName": "_allow_level_without_connect_by",
"ApplyType": "dynamic",
"Description": "_allow_level_without_connect_by",
"IsModifiable": true,
"Source": "engine-default",
"DataType": "boolean"
},
{
"AllowedValues": "CHOOSE,OFF,CUBE,NESTED_LOOPS,MERGE,HASH",
"ParameterName": "_always_semi_join",
"ApplyType": "dynamic",
"Description": "_always_semi_join",
"IsModifiable": true,
"Source": "engine-default",
"DataType": "string"
},
{
"AllowedValues": "TRUE,FALSE",
"ParameterName": "_b_tree_bitmap_plans",
"ApplyType": "dynamic",
"Description": "_b_tree_bitmap_plans",
"IsModifiable": true,
"Source": "engine-default",
"DataType": "boolean"
},
{
"AllowedValues": "TRUE,FALSE",
"ParameterName": "parallel_automatic_tuning",
"ApplyType": "static",
"Description": "enable intelligent defaults for parallel execution parameters",
"IsModifiable": true,
"Source": "engine-default",
"DataType": "boolean"
},
{
"AllowedValues": "ENABLE,DISABLE",
"ParameterName": "xml_db_events",
"ApplyType": "dynamic",
"Description": "are XML DB events enabled",
"IsModifiable": false,
"Source": "engine-default",
"DataType": "string"
}
]
}
}
