Solved

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

Posted on 2013-11-11
7
526 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
Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

 
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 Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

707 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