Solved

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

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
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
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

770 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