Posts

Showing posts from 2014

OTech Magazine Winter 2014 Issue Released!

Image
OTech Magazine Winter 2014 Issue is a more than one hundred page independent Oracle technology magazine especially designed for the holidays.  First part of my Oracle Database In-Memory article series also published in this issue. You can download the Winter 2014 issue of OTech Magazine here My special thanks to Oracle ACED Douwe Pieter van den Bos for all efforts.  Best Regards Mahir M. Quluzade

OTN Article Series: Oracle Data Guard 12c - Redo Gap Resolutions

Image
OTN - Oracle Technology Network Latina America published our next technical articles series. This article series cover Redo Gap Resolutions in Oracle Data Guard 12c entitled in Portuguese language as Oracle Database 12c – Resolução de Redo Gap (Part I , II )  written by Joel Perez (Oracle ACED) , Mahir M. Quluzade (OCE). This article series consists of two parts. You can read articles from following links in Portuguese Language.   Oracle Database 12c – Resolução de Redo Gap (Part I)   Oracle Database 12c – Resolução de Redo Gap (Part II)   Thanks to my friend Joel for all effort, and OTN Latina. Regards Mahir M. Quluzade

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

Image
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 r

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

Image
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

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

Image
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

OTech Magazine Issue #4: Summer 2014 Published

Image
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

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 Multitenant - PDB New Clauses - Standbys (12.1.0.2) - Part II

As you know, 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). With new release coming new  PDB Clauses. This article series covers following new clauses: PDB Containers Clause PDB Standbys Clause PDB Logging Clause  (as soon) Part II: PDB Standbys Clause PDB Inclusion in Standby CDBs feature is coming with Oracle Database 12c Release 1 (12.1.0.2). The STANDBYS clause of the CREATE PLUGGABLE DATABASE statement specifies whether the new PDB is included in standby CDBs. You can specify one of the following values for the STANDBYS clause: ALL includes the new PDB in all of the standby CDBs. NONE excludes the new PDB from all of the standby CDBs. When a PDB is not included in any of the standby CDBs, the PDB's data files are offline and marked as unnamed on all of the standby CDBs. Any new standby

Oracle Multitenant - PDB New Clauses - Containers (12.1.0.2) - Part I

As you know, 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). With new release coming new PDB Clauses. This article series covers following new clauses: PDB Containers Clause PDB Standbys Clause PDB Logging Clause  (as soon) Part I: PDB Containers Clause The CONTAINERS clause in PDB enables you to query user-created tables and views across all PDBs in a CDB.The tables and views, or synonyms of them, specified in the CONTAINERS clause must exist in the root and in all PDBs and must be owned by the common user. A query that includes the CONTAINERS clause must be run in the root. Follow examples: [oracle@oel62-ora12c2 ~]$ export ORACLE_SID=prmcdb [oracle@oel62-ora12c2 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 24 16:02:21 2014 Copyright (c) 1982, 2014, Oracle. All rights

Oracle Multitenant - PDB Clone New Features (12.1.0.2.0) - Part III

As you know, Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014. You can download new release from here. With this new release coming some new features. This article series covers PDB Clone new features of Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2.0). This article is in four parts: Excluding Data When Cloning a PDB Non-CDB Adopt to CDB as a PDB. PDB Subset Cloning  PDB Snapshot Cloning (as soon) Part III. PDB Subset Cloning Sometimes we using many schemas that each supported a different application in a database (Schema Consolidation).  With Oracle Database 12c coming new option Oracle Multitenant, which is helpful for simplify consolidate databases.Database Consolidation means, each pluggable database (PDB) support a different application and all pluggable databases adopted in same Multitenant Container Database (CDB). If we move a non-CDB to a PDB, and the non-CDB had different schemas that each supported a diffe

Oracle Multitenant - PDB Clone New Features (12.1.0.2.0) - Part II

As you know, Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014. You can download new release from  here . With this new release coming some new features. This article series covers PDB Clone new features of Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2.0).  This article is in four parts:  Excluding Data When Cloning a PDB Non-CDB Adopt to CDB as a PDB. PDB Subset Cloning  PDB Snapshot Cloning (as soon) Part II. Non-CDB Adopt to CDB as a PDB. 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. This feature further improves rapid provisioning of pluggable databases. Administrators can spend less time on provisioning and focus more on other innovative operations. Follow examples: I'll create a PDB using database link from follo

Oracle Multitenant - PDB Clone New Features (12.1.0.2.0) - Part I

