RE: AWE implementation on Windows 2000 - Potential solution for intermittent TNS-12560
Date: Tue, 12 May 2009 12:02:36 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB0675043F4E1F_at_mds3aex08.USIEXCHANGE.COM>
The theory is that shared server connections (MTS) should use less memory. However, I have been burned so many times with bugs and oddities, in everything from Oracle 7.3 to 10g, that I rarely use MTS. Our standard is not to use it, and if we do use MTS we run a stress test that is supposed to reveal any issues (and that test has mixed results).
That said, I love the idea of MTS and if the situation warrants it, you should try it.
-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
Sent: Tuesday, May 12, 2009 11:53 AM
To: cicciuxdba_at_gmail.com; Crisler, Jon; oracle-l-freelists
Subject: Re: AWE implementation on Windows 2000 - Potential solution for
intermittent TNS-12560
Hi do your users use dedicated or shared server connections? You may find that using shared servers reduces the memory pressure on the oracle.exe process.
On 5/11/09, Guillermo Alan Bort <cicciuxdba_at_gmail.com> wrote:
> I know the upgrade options I can take, the problem is the upgrade plan
is
> scheduled for the end of the year, and If I have to go through the
next
> eight monthgs without sleeping because of these database, I'll murder
> someone. So I need a somewhat short term solution. I keep reading
about
> this, but cannot find anything. I don't want to enable the 3G switch
because
> it could cause more instance evictions... At this point, I don't
really know
> what to do.
>
> Thanks anyway.
> Alan Bort
> Oracle Certified Professional
>
>
> On Mon, May 11, 2009 at 4:46 PM, Crisler, Jon <Jon.Crisler_at_usi.com>
wrote:
>
>> Its been a while since I worked on these versions, but perhaps you
are
>> running into a limit of 9i 32 bit ? For instance, 32 bit 9i and 10g
on
>> RedHat Linux have a practical limit of 1.7gb in the sga, unless you
resort
>> to tricks like hugemem, hugepages or hugetlb in the kernel, then
relink
>> Oracle 9i (no need to relink 10g).
>>
>>
>>
>> Assuming that Siebel supports 10g, this would be a perfect candidate
for
>> Oracle 10g RAC on Linux.
>>
>>
>> ------------------------------
>>
>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *On Behalf Of *Guillermo Alan Bort
>> *Sent:* Friday, May 08, 2009 6:25 PM
>> *To:* oracle-l-freelists
>> *Subject:* AWE implementation on Windows 2000 - Potential solution
for
>> intermittent TNS-12560
>>
>>
>>
>> Listers,
>>
>> I have a two node 9i RAC on Windows 2000 (SP4) Advanced Server.
This
>> database serves a Siebel software running on a different machine. I
don't
>> know why these are windows machines, and I have no prior experience
with
>> RAC
>> on windows. I know some of you might, but I'm not so sure about 9i.
>>
>> As this is 9i (9.2.0.8.0) ASM is out of the question. This
particular
>> setup is based on OCFS (OCSF1, of course) with the latest patchset
applied
>> to the srvm.
>>
>> Now, the problem started some time ago with frequent instance
evictions
>> (actually the version back then was 9.2.0.5.0) becoming more frequent
>> after
>> an anti-virus upgrade. I have requested to add oracle osd9i and
>> oracle_home
>> to the exception list of the AV, but with no luck so far (they have
not
>> done
>> so yet). I applied 9.2.0.8.0 both to CRM and OH in order to be in a
>> supported level, and opened an S.R. with Oracle.
>>
>> Instance evictions have actually dimished considerably (if not
stopped)
>> but a new problem arose. Since the upgrade we have been getting
several
>> TNS-12560 Protocol Adapter Error from one of the nodes (the second
one)
>> which is the one most users use to connect. After opening yet another
SR
>> with Oracle, they suggested that I should increase the buffer cache.
Now,
>> this is windows 2000, with 6GB (and obviously PAE wnabled at the OS
level)
>> but I've been unable to extend the db_cache beyond the 2G limit.(I
did
>> indeed use indirect_data_buffers and the legacy parameter
>> db_block_buffers).
>> Even so, I'm not able to extend the SGA beyond 2G.
>>
>> I've researched metalink and I'm most certain I'm missing
something. so
>> I was wondering what you take on this is, and if you have any ideas.
>>
>> On the other hand, I will get a SP report to make sure we have no
wild
>> queries and try to install OSW to monitor os performance.
>>
>> Thanks in advance.
>> Alan Bort
>> Oracle Certified Professional (just in 10g)
>>
>
-- Sent from Google Mail for mobile | mobile.google.com Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 12 2009 - 11:02:36 CDT