ORA-12154 from background job

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 Received on Fri Aug 23 2002 - 03:16:22 CDT