Re: Oracle startup script won't end.

Yes, just put an N instead of a Y at the end of each line in the ORATAB file.
It only starts or stops the ones with the Y. Also, make sure you edit the dbshut script and wherever it does a shutdown, change that to shutdown immediate,
otherwise it'll hang shutting down oracle.

As for the script that was written at the end of this thread, perhaps you should exit from svrmgrl before EOF? Just guessing on that one.

Tom <tray_at_voicenet.com> wrote in message news:01beef2c$13339660$03cf34aa_at_oxt...
> 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 - 15:03:51 CDT