Re: AWE implementation on Windows 2000 - Potential solution for intermittent TNS-12560

From: Guillermo Alan Bort <>
Date: Mon, 11 May 2009 17:26:46 -0300
Message-ID: <>

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 <> 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:* [mailto:
>] *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 ( 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 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 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)

Received on Mon May 11 2009 - 15:26:46 CDT

Original text of this message