Re: Job Queue problem with 8i

Nilendu,

I had something similar to this, and our problem was that when Oracle started up, the TNS_ADMIN parameter was not pointing to the correct location when the TNSNAMES.ORA file is located, and therefore the SNP0 process did not know about the TNS Alias conversion. When run as a real user, you have the correct TNS_ADMIN configuration, hence it works with DBMS_JOB.RUN(...); Just a thought,
Andrew

BTW - O7 v7.3 not o8i, and we were not running Oracle Names.

nilendu_at_my-dejanews.com wrote:

> HI All,
> I am facing an interesting problem.
>
> I want to run a job through DBMS_JOB.This is actually three procedures
> involving TWO database instance on the same machine(Oracle 8i on Win NT
> 4).
>
> Now when I submit a job to be run THIS job is run,as I get from
> querying DBA_JOBS_RUNNING.But it does not get completed.It just
> FAILS.And I can read that from USER_JOBS.
>
> What I thought initially that,there could be some problem with my
> procedure.So I ran DBMS_JOB.RUN(my job number) and Oracle ran the
> procedures perfectly.
>
> Now could you experts give me any suggestion where to look for.
> I strongly suspect that since it acceses two databases through Names
> Server something is going wrong there.In the other database also I
> checked for the INIT.ORA parameters and they are same as the database
> running that job.
>
> TIA,
> Nilendu
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Mon May 24 1999 - 19:27:02 CDT