Creating the Update Readiness Tool database account for Amazon RDS for Oracle

You can run the Update Readiness Tool from the command prompt on the Enforce Server host computer.
  1. Log on as the RDS Master user.
    The following steps use
    masteruser
    for the RDS Master user and
    password
    for the password. Enter information specific to your implementation for these values.
  2. Run the following script:
    sqlplus
    masteruser
    /
    password
    @endpoint_name.rds.amazonaws.com:1521/
    protect
  3. Run the following script to grant full access to the
    DATA_PUMP_DIR
    to the "protect" user:
    SQL> GRANT read,write on DIRECTORY DATA_PUMP_DIR to
    protect
    ;
  4. Run the following script to logon to the Amazon RDS for Oracle:
    sqlplus
    Oracle RDS username
    /
    password
    @endpoint_name.rds.amazonaws.com:1521/
    RDS Servicename
    Replace
    Oracle RDS username
    ,
    password
    , and
    RDS Servicename
    with information specific to your implementation.
  5. Run the following script to create the Update Readiness Tool database account:
    SQL> @oracle_create_user_aws_oracle_rds.sql
  6. Enter the following information where prompted:
    • protect
      at
      Please enter the database username:
    • protect
      at
      Please enter the database user password:
    • protect_urt
      at
      Please enter the database readiness username:
    • protect
      at
      Please enter the database readiness user password:
    • endpoint_name.rds.amazonaws.com:1521/protect
      at
      Please enter the database service name: