Solved

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

Posted on 2013-11-11
7
524 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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 22

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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

730 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