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

  • From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
  • To: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • Date: Mon, 11 May 2009 17:26:46 -0300

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@xxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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)

Other related posts: