No DP Slot available to create server, tracefile - 19c

From: Douglas Dunyan <dmdunyan_at_gmail.com>
Date: Wed, 22 Sep 2021 14:16:39 -0700
Message-ID: <CA+UckTtgi2kmKkEUO4H2RATRAUTmR-AEA3YT-wcF8wauUZM-EA_at_mail.gmail.com>

Greets oraGuru's

  In a 19c RAC database, the alert log file is filling with the following messages many many many times:

"No DP Slot available to create server, tracefile  /{$oracle_base}/diag/rdbms/{dbname}/{instance}/trace/{INSTANCE}_pxmn_{pid}.trc "

Min parallel servers is set to 2, max parallel servers set to 8. The tracefile for the parallel execution monitor shows:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0
Build label: RDBMS_19.9.0.0.0DBRU_LINUX.X64_200930

ORACLE_HOME: /u01/ora19c_db
System name: Linux
Node name: {nodename}

Release: 4.18.0-240.el8.x86_64
Version: #1 SMP Wed Sep 23 05:13:10 EDT 2020
Machine: x86_64

Instance name: {INSTANCE_NAME}
Redo thread mounted by this instance: 1
Oracle process number: 45
Unix process pid: 390675, image: oracle_at_{nodename} (PXMN)

• 2021-09-14T07:59:58.564681-07:00 (CDB$ROOT(1))
• SESSION ID:(13148.48277) 2021-09-14T07:59:58.564756-07:00
• CLIENT ID:() 2021-09-14T07:59:58.564768-07:00
• SERVICE NAME:(SYS$BACKGROUND) 2021-09-14T07:59:58.564777-07:00
• MODULE NAME:() 2021-09-14T07:59:58.564786-07:00
• ACTION NAME:() 2021-09-14T07:59:58.564793-07:00
• CLIENT DRIVER:() 2021-09-14T07:59:58.564800-07:00
• CONTAINER ID:(1) 2021-09-14T07:59:58.564808-07:00

DP slot 0 flag is 0x18
DP slot 1 flag is 0x18
DP slot 2 flag is 0x18
DP slot 3 flag is 0x18
DP slot 4 flag is 0x18
DP slot 5 flag is 0x18
DP slot 6 flag is 0x18
DP slot 7 flag is 0x18

I can find no information about what is a DP slot, and why this is polluting my alert logs. I have checked ulimits for user oracle, as well as cluvfy with no hints as to why this one RAC database is exhibiting this behavior.

Any hints on this would be greatly appreciated.

TIA Doug

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 22 2021 - 23:16:39 CEST