TNS Protocol Error
Posted: Mon Sep 29, 2008 1:29 pm
Hi All,
I have a job that reads the data from DRS Stage and Loads to Oracle Eneterprise stage.
When I hard code the parameter values in DRS Stage the job is running fine. When I use the enviroinment variables it is getting aborted. I had cross verified the values and they are correct for ENV. The following are the errors I get in the job:
Failure during execution of operator logic.
Fatal Error: Fatal: ORA-12560: TNS:protocol adapter error
node_node1: Player 1 terminated unexpectedly.
main_program: APT_PMsectionLeader(1, node1), player 1 - Unexpected exit status 1.
If I login directly to server and run the job the job is working fine with enviroinment variables. But when I login to client and run the job iam getting the following error.
Best Regards
Cherry
I have a job that reads the data from DRS Stage and Loads to Oracle Eneterprise stage.
When I hard code the parameter values in DRS Stage the job is running fine. When I use the enviroinment variables it is getting aborted. I had cross verified the values and they are correct for ENV. The following are the errors I get in the job:
Failure during execution of operator logic.
Fatal Error: Fatal: ORA-12560: TNS:protocol adapter error
node_node1: Player 1 terminated unexpectedly.
main_program: APT_PMsectionLeader(1, node1), player 1 - Unexpected exit status 1.
If I login directly to server and run the job the job is working fine with enviroinment variables. But when I login to client and run the job iam getting the following error.
Best Regards
Cherry