Skip to content

Archive for

ORA-12203: TNS:unable to connect to destination

I just created one test db on my local PC (Windows 7) .This pc connected through Domain network.When I trying to connect this db one of the schema from application server. It shows
Enter user-name: prem_saico_auh/prem_saico_auh@azardb
ORA-12203: TNS:unable to connect to destination

This Error may be occur, your db server not reachable for client machine Either Ipaddress wrong or ping or Firewall Blocked.

Firewall : This is the case for me. So I looked my firewall settings of my local PC, The Firewall is OFF. But the Domain network firewall is ON.

So I need to Switch OFF firewall for my domain network. But I cann’t without Network Administrator Advise. So I just decided , Atleast I want to Enable allow inbound connections, I just fixed and then I can easily connect my db from Appication Server.

How do We do?

Go –> Control Panel –> Adminisrative Tools –> Windows Firewal with Advanced Security

It shows like

So I need to change or allow Inbound connections for Domain network.

Click –> Windows Firewall Properties.

Choose Domain Profile

Choose Inbound connections –> Allow and then Apply.Now I just try to connect my db from client, Its works fine.

Enter user-name: prem_saico_auh/prem_saico_auh@azardb

Connected to:
Oracle Database 11g Enterprise Edition Release – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options