Re: Creating Pid file with oracle

[rory]

I don't know oracle, but mysql and postgres both write out pid files if
configured correctly for the master process. I'd be surprised if Oracle
did not have this option.

You can also try the suggestion at:

http://mail.gnu.org/archive/html/monit-dev/2003-03/msg00003.html

> Hi,
>
> I am new to using monit. I want to monitor oracle with it. but i am not
> able to create oracle.pid file with oracle.
>
> Here is the extract from my /etc/init.d/dbora  script i am trying to use
> to start oracle
>
>
>    echo $$ > /var/run/oracle.pid
>     su $ORACLE_OWNER -c  $ORACLE_SCRIPTS_DIR/dbstart.sh
>
> But the problem is that the pid thats getting stored in the oracle.pid
> is not the pid of the oracle instance. Moreover my ps -ef gives
> something like this
> This indicates that many processes are  created with ppid of 1 and there
> is no single parent process. I am using oracle 9i.
>
> oracle   23147     1  0 20:47 ?        00:00:00 ora_pmon_DELLDB
> oracle   23149     1  0 20:47 ?        00:00:00 ora_dbw0_DELLDB
> oracle   23151     1  0 20:47 ?        00:00:00 ora_lgwr_DELLDB
> oracle   23153     1  0 20:47 ?        00:00:00 ora_ckpt_DELLDB
> oracle   23155     1  0 20:47 ?        00:00:00 ora_smon_DELLDB
> oracle   23157     1  0 20:47 ?        00:00:00 ora_reco_DELLDB
> oracle   23159     1  0 20:47 ?        00:00:00 ora_cjq0_DELLDB
> oracle   23161     1  0 20:47 ?        00:00:00 ora_qmn0_DELLDB
> oracle   23163     1  0 20:47 ?        00:00:00 ora_s000_DELLDB
> oracle   23165     1  0 20:47 ?        00:00:00 ora_d000_DELLDB
> oracle   23169     1  0 20:47 ?        00:00:00 ora_j000_DELLDB
> oracle   23171     1  0 20:47 ?        00:00:00 ora_j001_DELLDB
> oracle   23173     1  0 20:47 ?        00:00:00 ora_j002_DELLDB
> oracle   23177     1  0 20:48 ?        00:00:00 ora_j003_DELLD
>
>
>
>
>
> Thanks in advance,
>
> Srinath Maddali
> Deltion Ltd
> address@hidden
> Tel     : 44 (0) 208 755 5855
> Direct : 44 (0) 208 755 5831
> Fax    : 44 (0) 208 755 5885