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 later
Information 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

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

* 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Startup nomount is too slow due to RDS load (Doc ID 2744358.1)

Applies to:

Symptoms

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!