ORA-00120: invalid ‘shared_servers’ value for the PDB

Error Message

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 re-enable within the PDB, use ‘alter system reset shared_servers’.

You May Also Like

Leave a Reply?