As you know, Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014. You can download new release from  here . With this new release coming some new features. This article series covers PDB Clone new features of Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2.0).  This article is in four parts:  Excluding Data When Cloning a PDB Non-CDB Adopt to CDB as a PDB. PDB Subset Cloning  PDB Snapshot Cloning (as soon) Part I:  Excluding Data When Cloning a PDB We can create clone of PDB with CREATE PLUGGABLE DATABASE ... FROM statement from existing PDB. All clones of PDB contains all object definitions and data in PDB. Sometimes we need quickly creating clones of a PDB with only the users object definitions and no data. New NO DATA clause included the CREATE PLUGGABLE DATABASE ... FROM statement in 12.1.0.2.0 version. The NO DATA clause specifies that a PDB's data model definition is cloned but not the PDB's data.

Oracle Database 12c Release 1 (12.1.0.2) New Features

Image
Oracle Database 12.1.0.2 is available for download now.   here 1. Advanced Index Compression Advanced Index Compression works well on all supported indexes, including those indexes that are not good candidates for the existing prefix compression feature; including indexes with no, or few, duplicate values in the leading columns of the index. Advanced Index Compression improves the compression ratios significantly while still providing efficient access to the index. 2. Approximate Count Distinct The new and optimized SQL function, APPROX_COUNT_DISTINCT(), provides approximate count distinct aggregation. Processing of large volumes of data is significantly faster than the exact aggregation, especially for data sets with a large number of distinct values, with negligible deviation from the exact result. The need to count distinct values is a common operation in today's data analysis. Optimizing the processing time and resource consumption by orders of magnitude while prov

OTN Article : Oracle Database 12c – Nuevas Características de "Oracle Partitioning"

Image
Oracle Technology Network - OTN (Latina America)  published our 6th article in Spanish Language. This article entitled : Oracle Database 12c – Nuevas Características de "Oracle Partitioning")  by Joel Perez (Oracle ACED) and Mahir M. Quluzade (OCE)  Published : 17 July 2014 Article link :  Oracle Database 12c: Nuevas Características de “Oracle Partitioning” This article covers a bit new features of "Oracle Partitioning" on Oracle Database 12c (12.1) Regards Mahir M. Quluzade 

Oracle Multitenant - 12 Jul at Orient ITM

Image
All photos from seminar at  here . I presented entitled "Oracle Multitenant" at an event organized by   Orient ITM .   (Baku, Azerbaijan). What is Oracle Multitenant? A new option for Oracle Database 12c, Oracle Multitenant delivers a new architecture that allows a multitenant container database to hold many pluggable databases. An existing database can simply be adopted with no application changes required. Oracle Multitenant fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. The many pluggable databases in a single multitenant container database share its memory and background processes. This enables consolidation of many more pluggable databases compared to the old architecture, offering similar benefits to schema-based consolidation but with none of the major application changes required by that approach. Creating pluggable databases, moving pluggable databases between containers, and cloning pluggable

OTech Magazine - Spring 2014 Released!

Image
OTech Magazine is an independent magazine for Oracle professionals. OTech Magazine is a trusted source for news, information and analysis about Oracle and its products. Our readership is made up of professionals who work with Oracle and Oracle related technologies on a daily basis, in addition we cover topics relevant to niches like software architects, developers, designers and others.OTech Magazine‘s writers are considered the top of the Oracle professionals in the world. Only selected and high-quality articles will make the magazine. Our editors are trusted worldwide for their knowledge in the Oracle field. Read more about OTech Magazine in here. Today the third issue of OTech Magazine released.  Content of OTech Magazine - Spring 2014 as below:  My article is published in this issue, too. You can download the Spring 2014 issue of OTech Magazine in here:  http://www.otechmag.com/2014/otech-magazine-spring-2014/ or from direct link :  http:

My article on GPO (Grupo de Profissionais Oracle) Portal

Image
GPO (Group Oracle Professionals) - The greater Oracle community in Brazil. GPO portal is a comprehensive portal implemented with various technologies and various topics on Oracle Technologies. GPO (Grupo de Profissionais Oracle) Portal :  http://www.profissionaloracle.com.br/gpo My article published on GPO (Group Oracle Professionals) portal.  Article link : Oracle Database 12c - What happens during CDB startup if one the PDB has a media problem? And it is my GPO profile :  http://www.profissionaloracle.com.br/gpo/artigo/articulistas/60-marzade Mahir M. Quluzade - GPO Profile Special thank to Victor Armbrust (Founder-Director of the GPO Portal, Oracle ACE), Sergio Willians (Coordinator GPO Portal, Oracle ACE), Alex Zaballa (Autor of GPO, Oracle AСE). Regards Mahir M. Quluzade

Oracle Database 12c: What happens during CDB startup if one the PDB has a media problem? - Continue

