using the scheduled tasks wizard set the task to run under a dedicated
account (we use one imaginatively named scheduler) and make this user member
of the appropriate groups (local administrator *may* be appropriate).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Denys Williams" <denys_williams_at_yahoo.com> wrote in message
news:509be57b.0208060629.b1fe720_at_posting.google.com...
> Any help appreciated...
>
> I have Oracle 8.1.6 running on Windows 2000 server SP2
>
> I have written a batch file that will perform an export every night
> (when executed from 'Scheduled Tasks') and when I manually execute the
> batch file, it produces the desired result (generates an export of the
> listed schema) but when I get the Windows 2000 Scheduler to run the
> batch file that contains...
>
> D:\Oracle\Ora81\BIN\EXP system/manager file=f:\exptest.dmp compress=n
> buffer=20971520 owner=owner1 log=filename.log
>
> I get:
>
> EXP-00056: ORACLE error 12638 encountered
> ORA-12638: Credential retrieval failed
> EXP-00000: Export terminated unsuccessfully
>
> in filename.log
>
> Naturally I am doing the export manually for now...
>
> I have tried scheduling the EXP.EXE command directly (instead of
> having it in a batch file).
> I have tried executing cmd.exe and passing the batch file to it
> I have tried executing cmd.exe and passing the exp command directly to
> it for execution.
>
> Bearing in mind that the EXP parameters provide a
> system/syspasswd(@localhost - tried both) authentication string as
> well as a log=filename.log paramater (which is recognized and
> generates filename.log that contains the output included above) I
> cannot understand why this should work from explorer or the command
> line but not from scheduler...
>
> I would prefer not to have to change SQLNET.AUTHENTICATION_SERVICES =
> (NTS)
>
> Thanks in advance
>
> Denys Williams
Received on Tue Aug 06 2002 - 10:06:03 CDT
