Skip to content
Advertisements

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>

Advertisements
7 Comments Post a comment
  1. Rawia #

    I faced the same problem but in windows xp so i can’t find Windows Firewal with Advanced Security any suggestion?

    July 26, 2011
    • 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?

      July 26, 2011
  2. Rawia #

    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 .

    July 26, 2011
  3. Rawia #

    The problem solved by turn off the firewall in server and client machine

    September 14, 2011
    • Oscar #

      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.

      May 24, 2012
  4. Tanveer #

    Thank you very much for share this, the problems solved when turn off firewall in server.

    February 6, 2016
  5. Ghulam Yassen #

    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

    June 12, 2016

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: