Re: ORA-12154 from background job

Ulrich Mertin wrote:

> Hello group,
>
> I'm using Oracle 8i and TOAD as development tool.
>
> I wrote a procedure that retrieves data from another database. When I
> ran this procedure directly through TOAD, it worked fine.
> I then set up a background job calling this procedure. When I executed
> this job immediately through TOAD, it also worked fine.
>
> When the job ran at the scheduled time, though, I got the message
> "ORA-12154: TNS:could not resolve service name".
>
> Other background jobs that select data from remote db's work fine. I
> could not find any difference between the db's in tnsnames.ora, only
> that the working db is on another server, the failing one on the same
> as the db in which the job runs.
>
> The db link was created by the following command:
> create database link PFEPTEST.WORLD connect to PFEPPRO identified by
> <pwd> using 'PFEPTEST'
>
> The select is: select eventnum, msg, timestamp from
> pfeppro.y_event_log_at_pfeptest
>
> Any idea?
>
> Thanks
>
> Ulrich

Not without seeing the code.

Daniel Morgan Received on Fri Aug 23 2002 - 12:08:27 CDT