Oracle ASM介紹和安裝Linux5.2+Oracle10g+ASM過程

Oracle ASM介紹和安裝Linux5.2+Oracle10g+ASM過程

1）ASM（自動儲存管理）的來由：

ASM是Oracle 10g R2中為了簡化Oracle資料庫的管理而推出來的一項新功能，這是Oracle自己提供的卷管理器，主要用於替代作業系統所提供的LVM，它不僅支援單一實例，同時對RAC的支援也是非常好。ASM可以自動管理磁碟組並提供有效資料冗餘功能。使用ASM（自動儲存管理）後，資料庫管理員不再需要對ORACLE中成千上萬的資料檔案進行管理和分類，從而簡化了DBA的工作量，可以使得工作效率大大提高。

2）什麼是ASM

ASM它提供了以平台無關的檔案系統、邏輯卷管理以及軟RAID服務。ASM可以支援條帶化和磁碟鏡像，從而實現了在資料庫被載入的情況下添加或移除磁碟以及自動平衡I/O以刪除“熱點”。它還支援直接和非同步I/O並使用Oracle9i中引入的Oracle資料管理器API（簡化的I/O系統調用介面）。

ASM是做為單獨的Oracle執行個體實施和部署，並且它只需要有參數檔案，不需要其它的任何物理檔案，就可以啟動ASM執行個體，只有它在啟動並執行時候，才能被其它資料訪問。在Linux平台上，只有運行了OCSSD服務（Oracle安裝程式預設安裝）了才能和訪問ASM。

如何修改ASM的sys密碼

如何將ASM中的資料檔案複製到作業系統中

Oracle 11g RAC ASM磁碟全部丟失後的恢複

Oracle 11g從入門到精通 PDF+光碟片原始碼

RHEL6 ASM方式安裝Oracle 11g R2

Oracle 10g 手工建立ASM資料庫

Ubuntu 12.04(amd64)安裝完Oracle 11gR2後各種問題解決方案

如何修改Oracle 10g ASM的sys密碼

3）安裝配置asm軟體

1.：otn http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel4-092650.html 找對應核心的asm所需安裝包

2.以root使用者安裝asm包: 

ps:kernel-debug kernel-PAE kernel-xen 是asm所需先前包，從linux安裝光碟片中可以獲得 

 3.硬碟分區 

[root@localhost temp]# fdisk -l


Disk /dev/sda: 214.7 GB, 214748364800 bytes
255 heads, 63 sectors/track, 26108 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes


Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 535 4192965 82 Linux swap / Solaris
/dev/sda3 536 26108 205415122+ 83 Linux


Disk /dev/sdb: 214.7 GB, 214748364800 bytes
255 heads, 63 sectors/track, 26108 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes


Disk /dev/sdb doesn't contain a valid partition table


Disk /dev/sdc: 107.3 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes


Disk /dev/sdc doesn't contain a valid partition table
[root@localhost temp]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.




The number of cylinders for this disk is set to 26108.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)


Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-26108, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-26108, default 26108):
Using default value 26108


Command (m for help): w
The partition table has been altered!


Calling ioctl() to re-read partition table.
Syncing disks.
[root@localhost temp]# fdisk /dev/sdc
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.




The number of cylinders for this disk is set to 13054.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)


Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-13054, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-13054, default 13054):
Using default value 13054


Command (m for help): w
The partition table has been altered!


Calling ioctl() to re-read partition table.
Syncing disks.

更多詳情見請繼續閱讀下一頁的精彩內容：

1 2 3 下一頁