Default administrative users when creating a PDB with DBCA

When creating a CDB and at least 1 PDB, DBCA creates the well known users SYS and SYSTEM and the user PDBADMIN. Where is this user created and which privileges are granted to PDBADMIN?

Continue reading

Posted in Common, Oracle 12c | Comments Off on Default administrative users when creating a PDB with DBCA

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