Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3406
  • Last Modified:

Oracle "timeout" problem

I am supporting an n-tiered application. The front end is an Eclipse plug in. The eclipse plug in sends XML messages to a middleware layer that connects to an Oracle database and returns an XML message.  At one site, a "timeout" has been set for security reasons. As a result, the middleware is losing connectivity to the database after 30 minutes and subsequent queries fail.

I have been told that the timeout has been set at  the database level, but cannot figure out what may have been done exactly.

My goal:  to reproduce this timeout error on my own system (I do not have an error message handy, but it was a standard "not connected to oracle" message - will post it if I can get it).  

Thanks
0
AaronAbend
Asked:
AaronAbend
1 Solution
 
sdstuberCommented:
It could be a sqlnet.ora option on the middle tier

It could also be a profile set in the database

select * from dba_profiles where resource_name in ('IDLE_TIME','CONNECT_TIME')    --  use this to find what the parameters are set to

select username, profile from dba_users   -- use this to see what profile is assigned to the middle tier's account.
0
 
AaronAbendAuthor Commented:
Thanks - I think it was the resource_limit that is set at this site.  the last step was to set resource_limit=true at the database level (alter system set resource_limit=true) since without that setting resource limits are not applied.

Premature congratulations on making guru - looksl like you are only a few points away.  These should help!

Best,

Aaron
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now