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

Oracle Linux 7.2 and Grid Infrastructure 11.2.0.4 – A marriage with obstacles

There may be reasons to run an Oracle cluster with the new version of Oracle Linux – version 7.2 – and the „old“ but stable release of the Grid Infrastructure, 11.2.0.4. It‘s certified, it works – but there are some obstacles during the installation..

The support note 1951613.1 („Installation walk-through – Oracle Grid/RAC 11.2.0.4 on Oracle Linux 7“) is a good starting point for such an installation. But there are some more small issues:

Continue reading

Posted in RAC | Comments Off on Oracle Linux 7.2 and Grid Infrastructure 11.2.0.4 – A marriage with obstacles

CDB architecture, multitenant architecture – what’s the correct naming?

After an internal discussion at Trivadis, I thought about the naming conventions for database architectures in Oracle Database 12c. Many people call the “new architecture” “multitenant architecture”. This can result in some confusion because the “Multitenant Option” is an extra-cost option of the Oracle Database and so people stop thinking about the new architecture because they think “Multitenant architecture = Multitenant Option = expensive = too expensive for us”.

Continue reading

Posted in Oracle 12c | Comments Off on CDB architecture, multitenant architecture – what’s the correct naming?