Moving Oracle server from HPUX/Solaris to AIX
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <Rich.Jesse@xxxxxx>
- Date: Wed, 10 May 2006 10:16:45 -0700
Hi Jesse,
Lucky for you, I've just gone through the same HP > AIX migration, twice now
(IBM must have some great sales people). Here is a summary of what I've
learned:
1) Use concurrent IO (cio) - for 9i you have to mount your filesystems with -o
cio, and set filesystemio_options=setall, but for 10g it is not necessary to
mount the filesystems with cio as Oracle will issue the O_CIO flag in its file
open calls. For your redologs, place them on a separate filesystem mounted
with cio and created with agblksize=512
2) export AIXTHREAD_SCOPE=S in Oracle's environment before starting your
instance & listener
3) set minperm/maxperm/maxclient to 5/15/15 to start with and adjust from there
if necessary
4) Bump up maxservers for aio, it is per CPU and you'll probably want to start
with 50-100 and adjust from there by checking the number of aioserver processes
under a load and seeing if you're hitting the max.
5) Pin SGA and use large pages (e.g. LOCK_SGA=true, v_pinshm=1, vmo-r -o
lgpg_size= 16777216 -o lgpg_regions=(SGA size / 16 MB), chuser
capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle)
I've had excellent performance with the above config, but of course YMMV.
Regards,
Brandon Allen
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Jesse, Rich
> Sent: Tuesday, May 09, 2006 4:23 PM
> To: ORACLE-L
> Subject: Moving Oracle server from HPUX/Solaris to AIX
>
> Hey all,
>
> The hammer has fallen and I've just been told that our ERP system's DB
> will be AIX.
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
