Oracle Enterprise Stage-How to define timeout period

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
RaviReena
Premium Member
Premium Member
Posts: 68
Joined: Tue Jul 29, 2008 10:01 am

Oracle Enterprise Stage-How to define timeout period

Post by RaviReena »

My ORACLE enterprise read stage is failing with ORA-12170: TNS:Connect timeout occurred.How we can define timeout parameter more than 60 secs, looks like default timeout is 60 sec from other posts.Is it possible to define thru Additional connection options?

Any help is greatly appreciated.
Rao V
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That would be more of a DBA / sqlnet configuration discussion. For example: http://www.dba-oracle.com/t_ora_12170_t ... imeout.htm
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply