?
Solved

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

Posted on 2011-03-21
4
Medium Priority
?
1,016 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
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

569 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