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
ERROR:
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 11.2.0.1.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
DBA 
I faced the same problem but in windows xp so i can’t find Windows Firewal with Advanced Security any suggestion?
I don’t have right now Windows XP machine. However this cause happen due to Firewall, or your IP does not ping Database Server. Can you able to ping your ip address in db server or Can you able to ping server ip address in client machine?
Yeah I can ping sever ip address from the clinet machine , and I am facing this problem for the first time, so I agree with you may be the firewall setting causing this problem ,but is it enough to turn the firewall of in server and client machine .
The problem solved by turn off the firewall in server and client machine
Correcto el problema se da en los server 2008, lo que hice en mi caso es habilitar todas las entradas y salidas del firewall, en las opciones de Centro de redes y recursos compartidos de la misma manera habilite los archivo e impresoras compartidas
Suerte.
Thank you very much for share this, the problems solved when turn off firewall in server.
Dear #MOHAMED AZAR#
Your article helped me alot and solved my problem.
thanks you very much for sharing your great skills and knowledge.
Please contact me ghulamyassen@gmail.com