This section provides the steps to set up an Oracle server on an Amazon Web Services (AWS) Relational Database Service (RDS).

  1. Open an AWS account with an AWS master account named, for example, "AWSME".

Tip

You can sign up for an Amazon AWS account by navigating to https://portal.aws.amazon.com/gp/aws/developer/registration/index.html and then follow the directions on the screen.

  1. Login to AWS as master user AWSME and create an AWS Identity and Access Management (IAM) user account named, for example, "PERSEPHONE".

Tip

Refer to Amazon's "To create an IAM user for yourself" section on the Creating an Administrators Group Using the Console page for more information.

  1. Create an RDS database named, for example, "PERSDB" (with sufficient storage space and processing power) with IAM user PERSEPHONE as the master user.

Note

The creation of an RDS database instance incurs charges to your AWS master account.

In addition, you must use the WE8MSWIN1252 character set. Using any other character set may result in unpredictable complications. You will then be forced to create another RDS database at an additional cost to you.

  1. Login to PERSDB as Oracle user PERSEPHONE.
  2. Create a tablespace named, for example, "PERSEPHONE_TS". The following would create a 120GB tablespace named "PERSEPHONE_TS" in 30GB segments.

CREATE TABLESPACE PERSEPHONE_TS datafile '/oradat/persephone/persephone_01.dbf'
size 30g extent management local segment space management auto;
   ALTER TABLESPACE PERSEPHONE_TS add datafile
'/oradat/persephone/persephone_02.dbf' size 30g;
   ALTER TABLESPACE PERSEPHONE_TS add datafile
'/oradat/persephone/persephone_03.dbf' size 30g;
   ALTER TABLESPACE PERSEPHONE_TS add datafile
'/oradat/persephone/persephone_04.dbf' size 30g;

  1. Alter user PERSEPHONE's default tablespace to PERSEPHONE_TS as shown in the example below.

SQL> alter user PERSEPHONE default tablespace PERSEPHONE_TS

  1. Increase/Resize the TEMP tablespace to 2GB or more as shown in the example below.

SQL> alter tablespace TEMP resize 2GB

  1. Logoff from PERSDB (as Oracle user PERSEPHONE).
  2. Run PersephoneShell utility to initialize the database schema (command init).

PS> init -v


Optional: Oracle Server Maintenance Utilities

Refer to Oracle Maintenance Utilities for SQL commands to view and modify your Oracle database.