Wednesday, February 9, 2011

Adding swap space in AIX7.1 for running Oracle 11gR2

The swap requirement for running Oracle 11g R2 on AIX7.1 is as follows:
For 4 GB to 8 GB Memory the swap requirement is 2 times the size of RAM, for 8 GB to 32 GB the requirement is 1.5 times the size of RAM, and if the Memory is more than 32 GB then the swap space required is 32 GB.

isvp17> lsps -a
Page Space      Physical Volume   Volume Group Size %Used Active  Auto  Type Chksum
hd6             hdisk0            rootvg         512MB     3   yes   yes    lv     0
Ok, we are not doing good in that front. We'll have to find a way to increase the size of swap from 512MB to 
36GB.


So let us see how this can be done on AIX 7.1 .

isvp18> lspv
hdisk0          00f65d52a5abd459                    rootvg          active
hdisk1          00f65d52c3d3cfa6                    oradata         active
hdisk2          none                                None
hdisk3          none                                None
hdisk4          00f65d51c465f8eb                    metro
hdisk5          none                                None
isvp18> mkvg -y swap hdisk5


isvp17> lspv
hdisk0          00f65d51a5aa3cf1                    rootvg          active
hdisk1          00f65d51bfba4e2e                    test1           active
hdisk2          none                                None
hdisk3          none                                None
hdisk4          00f65d51c465f8eb                    metro           active
hdisk5          00f65d51cdf2c48c                    swap            active
isvp17> smitty mkps
+--------------------------------------------------------------------------+
|                            VOLUME GROUP name                             |
|                                                                          |
| Move cursor to desired item and press Enter.                             |
|                                                                          |
|   rootvg                                                                 |
|   test1                                                                  |
|   metro                                                                  |
|   swap                                                                   |
|                                                                          |
| F1=Help                 F2=Refresh              F3=Cancel                |
| F8=Image                F10=Exit                Enter=Do                 |
| /=Find                  n=Find Next                                      |
+--------------------------------------------------------------------------+



Add Another Paging Space

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

[Entry Fields]
Volume group name                                   swap
SIZE of paging space (in logical partitions)       [564]                   #
PHYSICAL VOLUME name                                                       +
Start using this paging space NOW?                  yes                    +
Use this paging space each time the system is       yes                    +
RESTARTED?
Checksum Size                                      []                      +#








F1=Help             F2=Refresh          F3=Cancel           F4=List
F5=Reset            F6=Command          F7=Edit             F8=Image
F9=Shell            F10=Exit            Enter=Do





COMMAND STATUS

Command: OK            stdout: yes           stderr: no

Before command completion, additional instructions may appear below.

paging00



isvp17> lsps -a
Page Space      Physical Volume   Volume Group Size %Used Active  Auto  Type Chksum
paging00        hdisk5            swap         36096MB     1   yes   yes    lv     0
hd6             hdisk0            rootvg         512MB     3   yes   yes    lv     0
isvp17>

There we go, we now have more than enough swap to run Oracle 11gR2 on AIX7.1

No comments: