Doesn't dbstart/dbstop execute for all instances in the oratab file? Is
there a way to stop an individual instance without stopping the others?
BIG <lionel.grosgeorge_at_renault.com> wrote in article
<7q0dgb$88p$1_at_ons.mc2.renault.fr>...
> You must be oracle user to start and stop database.
>
> If your script is executed bye an other user, try these commands :
>
> to start :
> su - oracle -c dbstart
> to stop
> su - oracle -c dbshut
>
>
>
> Tom a écrit dans le message <01beee6c$df286e00$03cf34aa_at_oxt>...
> >Good idea. I'll try it. I do need to be more detailed with my original
> >question though. After further investigation, I found that this script
> >isn't run locally, unfortunately the job is being run via an rexec from
an
> >MVS batch job that doesn't end because the database comes up (on the
RISC
> >box) and leaves the processes started leaving MVS to believe the job is
> >still running. The MVS job eventually times out. Not good. So, what
> >newsgroup should I ask about this one? Any suggestions?
> >
> >
> >Kenneth C Stahl <BluesSax_at_Unforgettable.com> wrote in article
> ><37C2EC05.9E2C0631_at_Unforgettable.com>...
> >> Tom wrote:
> >>
> >> > Hi all!
> >> > I have created a simple script to startup and shutdown my
> >instances
> >> > automatically. I run the startup script and it doesn't finish, but
the
> >> > shutdown script does. Is this because the script spawns other
> >processes?
> >> > How can I get the script to end without killing it? This could be an
> >AIX or
> >> > Oracle issue. I wasn't sure so I posted to both. Any help would be
> >> > appreciated. Here is the script. (as you can see I'm very
inexperienced
> >in
> >> > script writing)
> >> >
> >> > #!/bin/ksh
> >> > set -xv
> >> > /u01/home/oracle/product/7.2.3/.profile
> >> > ORACLE_SID=GOOFY
> >> > svrmgrl <<EOF
> >> > connect internal
> >> > startup
> >> > EOF
> >> >
> >> > thanks in advance,
> >> > Tom
> >> >
> >> >
> >>
> >> Why not just use the dbstart that Oracle provides?
> >>
> >>
> >>
>
>
>
Received on Wed Aug 25 1999 - 13:59:43 CDT
