• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 17069
  • Last Modified:

ORA-03135:connection lost contact


Hello there,

i am trying to connect to a remote oracle 10g db.but i get a ORA-03135 error.there is no firewall on that server.other computer on the netwrok can connect to the db.i also have a oracle 10g db on my local computer to which i can connect without problem.then why can't i connect to the remote computer.

cheers
0
zolf
Asked:
zolf
  • 2
1 Solution
 
haidersyedCommented:
if you are using windows 20003 there is a software firewall on server machine you can disable it in control panel
0
 
zolfAuthor Commented:

can you please tell me in more details what do you mean.i did not quite understand
0
 
ExpertAdminCommented:
You may need to verify your TNSNames file has the correct connection information on the machine that will not connect (Assuming you are using TNSNames). If that is not the problem, try using a different tool to connect with and see if you have the same problem.

For example, if you have been attemting to connect with TOAD or SQL Worksheet, try connecting with SQL Plus and see if you get the same error. If all of your tools give the same error, it is likely a configuration problem on your machine (for example, incorrect TNS entry), but if SQL Plus will connect, you probably have bad connection information in an individual tool.

M@
0
 
haidersyedCommented:
In controlpanel windows firewall is there please disable that
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now