I am the user who creates/runs the batch jobs, and I have full
administrative rights in NT. The batch file runs fine at its designated
time. It's just that, within the SQL shutdown script, the connection to
oracle fails, with "insufficient privileges". That's oracle's message, not
NT's.

-----Original Message-----
From: Lages, Carl [mailto:[Email Address Removed] Thursday, May 31, 2001 8:48 AM
To: LazyDBA.com Discussion
Subject: RE: NT AT command and SLQPLUS


Check the advanced user rights for the user who created/runs the batch jobs
and make sure they have log on as batch job,log on as service and act as
part of the operating system.
Hope this helps,
Carl

-----Original Message-----
From: Rosol, Martin, CTR, DOD/WHS/DFOISR
[mailto:Martin.[Email Address Removed] Thursday, May 31, 2001 8:11 AM
To: LazyDBA.com Discussion
Subject: NT AT command and SLQPLUS


Hi List!

Last night I started using NT's AT command to schedule and auto-run my cold
backups. All my batch fiels and SQL scripts run when I start them manually,
but using AT, INTERNAL doesn't connect. My shutdown script is supposed to
connect to the database as internal using:

SQL> CONNECT INTERNAL/<password>@<service>

And I get "Insufficient Privileges".

My NT documentation is incomplete, but I suspect a certain NT user account
is used with AT commands, and this user needs to be added to the ORA_DBA
group, so that it can be authenticated.

Am I right? Can someone please fill in the details, and help me figure this
out so I get a REAL, and CONSISTENT backup tonight? For example, what is
the NT user that is active during AT command execution?

Thanks in advance.

-- Martin

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page