ORA-3113 at Database Startup (nomount)
最近x7一体机补丁更新碰见各种各样问题,由于未使用一体机专用补丁导致数据库通讯使用UTP协议,发现这个问题后,立即使用备份目录进行还原操作,但是节点1无法启动,节点2可以正常启动,启动过程如下报错
[oracle@dm01dbadm01 ~]$ ss
SQL*Plus: Release 11.2.0.4.0 Production on Thu May 19 12:17:48 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORA-03113: end-of-file on communication channel
SQL> exit
遇到这个错误也是比较懵逼的,一般情况下启动到mount状态时这个问题比较常见,nomount状态就报错还是头一次遇见,alert日志信息如下
##并未有什么错误日志信息
Thu May 19 11:51:04 2022
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = 339 GB
Total Shared Global Region in Large Pages = 200 GB (100%)
Large Pages used by this instance: 102401 (200 GB)
Large Pages unused system wide = 19721 (39 GB)
Large Pages configured system wide = 123140 (241 GB)
Large Page size = 2048 KB
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 48
Number of processor cores in the system is 24
Number of processor sockets in the system is 1
查看Oracle用户使用的共享内存段和信号量,虽然数据库未启动,但是startup nomount之后共享内存段和信号量都没有释放
[oracle@dm01dbadm01 ~]$ ipcs -a
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 0 root 644 64 2 dest
0x00000000 32769 root 644 16384 2 dest
0x00000000 65538 root 644 280 2 dest
0x00000000 98307 root 644 80 2
0x00000000 131076 root 644 16384 2
0x00000000 163845 root 644 280 2
0x00000000 1867786 oracle 640 1610612736 0
0x00000000 1900555 oracle 640 133680857088 0
0x00000000 1933324 oracle 640 66571993088 0
0x00000000 1966093 oracle 640 33285996544 0
0x00000000 1998862 oracle 640 16642998272 0
0x00000000 2031631 oracle 640 4294967296 0
0x00000000 2064400 oracle 640 12348030976 0
0x4fa509b8 2097169 oracle 640 2097152 0
------ Semaphore Arrays --------
key semid owner perms nsems
0x61000c72 98306 root 666 1
0x1d843a0c 6029319 oracle 640 626
0x1d843a0d 6062088 oracle 640 626
0x1d843a0e 6094857 oracle 640 626
0x1d843a0f 6127626 oracle 640 626
0x1d843a10 6160395 oracle 640 626
通过查看补丁集发现问题,明明已经通过备份目录进行还原,但是还存在更新补丁的记录
通过还原最早的备份目录解决,重启后集群状态如下