Moving Oracle server from HPUX/Solaris to AIX

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_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> 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.

--
http://www.freelists.org/webpage/oracle-l