SAS DI Oracle conncetion time out.

[raxit143]

Hello Mates,

I am getting attached error in DI job in oracle libname statement. Sometimes the job runs successfully but most of the times we are getting connection timeout.

The problem is at the same time - Oracle database in running fine and we can connect through toad.

What can be the possible cause and solution ?

Regards,

Rak**bleep** Shah

[ChrisLysholm]

Hello,

The ORA-12170 error can occur for a number of reasons such as database down, listener down, bad sqlnet.ora parameter, network issues and firewall issues among others.

Please see: http://www.dba-oracle.com/t_ora_12170_tns_connect_timeout.htm

If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values.