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 