亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

Linux RH5平臺下使用Oracle ASM創建數據庫

系統 1966 0
一、安裝配置先決條件

1.安裝oracleasm支持包

創建asm數據庫,首先需要ASMLib驅動程序包,可以從相關的網站下載到和操作系統對應的rpm文件,分別為oracleasm-support- 2.0.3-1、oracleasm-2.6.18-8.el5- 2.0.4-1.el5、oracleasmlib-2.0.3-1.el5。

# rpm -Uvh oracleasm*.rpm

# rpm -qa|grep oracleasm
oracleasm-support-2.0.3-1
oracleasm-2.6.18-8.el5-2.0.4-1.el5
oracleasmlib-2.0.3-1.el5

2.添加磁盤

關閉VMware,添加一塊磁盤并格式化。

# 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 1044.
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-1044, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-1044, default 1044):
Using default value 1044

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

Calling ioctl() to re-read partition table.
Syncing disks.
[root@server oracleasmlib]# fdisk -l

Disk /dev/sda: 17.1 GB, 17179869184 bytes
255 heads, 63 sectors/track, 2088 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??????? 2088??? 16667437+ 8e Linux LVM

Disk /dev/sdb: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot????? Start???????? End????? Blocks?? Id System
/dev/sdb1?????????????? 1??????? 1044???? 8385898+ 83 Linux

3.配置rawdevices

因為rh5中取消了rawdevices服務,要使用裸設備創建asm,需要做以下配置。

# vi /etc/udev/rules.d/60-raw.rules

添加以下部分的內容

ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"

# start_udev
Starting udev: [ OK ]


4.配置oracleasm

以root用戶登陸,執行
# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface [oracle]:
Default group to own the driver interface [dba]:
Start Oracle ASM library driver on boot (y/n) [y]:
Fix permissions of Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: [ OK ]
Loading module "oracleasm": [ OK ]
Mounting ASMlib driver filesystem: [ OK ]
Scanning system for ASM disks:
[ OK ]

# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1
Marking disk "/dev/sdb1" as an ASM disk: [ OK ]
#
[root@server oracleasmlib]# /etc/init.d/oracleasm listdisks
VOL1
[root@server oracleasmlib]# /etc/init.d/oracleasm scandisks
Scanning system for ASM disks:
[ OK ]

二、創建ASM實例

1.創建初始化文件

$ su – oracle
$ cd $ORACLE_HOME/dbs
$ vi init+ASM.ora

*.asm_diskstring='ORCL:VOL*'
*.background_dump_dest='/oracle/admin/+ASM/bdump'
*.core_dump_dest='/oracle/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/oracle/admin/+ASM/udump'

2.創建密碼文件

$ su – oracle
$ cd $ORACLE_HOME/dbs
$ orapwd file=orapw+ASM password=dba

3. 創建目錄結構
$ su – oracle
$ cd $ORACLE_HOME/dbs
$ mkdir –p $ORALCE_BASE/admin/+ASM/udump
$ mkdir –p $ORALCE_BASE/admin/+ASM/bdump
$ mkdir –p $ORALCE_BASE/admin/+ASM/cdump

4. 啟動實例
$ export ORACLE_SID=+ASM
$ sqlplus / as sysdba
SQL> startup
ASM instance started

Total System Global Area?? 100663296 bytes
Fixed Size?????????????????? 777616 bytes
Variable Size????????????? 99885680 bytes
Database Buffers????????????????? 0 bytes
Redo Buffers????????????????????? 0 bytes
ORA-15110: no diskgroups mounted

因為我們是首次啟動asm實例,還沒有創建diskgroup,所以顯示15110錯誤是正常的。

如果啟動實例的時候碰到如下報錯:
ORA-29701: unable to connect to Cluster Manager
那么請檢查/etc/inittab 文件,看看是否有下面這行
h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1 </dev/null
如果沒有請添加,如果被注釋了請取消注釋。

5. 創建 spfile,重新啟動
SQL> create spfile from pfile;
SQL> shutdown immediate;
SQL> startup;

6. 創建 diskgroup
SQL> create diskgroup dgroup1 external redundancy
2 failgroup fgroup1 disk 'ORCL:VOL1';

Diskgroup created.

SQL> col name for a10
SQL> select name,state from v$asm_diskgroup;

NAME?????? STATE
---------- ----------------------
DGROUP1??? MOUNTED

如果上述命令返回的 state是 DISMOUNTED,那么我們需要手工將掛載 diskgroup
SQL> ALTER DISKGROUP dgroup1 MOUNT;

Diskgroup altered.

SQL> show parameter asm_diskgroups

NAME???????????????????????????????? TYPE?????? VALUE
------------------------------------ ---------- ------------------------------
asm_diskgroups?????????????????????? string???? DGROUP1

三、創建ASM數據庫

接下來,創建ASM數據庫的工作就非常的簡單了。執行dbca實用程序,在第六步“storage options”部分選擇“Automatic Storage Management ”,在接下來的“ASM Disk Groups”步驟中,選擇之前創建的“DGROUP1”,再按照普通建庫的方式完成數據庫的創建就OK了。

Linux RH5平臺下使用Oracle ASM創建數據庫


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦?。。?/p>

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 五月天 亚洲| 美女色影院 | 国产精品成人观看视频网站 | 国产黄色自拍 | 中文字幕一区二区精品区 | 色婷婷精品大视频在线蜜桃视频 | 久艾草国产成人综合在线视频 | 日韩不卡在线观看 | 亚洲精品一区二 | 日本a级精品一区二区三区 日本a毛片在线播放 | 久久国产精品国产精品 | 精品成人在线视频 | 中国日韩欧美中文日韩欧美色 | 四虎永久免费在线观看 | a4yy私人毛片 | 99国产精品热久久久久久夜夜嗨 | 欧美在线操 | 一区二区三区免费在线 | 91国内在线国内在线播放 | 99热这里只有精品国产在热久久 | 久久精品免费大片国产大片 | 久久久免费| 天天操天天插天天射 | 久久www香蕉免费人成 | 亚洲欧洲日韩国产一区二区三区 | 四虎澳门永久8848在线影院 | 亚洲精品久久99久久一区 | 久久草在线观看 | 特黄特a级特别特级特毛片 特黄特黄aaaa级毛片免费看 | 无码免费一区二区三区免费播放 | 2021最新国产成人精品视频 | 亚洲免费片 | 四虎永久在线精品视频播放 | 综合久久久久综合 | 亚洲国产精品综合欧美 | 欧美特级一级毛片 | 不卡午夜视频 | 国产 高清 在线 | 奇米在线777在线视频 | 欧美人成一本免费观看视频 | 亚洲精品在线不卡 |