ORA 00020 error in ASM Alert Log with Multiple ASM_user999999 processes spawned by a simple query to ASM database. (Doc ID 2260540.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

This was working well with 11g databases. Once we moved to 12c grid with an ASM upgrade, we started seeing ORA 00020 errors in the ASM alert log. We also saw multiple ASM_user999999 processes spawned by a simple query to the ASM database.

ASM Alert log file:

Thu Dec 01 10:20:36 2016
ORA-00020: maximum number of processes (500) exceeded
ORA-20 errors will not be written to the alert log for the next minute. Please look at trace files to see all the ORA-20 errors.
Thu Dec 01 10:20:36 2016
Errors in file /oracle/diag/asm/+asm/+ASM/trace/+ASM_ora_7105.trc:
ORA-17503: ksfdopn:2 Failed to open file +FRA01/asm/password/pwdasm.258.902787125
ORA-00020: maximum number of processes (500) exceeded

This Database have Secure External Password Store (SEPS) configuration in Database server sqlnet.ora file.

DB server sqlnet.ora file with SEPS configuration:


WALLET_LOCATION =
  (SOURCE =
  (METHOD = FILE)
  (METHOD_DATA =
  (DIRECTORY = /oracledba/scripts/ora_wallet)
  )
  )

SQLNET.WALLET_OVERRIDE = TRUE

 

when I am on the DB server and connecting locally to the ASM database and execute simple query:
sqlplus / as sysdba
select * from v$pwfile_users;

 

From another OS window, I can see the sessions being spawned while the query is running and then returns to 0 when the query completes.

Hundreds of these processes spawned when a simple query is executed:

oracle 4469 1 3 13:53 ? 00:00:00 oracle+ASM_user4461_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4473 1 3 13:53 ? 00:00:00 oracle+ASM_user4465_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4477 1 3 13:53 ? 00:00:00 oracle+ASM_user4469_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4481 1 3 13:53 ? 00:00:00 oracle+ASM_user4473_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4485 1 6 13:53 ? 00:00:00 oracle+ASM_user4477_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4489 1 7 13:53 ? 00:00:00 oracle+ASM_user4481_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4493 1 6 13:53 ? 00:00:00 oracle+ASM_user4485_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4497 1 8 13:53 ? 00:00:00 oracle+ASM_user4489_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4501 1 7 13:53 ? 00:00:00 oracle+ASM_user4493_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4505 1 7 13:53 ? 00:00:00 oracle+ASM_user4497_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4509 1 7 13:53 ? 00:00:00 oracle+ASM_user4501_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4513 1 7 13:53 ? 00:00:00 oracle+ASM_user4505_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4517 1 7 13:53 ? 00:00:00 oracle+ASM_user4509_+asm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms