Connect to the EC2 Instance


  1. Go to the AWS EC2 console and click on Instances in the left column.

    \[EC2-Connect-01\]

  2. Select the instance with the name <StackName>-EC2Instance and then click the Actions button. Click on Connect.

    \[EC2-Connect-02\]

  3. Go to the RDP client section, and click on Get Password.

    \[EC2-Connect-03\]

  4. Click on Browse and upload the Key Pair file that you downloaded earlier.

  5. Click on Decrypt Password.

    \[EC2-Connect-04\]

  6. Copy the generated password to your notepad. You will use this password to connect to login to the EC2 instance.

    \[EC2-Connect-05\]

  7. Click on Download Remote Desktop File to download the RDP file to access this EC2 instance.

  8. Connect to the EC2 instance using a RDP client.

  9. Once connected, open SQL Server Management Studio from the Start Menu.

    \[SqlServer-to-SqlServerRDS-05\]

  10. Once connected, open Oracle SQL Developer from the Task Bar.

    \[Oracle-to-Oracle-05\]

  11. Click on the plus sign from the left-hand menu to create a New Database Connection using the following values, then click Connect.

    Parameter Value
    Connection Name Source Oracle
    Username dbmaster
    Password dbmaster123
    **Save Password ** Check
    Hostname < SourceOracleEndpoint >
    Port 1521
    SID ORACLEDB

    \[Oracle-to-Oracle-06\]

  12. After the you see the test status as Successful, click Connect.