Re: Enterprise Manager

In a nutshell, what is really happening when you submit a job:

The agent (on the node where the job will be run) stores the information until it is time to run the job. You will notice the *.q files in the agent directory. When the agent starts the job, he has to log into NT (or whatever os you are using) for some of the functions he may have to perform. Since there is not really anybody sitting there, the agent creates a batch job to run (that's why the user created has to have 'log on as a batch job').

The preferred credentials you set in OEM tell the agent how to log into the os (or database). The preferred credentials should be set for the node where the work has to be done. The user names can be different for each node, just use the preferred credentials to identify each username/password for each node.

The thing that causes the most problem is creating the user at the local level instead of the domain level. Make sure when you are in User Manager, your machine name is showing up in the title bar, and not the domain.

As far as the sql*net connection, once the job has been submitted, the sql*net connection can be broken between the OEM console and the server, and the jobs will still run.

Hope this didn't confuse things even more!!!!!!!

Marty

HTS Process Control wrote in message <37E2399D.58E_at_globalserve.net>...
>Marty,
>
>I checked my access but I have a question (probably a dumb one!) Do the
>users on both machines have to be the same? i.e. should I have a
>Roza21Operator user account on both NT machines? I have one in each of
>my databases but only in the machine I am running the job from do I have
>a Roza21Operator NT user.
>
>I am really confused why I need an NT user anyway. Am I not just
>connecting through SQL*net? In which case I have never had to worry
>about NT users before. I am just using a TCP/IP connection on a
>standard ethernet network connection. No domains or anything just a
>default workgroup.
>
>Thanks,
>
>Jenn :)
>
>
>Marty Grinstead wrote:
>>
>> Jenn,
>> If the file system is NTFS, make sure the user has full access to the
>> necessary directories. It's easiest (if security is not an issue) to
grant
>> full access to the Oracle home, or even the entire drive.
>>
>> Keep us posted..........
>>
>> Marty
>>
Received on Fri Sep 17 1999 - 17:33:30 CDT