Welcome 微信登录

首页 / 数据库 / MySQL / 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       
  • 1
  • 2
  • 3
  • 下一页
【内容导航】
第1页:创建VG第2页:创建lv
第3页:在已经创建的lv上创建文件系统
配置MySQL服务的自启动Oracle 10g中dbms_mview.refresh()函数相关资讯      AIX  Oracle基础教程 
  • AIX上断开的NFS 挂载点 导致   (02/18/2015 09:27:04)
  • 扩展AIX上的LV大小  (05/25/2014 07:30:14)
  • AIX下做定时任务注意事项  (04/26/2014 10:46:52)
  • AIX HACMP系统错误--NODE同步配置  (08/06/2014 14:42:53)
  • 使用Smitty进行AIX上Logical   (05/03/2014 14:32:47)
  • 断电导致的AIX上hacmp不能启动的问  (02/10/2014 19:49:10)
本文评论 查看全部评论 (0)
表情: 姓名: 字数