Home » SQL & PL/SQL » Client Tools » connection problem
connection problem [message #637759] Sun, 24 May 2015 00:13 Go to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
Hi guys,
I am facing a connection problem between my Server and My Clint with Oracle Database 10 g and Oracle Developer 10g with Windows 8.
Here are what I have done so far.
I installed my database in a computer with windows 8.
As well, I installed Oracle Developer in the same computer to check my database and the connection.
The tnsnames as the following:
INST -
( DESCRIPTION =
( ADDRESS = (PROTOCOL = TCP )(HOST = INST)(PORT = 1521))
( CONNECT_DATA =
( SERVER = DEDICATED)
(SERVICE_NAME = INST)
)
)
Though, I made the IP of this computer a static IP 192.169.1.10
__________________________________________________________________
then, I made a small network that contains one server and one client all windows 8.
I installed Developer 10 g in the client. and did the same with the tnsnames.
It has this error when I try to connect :
ora-12170 connect timeout occurred toad

Where and what could be the problem?
Re: connection problem [message #637760 is a reply to message #637759] Sun, 24 May 2015 00:21 Go to previous messageGo to next message
BlackSwan
Messages: 26289
Registered: January 2009
Location: SoCal
Senior Member
The most common cause of TIMEOUT is a Firewall on or between client & DBServer

What has changed?
When was last time all was OK?
Re: connection problem [message #637762 is a reply to message #637760] Sun, 24 May 2015 00:54 Go to previous messageGo to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
It has never been OK. But, I will turn off the firewall and check.
Re: connection problem [message #637763 is a reply to message #637762] Sun, 24 May 2015 00:57 Go to previous message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
Thank you so much. I turned off the firewall and it connected
Previous Topic: Data Dictionary (Data Modeler)
Next Topic: Redundant blank line generated
Goto Forum:
  


Current Time: Wed Nov 21 08:10:36 CST 2018