I created a Relational Database Service (RDS) with Oracle database at Amazon Web Services (aws.amazon.com). However, when I attempt to connect to the database (with SQLDeveloper or Navicat), I am getting:
ORA-12545: Connect failed because target host or object does not exist
Other databases in RDS work (I tested MySQL and PostgreSQL). Based on the error message I know that I can connect to the database and it's not a firewall issue.
When I connect to the database with:
nc -zv oracle3.cocvztbjagzq.us-west-2.rds.amazonaws.com 1521
I am getting:
Connection to oracle3.cocvztbjagzq.us-west-2.rds.amazonaws.com port 1521 [tcp/ncube-lm] succeeded!
I tried to reboot the DB instance and wait for a few hours. But that neither help.
Do you have an idea how to fix the problem?
Note: RDS from Amazon is provided as a service – I do not have access to the operation system.
Best Answer
Are you able to run this command from a client that has the AWS tools configured ? (you could launch an EC2 instance with an Amazon AMI Linux image which is already configured to run this command if not)
rds-describe-db-instances --headers
This should return info to verify the port number and hostname as per here