Database | Amazon RDS for Oracle Database Flashcards

1
Q

What types of licensing options are available with Amazon RDS for Oracle?

Licensing and Support

Amazon RDS for Oracle Database | Database

A

There are two types of licensing options available for using Amazon RDS for Oracle:

Bring Your Own License (BYOL): In this licensing model, you can use your existing Oracle Database licenses to run Oracle deployments on Amazon RDS. To run a DB instance under the BYOL model, you must have the appropriate Oracle Database license (with Software Update License & Support) for the DB instance class and Oracle Database edition you wish to run. You must also follow Oracle’s policies for licensing Oracle Database software in the cloud computing environment. DB instances reside in the Amazon EC2 environment, and Oracle’s licensing policy for Amazon EC2 is located here.

License Included: In the “License Included” service model, you do not need separately purchased Oracle licenses; the Oracle Database software has been licensed by AWS. “License Included” pricing is inclusive of software, underlying hardware resources, and Amazon RDS management capabilities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which Oracle Database Editions are available with Amazon RDS for Oracle?

Licensing and Support

Amazon RDS for Oracle Database | Database

A

Amazon RDS currently supports the following Oracle Database editions under each of the licensing models below:

BYOL: Standard Edition Two (SE2), Standard Edition One (SE1), Standard Edition (SE), and Enterprise Edition (EE)

License Included: Standard Edition One (SE1), and Standard Edition Two (SE2)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the licensing policies for using Amazon RDS for Oracle?

Licensing and Support

Amazon RDS for Oracle Database | Database

A

BYOL: To run a DB instance under the BYOL model, you must have the appropriate Oracle Database license (with Software Update License & Support) for the DB instance class and Oracle Database edition you wish to run. You must follow Oracle’s policies for licensing Oracle Database software in the cloud computing environment. DB instances reside in the Amazon EC2 environment, and Oracle’s licensing policy for Amazon EC2 is located here.

License Included: In the “License Included” service model, you do not need separately purchased Oracle licenses; the Oracle Database software has been licensed by AWS.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How is Amazon RDS for Oracle supported?

Licensing and Support

Amazon RDS for Oracle Database | Database

A

BYOL: Under this model, you continue to use your active Oracle support account and contact Oracle directly for Oracle Database specific service requests. If you have an active AWS Premium Support account, you can contact AWS Premium Support for Amazon RDS specific issues. Amazon Web Services and Oracle have multi-vendor support process for cases which require assistance from both organizations.

License Included: In this model, if you have an active AWS Premium Support account, you should contact AWS Premium Support for both Amazon RDS and Oracle Database specific service requests.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How does the license option impact DB instance scaling?

Licensing and Support

Amazon RDS for Oracle Database | Database

A

BYOL: You may scale your DB instances in accordance with the terms of your Oracle license(s).

License Included: DB instances running Oracle may be scaled up and down at any point, subject to the prevailing hourly pricing for each DB instance class.

For more information on the scaling implications of reserved DB instances, see the reserved instance page.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How does the license option impact version upgrades?

Licensing and Support

Amazon RDS for Oracle Database | Database

A

BYOL: You should have “Software Update License & Support” from Oracle to use Amazon RDS for Oracle Database.

License Included: The cost of the “Software Update License” is embedded in the hourly price, enabling access to Oracle Database software updates.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Can I change the licensing option for my DB instance (e.g. from ‘BYOL’ to ‘License Included’)?

Licensing and Support

Amazon RDS for Oracle Database | Database

A

Yes, you can use change your license options through the AWS CLI or through the AWS console by selecting Modify Instance and selecting the appropriate option in the ‘Licensing Model’ dropdown.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Can I change the Oracle edition I’m running for a DB instance (e.g. from Oracle 11g R2 SE2 to EE)?

Database Engine Versions

Amazon RDS for Oracle Database | Database

A

