Re: Scheduled exports with 8.1.7

After you startup restrict the second time, you need to reconnect to the database as part of the export command.

Andrew Simkovsky
OCP DBA "Fredy Tschui" <ftschui_at_edvpraxis.ch> wrote in message news:3ade976b$1_5_at_news.bluewin.ch...
> Hello
>
> I have troubles to run a scheduled export batch under Oracle 8.1.7
 (Windows
> NT 4.0/SP5)
> - When i'm running the export.bat from the command line, anything works
> fine.
> - When i'm using the following AT-Command to schedule this batch, nothing
> works anymore
> at 23:00 /interactive /every:mo cmd /c .....\Export.bat
>
> Thanks for any help,
> Fredy
>
>
> ***** export.bat *****
>
> set ORACLE_SID=TEST
> svrmgrl @.....\export.sql
>
> ***** export.sql *****
>
> connect internal;
> shutdown immediate;
> startup restrict;shutdown normal;
> startup restrict;
> host exp .....
> alter system disable restricted session;
>
> ***** Oracle-Trace *****
>
> Dump file ORA00151.TRC
> Tue Apr 10 18:56:00 2001
> ORACLE V8.1.7.0.0 - Production vsnsta=0
> vsnsql=e vsnxtr=3
> Windows NT Version 4.0 Service Pack 5, CPU type 586
> Oracle8i Release 8.1.7.0.0 - Production
> JServer Release 8.1.7.0.0 - Production
> Windows NT Version 4.0 Service Pack 5, CPU type 586
> Instance name: test
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 0
>
> 151
>
> *** 2001-04-10 18:56:00.812
> FATAL ERROR IN TWO-TASK SERVER: error = 12571
> *** 2001-04-10 18:56:00.812
> ksedmp: internal or fatal error
> Current SQL information unavailable - no session.
> ----- Call Stack Trace -----
> .....
> ----- End of Call Stack Trace -----
> ===================================================
> Files currently opened by this process:
> ===================================================
> PROCESS STATE
> -------------
> Process global information:
> process: 0, call: 0, xact: 0, curses: 0, usrses: 0
> No process is allocated.
> END OF PROCESS STATE
>
>
>
Received on Thu Apr 19 2001 - 12:36:41 CDT