Sunday, September 4, 2011

Oracle11g Failure IO exception: The Network Adapter could not establish

Today,  I have installed Oracle 11g enterprise in my Windows 7 Enterprise 64 bit machine.   Oracle server and sql developer are in the same machine.

When I tried to connect the User Scott through SQL Developer,
I gave these details:
Hostname: localhost
Port: 1521
SID: orcl
 I got the error, Status: Failure -Io exception.   The Network Adapter could not establish.....

I have tried few steps provided in other blogs, forums, no use....

But when checked the tnsnames.ora,

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.xyz.cc.bb)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.168.10.xyz)
    )
  )

I used these details for connection, it is working fine....

No comments:

Post a Comment

Andrew Ng machine learning course

Hi, I was failing in the week 2 quiz - Machine learning course in Coursera.org, especially in one of the question which has multiple opti...