问题:

ORA-00445: background process "J000" did not start after 120 seconds

alert日志:

2021-11-22T17:06:44.576509+08:00
Starting ORACLE instance (normal) (OS id: 27383)
2021-11-22T17:06:44.950311+08:00
****************************************************
 Sys-V shared memory will be used for creating SGA 
 ****************************************************
2021-11-22T17:06:44.950938+08:00
**********************************************************************
2021-11-22T17:06:44.950970+08:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

2021-11-22T17:06:44.951029+08:00
 Domain name: user.slice
2021-11-22T17:06:44.951060+08:00
 Per process system memlock (soft) limit = 3072M
2021-11-22T17:06:44.951090+08:00
 Expected per process system memlock (soft) limit to lock
 instance MAX SHARED GLOBAL AREA (SGA) into memory: 1794M
2021-11-22T17:06:44.951146+08:00
 Available system pagesizes:
  4K, 2048K 
2021-11-22T17:06:44.951203+08:00
 Supported system pagesize(s):
2021-11-22T17:06:44.951232+08:00
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2021-11-22T17:06:44.951268+08:00
        4K       Configured               3          458755        NONE
2021-11-22T17:06:44.951342+08:00
     2048K                0             897               0        NONE
2021-11-22T17:06:44.951372+08:00
RECOMMENDATION:
2021-11-22T17:06:44.951402+08:00
 1. For optimal performance, configure system with expected number 
 of pages for every supported system pagesize prior to the next 
 instance restart operation.
2021-11-22T17:06:45.045730+08:00
**********************************************************************
2021-11-22T17:06:48.954503+08:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2021-11-22T17:06:49.065043+08:00
Initial number of CPU is 1
Number of processor cores in the system is 1
Number of processor sockets in the system is 1
2021-11-22T17:06:50.681967+08:00
KSXRTEST ISGA: RM Channel count = 1
KSXRTEST ISGA: rcnt= 70 rmrcnt = 1
2021-11-22T17:06:57.141096+08:00
Capability Type : Network 
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Runtime Environment 
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems 
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Database Test 
capabilities requested : 3 detected : 0 Simulated : 0
2021-11-22T17:06:58.641033+08:00
kjidomenacan initialized to 3
2021-11-22T17:07:02.274350+08:00
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/19c/db_1/dbs/arch
2021-11-22T17:07:04.109659+08:00
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =497
2021-11-22T17:07:06.121626+08:00
LICENSE_MAX_USERS = 0
SYS auditing is enabled
2021-11-22T17:07:11.322414+08:00
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
2021-11-22T17:07:24.185900+08:00
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
NOTE: Cluster configuration type = CLUSTER [4]
2021-11-22T17:07:39.120405+08:00
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0.
ORACLE_HOME:    /u01/app/oracle/product/19c/db_1
System name:	Linux
Node name:	rach01
Release:	3.10.0-1127.el7.x86_64
Version:	#1 SMP Tue Feb 18 16:39:12 EST 2020
Machine:	x86_64
Using parameter settings in client-side pfile /u01/app/oracle/cfgtoollogs/dbca/rach/initrachTempOMF.ora on machine rach01
System parameters with non-default values:
  processes                = 3000
  nls_language             = "AMERICAN"
  nls_territory            = "AMERICA"
  sga_target               = 1792M
  control_files            = "/u01/app/oracle/cfgtoollogs/dbca/rach/tempControl.ctl"
  db_block_size            = 8192
  compatible               = "19.0.0"
  db_create_file_dest      = "+RACHDATA"
  undo_tablespace          = "UNDOTBS1"
  instance_number          = 1
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=rachXDB)"
  local_listener           = "-oraagent-dummy-"
  audit_file_dest          = "/u01/app/oracle/admin/rach/adump"
  audit_trail              = "DB"
  db_name                  = "seeddata"
  db_unique_name           = "rach"
  open_cursors             = 300
  pga_aggregate_target     = 597M
  _diag_hm_rc_enabled      = FALSE
  diagnostic_dest          = "/u01/app/oracle"
  enable_pluggable_database= TRUE
2021-11-22T17:07:52.429506+08:00
Cluster Communication is configured to use IPs from: GPnP
IP: 169.254.26.62	 Subnet: 169.254.0.0
KSIPC Loopback IP addresses(OSD): 
127.0.0.1	
KSIPC Available Transports: UDP:TCP
KSIPC: Client: KCL	 Transport: UDP
KSIPC: Client: DLM	 Transport: UDP
KSIPC CAPABILITIES :MGA:IPCLW:GRPAM:TOPO:DLL:STATSFW:CRTRK
KSXP: ksxpsg_ipclwtrans: 2 UDP
2021-11-22T17:07:54.398188+08:00
cluster interconnect IPC version: [IPCLW over UDP(mode 3) ]
IPC Vendor 1 proto 2
2021-11-22T17:09:45.561274+08:00
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 6.0 
2021-11-22T17:10:48.197046+08:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2021-11-22T17:14:46.671081+08:00
Starting background process PMON
2021-11-22T17:19:51.156589+08:00
Errors in file /u01/app/oracle/diag/rdbms/rach/rach1/trace/rach1_ora_27383.trc  (incident=24001) (PDBNAME=CDB$ROOT):
ORA-00445: background process "PMON" did not start after 120 seconds
2021-11-22T17:19:55.357038+08:00
Incident details in: /u01/app/oracle/diag/rdbms/rach/rach1/incident/incdir_24001/rach1_ora_27383_i24001.trc
2021-11-22T17:21:31.120509+08:00
USER (ospid: ): terminating the instance due to ORA error 
2021-11-22T17:21:32.930670+08:00
Instance terminated by USER, pid = 27383

执行挂载/dev/shm到tmpfs信息,写入/etc/fstab文件中,具体流程如下:

oracle rac dbca建库时出现Action: Modify /etc/fstab to mount /dev/shm with appropriate size._柠檬的博客-CSDN博客

再次安装:

报错如下:

DIA0 Critical Database Process Blocked: Hang ID 1 blocks 3 sessions
     Final blocker is session ID 21 serial# 41468 OSPID 9889 on Instance 2
     No resolution will be attempted by Hang Manager
2021-11-23T10:08:02.236578+08:00
Errors in file /u01/app/oracle/diag/rdbms/rach/rach2/trace/rach2_asmb_10495.trc:
ORA-59708: Cluster site operation failed with error 5.
CLSU-910: Named exception clsu mod=clsu_get_node_site loc=8611 msg=PROCL-48: Cannot perform the Oracle Local Registry operation due to a transient error. Messaging error [gipcretTimeout] [16]
CLSU-600: Internal Error [5] [48] [SYSTEM.version.localhost.site] [0] [0]
2021-11-23T10:08:05.551334+08:00
Errors in file /u01/app/oracle/diag/rdbms/rach/rach2/trace/rach2_asmb_10495.trc  (incident=297) (PDBNAME=CDB$ROOT):
ORA-59708 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/rach/rach2/incident/incdir_297/rach2_asmb_10495_i297.trc


DIA0 Critical Database Process Blocked: Hang ID 1 blocks 2 sessions
     Final blocker is session ID 21 serial# 50439 OSPID 16874 on Instance 1
     No resolution will be attempted by Hang Manager

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