Hello, I have an AIX Oracle database server that I need to create a new filesystem/mount where I can create a new ORacle home to install 11g on. What are the needed steps to create this? There are mounts for Oracle 9i and 10g already. Thank you.
For hp-ux, you would have
pvcreate to create the physical volume
vgcreate to create the volume group
lvcreate to create the logical volume (or your mount point)
I seem to recall AIX as
mkdev
mkvg
mklv
So, take a look at mklv command.
The following link has a good cross-reference, so if you know a command for one unix flavor, it would point you to the associated command for a different unix flavor (or system type).
http://www.unixguide.net/
I am not having much luck here. Here are 2 mount point I have on my system.
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/fslv10 6029312 382560 94% 77098 46% /oracle9i
/dev/fslv14 7077888 318124 96% 33588 29% /oracle10G
All I want to do is create a new mount point called /oracle11g. How can I see what file systems are available. In Solaris there is a format command for formatting disks and allocating partitions. There is also a newfs command for putting a UFS filesystem on a disk. How do I set this all up on AIX? Thank you for you help.
mount
df
lsfs
You gotta know onto which Volume Group (vg) you want to place it, if you want to mirror it and how large it should be.
Then you have to create a Logical Volume (lv) and on top of it a filesystem (fs). Here an example for a LV with 1 copy (no mirror) of type "jfs2" with lv_ora11 as LV name placed on "somevg" using 12 Physical Partitions. How large 1 Phsyical Partitions is you can get by issuing "lsvg somevg".
mklv -c 1 -t jfs2 -y lv_ora11 somevg 12
Now for the FS:
crfs -v jfs2 -d /dev/lv_ora11 -m /oracle11g
mount /oracle11g
If you want different options, best check the man pages for those commands. You are lucky since in AIX are plenty of explained examples at the end of the man pages for about every command. I miss that on other OS'es sometimes. There are some considerations when using that in clusters or when creating FS'es with an extra log LV cause of performance.
Also you can use "smitty lvm" and use the ascii menues.
Okay I have an existing group on my system
# lsvg
rootvg
vg01
# lsvg vg01
VOLUME GROUP: vg01 VG IDENTIFIER: 000a8dac00004c00000000fc5ae7fa77
VG STATE: active PP SIZE: 128 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 1092 (139776 megabytes)
MAX LVs: 256 FREE PPs: 98 (12544 megabytes)
LVs: 24 USED PPs: 994 (127232 megabytes)
OPEN LVs: 17 QUORUM: 2
TOTAL PVs: 2 VG DESCRIPTORS: 3
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 2 AUTO ON: yes
MAX PPs per VG: 32512
MAX PPs per PV: 1016 MAX PVs: 32
LTG size: 128 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
I would like to create a 20GB mount point. In Solaris I can use the format command to see what disks are available to format and create a filesystem on. Can this volumn group be used. If not how do I see what is available on a disk to format?
-David
Using smitty lvm I created a new logical volume called fslv07:
LOGICAL VOLUME: fslv07 VOLUME GROUP: vg01
LV IDENTIFIER: 000a8dac00004c00000000fc5ae7fa77.15 PERMISSION: read/write
VG STATE: active/complete LV STATE: closed/syncd
TYPE: jfs2 WRITE VERIFY: on
MAX LPs: 512 PP SIZE: 128 megabyte(s)
COPIES: 1 SCHED POLICY: parallel
LPs: 12 PPs: 12
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle UPPER BOUND: 1
MOUNT POINT: N/A LABEL: /0racle11g
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?: YES
I believe that I need to create a mount point to it now using smitty fs. What determines what size this filesystem is? I need around 15 to 20GB.
Thank you.
-David
I created a filesystem but it is too small. When I tried to increase the size it complained. Using smitty fs:
Thank you.
-David
Okay, after much research I was able to create my logical volume and file system and allocate the desired disk soace to it. I need to deallocate space from other file systems first. Then I was able to increase my new one. Thanks to all for your help.
-David