Oracle 12c OCP Exam Notes (1z0-060)
Oracle DBA 12c Certification Notes
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.
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.
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 how to manage the Multitenant feature.
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.
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.
Temporal Validity in Oracle Database 12c
The concept of Temporal Validity is not new and organizations have been implementing this for quite sometime. Even in Oracle E-business suite the same concept is implemented using the custom columns named Effective Start date and Effective End data. In E-business suite these tables are suffixed with _F. In this article we will look at how Oracle has simplified Temporal Validity in database 12c.
In-Database Archiving in Oracle 12c Database
The In-Database Archiving in Oracle 12c Database, allows you to mark certain rows inside the table as inactive or archived. The rows marked as archived will stay in table but they will be unavailable to users and applications.
Overview of Unified Auditing in Oracle Database 12c
Starting from 12c you can now use Unified auditing to keep track of all audit data in a single audit trail. Learn more here.
Oracle 12c: Data Redaction Unified Auditing Extended SHA-2
Oracle 12c Security Data Redaction and Unified Auditing with Extended SHA-2 delivers enhancemes security features to protect your data.