ååãŸã§ã®ãããã
ããã«ã¡ã¯ãæ°äººè¥äºãããåºæ¥å 茩ã®å©ããåããªãããã¢ããŸã³ ãŠã§ã ãµãŒãã¹(以äžAWS)äžã§Oracle DBãäœæããããšèšããã®äŒç»ãååã§ã¯VNCã䜿ã£ãä»®æ³ãã·ã³ãžã®ãã°ã€ã³ãOracleã®èŠä»¶ã«åãããEC2ã®ã€ã³ã¹ã¿ã³ã¹ã¿ã€ãã®å€æŽãè¡ããŸãããååã¹ã¯ããé åãè¶³ããªãããšããããã£ã¹ã¯ã远å ããŸããã®ã§ãç¶ããã©ããã
![]()
è¥äº ããã (ãããããã)
æ°äººãšã³ãžãã¢ã§ãä»åããŒã¿ããŒã¹èª²ã«é å±ãšãªã£ããæ¬ç©èªã®äž»äººå ¬ã
![]()
åºæ¥ ç代 (ã§ã ãŸãã)
äžå ãšã³ãžãã¢ã§ãããŒã¿ããŒã¹èª²ã«æå±ããã幎霢ã¯äžè©³ãä»äºç±å¿ã§ãæ¯èŒçåŸèŒ©ã®é¢åèŠããããå§ããŸã¿ã€ããâ» ãã®ç©èªã¯ãã£ã¯ã·ã§ã³ã§ãããç»å Žããå£äœã»äººç©ãªã©ã®åç§°ã¯ãã¹ãŠæ¶ç©ºã®ãã®ã§ã
EC2ãžãã£ã¹ã¯ã远å ããã
åºæ¥ããElastic BLOCK STORE(以äžEBS)ãã4GBã®ããªã¥ãŒã ãäœã£ãŠã皌åäžã®EC2ãžã®ãAttachããå®äºããããæ¬¡ã¯è¿œå ããããªã¥ãŒã ãå©çšã§ããããã«OSã®èšå®ãããå¿
èŠãããã®ããã
è¥äºãä»åã¯4GBå
šéšãã¹ã¯ããé åãšããŠå©çšãããã§ããããã
åºæ¥ãããããOracleã®æšå¥šå€ããçŸåšã®3.6GBã®ã¡ã¢ãªã®å Žåãã¹ã¯ããã¯åçšåºŠã®å€§ããã®ã¹ã¯ããé åãšãªã£ãŠããããããã
è¥äºãåãããŸãããã
åºæ¥ããŸãã¯ã远å ãããã£ã¹ã¯ãOSã§èªèãããŠãããã©ãã確èªããŸããããã
[root@ip-172-31-24-192 ~]# cat /proc/partitions
major minor #blocks name
202 65 6291456 xvde1
202 144 4194304 xvdj
[root@ip-172-31-24-192 ~]#
è¥äºãxvdjãšãã4GBã®ãã£ã¹ã¯ãèªèãããŠããã¿ããã§ãããã
åºæ¥ããã®ç¶æ
ã ãšããŸã äœãåæåãããŠããªãããããŸãã¯fdiskã³ãã³ãã䜿ã£ãŠãããŒãã£ã·ã§ã³ãäœããŸããããã
[root@ip-172-31-24-192 ~]# fdisk /dev/xvdj
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xc7e4efe3.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help):
åºæ¥ãfdiskã³ãã³ãã¯ãã£ã¹ã¯ã«å¯ŸããŠããããããªæäœãã§ããã®ãmã³ãã³ãã§ãã«ããèŠããããã確èªããŠãããŸããããã
Command (m for help): m
Command action
a toggle a bootable flag
b edit bsd disklabel
c toggle the dos compatibility flag
d delete a partition
l list known partition types
m print this menu
n add a new partition
o create a new empty DOS partition table
p print the partition table
q quit without saving changes
s create a new empty Sun disklabel
t change a partition's system id
u change display/entry units
v verify the partition table
w write table to disk and exit
x extra functionality (experts only)
Command (m for help):
åºæ¥ããŸãã¯çŸç¶ã®ãã£ã¹ã¯ã®ç¶æ ã確èªããŸããããpã³ãã³ããå ¥åããŠãã
Command (m for help): p
Disk /dev/xvdj: 4294 MB, 4294967296 bytes
255 heads, 63 sectors/track, 522 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xc7e4efe3
Device Boot Start End Blocks Id System
Command (m for help):
åºæ¥ããããçŸç¶ã®ãã£ã¹ã¯ã®ç¶æ ãããŸã äœãããŒãã£ã·ã§ã³ãåãã㊠ããªããããäžèЧã«ã¯äœãåºãŠãªãããããããããŒãã£ã·ã§ã³ãäœæããŠã¿ãŸããããnã³ãã³ãã§äœæã¢ãŒãã«ãªã£ãŠãã
Command (m for help): n
Command action
e extended
p primary partition (1-4)
åºæ¥ãä»åã¯primary partitionãäœæãããããpã³ãã³ããå ¥åããŠããŒãã£ã·ã§ã³çªå·ã«ã¯1ãå ¥åããŠãã
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
åºæ¥ã次ã¯éå§ã·ãªã³ããçµäºã·ãªã³ãã®èšå®ãå ¥åãããã ãã©ãä»å㯠ãè€æ°ã«åå²ã¯ããªããããå šãŠããã©ã«ãã®ãŸãŸã§å€§äžå€«ããã
First cylinder (1-522, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-522, default 522):
Using default value 522
Command (m for help):
åºæ¥ãäœæã§ããããããäžåºŠããã£ã¹ã¯ã®ç¶æ ã確èªããŸããããã
Command (m for help): p
Disk /dev/xvdj: 4294 MB, 4294967296 bytes
255 heads, 63 sectors/track, 522 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xc7e4efe3
Device Boot Start End Blocks Id System
/dev/xvdj1 1 522 4192933+ 83 Linux
Command (m for help):
åºæ¥ããã£ã¹ã¯ã«æ°ããããŒãã£ã·ã§ã³ã/dev/xvdj1ãã远å ãããŠããããšã確èªã§ããããããã®ãã£ã¹ã¯ãã¹ã¯ããé åãšããŠäœ¿ãããã«tã³ãã³ãã䜿ã£ãŠãããŒãã£ã·ã§ã³ã®ã¿ã€ãã82(Linuxã¹ã¯ãã)ã«å€æŽããã®ãã
Command (m for help): t
Selected partition 1
Hex code (type L to list codes): 82
Changed system type of partition 1 to 82 (Linux swap / Solaris)
Command (m for help): p
Disk /dev/xvdj: 4294 MB, 4294967296 bytes
255 heads, 63 sectors/track, 522 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xc7e4efe3
Device Boot Start End Blocks Id System
/dev/xvdj1 1 522 4192933+ 82 Linux swap / Solaris
Command (m for help):
åºæ¥ãæåŸã«ãããŸã§ãã£ã倿Žãä¿åããããã«ãwã³ãã³ãã䜿ã£ãŠãfdiskãçµäºããŠãã
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@ip-172-31-24-192 ~]#
åºæ¥ãããã§ããŒãã£ã·ã§ã³ã¯å®æããæ¬¡ã«ãã®ããŒãã£ã·ã§ã³ãã¹ã¯ããé åã«ããŸãããããŸãã¯mkswapã³ãã³ãã§ã¹ã¯ããé åãäœæãããããã
[root@ip-172-31-24-192 ~]# mkswap /dev/xvdj1
Setting up swapspace version 1, size = 4192928 KiB
no label, UUID=cb96bf8d-1c61-4cc4-97d5-6d56ba0c4af2
[root@ip-172-31-24-192 ~]#
åºæ¥ã次ã«äœæããã¹ã¯ããé åã®æå¹åãã
[root@ip-172-31-24-192 ~]# swapon /dev/xvdj1
åºæ¥ãããã§ã¹ã¯ããé åã®äœæã¯å®äºããäžæŠãã¹ã¯ããé åã®ç¢ºèªãããŠã¿ãŸãããããã
[root@ip-172-31-24-192 ~]# grep SwapTotal /proc/meminfo
SwapTotal: 4192924 kB
[root@ip-172-31-24-192 ~]#
è¥äºãã¹ã¯ããé åã«4GBèªèãããŠããŸãããã
åºæ¥ãOKãããããã®ã¹ã¯ããé åãåèµ·åããŠããèªåçã«ããŠã³ããããããã«ãã/etc/fstabããã¡ã€ã«ã«ä»åã®å
容ã远èšããŠãã
è¥äºãäºè§£ããŸããã远èšããŸããã
[root@ip-172-31-24-192 ~]# vi /etc/fstab
[root@ip-172-31-24-192 ~]# cat /etc/fstab
LABEL=_/ / ext4 defaults 1 1
/dev/xvdb /mnt ext3 defaults,context=system_u:object_r:usr_t:s0 0 0
none /proc proc defaults 0 0
none /sys sysfs defaults 0 0
none /dev/pts devpts gid=5,mode=620 0 0
none /dev/shm tmpfs defaults 0 0
/dev/xvdj1 swap swap defaults 0 0 âââãã®è¡ã远èš
[root@ip-172-31-24-192 ~]#
è¥äºãããã確èªã®çºã«äžååèµ·åããŸãããã
[root@ip-172-31-24-192 ~]# shutdown -r now
è¥äºã倧äžå€«ã§ãããèªåã§ããŠã³ããããŠãŸããã
åºæ¥ãããã§ãã¹ã¯ããé åãå®äºããæ¬¡ã®èŠä»¶ã®ç¢ºèªã«ç§»ããŸããããã(第4話åç
§)ã
åºæ¥ã次ã¯ã/tmpã®ãã£ã¹ã¯å®¹éã®ç¢ºèªããã
è¥äºãdf -hã®çµæã¯ãããªæãã§ãããã
[root@ip-172-31-24-192 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvde1 6.0G 2.7G 3.2G 47% /
none 1.9G 0 1.9G 0% /dev/shm
[root@ip-172-31-24-192 ~]#
åºæ¥ã/tmpãã£ã¬ã¯ããªã¯ã/dev/xvde1ãã®ãã£ã¹ã¯äžã«é
眮ãããŠãããããããã¯åé¡ãªãããããã
è¥äºããããæ¬¡ã®èŠä»¶ã®ç¢ºèªã¯ããœãããŠã§ã¢ãããŒã¿ãã¡ã€ã«ã®ãã£ã¹ã¯èŠä»¶ã§ããã©ãããã¯å
šãè¶³ããªãã§ãããã
åºæ¥ãããããã¹ã¯ããé åãäœæããèŠé ã§ãããäžåãã£ã¹ã¯è¿œå ããŸãããããä»åºŠã¯20GBã®ãã£ã¹ã¯ã远å ããŸããããã
è¥äºãåãããŸããããŸãã¯ããAWS ãããŒãžã¡ã³ã ã³ã³ãœãŒã«ããããEBSã®äœæãšEC2ãžã®ãAttachãããããŸããã
â» ãã®éšåã®æé ã«é¢ããŠã¯ç¬¬4åãåç §ããŠäžããã
è¥äºã次ã¯è¿œå ãããã£ã¹ã¯ãOSã§èªèããŠãããã©ãã確èªããŸããã
[root@ip-172-31-24-192 ~]# cat /proc/partitions
major minor #blocks name
202 65 6291456 xvde1
202 144 4194304 xvdj
202 145 4192933 xvdj1
202 160 20971520 xvdk
[root@ip-172-31-24-192 ~]#
è¥äºã20GBã®ãã£ã¹ã¯ãããxvdkããšããŠèªèãããŸãããã
åºæ¥ããããããä»åãããŒãã£ã·ã§ã³ã®äœæã¯åºæ¬ããŒãã£ã·ã§ã³ã§å€§äžå€«ããã ãã©ãä»åã¯ã¹ã¯ããé åã§ã¯ç¡ããããããŒãã£ã·ã§ã³ã¿ã€ããã¹ã¯ããé åã«å€æŽããå¿
èŠã¯ãªããããŸãã¯ããŒãã£ã·ã§ã³ã®äœæãŸã§ãã£ãŠã¿ãŠãã
[root@ip-172-31-24-192 ~]# fdisk /dev/xvdk
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xf1a43be2.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): m
Command action
a toggle a bootable flag
b edit bsd disklabel
c toggle the dos compatibility flag
d delete a partition
l list known partition types
m print this menu
n add a new partition
o create a new empty DOS partition table
p print the partition table
q quit without saving changes
s create a new empty Sun disklabel
t change a partition's system id
u change display/entry units
v verify the partition table
w write table to disk and exit
x extra functionality (experts only)
Command (m for help): p
Disk /dev/xvdk: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xf1a43be2
Device Boot Start End Blocks Id System
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2610, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-2610, default 2610):
Using default value 2610
Command (m for help): p
Disk /dev/xvdk: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xf1a43be2
Device Boot Start End Blocks Id System
/dev/xvdk1 1 2610 20964793+ 83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@ip-172-31-24-192 ~]#
è¥äºãã¯ããå®äºããŸãããã
åºæ¥ãããããæ¬¡ã¯ã远å ããããŒãã£ã·ã§ã³ãåæåãããŸããããä»åã¯ãmkfsãã³ãã³ãã§ãext4ããšãããã©ãŒãããã§åæåããããããã¯ãã°ããæéãæããããäžæŠäŒæ©ã«ããŸããããã
è¥äºããµãŒãã¡ãã£ãšã³ãŒããŒé£²ãã§ãããã
åºæ¥ãããã猶ã³ãŒããŒãªã奢ãããã
è¥äºãå
茩ãããããšãããããŸã!ã
[root@ip-172-31-24-192 ~]# mkfs.ext4 /dev/xvdk1
mke2fs 1.41.12 (17-May-2010)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
1310720 inodes, 5241198 blocks
262059 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
160 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information:
done
This filesystem will be automatically checked every 37 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
[root@ip-172-31-24-192 ~]#
ãŸã ãŸã ãOracleã®ã€ã³ã¹ããŒã«èŠä»¶ã®ç¢ºèªã¯ç¶ããŸããæ¬¡åãžç¶ãã
å·çè 玹ä»
å±±å£ æ£å¯(YAMAGUCHI Masahiro)
æ ªåŒäŒç€Ÿã·ã¹ãã ãµããŒã æ±äº¬æ¯ç€Ÿã€ã³ãã©ãœãªã¥ãŒã·ã§ã³äºæ¥éšæå±ã
å瀟ãåŸæãšããOracleããŒã¿ããŒã¹ã®ãšã³ãžãã¢ã§ãå€§èŠæš¡DWHã®DB管çè ãDBã³ã³ãµã«ã¿ã³ããªã©ãçµéšããŸããå瀟ã®ç¡æã»ãããŒã®äŒç»ã«ãæºããã
ä»åãæ©åšããªããŠãæ°è»œã«ç°å¢ãæ§ç¯ãæ€èšŒããããšããããåãã« AWSäžã§OracleããŒã¿ããŒã¹ãæ§ç¯ããããšãã¹ããŒãªãŒèª¿ã§èšèŒããã å°ãå瀟ã¯AWSãçšããã¯ã©ãŠãå·¥æ¿ powered by AWSãšãããããã¯ãããããç£åŠå®é£æºã§ã掻çšããŠããã