ORA-12571: TNS:packet writer failure
Posted: Wed Sep 16, 2009 11:11 am
I am running a Job which reads the data from a dataset and writes the data to a Oracle Table. There are no column level transformations or filters in the Job. This is a simple Job which inserts/updates the source data to the target table on a daily basis.
Dataset -> Transformer -> Oracle Enterprise Stage
The Job is aborting consistently with the following error.
ORA-12571: TNS:packet writer failure
and when I restart the Job, the Job runs successfully.
We turned on the tracing at the database level/network level/Job level but no issues were seen in the trace files by the Oracle/IBM customer support. Right now Information Server is on windows and we recently migrated to AIX and tested the Jobs on AIX but there are no TNS errors reported on AIX.
Today when I ran the Jobs on windows every job that I start is failing with TNS error and our DBA informed me that he is seeing blocking locks on the tables. Does the blocking locks cause this error? If so why is the same job with the same data running fine on AIX? Is this error environment related(Windows Vs AIX) or network related? I worked on multiple projects but haven't encountered this error in my earlier projects.
Moving to AIX will help us overcome this issue but I want to understand the root cause of this problem. Can someone help me out?
Thanks in advance for your inputs.
Dataset -> Transformer -> Oracle Enterprise Stage
The Job is aborting consistently with the following error.
ORA-12571: TNS:packet writer failure
and when I restart the Job, the Job runs successfully.
We turned on the tracing at the database level/network level/Job level but no issues were seen in the trace files by the Oracle/IBM customer support. Right now Information Server is on windows and we recently migrated to AIX and tested the Jobs on AIX but there are no TNS errors reported on AIX.
Today when I ran the Jobs on windows every job that I start is failing with TNS error and our DBA informed me that he is seeing blocking locks on the tables. Does the blocking locks cause this error? If so why is the same job with the same data running fine on AIX? Is this error environment related(Windows Vs AIX) or network related? I worked on multiple projects but haven't encountered this error in my earlier projects.
Moving to AIX will help us overcome this issue but I want to understand the root cause of this problem. Can someone help me out?
Thanks in advance for your inputs.