Pluggable Database save state (automatic start)

On this post I will show one interesting feature on 12c at version 12.1.0.2, save state of a pluggable database.
After restart a container database all pluggables databases stays on mount state, imagine if you are a DBA with more than 100 PDBs.
You may need to write a trigger event or a script to put the PDBs on write mode, this operations could be complexs.
Considering that not all PDBs don’t have to stay on write mode.

Let’s start: Continue reading

Oracle Database 12c: Data pump views_as_tables parameter (New feature)

Hello everyone!!
How many times, you would like to converted a view into a table during an export or import process.
Well, now on Oracle 12c this is can be possible with the views_as_tables parameter, with this parameter allows you to convert a view into a table during either an export to a dump file or a import from a dump file.
During the process of export dump file, the views listed into the parameter views_as_tables are converted during the process. Continue reading

Oracle Entreprise Manager Cloud 12c: Configuring e-mail alerts

Hello everyone!
Today I will show how to configure e-mail alerts in OEM 12c.
I did one implementation in one client last week, all databases are monitored with OEM 12c, this is a very good tool.
The scopes of OEM 12c are not limited only at database level.
We will create commun alert for full tablespaces.
Let’s start: Continue reading

Oracle Database 12c (12.1.0.2) installation on Solaris 11 (11.2 x86)

Hello everyone!!
Today I will show, how to prepare the Solaris 11.2 for install Oracle Database 12c (12.1.0.2).
I am still familiarizing with Solaris systems, to me it has been a good experience.
I am discovering very good features about Solaris systems. This is a simple post, with few steps you can be prepare.

To complete the steps you will need the following prerequisites Continue reading