Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What causes ORA-12547: TNS:lost contact ?
I remembered in the old days (meaning 3 years ago). For some versions
of Oracle, it is not behaving properly if stay up for more than one
year. Now you are only about 100 days. So should be okay. But staying
up for 400 days is long enough. I would say reboot and start from fresh
on a yearly basis is sound manangement practice.
Stan Brown wrote:
> Last night on an instance that has been up for over 100 days, and on a
> machine with an uptime over 400 days (HP-UX 10.20 and Oracle 7.3.4.5.0,
> I started getting :
>
> ERROR: ORA-12547: TNS:lost contact
>
> Intermitentaly on attempts to connect to the instance. I also got some
> errors about TNS path? Sorry I don't have that one handy.
>
> From an OS perspective, the machine seems healthy (not out of process table
> entries or anything like that, I don't believe).
>
> What should I look for to troubleshoot this problem?
>
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
Received on Fri Jul 28 2006 - 12:46:51 CDT