Solved

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

Posted on 2013-11-11
7
520 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
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 34

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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

786 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