Thursday, January 6, 2011

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

in 11gR2
SQL> 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]]

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: crsctl stat res
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on m3p131


m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: srvctl add asm -l LISTENER
m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: crsctl stat res
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.asm
TYPE=ora.asm.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on m3p131

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs:

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: sqlplus '/as sysasm'

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 6 09:43:53 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Automatic Storage Management option

SQL> create spfile from memory;

File created.

No comments: