Link to home
Start Free TrialLog in
Avatar of Alex Matzinger
Alex MatzingerFlag for United States of America

asked on

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

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
Avatar of gopisera
gopisera

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 :)

Avatar of Aaron Shilo
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.
Avatar of Alex Matzinger

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Alex Matzinger
Alex Matzinger
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial