user environment variables

[krisna]

Hi All,

I have simple parallel job drs stage --> transformer --> seq. When the values like hostname, username, password are defaulted then the job is executing succssesfully but the same jobs executed wtih project leve paramaeters (user environment variables) job is getting aborted. In log we are getting the message that 'Fatal Error: Fatal: ORA-12545: Connect failed because target host or object does not exist.

Note : Job is designed using datastage 7.5.3 and moved to datastage 7.5.2
all the environment variables are in 7.5.2 environment also.

Thanks in advance.

[vinothkumar]

Are both versions are installed in same unix server. If yes, check the values of the parameters that got populated through Environment variables by seeing the director log.

[mobashshar]

This error usually happens when your dsenv file values are wrong. Please check your 7.5.2 dsenv and make sure it is pointing to the correct and valid oracle_home and you are exporting the correct TNS_ADMIN value.

[ArndW]

can you do a tnsping to your database from the DataStage server?