Comments for Multitenant : Configure Instance Parameters and Modify Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1)
Pavel.Rabel@gmail said...Regarding MAX_SHARED_TEMP_SIZE , see
PDB to Use Global CDB (ROOT) Temporary Tablespace Functionality is Missing (Doc ID 2004595.1)
Sorry for the delay. I've put a note in the article about this and given you a shout out. :)
Perhaps it's worth mentioning that if using both SCOPE and CONTAINER in an ALTER SYSTEM, CONTAINER must come first, otherwise "ORA-02065: illegal option for ALTER SYSTEM" is thrown.
alter system set ... container=... scope=... --> works
alter system set ... scope=... container=... --> ORA-02065
That is the opposite of the documentation. See:
If you are experiencing that, you should raise an SR against the product or the manual to make them match.
Mor said...SYS@cusg> show con_name
SYS@cusg> alter system set "_index_partition_large_extents"=false container=all scope=both;
continued on next
Mor said...SYS@cusg> alter system set "_index_partition_large_extents"=false scope=both container=all;
alter system set "_index_partition_large_extents"=false scope=both container=all
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
As before, it is either a bug in the docs or the product. You should raise a SR on it so it is fixed, or the docs get corrected.
Mor said...Severity 4 SR 3-13385379701 : Documentation of Alter System does not match actual behavior with order of CONTAINER and SCOPE
In case you care to follow...
Tim... said...Cool! :)
Ian said...Hi Tim,
Your article says "When connected as a privileged user and pointing to the root container, any ALTER SYSTEM command will by default be directed at just the root container."
But using 18.104.22.168 this isn't the case, if you don't specify CONTAINER then parameter value also populates the PDBs.
Is your article just for 22.214.171.124?
Ian said...Sorry, it appears by default it overwrites the pluggable value UNLESS you have explicitly specified a value in the pluggable database.
Which means your article is correct and I misunderstood.
Thanks for all the articles by the way, they're great.
Please check the section : 40.5 Using the ALTER SYSTEM SET Statement in a CDB
It gives complete picture..
The article is meant to be a summary, which is why I put links to the documentation, for people who want to read them. :)
satya said...It is not a summary .It has detailed explanation on 12c parameter setting for CDB/PDB.
Anyhow your effort towards oracle-base.com is appreciable..
I wrote it and I think it is a summary. The same could be said for just about every article on my site. The documentation always gives additional information, which I why I put links to the docs for more information. Think about the content of ALTER DATABASE, ALTER SYSTEM and the related views alone. That's a massive amount of information. This is a summary to give people an idea of how parameters work with multitenant. It's not meant to answer all their questions. That is what the docs are for.
satya said...Sorry What i meant is documentation has detailed explanation..
Yes. The docs are always more detailed than blog posts, articles and even non-Oracle books. Expecting other resources to cover all the same ground is unrealistic, which is why people should link to the reference material, so people can see there is more to know. :)
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.