Oracle 12c Database New Features – The Index

Oracle 12c Installation Guides

Oracle 12c Database Installation On Solaris 11 Using VirtualBox
Quick install instructions for Oracle 12c database on Solaris 11. Check how you can install latest version of Oracle database on Oracle Solaris 11 running on Virtualbox.

Oracle 12c RAC: Installation on Oracle Linux 6 using VirtualBox
A quick guide of Oracle 12c RAC Installation on your laptop running Windows. A step by step guide to configure Oracle 12c Grid and the database Software.

Oracle 12c Silent Mode Binary Install and De-install
Installation of the Oracle Binaries is a pretty simple task for the DBA’s. However the process may become exhaustive if you are repeatedly performing these installs on a number of servers.

Cloning Oracle 12c Home Binaries
Almost every backup and recovery concern is focused on protecting the data stored inside database and rightly so. But during the course of a DBA career, restoring the Oracle Home or duplicating is sometimes is necessary. Learn how to cone the binary home.

Oracle 12c Database : Upgrading to Oracle Database 12c
A Quick Guide to upgrading to Oracle Database 12c. See how you can upgrade a database running in 11.2.0.3 (or lower) to the newest 12c database.

Oracle Pre-Upgrade Check – DMSYS schema exists in the Database
Prior to upgrading my database to 11.2.0.4, on running the utlu112i.sql all my checks passed except for the “DMSYS schema exists in the Database” message. See how to drop DMSYS schema.

Oracle 12c Database: Managing PDBs using Database Configuration Assistant
In 12c, the database configuration assistant can also be used to manage the PDB’s alongside the CDB and non-CDB databases. In this article we will look at managing the PDBs, using the database configuration assistant.

Multitenancy in Oracle 12c

Benefits of Multitenant Databases in Oracle 12c
With Oracle 12c Oracle has introduced the new multitenant architecture. The benefits of Multitenant databases in Oracle 12c using the new Multitenant Architecture include solving the many problems and reducing resources associated with the large infrastructure deployments.

Managing Oracle 12c CDB and PDB – Getting started – Part 1
Managing Oracle 12c CDB and PDB is different in many ways. That’s mainly because of architectural changes introduced 12c. Learn the new features and how to manage the CDB and PDB databases.

Managing Oracle 12c CDB’s and PDB’s – Plugging and Unpluggging PDB’s – Part 2
One of the main features of the Oracle Database 12c is the portable nature of the pluggable databases (PDBs). You can easily unplug a PDB from a CDB and then plug it into a different Container database (CDB). This ease of Plugging in and Unplugging PDBs makes the 12c database truly Cloud ready. If you have just downloaded the Oracle Database software you may want to read the following articles I have written previously.

Managing Oracle 12c CDB’s and PDB’s – Cloning PDB’s – Part 3


Oracle 12c – Manage Multitenant CDB and PDBs with EM Express
Manage Multitenant CDB and PDBs with EM Express. Quick and easy steps to create, setup and deploy EM Express.

Oracle 12c Database: Create 12c CDB, PDB Databases Using OUI
When installing Oracle Software, you can create 12c CDB, PDB Databases using OUI, just like you used to do in the previous versions of the Oracle database. Read how to create the database.

Oracle 12c Database: Create CDB Database with DBCA
The database configuration assistant is the preferred tool for creating and configuring databases. It has been available for years and with every database version, it’s getting better and better.

Oracle 12c Database: SGA Instance Parameters in CDB and PDB
The new multitenant architecture in Oracle 12c poses a few different concepts which we need to be familiar with when modifying instance parameters. As the instance in the multitenant architecture only belongs to the CDB container, all PDB’s inherit these CDB instance parameters. In this article we will look at changing the instance parameters for both CDB and PDB.

Oracle 12c Database: Managing CDB and PDB tablespaces
In Oracle 12c the tablespace management mostly remains unchanged and the basic operations are performed in a similar way as in 11g. This is because Oracle has made sure that every PDB, though it is a subset of the CDB, in itself functions as a standalone, complete database. In this article we will look at managing the tablespaces in the CDB container and the PDB database.

Oracle 12c Database: Managing Common and Local Users, Roles and Privileges
Managing users, roles and privileges is a very important aspect of the database administration. With Oracle 12c there is a second dimension to controlling this user access and privileges.

Backup of PDB and CDB in Oracle 12c
There are two approaches to managing Backup of PDB and CDB in Oracle 12c Multitenant Environment. The first one is to maintain backups of CDB as a whole. The complete backup of CDB would include the backup of ALL PDBs.

Oracle 12c Database: Flashback a CDB Database
The Flashback feature provides a convenient method to undo mistakes, including reverting DML and dropping of a table.Flashback a CDB Database in Oracle 12c to recover from a logical error.

Oracle 12c Database New Features

Oracle 12c Database: What is Oracle 12c?
There has been a lot of buzz recently about Oracle 12c. Everyone in any way related to Oracle technologies, really want to know what Oracle 12c is and why it is important. Well, simply put it is the next generation naming convention for all Oracle products. Learn more about it here.

Oracle 12c Database: New Features
The Oracle 12c Database has the most new features ever released with any version of any database. As you might have guessed from it’s name, the new version is more focused on Cloud Computing.

