Re: help !!!!!!!! oracle error ORA-12547: TNS:lost contact

From: Olga <polenta_at_aristotle.net>
Date: Wed, 13 Jan 1999 23:13:01 -0600
Message-ID: <77jurt$lbv$1@socrates.aristotle.net>

skeller wrote in message <77if3q$8vn$1_at_pollux.ip-plus.net>...
>i have an c-program with emb. SQL.
>this prog is running every hour (started from Autosys, a systemscheduling
>tool (aix)).
>
>sometimes i get this error "error ORA-12547: TNS:lost contact", i can't
find
>out what exactly happens, i guess something with the listener could be
>wrong.
>
>plse answer also to: stefan.keller_at_oiz.stzh.ch
>

>

Check your SQLNET.ORA file ... Does it have a setting for SQLNET.EXPIRE_TIME ? If so, then this is the number of minutes between attempts to clean up and get rid of dead connections. You might try to change this value... Resetting the server is not necessary.

Are you using the multi-threaded server and Net8? If so, are you doing connection pooling, where the connection is multiplexed? Check the INITsid.ORA file for the settings for multi-threaded server. Changing this line means shutting down and restarting the server.

Finally, check the SQLNET.LOG file. This could be in the $TNS_ADMIN directory, or could be in the same directory from which the program is launched. Received on Wed Jan 13 1999 - 23:13:01 CST