Saturday, March 2, 2013

ORACLE - Unable To Create ASM Spfile

Unable To Create ASM Spfile :

SQL> select * from V$ASM_ATTRIBUTE;
no rows selected

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL> alter diskgroup MWDATA1 set ATTRIBUTE 'compatible.asm' = '11.2.0.0.0';
Diskgroup altered.

SQL> select * from V$ASM_ATTRIBUTE;
name                                     value                                      
------------------------------------------------
disk_repair_time                        3.6h     
au_size                                      1048576
sector_size                                 512    
compatible.asm                          11.2.0.0.0
compatible.rdbms                       10.1.0.0.0
cell.smart_scan_capable              FALSE  
access_control.enabled               FALSE
access_control.umask                 066
SQL> startup
ASM instance started
Total System Global Area  283930624 bytes
Fixed Size                  2227664 bytes
Variable Size             256537136 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

create spfile='+MWDATA1' from pfile='/u01/app/oracle/product/11.2.0/grid/dbs/initHMWHIST.ora';

SQL> show parameter spfile;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +MWDATA1/asm/asmparameterfile/registry.253.806108083

Ref: Unable To Create ASM Spfile Standalone [ID 1082332.1]

No comments:

Post a Comment