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

Oracle Server connection error TNS ORA-12541; No Listener Error on single PC only

My company has an Oracle data source that I use to pull regular data from my operation.  I had to re-start of my MS Servers and after restarting I cannot connect to this data source any longer.  Prior to re-starting, I was able to connect.  I can successfully connect to the same Oracle data source from two different machines.  

When i try to connect, i get the error ORA-12541: No Listener.  Everything I have found says that the listener needs to on the host server, i.e. the target oracle server one is pulling data from.  Since I can successfully connect to that server from other computers but not my one server, that doesn't seem like it is the problem.  

I can connect to other oracle data-sources from that server.  Only this one connection seems to have been corrupted.  

Any suggestions on how to trouble shoot?
0
AHenderson526
Asked:
AHenderson526
1 Solution
 
ThommyCommented:
Ping the Oracle Server from the client by running:  tnsping ORACLE_SID

Tell me the results...
0
 
johnsoneSenior Oracle DBACommented:
The first 2 things I would check is:

Firewall - did something change that isn't allowing the machine through now
Port # in tnsnames.ora - if port number is wrong you would get a no listener error
0
 
ThommyCommented:
Also check, if you have a parameter NAMES.DEFAULT_DOMAIN in your client SQLNET.ORA
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Mark GeerlingsDatabase AdministratorCommented:
If none of those suggestions help, check your C:\WIndows\System32\drivers\etc folder for a "hosts" file, and make sure that it does not have an incorrect entry there for your database server.  No entry there for your database server should be OK, then that PC will use your network DNS server to resolve the database host name.
0
 
AHenderson526Author Commented:
All,

Thanks for your input and suggestions.  I restarted the server again last night just befor leaving and, of course, that fixed the problem.  

Reminds me of the story when three engineers were driving in a car when it stopped running.  One was a mechanical engineer, one an electrical engineer and the last was a software engineer.  

The machanical engineer started talking about the values or transmission being the problem.  The electrical engineer was thinking the problem was in the distributer or maybe the spark plugs.  

Then the software engineer spoke up and suggested that all they needed to do was to close all the windows, then open them back up and that should solve the problem...

Anyway... not sure what the problem was but it was resolved with the restart.  Thanks again to everyone to took the time to try and suggest a solution.
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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