Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-11-11
7
Medium Priority
?
541 Views
Last Modified: 2014-06-03
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
Comment
Question by:AHenderson526
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 19

Expert Comment

by:Thommy
ID: 39640856
Ping the Oracle Server from the client by running:  tnsping ORACLE_SID

Tell me the results...
0
 
LVL 35

Expert Comment

by:johnsone
ID: 39641494
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
 
LVL 19

Expert Comment

by:Thommy
ID: 39641769
Also check, if you have a parameter NAMES.DEFAULT_DOMAIN in your client SQLNET.ORA
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 39642072
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
 
LVL 3

Accepted Solution

by:
AHenderson526 earned 0 total points
ID: 39642886
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
 
LVL 23

Expert Comment

by:Steve Wales
ID: 40108029
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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question