Search This Blog

Total Pageviews

Thursday 22 May 2014

ASM init file  .....

How to create a init+ASM.ora 


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


Create spfile for above error ...

init+ASM.ora 
 
 
###########################################
# Cache and I/O
###########################################
large_pool_size = 12m

###########################################
 # ASM Instance Parameters
###########################################
instance_type = asm
asm_power_limit = 1

###########################################
# Security and Diagnostics
###########################################
remote_login_passwordfile = exclusive
diagnostic_dest = '/u01/app/grid'

[grid@unknown dbs]$ vi init+ASM.ora
[grid@unknown dbs]$ !sql
sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 22 13:12:30 2014

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


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

SQL> create spfile from pfile ;

File created.

SQL> !cat init+ASM.ora
###########################################
# Cache and I/O
###########################################
large_pool_size = 12m
###########################################
 # ASM Instance Parameters
###########################################
instance_type = asm
asm_power_limit = 1
###########################################
# Security and Diagnostics
###########################################
remote_login_passwordfile = exclusive
diagnostic_dest = '/u01/app/grid'
 

ORA-15100: invalid or missing diskgroup name



ORA-15110: no diskgroups mounted 

ORA-15100: invalid or missing diskgroup name


set linesize 200
col PATH format a30
col LABEL format a15
select group_number, disk_number, name, label, path, redundancy, mount_status, header_status  from v$asm_disk;

GROUP_NUMBER DISK_NUMBER NAME                           LABEL           PATH                           REDUNDA MOUNT_S HEADER_STATU
------------ ----------- ------------------------------ --------------- ------------------------------ ------- ------- ------------
           0           0                                DATA            ORCL:DATA                      UNKNOWN CLOSED  MEMBER


SQL>  ALTER DISKGROUP data mount ;


set linesize 200
col PATH format a30
col LABEL format a15
select group_number, disk_number, name, label, path, redundancy, mount_status, header_status  from v$asm_disk;

GROUP_NUMBER DISK_NUMBER NAME                           LABEL           PATH                           REDUNDA MOUNT_S HEADER_STATU
------------ ----------- ------------------------------ --------------- ------------------------------ ------- ------- ------------
           1           0 DATA                           DATA            ORCL:DATA                      UNKNOWN CACHED  MEMBER



alter system set asm_diskstring='/dev/rdsk/*' scope=both;

SQL> alter system set asm_diskstring='ORCL:DATA' scope=both;

System altered.


SQL> alter system set asm_diskgroups='DATA' scope=both ;

Oracle DBA

anuj blog Archive