Re: PMON Problem : server process without user process

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 13 Dec 2006 12:39:50 +0100
Message-ID: <457fe723$0$30323$9b4e6d93@newsspool1.arcor-online.net>

h.jalalipoor_at_gmail.com schrieb:
> Maxim wrote :

>> but can well be on totally another machine ( as probably in your case),
>> so you would find it with ps -ef|grep not on the Oracle server's host,
>> but on the client's host.

>
> If you focus to result of my query, you can see that user process must
> be on ESCOERP2. it is my database server.
>
> Best Regards.
>

That may occur if your client application was terminated abnormally. To handle such issues, have a look on the SQLNET.EXPIRE_TIME parameter. http://www.stanford.edu/dept/itss/docs/oracle/10g/network.101/b10776/sqlnet.htm

Best regards

Maxim Received on Wed Dec 13 2006 - 05:39:50 CST