Startup nomount is too slow due to RDS load
(Doc ID 2744358.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Startup nomount is too slow.
DB alert log shows as below
2020-11-20T20:02:34.726507+09:00
Starting ORACLE instance (normal) (OS id: 27992)
2020-11-20T20:02:35.371233+09:00
SGA allocation is optimized
2020-11-20T20:02:35.373635+09:00
************************************************************
Instance SGA_TARGET = 577536 MB and SGA_MAX_SIZE = 577536 MB
************************************************************
2020-11-20T20:02:39.961757+09:00
...
optimizer_adaptive_plans = FALSE
diagnostic_dest = "/opt/oracle/app/oracle"
2020-11-20T20:04:21.196079+09:00 <-----******* taking 1 min 47 sec
Cluster Communication is configured to use IPs from: GPnP
IP: <IP ADDRESS> Subnet: <SUBNET>
KSIPC Loopback IP addresses(OSD):
127.0.0.1
2020-11-20T20:05:23.047408+09:00 <-----******* taking 1 min 2 sec
KSIPC Available Transports for cluster communication: 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
cluster interconnect IPC version: [IPCLW over UDP(mode 3) ]
IPC Vendor 1 proto 2
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 6.0
============================================================
NOTE: PatchLevel of this instance 0
============================================================
Starting background process PMON
2020-11-20T20:05:23.610825+09:00
PMON started with pid=2, OS id=6921
Starting background process CLMN
Starting ORACLE instance (normal) (OS id: 27992)
2020-11-20T20:02:35.371233+09:00
SGA allocation is optimized
2020-11-20T20:02:35.373635+09:00
************************************************************
Instance SGA_TARGET = 577536 MB and SGA_MAX_SIZE = 577536 MB
************************************************************
2020-11-20T20:02:39.961757+09:00
...
optimizer_adaptive_plans = FALSE
diagnostic_dest = "/opt/oracle/app/oracle"
2020-11-20T20:04:21.196079+09:00 <-----******* taking 1 min 47 sec
Cluster Communication is configured to use IPs from: GPnP
IP: <IP ADDRESS> Subnet: <SUBNET>
KSIPC Loopback IP addresses(OSD):
127.0.0.1
2020-11-20T20:05:23.047408+09:00 <-----******* taking 1 min 2 sec
KSIPC Available Transports for cluster communication: 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
cluster interconnect IPC version: [IPCLW over UDP(mode 3) ]
IPC Vendor 1 proto 2
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 6.0
============================================================
NOTE: PatchLevel of this instance 0
============================================================
Starting background process PMON
2020-11-20T20:05:23.610825+09:00
PMON started with pid=2, OS id=6921
Starting background process CLMN
Trace file of the server process shows as below.
*** 2020-11-20T20:02:43.215984+09:00
NOTE: Cluster configuration type = CLUSTER [4]
2020-11-20 20:02:43.643 : [ CLSINET][ CLSINET] failed to open OLR HAIP subtype SYSTEM.network.haip.group.cluster_interconnect.interface.valid key, rc=4
*** 2020-11-20T20:02:47.277808+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:02:50.716956+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:02:54.013219+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:02:56.263584+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:02:59.587555+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:02.260647+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:03.882127+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:06.840212+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:09.109833+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:11.325341+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:14.025044+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:16.778158+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:20.692702+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:23.482074+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:26.131394+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
..
*** 2020-11-20T20:05:14.233438+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:05:17.682303+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:05:20.368321+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:05:23.031387+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
NOTE: Cluster configuration type = CLUSTER [4]
2020-11-20 20:02:43.643 : [ CLSINET][ CLSINET] failed to open OLR HAIP subtype SYSTEM.network.haip.group.cluster_interconnect.interface.valid key, rc=4
*** 2020-11-20T20:02:47.277808+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:02:50.716956+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:02:54.013219+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:02:56.263584+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:02:59.587555+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:02.260647+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:03.882127+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:06.840212+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:09.109833+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:11.325341+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:14.025044+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:16.778158+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:20.692702+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:23.482074+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:03:26.131394+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
..
*** 2020-11-20T20:05:14.233438+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:05:17.682303+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:05:20.368321+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
*** 2020-11-20T20:05:23.031387+09:00
[NETSVC]: ipcor_net_svc_load_rds: sskgxp_load_rds_interface() failed, ret: 2
* ipcor_net_svc_load_rds take 3 sec and is executed repeatedly.
This lead to delay.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |