Connect To The Source Oracle Database

  1. Once connected, open Oracle SQL Developer from the Taskbar. Note your icons maybe in a different order than the image below.

  2. Click on the plus sign from the left-hand menu to create a New Database Connection using the following values, Please note the password is not provided below you need to goto Secrets Manager and open DMSDBSecret and reveal the password. It is also on first Cloudformation Stack’s output tab (note it is the same if you’ve already gotten it from there) then click Connect.

    ParameterValue
    Connection NameSource Oracle
    Usernamedbadmin
    PasswordSee Cloudformation Output tab for the “cfn%” stack and obtain the value found for “DMSDBSecretP” or look it up in AWS Secrets Manager in the secret for Oracle
    Save PasswordCheck
    Hostname< SourceOracleEndpoint (you can find this in Cloudformation Output tab or goto RDS service in console and pick your RDS Oracle Source instance)>
    Port1521
    SIDORACLEDB

  3. After the you see the test status as Successful, click Connect. Your window should look like below.