Solved

How do I disable TNS-12547: TNS:lost contact error in Oracle

Posted on 2011-03-21
4
982 Views
Last Modified: 2012-08-14
Hello,
I have a v11g Oracle database that randomly reports the following error in the alert logs:
TNS-12547: TNS:lost contact
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

Open in new window


I was wondering if there was a way to disable this error in oracle?  
Thank You
0
Comment
Question by:Alex Matzinger
[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
  • 2
4 Comments
 
LVL 3

Expert Comment

by:gopisera
ID: 35185861
Hoping the error comes when the  listener log file reaches maximum.  Unable to write the data in the listener log file.

make of copy of exiting and try to create an empty log file.

If this is not due these. Please let me know :)

0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35190715
first of all NO you cant disable the error message.

i had a similar issue and what worked for me was to delete the listener.log file that grow very large.
0
 
LVL 4

Author Comment

by:Alex Matzinger
ID: 35261987
It does not appear that this problem is related to the size of the log file.  I have tried clearing this out, and it is still occurring.  I am still investigating what may be causing this error,  and if there is a way to side step it.  It does not appear to be effecting my databases performance, it is just annoying, i will keep this thread up to date with any findings I come across.
0
 
LVL 4

Accepted Solution

by:
Alex Matzinger earned 0 total points
ID: 35740444
This problem is related to connections timing out in oracle.  I set the two paramters in the listener.ora file and the sqlnet.ora file, and they reduced the number of errors I saw.  The parameters:

Sqlnet.ora: SQLNET.INBOUND_CONNECT_TIMEOUT=120
Listener.ora: INBOUND_CONNECT_TIMEOUT_LISTENER=120 

Open in new window

0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database ERD 4 81
oracle forms question 22 48
i am unable to add data to mysql database 6 55
MySQL - Adding an incremented value to a duplicate string 30 23
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
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.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

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