I have migrated my local DB to amazon and everything was working fine, DB was up and running. Now I need to access the DB through SQL Developer or any other tool like. How do I able to access it?
Example: URL: http://ec2-10-20-30-40.compute-1.amazonaws.com
Internal IP: ip-10-20-30-40-ec2-internal
Note: I'm not using RDS which is in EC2
I resolved it by changing the tnsnames.ora and listener.ora files adding the external web entry url "ec2-10-20-30-40.compute-1.amazonaws.com" and now am able to access it externally.