呀!ASM例項起不來可咋整

sjw1933發表於2020-06-05

   

一般來說,asm例項起不來有這麼幾種情況(以11g為例):

1、ocrvote磁碟損壞

2、asm例項記憶體分配不合理(很有可能是手賤亂設定重啟後起不來了,嘿嘿)

3、碰到bug了

 

進入正題,萬一碰到asm記憶體分配不合理,asm例項無法啟動咋整:

比如 ORA-00823: Specified value of sga_target greater than sga_max_size

 

下面是最常見和最常用的 ASM 初始化引數配置:

+ASM1.asm_diskgroups='DATA'#Manual Mount

+ASM2.asm_diskgroups='DATA'#Manual Mount

*.asm_diskstring='/dev/asm*'

*.asm_power_limit=1

*.diagnostic_dest='/u01/gridbase'

*.instance_type='asm'

*.large_pool_size=12M

*.remote_login_passwordfile='EXCLUSIVE'

 

當asm例項沒起來的時候你是無法更改asm引數檔案spfile的,這可咋整??

新建一個pfile:

[grid@racpri1 tmp]$ vi asm.ora

 

用pfile啟動asm例項

SQL> startup pfile='/tmp/asm.ora' mount  

ASM instance started

 

Total System Global Area 1135747072 bytes

Fixed Size                  2260728 bytes

Variable Size            1108320520 bytes

ASM Cache                  25165824 bytes

ASM diskgroups mounted

 

 

重建asm spfile:

SQL> create spfile='+ocrvt/racpri-cluster/ASMPARAMETERFILE/spfileasm.ora' from pfile='/tmp/asm.ora'

 

<<<<<<<<<<<<<<<< 自動修改了 gpnp profile 配置

[grid@racpri1 ~]$ asmcmd spget

+ocrvt/racpri-cluster/ASMPARAMETERFILE/spfileasm.ora

 

重啟驗證

 SQL> show parameter spfile

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string      +OCRVT/racpri-cluster/asmparam

                                                 eterfile/spfileasm.ora

SQL>


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23825935/viewspace-2696597/,如需轉載,請註明出處,否則將追究法律責任。

相關文章