Re: Enterprise Manager on NT...

Kenny, you are the greatest! I was having the exact same problem...and was TOTALLY confused by the entire login for the job process, but now it works like a charm!

thanks much!

In article <36967C36.DCCE588D_at_erols.com>,   Kenny Rosenblatt <karosenb_at_erols.com> wrote:
> 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.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 22 1999 - 09:49:17 CST