Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle needs to be restarted to accept new connections

Re: Oracle needs to be restarted to accept new connections

From: Oracle Software Owner <oracle_at_linux.site>
Date: Tue, 01 Nov 2005 17:27:47 +0100
Message-Id: <pan.2005.11.01.16.27.45.831290@linux.site>


David,

And you could also trace the connections:

TRACE_LEVEL_SERVER = ADMIN
TRACE_FILE_SERVER = listener
TRACE_DIRECTORY_SERVER = $ORACLE_HOME/network/trace

in your sqlnet.ora
If you have onames,DNS,network problems you could find messages like this in your trace file:
...
read(6,0x1003D45D6, 2064) (sleeping...) ...

regards,

Ivan

On Tue, 01 Nov 2005 06:58:03
-0800, DavidDublin wrote:

> Thanks - I will add tnsping to my cron job and monitor it.
Received on Tue Nov 01 2005 - 10:27:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US