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....
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