Re: PMON Problem : server process without user process

From: <h.jalalipoor_at_gmail.com>
Date: 13 Dec 2006 02:49:35 -0800
Message-ID: <1166006975.425658.171660@16g2000cwy.googlegroups.com>

I`m sorry, it is a typo on this line :
oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1194

I explain my problem again.
I execute this query:
SQL> select s.status, s.sid, s.process, s.machine, s.taddr, p.spid from v$session s, v$process p
where s.paddr=p.addr
and s.sid=42
/
STATUS SID PROCESS MACHINE TADDR SPID

-------- ----- --------- ---------- ---------------- -------
ACTIVE      42 1194      ESCOERP2   C0000000DFB40EF8 1196

v$session show me that I must have a session with Oracle SID 42, Oracle process id 1196 (as server process) and unix process id 1194 (as user process).
but when i search unix process id, i don`t find it. i execute this command :
(oraprod_at_ESCOERP2) > ps -ef|grep 1194
oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1194

(oraprod_at_ESCOERP2) > ps -ef|grep 1196
oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1196 oraprod 1196 1 0 08:33:49 ? 3:08 oraclePROD (LOCAL=NO)

The above result show me that i have a session with Oracle SID 42, Oracle process id 1196 but no unix process id 1194!

Normally, at this time PMON should clean up the session but it did not!. the session remained on the database and don`t clean by PMON.

Thanks.

Maxim Demenko wrote:
> Maxim Demenko schrieb:
> >> (oraprod_at_ESCOERP2) > ps -ef|grep 1196
> >> oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1194
> >> oraprod 1196 1 0 08:33:49 ? 3:08 oraclePROD (LOCAL=NO)
> >>
> >
> > Until now i don't see anything unusual
> >

>

> Looking once again, i noticed, i was something wrong:

>

> (oraprod_at_ESCOERP2) > ps -ef|grep 1196
> oraprod 9067 4340 1 11:00:36 pts/4 0:00 grep 1194

>

> It seems, you can't rely on your grep filtering capabilities...
>
> Best regards
>
> Maxim
Received on Wed Dec 13 2006 - 04:49:35 CST