Re: Enterprise Manager on NT...

I am responding because I have had this error before. The only way I got my answer was through ORACLE Support themselves. Its undocumented and an easy fix. In the user preferences menu option go to the NODE (machine name) that the database is on. This is the most important place to enter userid and password. When you are done editing the userid and password, go to the NT machine that holds the database. Now in the start menu and choose Adminitstative Tools, then User Manager. Find the USER you just entered on the NODE. This user has to have a specific NT privilage called "USER CAN LOG ON AS BATCH JOB" This privilage is not granted automatically and is the reason you get the error. "FAILED TO AUTHENTICATE USER" Now, the reason for this is because when O.E.M.'s daemon is kicked of to run that job, it has to log onto NT to run against the DB. But this daemon just logs on to run a bactch job which happens to be your DB Shutdown script.

Hope that helps
Kenny Rosenblatt
Tech. Consultant

> Have you enabled auditing at Oracle level or security logging at NT, or
> SQL*Net logging ?
> Try doing one thing at a time: first a job which merely does a DIR on the
> NT directory, if that works then the NT side is ok. Try try increasing the
> complexity of the job until you find the point of failure.
>
> Eugene.
> ========================================
> "Kevin S Hoffman" <{khoff_at_plaza.ds.adp.com}> wrote:
>
> > I'm having trouble with Enterprise Manager on NT... I'm trying to schedule a
> > job
> > that will shut the database down every night at 1AM .. The problem is, that
> > every time
> > I submit the job, it fails to authenticate... At first, it fails to
> > authenticate when I don't
> > choose to override the preferences... Then, when I do override the
> > preferences and
> > type in the username of 'internal', and my password for the internal
> > account, that even
> > fails to authenticate, then I type in the name of another user with SYSDBA
> > permissions,
> > and that user's password, and it STILL fails to authenticate.
> >
> > Could someone please help me - I'm pulling out my hair here and
> > unfortunately enterprise
> > manager gets nothing more than an honorable mention in any of the books I
> > have...
> >
> >
> >
>
> Eugene Gardner.
> Oracle Certified dba available for hire on NT or VMS platforms.
Received on Fri Jan 08 1999 - 15:44:22 CST