ORA-29786: SIHA attribute GET failed

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE ORA-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

 

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

 

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

 

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

 

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29033984/viewspace-773265/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29033984/viewspace-773265/