2014/10/09

OTN Articles: Oracle Database 12c: “Nuevas Características para Desarrolladores”

OTN - Oracle Technology Network Latina America published our next technical articles series. This article series cover new features of Oracle Database 12c for developers, entitled in Spanish language as Oracle Database 12c: “Nuevas Características para Desarrolladores” written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE).

This article series consists of three parts.



You can see very useful examples for every new feature in this article series. So, Part I of this article series, covers "Invisible Columns", "Identity Columns", "Default Values Using Sequences",  Part II covers "Extended Data Types","Multiple Index on same Columns", "Online DDLs", "Limitations of Row Set". Part III covers  "Online Moving Partitions", " New types of compression for tables", "Granted Roles of a Program Units","Enhanced in Clause 'WITH'". 



You  can read articles from following links in Spanish Language. 


Thanks to my friend Joel for all effort, and OTN Latina.


Regards
Mahir M. Quluzade


2014/08/28

OTN Article: Oracle Database 12c: Que sucede en un CDB cuando uno de los PDB obtiene un problema? (in Spanish Language)

OTN - Oracle Technology Network Latina America continue publish our articles. Our 8th technical article published on OTN in Spanish Language at 28th August. This article entitled : Oracle Database 12c: ¿Que sucede en un CDB cuando uno de los PDB obtiene un problema? written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Bruno Nuñez (OCE).

It is a link of article: http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-cdb-problem-pdb-2279196-esa.html







Thanks to my friends, Joel and Bruno, for their all efforts and thanks to OTN. 

Regards
Mahir M. Quluzade

2014/08/21

OTN Article : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado (in Portuguese Language)


OTN - Oracle Technology Network Latina America continue publish our articles. Our 7th technical article published on OTN in Portuguese Language at 20th August. This article entitled : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Rodrigo Mufalini (Oracle ACE) .


It is a link of article: http://www.oracle.com/technetwork/pt/articles/database-performance/cdb-quando-pdb-tem-ser-recuperado-2270042-ptb.html




Thanks to my friends, Joel and Rodrigo, for their all efforts and thanks to OTN. 

Regards
Mahir M. Quluzade

2014/08/20

OTech Magazine Issue #4: Summer 2014 Published


OTech Magazine - The independent magazine for Oracle professionals. Yesterday fourth issue of the OTech Magazine published.



 In this issue also included my article: Oracle Database 12c: Cross Platform Transport non-CDB to PDB using RMAN Backup Sets




You can download online OTech Magazine #4 Isssue - Summer 2014

Summary of article

We can create a PDB using upgraded database (non-CDB) and can be adopt the 12.1 non-CDB into a CDB as a PDB. This article covers steps for cross-platform data transport of non-CDB to other platform and adopt the transported non-CDB into a CDB as a PDB. If 12.1 non-CDB and CDB running on same platform, then easily plug-in the non-CDB into a CDB as a PDB so, there is no need for any conversion of platform on non-CDB. If platforms are different, then we need cross-platform data transport of non-CDB with RMAN. Prior to Oracle Database 12c (12.1) RMAN only used image copies for cross-platform data transport. After 12.1 RMAN can be use backup sets for cross-platform data transport of databases. So RMAN allows following methods to cross-platform transport of databases with Oracle Database 12c (12.1):

  • Transport database using image copies
  • Transport database using backup sets

In this article I used method Transport database using RMAN backup sets. You can read more about Cross - Platform Database Transport from my articles on OTN (Part 1, Part 2 - in Portugalese Language)

Note: Oracle Database 12c Release 1 (12.1.0.1) used for this article. 

Updates related this article:

If you are using Oracle Database 12c Release 1 (12.1.0.2) then you can use new feature of multitenant - PDB Remote Clone. So,the new release of Oracle Multitenant fully supports remote full and snapshot clones over a database link. A non-multitenant container database (CDB) can be adopted as a pluggable database (PDB) simply by cloning it over a database link. You can read about this new feature in here


You can download online OTech Magazine #4 Isssue - Summer 2014

My special thanks to organizer of OTech Magazine Douwe Pieter van den Bos for all efforts.

Regards
Mahir M. Quluzade.


2014/08/01

Oracle Multitenant - PDB State Management Across CDB Restart (12.1.0.2.0)

Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014.
You can download new release from here.

Oracle Multitenant option also supports some news in Oracle Database 12c Release 1 (12.1.0.2.0).
This article covers PDB State Management in Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2) .

By default, any pluggable database (PDB) are not open in READ WRITE mode, when Multitenant Container Database (CDB) restarts. You can see this also from following example:

[oracle@oel62-ora12c2 ~]$ export ORACLE_SID=prmcdb
[oracle@oel62-ora12c2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 1 14:14:59 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

SQL> select cdb,name from v$database;        

CDB NAME
--- ---------
YES PRMCDB

SQL> select name, open_mode from v$pdbs;

NAME          OPEN_MODE
------------------------------ ----------
PDB$SEED         READ ONLY
PRMPDB01         READ WRITE
PRMPDB02         READ WRITE
PRMPDB03         READ WRITE