During Oracle Day 2014  (February 05, 2014, which was held in Baku/Azerbaijan), I met with my friends and had a conversation about several topics. I asked to my friend Teymur Hajiyev, what happens during CDB startup if one the PDB has a media problem? He said, CDB must open without a problem. But you need to open PDBs manually. In other words, by default PDBs in mount mode, you need call alter pluggable databases all open. After Oracle Day, Teymur shared his tests in here.  and faced the same issue. But he is wrote : If you apply PSU1 on 12c, you will not meet with such problem, CDB will skip opening problematic PDB and will open other PDBs. I will share my tests on patched database. I applied PSU1 to my database server:   Installation and configuration Patch 17552800 - 12.1.0.1.2 Patch Set Update My test environment as below: [oracle@oel62-ora12c /]$ export ORACLE_SID=prmcdb [oracle@oel62-ora12c /]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Wed Feb 1

Installation and configuration Patch 17552800 - 12.1.0.1.2 Patch Set Update

Image
Hi, Patch 17552800 - 12.1.0.1.2 Database Patch Set Update released: January 14, 2014. You can download this PSU  from Oracle My Support . I will show short steps installation and configuration this PSU. Note: To install the PSU 12.1.0.1.2 patch, the Oracle home must have the 12.1.0.1.0 Database installed. Subsequent PSU patches can be installed on Oracle Database 12.1.0.1.0 or any PSU with a lower 5th numeral version than the one being installed. 1. Download this patch set zip file from support web site and copy to database server. My Oracle Support [oracle@oel62-ora12c PSU1]$ pwd /tmp/oracle/PSU1 [oracle@oel62-ora12c PSU1]$ ls -l total 67952 -rw-r--r-- 1 oracle oinstall 69580299 Feb 12 09:17 p17552800_121010_Linux-x86-64.zip [oracle@oel62-ora12c PSU1]$ 2. Exract patch files from p17552800_121010_Linux-x86-64.zip file. [oracle@oel62-ora12c PSU1]$ unzip p17552800_121010_Linux-x86-64.zip Archive:  p17552800_121010_Linux-x86-64.zip    creating: 17552800/   inflating: 17

Oracle ACE Newsletter January 2014

Image
I saw my name in Oracle ACE Newsletter January 2014. It is first time, is my name in Oracle ACE Newsletter. I'm very glad. Thanks to Oracle Technology Network (OTN). Regards Mahir M. Quluzade

OTN Article : Oracle Database 12c – Transporte de “Tablespaces” de “11.2.0.3” a “12.1” ( Parte III )

Image
Oracle Technology Network - OTN (Latina America)  published our 5th article in Spanish Language. Oracle Database 12c – Transporte de “Tablespaces” de “11.2.0.3” a “12.1” ( Parte III ) written by Joel Perez (Oracle ACED) and Mahir M. Quluzade (OCE) Published : January 2014 You can read article from : http://www.oracle.com/technetwork/es/articles/database-performance/transporte-tablespace-11-a-12-part3-2111105-esa.html Regards Mahir M. Quluzade

OTN Article : Oracle Database 12c – “Cross Platform” Database Transport (Part I & Part II)

Image
Oracle Technology Network - OTN  (Latina America) published in  Portuguese Language : Oracle Data Guard 12c – “Cross Platform” Database Transport (Part II) written by Joel Perez (Oracle ACED), Rodrigo Mufalini (Oracle ACE) and Mahir M. Quluzade (OCE) You can read all parts of article following links : Part I: http://www.oracle.com/technetwork/pt/articles/database-performance/data-guard12c-cross-platform-2098313-ptb.html (in Portuguese) Part II: http://www.oracle.com/technetwork/pt/articles/database-performance/data-guard12c-cross-platform-parte2-2100280-ptb.html (in Portuguese) My special thank to my friends Joel and Rodrigo for all support. Regards Mahir M. Quluzade

OTN Article : Oracle Database 12c: “Upgrade” a “Oracle Database 12c” ( Parte III )

Image
OTN (Oracle Technology Network)  Spanish   published our next article.  Oracle Database 12c: “Upgrade” a “Oracle Database 12c” ( Parte III )   by Joel Perez (Oracle ACED) and Mahir M. Quluzade (OCE) (Published : January 2014) You can read our article from :  http://www.oracle.com/technetwork/es/articles/database-performance/upgrade-database-12c-parte-3-2099475-esa.html  (in Spanish) Special thanks to my friend Joel (from Venezuela) for all support.  Regards Mahir M. Quluzade 

OTN Article : Oracle Database 12c – “Cross Platform” Database Transport (Part I)

Image
OTN (Oracle Technology Network) Portuguese published our next article :  Oracle Data Guard 12c – “Cross Platform” Database Transport (Part I)  by authors Joel Perez (Oracle ACED), Rodrigo Mufalini (Oracle ACE) and Mahir M. Quluzade (OCE) You can read article from :  http://www.oracle.com/technetwork/pt/articles/database-performance/data-guard12c-cross-platform-2098313-ptb.html   (in Portuguese language) My special thank to my friends Joel and Rodrigo for all support. Regards Mahir M. Quluzade