RE: 11gR2 Rac install issue
- From: "Matthew Zito" <mzito@xxxxxxxxxxx>
- To: <development@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Sep 2010 15:47:36 -0400
One of our customers noted this the other day - we worked with Oracle,
turns out it's bug 9383000 - assuming you're hitting the same issue our
customer is.
There's a patch for it, and it's fixed in 11.2.0.2.
Matt
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Bach
Sent: Wednesday, September 08, 2010 3:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: 11gR2 Rac install issue
Hi Martin,
that's interesting. Normally you have a 1:1 mapping between threads and
instances. The mapping of thread to instance usually happens in the
initialisation file (spfile), where you find something like
instance_n.thread=n i.e.
prod1.thread=1
prod2.thread=2
...
prod7.thread=7
In a seven node cluster I wouldn't expect more than 7 public threads,
unless there were even more nodes in the cluster which haven't been
deconfigured properly. What's the output of this query?
select thread#,status,enabled,instance from v$thread;
Best regards,
Martin
On 08/09/2010 18:48, Martin Brown wrote:
> Hello,
> I am looking around in a new install and I've noticed that the install
> seems to have created too many threads and corresponding redo logs. We
> use a 7-node cluster and I see 13 public threads. Is this normal? Any
> ideas where to look to see what caused it if it isn't?
>
> TIA
--
Martin Bach
OCM 10g
http://martincarstenbach.wordpress.com
http://www.linkedin.com/in/martincarstenbach
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
