Re: Q: Running Pro*C Program During Reboot

On a project I worked on prior to my current employer, I turned the daemon.pc program into a system application that started in the /etc/rc file.

It required deciding how long to wait until Oracle was up, how many retries before exiting, changing the group id and user id on startup. We left the daemon running all the time, when Oracle went down at night for backups, it just slept until it thought Oracle was back up and tried to connect again.

It's still being used as far as I know.

-- 
Robert Carey
robert.w.carey_at_boeing.com

Mariah Abdul Rahim wrote:


> 

> Hello,

> 

> I'm running Oracle 7.3 on Solaris 2.5.  I've managed to make system call

> from Oracle by running the Pro*C daemon.pc program contained in Oracle

> Application Developer's Guide.  My problem is everytime my server is down,

> the daemon dies and need to be startup manually.  How do I set it up so

> that it will startup on reboot, just like dbstart does?  BTW, I've changed

> the program name to odaemon and all reference for daemon to odaemon.  I've

> created a script for reboot but it doesn't work either.  My script looks

> like this:

> 

>    echo -n "Oracle Daemon..."

>    /bin/su oracle -c "cd /oracle; \

>            $ORACLE_HOME/bin/odaemon < /dev/null >& /dev/null &"

>    echo "started"

> 

> Any help will be appreciated.  Thank you.

> 

> mariah_at_ms.mimos.my