In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Platform:AIX 5.3 standalone has a free disk hdisk1
General idea: Physical Volume PV-> Volume Group VG-> Logical Volume LV (type: raw)-> Add Tablespace
1. View all available volume groups
# lsvg -o
rootvg
2. Create volume group datavg for ORACLE
# smitty lvm
Volume Groups
Add a Volume Group
Add an Original Volume Group
[Entry Fields]
VOLUME GROUP name [datavg]
Physical partition SIZE in megabytes 64 +
* PHYSICAL VOLUME names [hdisk1] +
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 +
# lsvg -o
datavg
rootvg
3. Create lvdata002 bare device for datavg
Create a bare device
# mklv -t raw -y lvdata002 -a e -e x -o y datavg 10
lvdata002
-e x Set bare device to multi-disk partition
Assign 10 PPs, i.e. 640M
# lsvg -l datavg
datavg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
lvdata002 raw 10 10 1 closed/syncd N/A
1 logical volume (bare device) of this volume group is unused (if logical volume with closed/syncd status is displayed in results)
Bare Device Permission
# chown -R oracle:oinstall /dev/rlvdata*
# chown -R oracle:oinstall /dev/lvdata*
4. Log in to ORACLE and add bare device data files to table space USERS
SQL> alter tablespace users add datafile '/dev/rlvdata002' size 100M; //SIZE cannot be equal to or greater than LV value, bare device name/dev/rlv*
Tablespace altered.
added successfully
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.