I am getting flowing error when trying to access remote datastage though OCI plugin.
ORA-12537: TNS:connection closed
Its never happen sql promt. I am getting this error every 10.20 min. Some time its work fine.
I am trying to access remote database using 10/12 OCI pluging in same job.
TNS connection problem
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to ask your Oracle DBA about this. It's Oracle that's closing the connection, not DataStage. The DBA ought to be able to use tracing tools to determine a cause.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.