Re: Shutdown and startup processes

Willie,

We do cold backup overnight. The main script owns by root, in the script, we do su - $PSOFT_USER -c <call stop_peoplesoft_process> and then su - $ORACLE_USER -c <call dbshutdown script>. vice versa, we switch user, bring up oracle and ps process automatically. We don't deal it automatically at date time. manual is fine for us.

Joan

Townsend Willie wrote:
>
> Thanks Stephane!
>
> As you alluded to, ideally, I want it to work automatically even when I do
> manual shutdown/startup via svrmgrl etc. I will explore your suggestion of
> triggers/external function etc.
>
> Willie
>
> -----Original Message-----
> Sent: Thursday, September 12, 2002 2:44 PM
> To: Multiple recipients of list ORACLE-L
>
> Townsend Willie wrote:
> >
> > Gurus,
> >
> > I need to implement a process to startup/shutdown a PeopleSoft Unix batch
> > scheduler job whenever the Oracle instance is shutdown or started back up.
> > Does anyone know of a way to tie this process to an Oracle Instance to get
> > invoked at shutdown/startup time?
> >
> > Willie Townsend
> > Alverno Information Services
> > Supervisor (Database Administration)
> > 317-532-7800 X'6265'
> > eMail: willie.townsend_at_ssfhs.org
> >
>
> Modify $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut if your
> system is using them to automatically start up and shutdown Oracle. This
> seems to me the cleanest way to do it. Of course it will not work if you
> manually stop your database. Perhaps that some trigger calling an
> external function ... ? Yek.
>
> --
> Regards,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriole.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Townsend Willie
> INET: Willie.Townsend_at_ssfhs.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).