oracle rac dbca建库出现ORA-00445: background process “J000“ did not start after 120 seconds
问题:ORA-00445:backgroundprocess"J000"didnotstartafter120secondsalert日志:2021-11-22T17:06:44.576509+08:00Starting ORACLE instance (normal) (OS id: 27383)2021-11-22T17:06:44.950311+08:00******************
·
问题:
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

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