RE: AWE implementation on Windows 2000 - Potential solution for intermittent TNS-12560
- From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
- To: <cicciuxdba@xxxxxxxxx>, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 May 2009 15:46:10 -0400
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 (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)
Other related posts:
