Re: Oracle shadow process parent id of 1

dbaplusplus_at_hotmail.com wrote:
> Genrally, parent id is the pid of UNIX process who made connection to
> database.
> That is if I did
> sqlplus /nolog
> conn scott/tigger
>
> my process say is 1000,
> then Oracle will start a shadow process say process id of 1001. ps -aef
> will
> show parent id of process 1001 as 1000 and not 1.
>
> Somehow, in Oracle 10.1.0.4 on my HP unix machine, parent process id is
> 1
> for all oracle shadow processes.

You're only talking about local connections not going through listener. Here's my ps -ef output on Oracle 9.0.1.0.0 on Solaris 8:

% ps -ef | grep LOCAL
  oracle 661 660 0 06:07:17 ? 0:01 oracleTARENADB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))   oracle 669 1 2 06:08:12 ? 0:01 oracleTARENADB (LOCAL=NO)
 yong321 672 670 0 06:08:22 pts/2 0:00 grep LOCAL

My 'sqlplus user/password' process has pid 660 while my 'sqlplus user/password_at_TARENA', which caused pid 669 to be created by way of tnslsnr, has a different pid not shown here. In fact the second sqlplus could come from another machine. There shouldn't be any difference between 8i, 9i and 10g. If the shadow process is created by tnslsnr (process name has "LOCAL=NO"), it behaves like a standard UNIX daemon.

Are you saying your third party program kills processes whose parents are pid 1? There must be other critera you can set or it would kill processes such as utmpd, rpcbind, etc.

Yong Huang Received on Sat Oct 22 2005 - 17:41:17 CDT