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.
Thank you for sharing and greetings from Consolepark.
ReplyDeletecloud hosting providers
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.
ReplyDeleteCloud For Developers I Cloud Control I Managed Cloud solution
Just as I want for research. Thank you very much for sharing this very informative blog. Keep it up! :)
ReplyDeletephilwebservices
Oracle RDS on AWS - Connecting with DB tools the software used in like mysql its useful.
ReplyDeleteMicrosoft SPLA
Good information you have gave regarding the use of oracle in cloud. Really this cloud computing is a great technology which provides various benefits.
ReplyDeletecloud accounting
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.
ReplyDeleteThanks for sharing this useful links. Now i can get some useful information on oracle RDS connection in AWS. I am using AWS managed services from SupraITS and they provide all services but i will get some better opportunity to read myself.
ReplyDeletesimply superb,mind blowing, i will share your blog to my friends also
ReplyDeleteAWS Online Training