dbTalk Databases Forums  

Effect of listener on existing connections?

comp.databases.oracle.server comp.databases.oracle.server


Discuss Effect of listener on existing connections? in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Robert Klemme
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 01:17 AM






On 16.06.2008 23:48, groups.broberg (AT) gmail (DOT) com wrote:

Quote:
In any case, we haven't figured out how to replicate the scenario yet
- it only occurs in the production environment, and never showed up
during our testing. We typically tested a months worth of operation
at an accelerated rate (anywhere from 4x to 40x the normal speeds, so
tests finished in 2 - 7 days). We could start running some tests at
1x speeds, but given the intermittent rate of failure, it would be
hard to draw any conclusions from a non-zone-based system that didn't
fail after running for a month or two.

We may as well kick off a several-month simulation, though, in case we
start to see this problem occur with regularity.
I don't know Solaris too well but is there any chance to have some
monitoring run on the production box that exhibited the error over the
course of a week and try to capture circumstances of the error surfacing
that way? Maybe you can collect some network statistics along with
other data and later analyze it and find the error.

Kind regards

robert


Reply With Quote
  #42  
Old   
Robert Klemme
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 01:17 AM






On 16.06.2008 23:48, groups.broberg (AT) gmail (DOT) com wrote:

Quote:
In any case, we haven't figured out how to replicate the scenario yet
- it only occurs in the production environment, and never showed up
during our testing. We typically tested a months worth of operation
at an accelerated rate (anywhere from 4x to 40x the normal speeds, so
tests finished in 2 - 7 days). We could start running some tests at
1x speeds, but given the intermittent rate of failure, it would be
hard to draw any conclusions from a non-zone-based system that didn't
fail after running for a month or two.

We may as well kick off a several-month simulation, though, in case we
start to see this problem occur with regularity.
I don't know Solaris too well but is there any chance to have some
monitoring run on the production box that exhibited the error over the
course of a week and try to capture circumstances of the error surfacing
that way? Maybe you can collect some network statistics along with
other data and later analyze it and find the error.

Kind regards

robert


Reply With Quote
  #43  
Old   
Robert Klemme
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 01:17 AM



On 16.06.2008 23:48, groups.broberg (AT) gmail (DOT) com wrote:

Quote:
In any case, we haven't figured out how to replicate the scenario yet
- it only occurs in the production environment, and never showed up
during our testing. We typically tested a months worth of operation
at an accelerated rate (anywhere from 4x to 40x the normal speeds, so
tests finished in 2 - 7 days). We could start running some tests at
1x speeds, but given the intermittent rate of failure, it would be
hard to draw any conclusions from a non-zone-based system that didn't
fail after running for a month or two.

We may as well kick off a several-month simulation, though, in case we
start to see this problem occur with regularity.
I don't know Solaris too well but is there any chance to have some
monitoring run on the production box that exhibited the error over the
course of a week and try to capture circumstances of the error surfacing
that way? Maybe you can collect some network statistics along with
other data and later analyze it and find the error.

Kind regards

robert


Reply With Quote
  #44  
Old   
mpacheco_brazil@hotmail.com
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 08:07 AM



Not sure if it will help or if it is even related but the default
value of the environment parameter USE_SHARED_SOCKET changed from 9i
to 10g. In 9i the default was FALSE and now it is TRUE. Do you use any
kind of gateway to other databases or a Firewall in production?

Reply With Quote
  #45  
Old   
mpacheco_brazil@hotmail.com
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 08:07 AM



Not sure if it will help or if it is even related but the default
value of the environment parameter USE_SHARED_SOCKET changed from 9i
to 10g. In 9i the default was FALSE and now it is TRUE. Do you use any
kind of gateway to other databases or a Firewall in production?

Reply With Quote
  #46  
Old   
mpacheco_brazil@hotmail.com
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 08:07 AM



Not sure if it will help or if it is even related but the default
value of the environment parameter USE_SHARED_SOCKET changed from 9i
to 10g. In 9i the default was FALSE and now it is TRUE. Do you use any
kind of gateway to other databases or a Firewall in production?

Reply With Quote
  #47  
Old   
mpacheco_brazil@hotmail.com
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 08:07 AM



Not sure if it will help or if it is even related but the default
value of the environment parameter USE_SHARED_SOCKET changed from 9i
to 10g. In 9i the default was FALSE and now it is TRUE. Do you use any
kind of gateway to other databases or a Firewall in production?

Reply With Quote
  #48  
Old   
mpacheco_brazil@hotmail.com
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 08:07 AM



Not sure if it will help or if it is even related but the default
value of the environment parameter USE_SHARED_SOCKET changed from 9i
to 10g. In 9i the default was FALSE and now it is TRUE. Do you use any
kind of gateway to other databases or a Firewall in production?

Reply With Quote
  #49  
Old   
mpacheco_brazil@hotmail.com
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 08:07 AM



Not sure if it will help or if it is even related but the default
value of the environment parameter USE_SHARED_SOCKET changed from 9i
to 10g. In 9i the default was FALSE and now it is TRUE. Do you use any
kind of gateway to other databases or a Firewall in production?

Reply With Quote
  #50  
Old   
mpacheco_brazil@hotmail.com
 
Posts: n/a

Default Re: Effect of listener on existing connections? - 06-17-2008 , 08:07 AM



Not sure if it will help or if it is even related but the default
value of the environment parameter USE_SHARED_SOCKET changed from 9i
to 10g. In 9i the default was FALSE and now it is TRUE. Do you use any
kind of gateway to other databases or a Firewall in production?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.