debugMinor
Unable to connect to Oracle from SQL Developer
Viewed 0 times
oracleconnectsqlunabledeveloperfrom
Problem
below is the error
Status : Failure -Io exception: The Network Adapter could not
establish the connection
It's connecting from my system but unable to connect from other systems on the network.
ping command is working fine and
problem resolved thanks for the support..It wasn't the database fault...It was an network issue....
Status : Failure -Io exception: The Network Adapter could not
establish the connection
It's connecting from my system but unable to connect from other systems on the network.
ping command is working fine and
tnsping is also working. any suggestion and help is very helpful.problem resolved thanks for the support..It wasn't the database fault...It was an network issue....
Solution
This seems to be a hostname resolution problem. Please try to connect to the IP address instead of the hostname.
If this is not the solution could you please post the output of the following command:
EDIT 1:
EDIT 2:
It turned out to be an firewall problem. See comments below.
If this is not the solution could you please post the output of the following command:
lsnrctl statusEDIT 1:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)(KEY = EXTPROC1521)
)
(ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.2.64)(PORT = 1521)
)
)
)EDIT 2:
It turned out to be an firewall problem. See comments below.
Code Snippets
lsnrctl statusLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)(KEY = EXTPROC1521)
)
(ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.2.64)(PORT = 1521)
)
)
)Context
StackExchange Database Administrators Q#86751, answer score: 2
Revisions (0)
No revisions yet.