现在的位置: 首页 > 数据库 > 正文

oracle 11g rac asm 磁盘名字更换

2019年09月29日 数据库 ⁄ 共 1362字 ⁄ 字号 暂无评论
博客主机

原来用的是rhdisk*,现在需要用rhdiskpower*(数据是一样的,前面是链路盘,后面是聚合盘)

1、修改asm实例的asm磁盘默认查找路径参数asm_diskstring,使用如下命令:
alter system set asm_diskstring='/dev/rhdiskpower*' scope=spfile;

2、关闭整个Cluster
./crsctl stop cluster -all

3、修改磁盘熟悉

lsattr -El hdiskpower0
lsattr -El hdiskpower1 //确保磁盘的reserve_policy=no_reserve(防止共享盘被一台节点锁住)

//修改磁盘的reserve_policy属性
chdev -l hdiskpower0 -a reserve_policy=no_reserve
chdev -l hdiskpower1 -a reserve_policy=no_reserve

4、修改磁盘属组
chown grid:asmadmin /dev/rhdiskpower*
chmod 660 /dev/rhdiskpower*
ls -l /dev/rhdiskpower*

5、打开cluster
./crsctl start cluster -all

6、启动数据库的时候报错:
srvctl start database -d ebms

$ srvctl start database -d cad
PRCR-1079 : Failed to start resource ora.cad.db
CRS-5017: The resource action "ora.cad.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RAC/cad/spfilecad.ora'
ORA-17503: ksfdopn:2 Failed to open file +RAC/cad/spfilecad.ora
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 1002 (oinstall), current egid = 1001 (dba)

这个是oracle的权限不对导致的,修改权限如下:

chmod 6755 $GRID_HOME/bin/oracle
确保权限是如下:

[grid@gddb_1 ~]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 209914519 Apr 15 2017 /u01/app/grid/product/11.2.0/bin/oracle

还有就是查看两边节点的grid和oracle用户看是否一致:
id grid
id oracle

给我留言

留言无头像?