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]
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