View a markdown version of this page

Phase 0 – Initial setup phase - AWS Prescriptive Guidance

Phase 0 – Initial setup phase

  1. Install Oracle database 12.1.0.2 or later on the target Amazon Elastic Compute Cloud (Amazon EC2) instance.

  2. Verify the target database.

    You must verify whether the target database instance has the same time zone and character set as source database. Otherwise, this migration approach will fail

    To check that the time zone version in both the source and target is same, run the following command.

    SQL> select * from v$timezone_file;
FILENAME            VERSION    CON_ID
-----------------------   -------------   ----------
timezlrg_14.dat        14               0

    To check that both the DB character set and the national character set are the same in the source and target, run the following command.

    SQL> select * from nls_database_parameters
         where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');
PARAMETER                                  VALUE
--------------------------------------------   --------------------
NLS_NCHAR_CHARACTERSET         UTF8
NLS_CHARACTERSET                    AL32UTF8

  3. Set up the Oracle XTTS utility.

    On the source system, download and extract the script file, rman_xttconvert_VER4.zip from Oracle document 2471245.1. Modify the parameters in the xtt.properties file with the specific configuration. Then copy xtt.properties and xttdriver.pl scripts to the destination system.