Re: starting and stopping db instances

You could use Instance manager with Oracle agent jobs - dirty but simple.

Krister Lundmark

<dm-ll-dunyan_at_home.com> wrote in message news:37A3F9AA.AA6A8780_at_home.com...
> Okay - get a GOOD telnet client for Winnt that supports scripting and
> seesion/script associations. (I use Reflections by WRQ. It has good
vt-xxx
> emulations, mainframe w/ Regis Graphics, etc) Any way, when scripting a
logon,
> I can actually 'record' until I say stop. (I do have to edit it to remove
the
> popup password dialogue and just send my password for log-on.)
>
> I can then use the at scheduler with to schedule a bat file. In it there
is one
> line: the file name of the 'session profile' ex:
> axpb.r4w
> Because that session has the script associated, everything fires
automatically,
> once scheduled. You can also use things like MacroMagic, etc. Really,
lots of
> options. Cron jobs on the server...
>
> Doug
> Software Analyst/OCP
>
>
> Puneet Khanna wrote:
>
> > Hey David,
> > He wants to run it from NT. He's already using a shell script.
> >
> > David F. Newman <buzzwang_at_damocles.ourvillage.com> wrote in message
> > news:86oggudkbm.fsf_at_damocles.ourvillage.com...
> > > chienli_at_uclink4.berkeley.edu writes:
> > >
> > > > Hi,
> > > >
> > > > I have a problem that I can't figure out how to do or even know if
it is
> > > > possible.
> > > >
> > > > The problem is that I want to shutdown and startup an oracle
instance
> > > > everyone hour or so. Before, how we did it was to run a shell
script on
> > > > the server side to schedule a bunch of batch jobs. The shell script
> > > > calls svrmgrl and connects internal to do shutdown and startup. Now
I
> > > > would like to do this from my NT client and do the same thing from a
> > > > program I am writing.
> > > >
> > >
> > > Well,
> > > You could use a script like the following and just put it in
> > > cron to go off ever hour.
> > >
> > > #!/bin/sh
> > >
> > > ORACLE_SID=<insert SID here>
> > > ORACLE_HOME=`grep "^${ORACLE_SID}:" /var/opt/oracle/oratab |cut -d: -f
2`
> > > export ORACLE_SID ORACLE_HOME
> > >
> > > #########################
> > > # Shutdown the database #
> > > #########################
> > >
> > > ${ORACLE_HOME}/bin/svrmgrl <<END_OF_SHUTDOWN
> > > connect internal
> > > shutdown immediate
> > > END_OF_SHUTDOWN
> > >
> > > ######################
> > > # Start the database #
> > > ######################
> > > ${ORACLE_HOME}/bin/svrmgrl <<END_OF_STARTUP
> > > connect internal
> > > startup
> > > END_OF_STARTUP
> > >
> > > --
> > > David F. Newman
> > > Oracle DBA
> > > buzzwang_at_ourvillage.com
>
Received on Sun Aug 01 1999 - 13:23:27 CDT