Thursday, August 30, 2012

Oracle RDS on AWS - Connecting with DB tools

After taking some time to make sure security groups for my Oracle RDS instances were set properly, I was able to connect to two Oracle RDS instances I have spun up.  A few comments on the various tools:
1. SQL Plus - You can use the instant client latest 11g release.  You do need to make sure the connect string is set properly.  How to do this can be found here:
http://docs.amazonwebservices.com/AmazonRDS/2012-01-15/UserGuide/USER_ConnectToOracleInstance.html
2. SQL Developer - I used the 64 bit version that does not have the JDK installed so you will need to download the JDK separately,
3. TOAD - You need to point TOAD to the Oracle client software. This is done by adding Oracle client to the system path.  I have another blog entry on this.

Connecting to an EC2 based Oracle instance works the same way.

6 comments:

  1. Thank you for sharing and greetings from Consolepark.
    cloud hosting providers

    ReplyDelete
  2. Cloud Computing Really Works and What are its Benefits for Ordinary Users is really impressive. The benifts of cloud computing are explained in such a easy manner. Ordinary users will surely implement cloud computing with help of this blog. Thanks for sharing such valuable information.

    Cloud For Developers I Cloud Control I Managed Cloud solution


    ReplyDelete
  3. Just as I want for research. Thank you very much for sharing this very informative blog. Keep it up! :)
    philwebservices

    ReplyDelete
  4. Oracle RDS on AWS - Connecting with DB tools the software used in like mysql its useful.

    Microsoft SPLA

    ReplyDelete
  5. Good information you have gave regarding the use of oracle in cloud. Really this cloud computing is a great technology which provides various benefits.
    cloud accounting

    ReplyDelete
  6. Where do you run the the sqlplus from? from your local machine? I am using AWS and could not connect to the endpoint db not sure what the CLI meant as well if its from my local machine or from somewherein AWS.

    ReplyDelete