topic Re: SAS DI Oracle conncetion time out. in SAS Data Management

SAS DI Oracle conncetion time out.

raxit143 — Mon, 03 Jun 2019 18:33:01 GMT

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

Re: SAS DI Oracle conncetion time out.

ChrisLysholm — Mon, 03 Jun 2019 19:18:41 GMT

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.