Re: Oracle Export using WinNT AT Command

Just answered the same question in another newsgroup. This is a know problem with windows NT.
The AT command is basically a frontend for the Windows SCHEDULE service. This service is run as the operating system user. This system user is a kind of internal account that you normally do not see. However when you run as system you will not receive certain environment variables (ORACLE_HOME) etc. The solution is simple : stop the service SCHEDULE, open it, change the START AS option to the local Administraor account and start it again.

When you then add the local administrator to the ORA_DBA group you will also be able to do startup/shutdown scripts using connect internal without being prompted for a password. Irritating thing to hit :)

Greetz

Ron

"Meier Roland" <Roland_Meier_at_freesurf.ch> wrote in message news:a7a5mf$9gn$1_at_rex.ip-plus.net...
> Dear all,
>
> I have the following simple batch file. This batch exports an oracle
> database and packs it. When i am running the scrip manually the script
works
> fine, if i am running it using an AT command it cannot resolve TNS Name.
>
> Can anyone help me please ?
>
> Roland
>
> ECHO BACKING UP TST82 DATABASE. PLEASE WAIT...
>
>
> C:\oracle\ora81\bin\exp816.exe user/password_at_tst82 FULL=Y
> FILE=E:\Databases\TEMP\tst82.dmp LOG=E:\Databases\TEMP\tst82.log
>
>
>
> c:\winzip\wzzip.exe E:\Databases\tst82.zip E:\Databases\TEMP\*.*
>
>
>
>
>
Received on Thu Mar 21 2002 - 17:31:09 CST