For the BYOL model, you can migrate from one edition of Oracle software to another as long as you possess an unused Oracle license appropriate for the edition and class of DB instance you plan to run. To change the edition and retain your data, you should take a snapshot of your running DB instance and then create a new DB instance of the desired edition from that snapshot. You should then delete the old DB instance, unless you wish to keep it running and have the appropriate Oracle Database licenses.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are Amazon RDS DB engine versions for Oracle and how do they relate to Oracle Patch Sets?

Database Engine Versions

Amazon RDS for Oracle Database | Database

A

In the context of Oracle, Amazon RDS DB engine versions are organized as follows:

DB Engine Versions for Oracle = X.Y.Z

X = Major version (for ex: 11.2), Y = Release level (for ex: 0.2), Z = version number within release series (for ex: v2). For example, a DB Engine version for Oracle could be 11.2.0.2.v2

Oracle releases Database Patch Set Updates (PSU) for supported release levels on a quarterly basis. (e.g. 11.2.0.2.1). The PSUs include security fixes and additional non-security fixes recommended by Oracle.

The Amazon RDS DB Engine Versions are built with a given PSU as a baseline and may contain additional fixes beyond it.

From the Amazon RDS standpoint, a version change would be considered major if either major version or release level is being changed. Example: going from 11.2.0.2.Z -> 11.2.0.4.Z. A version change would be considered minor if the version number within the release is being changed. Example: going from 11.2.0.2.v2 -> 11.2.0.2.v3.

As of today, Amazon RDS supports major versions 11.2 (11g Release 2) and 12c. We plan to support additional major versions in the future.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the patch set composition of my DB engine version for Oracle?

Database Engine Versions

Amazon RDS for Oracle Database | Database

A

Refer to the Amazon RDS User Guide for details of the patch set composition of each DB engine version of Oracle.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Does Amazon RDS provide guidelines for upgrading engine versions or deprecation of engine versions that are currently supported?

Options and Features

Amazon RDS for Oracle Database | Database

A

Yes. Please refer to the Amazon RDS FAQs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What types of replication does Amazon RDS support for Oracle?

Options and Features

Amazon RDS for Oracle Database | Database

A

Amazon RDS for Oracle supports Multi-AZ deployments for both the License Included and Bring Your Own License (BYOL) licensing models.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Does Amazon RDS use Oracle Data Guard for Multi-AZ deployments?

Options and Features

Amazon RDS for Oracle Database | Database

A

Oracle Data Guard is a High Availability feature available for Enterprise Edition of Oracle database. Amazon RDS currently uses a different synchronous replication technology and automatic failover functionality to provide Multi-AZ deployments for Oracle DB Instances. Multi-AZ deployments are available for all Oracle database editions supported by Amazon RDS.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Will I need an additional license(s) if I use Multi-AZ deployments for my Oracle DB Instances under the “BYOL” licensing model?

Options and Features

Amazon RDS for Oracle Database | Database

A

Yes, we expect that you will need to use twice as many licenses for Multi-AZ deployments as you would for a corresponding Single-AZ deployment to account for the stand by DB Instance. However, you should review your Oracle Software Licensing Agreement and comply with Oracle’s licensing policies.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Is Oracle RAC supported on Amazon RDS?

Options and Features

Amazon RDS for Oracle Database | Database

A

No, RAC is not currently supported.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which Enterprise Edition Options are supported on Amazon RDS?

Options and Features

Amazon RDS for Oracle Database | Database

A

Following Enterprise Edition Options are currently supported under the BYOL model:

Advanced Security (Transparent Data Encryption, Native Network Encryption)

Partitioning

Management Packs (Diagnostic, Tuning)

Advanced Compression

Total Recall

17
Q

Which character sets are supported on Amazon RDS for Oracle?

Options and Features

Amazon RDS for Oracle Database | Database

A

Amazon RDS supports the thirty character sets in the Oracle “Recommended ASCII Database Character Sets” list. You can specify your desired character set when creating a new database instance. This is optional and the default character set is AL32UTF8. For more information, please refer to the Amazon RDS Documentation.