Re: Shutting Down Oracle on WIN/NT via AT Command

I have read this in a book but I didn't try it yet !

Go to the Windows NT registry on the local server that support the Oracle Database and
add string value in the following registry key :

HKLM/SOFTWARE/ORACLE/ The string to add is :
DBA_AUTHORIZATION = BYPASS and try your AT cmd.

 !!!! Be careful this parameter seems to be very sensible for the global security under Oracle !!!!

Otherwise, if it still doesn't work you can modify the current property of the Windows NT service Planning by specifying it the user account and the password to use.
Each time planning will run a task it connects a local session with the system account into Windows NT. By changing this parameter you can create and grant another user to perform all the task done by Planning. Be sure that the user exist under Windows NT (either the domain or the local server to make a local connection on the concerned server).

Check also in your batch that the environnement variable ORACLE_SD is properly set before running SVRMGR.

I hope those little tricks may give you some tracks to follow in order to hit your plan.

Claude Santero.

Judith Fehrenbacher <fehrenbacher_at_i-core.de> a écrit dans le message : 392538DC.40EDB7D6_at_i-core.de...
>
>
> Gerry Mulcahey wrote:
>
> > Hi
> > I work with Oracle on Unix, but recently installed Oracle 8i on our
> > office server which runs Windows NT. I wanted to setup a batch script
> > that would shutdown Oracle before the automated backups kicked in and
> > start it roughly after the backups completed.
> >
> > I created a "batch" file which started SVRMGR, connected internal and
> > issued a shutdown command. Works great at the command prompt, but when
> > I submit it via the AT command (which is controlled via Scheduler), I
> > see a message in my log file that it is asking for a password.
> >
> > I understand why - it's not the same user as when I am at the command
> > prompt.
> >
> > How does one automate a shutdown and startup in Windows NT without
> > purchasing some software? I should be able to stop Oracle with some
> > command prompt, right?
> >
> > Thanks.
> >
> > Gerry
> > mulcahey_at_travel-net.co
>
> Normally the schedule service runs using the system account. You can
 change
> this by modifing the startup parameters of the service.
>
Received on Tue May 23 2000 - 00:00:00 CDT