AIX 5L上安装Oracle 10G

AIX 5L上安装Oracle 10G

在AIX 5L上安装Oracle 10G，需要先划空间，下文将讲述使用smit创建vg的过程
shell>smitty mkvg:
Move cursor to desired item and press Enter.

  Add an Original Volume Group
  Add a Big Volume Group
  Add a Scalable Volume Group

选择第一项即可，第2和第3项都是在增加了vg容量作出了调整，但是本文是测试，不需要多大的空间，也没有那么多的pv供选择。
默认情况下是第一项，加车即可
回车后
Add an Original Volume Group

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

                                                        [Entry Fields]
  VOLUME GROUP name                                  [oradata]
  Physical partition SIZE in megabytes                8                                                                         +
* PHYSICAL VOLUME names                              [hdisk2]                                                                   +
  Force the creation of a volume group?               no                                                                         +
  Activate volume group AUTOMATICALLY                 yes                                                                        +
    at system restart?
  Volume Group MAJOR NUMBER                          []                                                                          +#
  Create VG Concurrent Capable?                       no                                                                         +
按两次回车确认
Command: failed        stdout: yes           stderr: no

Before command completion, additional instructions may appear below.

0516-1208 /usr/sbin/mkvg: Warning, The Physical Partition Size of 8 requires the
        creation of 35762 partitions for hdisk4.  The system limitation is 16256
        physical partitions per disk at a factor value of 16. Specify a larger
        Physical Partition Size or a larger factor value in order create a
        volume group on this disk.
0516-862 /usr/sbin/mkvg: Unable to create volume group.

晕，提示要加大pp的大小，用F3退回
因为普通vg要求 多只能含有16256个pp，因为目前的磁盘空间是35762*8/1024约为280G
从pv上看大小，大致也可以验证这一点：
[tydic91:root:/]#i=$((35762*8))
[tydic91:root:/]#echo $i
286096
[tydic91:root:/]#lspv hdisk4
PHYSICAL VOLUME:    hdisk4                   VOLUME GROUP:     oradata
PV IDENTIFIER:      005f555d8f66431e VG IDENTIFIER     005f555d00004c000000012ebf74ac0f
PV STATE:           active                                    
STALE PARTITIONS:   0                        ALLOCATABLE:      yes
PP SIZE:            512 megabyte(s)          LOGICAL VOLUMES:  0
TOTAL PPs:          558 (285696 megabytes)   VG DESCRIPTORS:   2
FREE PPs:           558 (285696 megabytes)   HOT SPARE:        no
USED PPs:           0 (0 megabytes)          MAX REQUEST:      256 kilobytes
FREE DISTRIBUTION:  112..112..111..111..112                   
USED DISTRIBUTION:  00..00..00..00..00                        
hdisk4为280G左右
16<285696/16256=17<32
因此，其最小大小应该为32M

测试下：
1）删除VG组
[tydic91:root:/]#lspv
hdisk0          005f555d8ece14ea                    rootvg          active
hdisk1          005f555d7afe4fe8                    rootvg          active
hdisk2          005f555d8f6640f8                    None           
hdisk3          005f555d8f66420a                    None           
hdisk4          005f555d8f66431e                    oradata         active
[tydic91:root:/]#varyoffvg oradata
[tydic91:root:/]#lspv
hdisk0          005f555d8ece14ea                    rootvg          active
hdisk1          005f555d7afe4fe8                    rootvg          active
hdisk2          005f555d8f6640f8                    None           
hdisk3          005f555d8f66420a                    None           
hdisk4          005f555d8f66431e                    oradata        
[tydic91:root:/]#exportvg oradata
[tydic91:root:/]#lspv
hdisk0          005f555d8ece14ea                    rootvg          active
hdisk1          005f555d7afe4fe8                    rootvg          active
hdisk2          005f555d8f6640f8                    None           
hdisk3          005f555d8f66420a                    None           
hdisk4          005f555d8f66431e                    None

2）以32M创建VG
再以32M创建
VOLUME GROUP name                                  [oradata]
  Physical partition SIZE in megabytes                32                                                                         +
* PHYSICAL VOLUME names                              [hdisk2]                                                                   +
  Force the creation of a volume group?               no                                                                         +
  Activate volume group AUTOMATICALLY                 yes                                                                        +
    at system restart?
  Volume Group MAJOR NUMBER                          []                                                                          +#
  Create VG Concurrent Capable?                       no                                                                         +
Command: OK            stdout: yes           stderr: no

Before command completion, additional instructions may appear below.

oradata
果然，32M不存在这个问题
3)最后重复第2步，将卷组名设置为oradatavg，PP大小为64M
VOLUME GROUP name                                  [oradata]
  Physical partition SIZE in megabytes                64                                                                          +
* PHYSICAL VOLUME names                              [hdisk2]                                                                   +
  Force the creation of a volume group?               yes                                                                        +
  Activate volume group AUTOMATICALLY                 yes                                                                        +
    at system restart?
  Volume Group MAJOR NUMBER                          []                                                                          +#
  Create VG Concurrent Capable?                       no                                                                         +

Command: OK            stdout: yes           stderr: no

Before command completion, additional instructions may appear below.

oradatavg

[tydic91:root:/]#lspv
hdisk0          005f555d8ece14ea                    rootvg          active
hdisk1          005f555d7afe4fe8                    rootvg          active
hdisk2          005f555d8f6640f8                    oradatavg    active           
hdisk3          005f555d8f66420a                    None           
hdisk4          005f555d8f66431e                    None