Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-00120

invalid 'shared_servers' value for the PDB

Cause

'shared_servers' cannot be set to a non-zero value in a non-ROOT pluggable database (PDB).


Action

In a multitenant container database (CDB) setup, shared servers can be configured only in ROOT. A non-ROOT PDB can disable shared servers for the PDB by setting 'shared_servers' to 0. No other values are allowed. To reenable within the PDB, use 'alter system reset shared_servers'.