Oracle 12c RAC: New Features
Oracle has come a long way from its inception of the 9i RAC database to its current 12c version. I remember the days when we had to deal with RAC related issues, ranging from performance to stability which gradually improved as this product matured. Learn more about the new feature now available with RAC.

Oracle 12c Database: De-Supported & Deprecated Features
While it is important to be familiar with new features of Oracle 12c, it is imporatant to be aware of features which are either being de-supported or deprecated with this database version. Learn more about this important topic.

Oracle 12c Database: Moving to Multithreaded Configuration
Starting in Oracle 12c database, you can change this and enable the new Multithreaded configuration! And that too by merely setting one parameter. You can change the architecture by making Oracle database use thread based architecture instead of process based. Once changed, all Oracle processes will be threads within a few Oracle processes. Thus if CPU moves from one Oracle process to the other, the time between the context switch will be reduced significantly as the switching from one thread to the other is within the same process.

Oracle 12c Database Default Column Value Enhancement
I remember that a number of times, developers have approached me with the question – How do I auto increment a default value in a table column? These were mostly folks who had worked in the MS SQL, Mysql and other database environments where this features exists. Now, Oracle 12c Default Column Value feature has been incorporated and puts this to rest.

Oracle 12c Database Identity Columns
Having a built-in mechanism to populate the identity columns was something that developers have been looking forward to as a feature in the Oracle database. But Oracle always provided and relied on the programmatic way of handling this. Developers used a sequence and a trigger combination to achieve the desired results. But finally Oracle has finally provided a built-in feature, Oracle 12c Database Identity Columns, to populate these Identity Columns. Let’s look at how you can use this new feature in Oracle 12c.

Oracle 12c Database Multiple Indexes On Same Set of Columns
Oracle database 12c has about 500+ new features when compared to 11gR2. Among these features there will be some which get the mainstream attention. But often little caveats or enhancements prove to be as vital as the big ones. One such enhancement is the ability to have multiple indexes on same column or same set of columns. Lets look at this feature and the possible uses cases.

Oracle 12c Database: Online Table Redefinition and Datafile Movement
Moving objects and datafiles around is required when you need to either change the physical location of the data files or when you want to migrate to ASM or some other Storage system. Up to now these operations caused the database to remain unavailable during the move activity. However in Oracle 12c this can be minimized to almost no downtime. Let’s look at how online table redefinition and datafile movement can help us in achieving zero downtime.

Oracle 12c DDL Logging in Oracle
By default Oracle database does not log any DDL operations performed by any user. The default settings for auditing only logs DML operations. However that does not mean that you cannot do anything about it. Oracle has provided several ways by which you can track the DDL operations performed on the database. In this article we will look at two of the most common and easy to use ways.

Difference between In-Database Archiving and Temporal Validity in 12c
Manage Multitenant CDB and PDBs with EM Express. Quick and easy steps to create, setup and deploy EM Express.

Oracle 12c Database Heat Maps and Automatic Data Optimization
When installing Oracle Software, you can create 12c CDB, PDB Databases using OUI, just like you used to do in the previous versions of the Oracle database.

Oracle 12c Last login time for Non-Sys Users
Oracle 12c introduced a new, very useful security feature to store and display the last login information for non-sys users, logging in via SQL*PLUS. The last login time is displayed in the banner by default when we log into the database using SQL*PLUS in 12c.

Setting up Oracle 12c Active Data Guard Database
In the Multitenant world, the PDB Database is considered an independent database but the operational tasks performed at the CDB level effect all the PDB databases plugged into it. The task of setting up of a Data Guard, switching or failing over are all performed at the CDB level. When the Data Guard is initially setup, with the CDB database, all PDB’s are also replicated to the target. Read more here.

If you are trying to setup a test environment to learn New Features of Oracle 12c Database or to hone your skills in managing it on Linux, Solaris or other OS environments, you can quickly have the host and the database ready for use in as short a time as 10 minutes. Unbelievable? Just install the VirtualBox and download the Pre-Built templates and import them to create a VM VirtualBox machine. The OS is already installed, the 12c database configured and it starts up as soon as the Virtual Machine is bought to life. No hassles with the pre-requisites or fulfilling other requirements. Just follow the simple steps below. Have a portable environment which you can have running on your Laptop!

Provision VirtualBox using Pre-Built Developer VMs
Step by step guide to setup the Oracle VM VirtualBox and import the prebuilt template to quickly create a portable (on your laptop) testing environment in 10 minutes!

Adding Disk Storage to Oracle VirtualBox
Need more space on your VirtualBox? Follow the instructions and use the drive space on your host machine to share space with the VM Virtual Box

Connecting Applications from Desktop to your VirtualBox Database
If you are trying to connect between VirtualBox Machines or trying to setup the network to communicate from the Desktop to the VirtualBox machines, follow the simple to use instructions here

Oracle 12c has introduced the new Multitenant Architecture which aims at solving the many problems associated with these large infrastructure deployments. Read these articles to become proficient on Managing this new Architecture.

Larry Ellison on Oracle 12c Multitenancy

Wikipedia on Oracle