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.
- Log on as the RDS Master user.The following steps usemasteruserfor the RDS Master user andpasswordfor the password. Enter information specific to your implementation for these values.
- Run the following script:sqlplusmasteruser/password@endpoint_name.rds.amazonaws.com:1521/protect
- Run the following script to grant full access to theDATA_PUMP_DIRto the "protect" user:SQL> GRANT read,write on DIRECTORY DATA_PUMP_DIR toprotect;
- Run the following script to logon to the Amazon RDS for Oracle:sqlplusOracle RDS username/password@endpoint_name.rds.amazonaws.com:1521/RDS ServicenameReplaceOracle RDS username,password, andRDS Servicenamewith information specific to your implementation.
- Run the following script to create the Update Readiness Tool database account:SQL> @oracle_create_user_aws_oracle_rds.sql
- Enter the following information where prompted:
- protectatPlease enter the database username:
- protectatPlease enter the database user password:
- protect_urtatPlease enter the database readiness username:
- protectatPlease enter the database readiness user password:
- endpoint_name.rds.amazonaws.com:1521/protectatPlease enter the database service name: