8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

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)

Tim... said...

Hi.

Sorry for the delay. I've put a note in the article about this and given you a shout out. :)

Cheers

Tim...

Mor said...

Hi,

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

-Mor

Tim... said...

Hi.

That is the opposite of the documentation. See:

https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#i2282157

If you are experiencing that, you should raise an SR against the product or the manual to make them match.

Cheers

Tim...

Mor said...

SYS@cusg> show con_name
CON_NAME
------------------------------
CDB$ROOT

SYS@cusg> alter system set "_index_partition_large_extents"=false container=all scope=both;
System altered.

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


Tim... said...

Hi.

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.

Cheers

Tim...

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...

Mor

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 12.1.0.2 this isn't the case, if you don't specify CONTAINER then parameter value also populates the PDBs.

Is your article just for 12.1.0.1?

Thanks

Ian

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.

Ian

satya said...

https://docs.oracle.com/database/121/ADMIN/cdb_admin.htm#ADMIN13650

Please check the section : 40.5 Using the ALTER SYSTEM SET Statement in a CDB

It gives complete picture..

Tim... said...

Hi.

The article is meant to be a summary, which is why I put links to the documentation, for people who want to read them. :)

Cheers

Tim...

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..


Tim... said...

Hi.

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.

Cheers

Tim...

satya said...

Sorry What i meant is documentation has detailed explanation..

Tim... said...

Hi.

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. :)

Cheers

Tim...

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.