With Oracle 12c, Oracle introduced “extended data types”, which raise the limit for CHAR and VARCHAR2 datatypes from 4000 bytes to 32767 bytes. However, this is not the default setting and it takes some steps to change this setting. Especially in a Multitenant environment.
Last time I ran into an issue with RMAN when trying to register a new 184.108.40.206 database in my 220.127.116.11 RMAN catalog database.
Over time, “srvctl” became a really powerful for the administration of resources of an Oracle cluster. Oracle added new components and options in every new version of the Grid Infrastructure software. With Oracle 18.104.22.168, “srvctl -help” lists 266 options for srvctl.”
Until 11.2, parameters were specified as single letters. However, there were duplicates (i.e. the meaning of a parameter (=letter) was not unique within srvctl).
And with Oracle 12c Oracle has changed the naming of the parameters for srvctl.
A new version of the “Database Migration Assistant for Unicode” (DMU), was released: DMU 2.1.1. Release 2.1.1 is a maintenance release with some small changes compared to DMU 2.1.
A few days ago I saw a query from a colleague. He wanted to exclude all Oracle-supplied schema in a Oracle 11.2 database from a query on DBA_SEGMENTS. And it came to my mind that the query is much simpler in Oracle database 12c: