Solved

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

Posted on 2011-03-21
4
978 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

This article describes some very basic things about SQL Server filegroups.
Creating and Managing Databases with phpMyAdmin in cPanel.
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 how to recover a database from a user managed backup

839 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