记录一下:
1.ASM无法启动进而导致DB无法启动
2.尝试su - grid,发现grid not exist,
但是有/home/grid,判定应该是谁删掉了 grid账户?
3.尝试建立grid账户,useradd -g oinstall -G dba,asmadmin,asmdba grid -d /home/grid
4.启动has与css
su - grid
crsctl start has
crsctl start css
5.启动asm
asmcmd -p
startup
asm启动ok
6.启动database:
su - oracle
sqlplus / as sysdba
startup
发现仍然无法起来
7.观察alert:
进入adrci
show alert -tail 10 -f,同时sqlplus / as sysdba >startup观察
看到 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/app/grid/grid_home/bin/oracle)(ARGV0=oracle+ASM_asmb_g3md)(ENVS=‘ORACLE_HOME=/app/grid/grid_home,ORACLE_SID=+ASM’)(ARGS=‘(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))’))(enable=setuser))
8.回到grid,给oracle进程授权
su - grid
cd $ORACLE_HOME/bin
chmod 6751 oracle
9.startup db again, it 's ok right now
记一次ASM無法啟動進而導致DB無法啟動的案例
于 2021-12-17 12:05:46 首次发布