Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> EXP-00056, ORA-12638 & Scheduled nightly exports under Oracle 8.1.6 and Windows 2000 server SP2

EXP-00056, ORA-12638 & Scheduled nightly exports under Oracle 8.1.6 and Windows 2000 server SP2

From: Denys Williams <denys_williams_at_yahoo.com>
Date: 6 Aug 2002 07:29:56 -0700
Message-ID: <509be57b.0208060629.b1fe720@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 - 09:29:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US