Categotry Archives: ASM

ASM discovered an insufficient number of disks for diskgroup “DATA” 错误

0

Posted on by

在asmca的时候在一边mount了,另一边没有mount:

[grid@rac1 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576      4094     3988                0            1994              0             N  ARCH/
MOUNTED  EXTERN  N         512   4096  1048576      6141     4106                0            4106              0             N  DATA/
MOUNTED  EXTERN  N[......]

查看全文

How to start up the ASM instance when the spfile is misconstrued or lost

1

Posted on by

在11g中,asm的spfile都存放在asm磁盘组中,所以当ASM的spfile被消失了或删除了,需要自己手动写个pfile 临时把磁盘组mount,然后create spfile到原来的磁盘组上。

错误:

- Start the ASM instance fail with error

SQL> startup;
ORA-00099: warning: no parameter file specified for ASM instance
ORA-00304: requested INSTANCE_NUMBER is busy

- Start up the CRS services fail with error

# crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors

- Checked t[......]

查看全文

11.2.0.3 asm报ORA-04031

0

Posted on by

数据库11.2.0.3 在ASM instances后台会报 ORA-04031这样的错

ERROR at line 1:
ORA-04031: unable to allocate 256 bytes of shared memory ("shared
pool","unknown object","PCursor","kglob")
 
原因是:
1) ASM instance was running out of shared pool free memory.
2) The shared pool free memory was close to 0 MB on the affected ASM instances:
 

+ASM1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~[......]

查看全文