I have a simple Parallel Job (7.5x) which has the following.
1) sff stage
2) OCI 9i stage
3) a join stage which inner joins data from (1) and (2).
4) Another OCI 9i stage which upserts into a different Oracle table.
The job ran successfully in Development and Stage . I also got my UAT done.
When this job got migrated to Production it aborts however, with the following error.
ociRiskChangeProviderContract,1: connect failed for env: EDWPROD, user: etl_user, password: *****
Oracle error: -12154
ORA-12154: TNS:could not resolve service name.
i know what it means, however i checked the server name and everything and it is correct.(tnsping works , logged in also though it isnt the user name/paswd problem)
If i remove the second OCI stage and put the output in a flat file and run it again without changing anything it runs perfectly fine.
I have another job but with a single OCI stage and that works fine too.
both the OCI stages are using the same parameters which are passed by the sequencer ( i double checked that).
The only difference between the three enviornments is the config file has 6 nodes in prod while only 2 in dev.
Secondly dev and stage env have a SID while production has a Service_name .
I am
![Confused :?](./images/smilies/icon_confused.gif)
Need help
Thanxs
-S