Architecting, installing and maintaining your SAS environment

How can I change the timeout period for SAS/Access to Oracle libraries?

Reply
Super Contributor
Posts: 387

How can I change the timeout period for SAS/Access to Oracle libraries?

Hi,

Occasionally our Oracle database is down during work hours.  This causes our pre-assigned Oracle libraries to (eventually) time out.  It takes a fairly long time to timeout, and this causes issues with one of our web applications, as the lengthy startup for the workspace server causes the web application to abort.  It also causes EG to take a *long* time to start the workspace server.

Is there a setting, either on the Oracle libname statement, or in the Oracle client (even better) that will cause this scenario to "fail fast"?

And if there are reasons why this would be a bad idea, please let me know.  But, when Oracle is up, the connection is quite snappy, so I would think I could shorten the timeout period a lot without causing problems.

Thanks,

Scott

Super User
Posts: 3,256

Re: How can I change the timeout period for SAS/Access to Oracle libraries?

Posted in reply to ScottBass

Do you use the DEFER = YES option on your Oracle pre-assigned libraries? We use it on all of our external database pre-assigned libraries as it helps speed up connections to workspace servers and helps reduce timeout problems because database connections are only established when they are actually used, rather than being active throughout the workspace server sessions.

Moderator
Posts: 252

Re: How can I change the timeout period for SAS/Access to Oracle libraries?

Posted in reply to ScottBass

Scott - do they need to be pre-assigned?

Ask a Question
Discussion stats
  • 2 replies
  • 1026 views
  • 0 likes
  • 3 in conversation