Switching a Multitenant Database to Extended Data Types

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.

Continue reading

Posted in Oracle 12c | Comments Off on Switching a Multitenant Database to Extended Data Types

RMAN, PSU & DBBP

Last time I ran into an issue with RMAN when trying to register a new 12.1.0.2 database in my 12.1.0.2 RMAN catalog database.

Continue reading

Posted in Oracle 12c | Comments Off on RMAN, PSU & DBBP

Oracle 12c: Changed parameter naming for “srvctl”

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 12.1.0.2, “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.
Continue reading

Posted in Oracle 12c, RAC | Comments Off on Oracle 12c: Changed parameter naming for “srvctl”

DMU 2.1.1 released

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.

DMU 2.1.1 Release Notes: List of changes

Download DMU 2.1.1

Posted in Common | Comments Off on DMU 2.1.1 released

A helpful column in Oracle database 12c: ORACLE_MAINTAINED

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:
Continue reading

Posted in Common, Oracle 12c | Comments Off on A helpful column in Oracle database 12c: ORACLE_MAINTAINED