ASM是搞定 就是数据库建不起来

bluemoon0083

clusterware和asm分开多好，非要整在一起

kogbdmanager

楼主，我创建好了oracle用户，然后然装grid Infrastructure 的时候在create disk group的时候没有可用的盘显示出来
[root@dzg u02]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [  OK  ]
Creating /dev/oracleasm mount point: [  OK  ]
Loading module "oracleasm": [  OK  ]
Mounting ASMlib driver filesystem: [  OK  ]
Scanning system for ASM disks: [  OK  ]
[root@dzg u02]# /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]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: [  OK  ]
Scanning system for ASM disks: [  OK  ]
[root@dzg u02]# /etc/init.d/oracleasm createdisk VOL1 /dev/hda6
Marking disk "/dev/hda6" as an ASM disk: [  OK  ]
[root@dzg u02]# /etc/init.d/oracleasm createdisk VOL2 /dev/hda7
Marking disk "/dev/hda7" as an ASM disk: [  OK  ]
[root@dzg u02]# /etc/init.d/oracleasm createdisk VOL3 /dev/hda8
Marking disk "/dev/hda8" as an ASM disk: [  OK  ]
[root@dzg u02]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
这里显示正常，就是在图形create disk group的时没有可用的盘

Himmelskorper

原帖由 kogbdmanager 于 2009-9-10 14:59 发表
楼主，我创建好了oracle用户，然后然装grid Infrastructure 的时候在create disk group的时候没有可用的盘显示出来
[root@dzg u02]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [  OK  ]
Creating /dev/oracleasm mount point: [  OK  ]
Loading module "oracleasm": [  OK  ]
Mounting ASMlib driver filesystem: [  OK  ]
Scanning system for ASM disks: [  OK  ]
[root@dzg u02]# /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  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]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: [  OK  ]
Scanning system for ASM disks: [  OK  ]
[root@dzg u02]# /etc/init.d/oracleasm createdisk VOL1 /dev/hda6
Marking disk "/dev/hda6" as an ASM disk: [  OK  ]
[root@dzg u02]# /etc/init.d/oracleasm createdisk VOL2 /dev/hda7
Marking disk "/dev/hda7" as an ASM disk: [  OK  ]
[root@dzg u02]# /etc/init.d/oracleasm createdisk VOL3 /dev/hda8
Marking disk "/dev/hda8" as an ASM disk: [  OK  ]
[root@dzg u02]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
这里显示正常，就是在图形create disk group的时没有可用的盘

去你帖子里回

楼主，你好！我也在这近几天玩了一次，也搞定了ASM，可是监控搞不定，DBCA也没有办法找到ASM存储。
不知道搞定ASM之后，如果让DBA找到ASM实例，监听如何处理

Himmelskorper

原帖由 zluo 于 2009-11-2 13:14 发表
楼主，你好！我也在这近几天玩了一次，也搞定了ASM，可是监控搞不定，DBCA也没有办法找到ASM存储。
不知道搞定ASM之后，如果让DBA找到ASM实例，监听如何处理

http://www.itpub.net/viewthread. ... p;extra=&page=2
参见顶楼 或51楼 还有问题 请附上已完成步骤 以及疑问点

nishishuia123

万恶的grid，我真是服了

Himmelskorper

原帖由 nishishuia123 于 2009-11-11 19:29 发表
万恶的grid，我真是服了

没啥万恶不万恶的 很多DBA现在都想DB复杂点 这样能保住工作 而个人是没有办法阻挡软件自动化的趋势的。自动化，简单化是趋势，虽然在短时间内有不稳定等问题，但长期来讲总是会解决的

stziyan

原帖由 Himmelskorper 于 2009-9-8 09:27 发表
建库到最后出现问题 没思路解决 有思路来看一下
623146
623147

请问这个有解决么？

stziyan

原帖由 Himmelskorper 于 2009-9-8 09:27 发表
建库到最后出现问题 没思路解决 有思路来看一下
623146
623147

搞定了，要把 grid加入dba组。

Charele

grid不必要加入dba组,oracle才要加入的.

安装Grid时用grid用户,安装Oracle11gR2时用oracle用户.