[Oracle] [Standby] [PDB] Modify parameters in PDB, set range to SPFILE, report ORA-65099 error

[Oracle] [Standby] [PDB] Modify parameters in PDB, set range to SPFILE, report ORA-65099 error

In the data gaurd Standby (or CDB is Read only), under the PDB, the following SQL error is executed:

sql> ALTER SYSTEM SET sga_target = M SCOPE = SPFILE;
ALTER SYSTEM SET sga_target = M SCOPE = SPFILE
*
An error occurred on line 1. :
Ora-65099:can not perform operation if CDB are not open

Also, even if CDB is opened with read-only, the same error occurred and could isn't be changed.

After investigation, it was found that:

When I modify the parameters in the PDB and specify the scope= SPFILE,
It is actually written to the pdb_spfile$ table, but this internal table is in the CDB.

And CDB is Read only state, in fact, cannot write, so error. This is a normal behavior and does not count as a bug.

Of course, this indicates that the PDB's reliance on CDB is still a bit large.

[Oracle] [Standby] [PDB] Modify parameters in PDB, set range to SPFILE, report ORA-65099 error