Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONEORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]

如果使用asmca建立的asm例項，asm會自動註冊到crs,手動建立asm例項需要註冊

[10:18:03 oracle(grid)@test ~]$ sql

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 10:18:04 2013

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Automatic Storage Management option

10:18:05 idle> show parameter name

NAME TYPE VALUE

------------------------------------ --------------------------------- ------------------------------

db_unique_name string +ASM

instance_name string +ASM

lock_name_space string

service_names string +ASM

10:18:14 idle> create spfile from pfile;

create spfile from pfile

*

ERROR at line 1:

ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200] lsts[0]]

Elapsed: 00:00:00.17

10:19:06 idle> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Automatic Storage Management option

[10:19:12 oracle(grid)@test ~]$ srvctl add asm -l LISTENER -p /oracle/product/11.2.0/grid/dbs/init+ASM.ora -d 'ASMDISK*'

PRCR-1001 : Resource ora.LISTENER.lsnr does not exist

[10:20:19 oracle(grid)@rmdgl ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.cssd ora.cssd.type ONLINE ONLINE rmdgl

ora.diskmon ora....on.type OFFLINE OFFLINE

ora.evmd ora.evm.type ONLINE ONLINE rmdgl

ora.ons ora.ons.type OFFLINE OFFLINE

[10:20:35 oracle(grid)@test~]$ srvctl add asm -p /u01/app/11.2.0/grid/dbs/spfile+ASM.ora -d 'ASMDISK*'

[10:20:56 oracle(grid)@rmdgl ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.asm ora.asm.type OFFLINE OFFLINE

ora.cssd ora.cssd.type ONLINE ONLINE rmdgl

ora.diskmon ora....on.type OFFLINE OFFLINE

ora.evmd ora.evm.type ONLINE ONLINE rmdgl

ora.ons ora.ons.type OFFLINE OFFLINE

[10:20:58 oracle(grid)@test ~]$ cd /u01/app/11.2.0/grid/dbs/

[10:21:21 oracle(grid)@test dbs]$ ll

total 20

-rw-rw---- 1 oracle oinstall 1257 Sep 5 02:34 ab_+ASM.dat

-rw-rw---- 1 oracle oinstall 1544 Sep 5 02:34 hc_+ASM.dat

-rw-r----- 1 oracle oinstall 169 Aug 30 13:49 init+ASM.ora

-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora

-rw-r----- 1 oracle oinstall 2560 Aug 30 13:50 orapw+ASM

[10:21:22 oracle(grid)@test dbs]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.asm ora.asm.type OFFLINE OFFLINE

ora.cssd ora.cssd.type ONLINE ONLINE rmdgl

ora.diskmon ora....on.type OFFLINE OFFLINE

ora.evmd ora.evm.type ONLINE ONLINE rmdgl

ora.ons ora.ons.type OFFLINE OFFLINE

[10:21:40 oracle(grid)@rmdgl dbs]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.asm ora.asm.type OFFLINE OFFLINE

ora.cssd ora.cssd.type ONLINE ONLINE rmdgl

ora.diskmon ora....on.type OFFLINE OFFLINE

ora.evmd ora.evm.type ONLINE ONLINE rmdgl

ora.ons ora.ons.type OFFLINE OFFLINE

[10:23:16 oracle(grid)@rmdgl dbs]$ srvctl start asm

[10:23:20 oracle(grid)@rmdgl dbs]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.asm ora.asm.type ONLINE ONLINE rmdgl

ora.cssd ora.cssd.type ONLINE ONLINE rmdgl

ora.diskmon ora....on.type OFFLINE OFFLINE

ora.evmd ora.evm.type ONLINE ONLINE rmdgl

ora.ons ora.ons.type OFFLINE OFFLINE

[11:13:50 oracle(grid)@test dbs]$ sql

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 11:14:39 2013

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Automatic Storage Management option

11:14:39 idle> create spfile from pfile;

File created.

Elapsed: 00:00:00.24

Elapsed: 00:00:00.26

ORA-29786: SIHA attribute GET failed

相關文章