Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

Oracle 12c Articles

Upgrade to Oracle Database 12c (1Z1-060) : OCP DBA Upgrade Exam

The articles in this section are specifically targeted at the 1Z0-060 "Upgrade to Oracle Database 12c" OCP upgrade exam. The exam also includes a key skills section, which amongst other things includes the new features added in the previous releases. You can read up on these features in these three sets of revision notes for the previous releases.

Multitenant : Overview of Container Databases (CDB) and Pluggable Databases (PDB) - This article provides a basic overview of the multitenant option, with links to more detailed articles on the functionality.

Multitenant : Create and Configure a Container Database (CDB) in Oracle Database 12c Release 1 (12.1) - Take your first steps with the Oracle Database 12c Multitenant option by creating container databases.

Multitenant : Create and Configure a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - Take your next steps with the Oracle Database 12c Multitenant option by creating pluggable databases.

Multitenant : Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - Learn now to start converting your existing regular databases into pluggable databases in Oracle Database 12c Release 1 (12.1).

Multitenant : Connecting to Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - This article explains how to connect to container databases (CDB) and pluggable databases (PDB) on Oracle 12c Release 1 (12.1).

Multitenant : Startup and Shutdown Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - Learn how to startup and shutdown container databases (CDB) and pluggable databases (PDB) in Oracle 12c Release 1 (12.1).

Multitenant : Configure Instance Parameters and Modify Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - This article shows how to configure instance parameters and modify the database for container databases (CDB) and pluggable databases (PDB) in Oracle Database 12c Release 1 (12.1).

Multitenant : Manage Tablespaces in a Container Database (CDB) and Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - This article demonstrates how to manage tablespaces in a container database (CDB) and pluggable database (PDB) in Oracle Database 12c Release 1 (12.1).

Multitenant : Manage Users and Privileges For Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - This article shows how to manage users and privileges for container databases (CDB) and pluggable databases (PDB) in Oracle Database 12c Release 1 (12.1).

Multitenant : Backup and Recovery of a Container Database (CDB) and a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - Learn how backup and recovery is affected by the multitenant option in Oracle Database 12c Release 1 (12.1).

Multitenant : Flashback of a Container Database (CDB) in Oracle Database 12c Release 1 (12.1) - Identify the restrictions when using flashback database against a container database (CDB) in Oracle 12c.

Multitenant : Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - Control resource allocation between pluggable databases and within an individual pluggable database.

Online Move Datafile in Oracle Database 12c Release 1 (12.1) - Rename and relocate datafiles with no downtime in Oracle Database 12c Release 1 (12.1).

RMAN Table Point In Time Recovery (PITR) in Oracle Database 12c Release 1 (12.1) - Oracle Database 12c makes Point In Time Recovery (PITR) of individual tables as easy as a single RMAN command.

Multithreaded Model using THREADED_EXECUTION in Oracle Database 12c Release 1 (12.1) - Learn how to switch the database between the multiprocess and multithreaded models in Oracle Database 12c Release 1 (12.1).

Data Pump Enhancements in Oracle Database 12c Release 1 (expdp, impdp) - This article provides an overview of the main Data Pump enhancements in Oracle Database 12c Release 1.

Row Limiting Clause for Top-N Queries in Oracle Database 12c Release 1 (12.1) - Simplify the syntax of Top-N queries using the row limiting clause of Oracle Database 12c.

Extended Data Types in Oracle Database 12c Release 1 (12.1) - Ease the migration of applications from other database engines to Oracle 12c by using extended data types.

Oracle Database 12c Release 1: Miscellaneous Articles

Oracle Database File System (DBFS) Enhancements in Oracle Database 12c Release 1 (12.1) - Access your DBFS file systems via HTTP/HTTPS, FTP and WebDAV in Oracle Database 12c Release 1.

DEFAULT Values for Table Columns : Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the changes to table column defaults in Oracle Database 12c.

Identity Columns in Oracle Database 12c Release 1 (12.1) - Replace trigger-based population of numeric ID columns with the new identity functionality in Oracle Database 12c Release 1.

Implicit Statement Results in Oracle Database 12c Release 1 (12.1) (DBMS_SQL.RETURN_RESULT and DBMS_SQL.GET_NEXT_RESULT) - Implicit statement results will simplify the migration of stored procedures from other database engines to Oracle 12c onward.

Multitenant : Running Scripts in Container Databases (CDBs) and Pluggable Databases (PDBs) in Oracle Database 12c Release 1 (12.1) - This article presents a number of solutions to help transition your shell scripts to work with the multitenant option.

PL/SQL White Lists Using the ACCESSIBLE BY Clause in Oracle Database 12c Release 1 (12.1) - Use the ACCESSIBLE BY clause to create white lists, adding an extra layer of security to your PL/SQL objects.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1) - Oracle Database 12c Release 1 adds more functionality to the Oracle scheduler.

Upgrading to Oracle Database 12c - This article provides an overview of some of the options for upgrading existing databases to Oracle 12c Release 1.

WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1) - Define PL/SQL functions and procedures in the WITH clause of SQL statements.

The 12c database has only recently been released, but Oracle OpenWorld 2012 included a number of presentations about new features, which you can read about in these blog posts to give you an idea of what's coming.

Tom’s Top 12 Things About the Latest Generation of Database Technology - Notes about Tom Kyte's Oracle OpenWorld 2012 presentation.

Oracle Database Optimizer: An Insider’s View of How the Optimizer Works - Notes about Maria Colgan's Oracle OpenWorld 2012 presentation.

What’s New in Security in the Latest Generation of Database Technology - Notes about Tom Kyte's Oracle OpenWorld 2012 presentation.

Oracle Database 12c Release 1 Installations

Oracle Database 12c Release 1 (12.1) Installation On Oracle Linux 5 - A brief guide to installing Oracle 12c Release 1 (12.1) on Oracle Linux 5.

Oracle Database 12c Release 1 (12.1) Installation On Oracle Linux 6 - A brief guide to installing Oracle 12c Release 1 (12.1) on Oracle Linux 6.

Oracle Database 12c Release 1 (12.1.0.1) RAC On Oracle Linux 6 Using VirtualBox - This article describes the installation of Oracle Database 12c Release 1 (12.1.0.1) RAC on Oracle Linux 6 using VirtualBox with no additional shared disk devices.

Oracle Database 12c Release 1 RAC On Windows 2012 Using VirtualBox - This article describes the installation of Oracle Database 12c Release 1 (12.1) RAC on Windows 2012 Server Standard Edition using VirtualBox with no additional shared disk devices.

Enterprise Manager Cloud Control 12c

Oracle Enterprise Manager Cloud Control 12c Release 1 Installation on Oracle Linux 5.7 and 6.1 - This article describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 1 on Oracle Linux 5.7 and 6.1.

Oracle Enterprise Manager Cloud Control 12c Release 2 Installation on Oracle Linux 5.8 and 6.3 - This article describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 2 on Oracle Linux 5.8 and 6.3.

Oracle Enterprise Manager Cloud Control 12c Release 3 Installation on Oracle Linux 5.9 and 6.4 - This article describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 3 on Oracle Linux 5.9 and 6.4.

Oracle Enterprise Manager Cloud Control 12c Post-Installation Setup Tasks - This article describes some of the basic post-installation tasks for Oracle Enterprise Manager Cloud Control 12c.

Installing Enteprise Manager Command Line Interface (EMCLI) for Cloud Control 12c - Learn how to install EMCLI for Cloud Control 12c on Windows and Linux.

WebLogic 12c

An Oracle DBA's Guide to WebLogic Server - An overview of WebLogic Server for beginners, especially DBA's, who are new to middle tier administration.

Create Self-Signed SSL Certificates - Notes on how to create self-signed SSL certificates using a variety of methods.

WebLogic Server 11g and 12c : Configure SSL for a Managed Server - This article descries how to configure SSL for WebLogic managed servers.

Reset the AdminServer Password in WebLogic 11g and 12c - If you have forgotten the AdminServer password for your WebLogic 11g or 12c domain, you can reset it from the command line using the following process.

WebLogic Server 11g and 12c : Configure Active Directory Authentication - Use Active Directory (AD) for your application authentication in WebLogic Server 11g and 12c.

WebLogic 12cR1

Oracle WebLogic Server (WLS) 12c Release 1 (12.1.1) Development-Only Installation on Oracle Linux 5 and 6 - This article describes the development-only installation of Oracle WebLogic Server (WLS) 12c Release 1 (12.1.1) on Oracle Linux 5 and 6.

Oracle WebLogic Server (WLS) 12c Release 1 (12.1.1) Installation on Oracle Linux 5 and 6 - This article describes the installation of Oracle WebLogic Server (WLS) 12c Release 1 (12.1.1) on Oracle Linux 5 and 6.

WebLogic Server 11g and 12cR1 : Create, Extend and Remove Domains - A quick overview of managing domains in WebLogic Server 11g and 12cR1.

WebLogic Server 11g and 12cR1 : Clustered Domains - Create clustered domains using Oracle WebLogic Server 11g and 12cR1.

WebLogic 12cR2

Oracle WebLogic Server (WLS) 12c Release 2 (12.1.2) Installation on Oracle Linux 5 and 6 - This article describes the installation of Oracle WebLogic Server (WLS) 12c Release 2 (12.1.2) on Oracle Linux 5 and 6.

WebLogic Server 12cR2 : ADF Application Development Runtime Installation on Oracle Linux - This article describes the steps necessary to install the ADF Application Development Runtime on a WebLogic Server 12c (12.1.2).

WebLogic Server 12cR2 : ADF Application Development Runtime - Repository Configuration Utility (RCU) - This article provides a brief example of using the Repository Configuration Utility (RCU) from the ADF Application Development Runtime.

WebLogic Server 12cR2 : Create, Extend and Remove Domains - A quick overview of managing domains in WebLogic Server 12c (12.1.2).

WebLogic Server 12cR2 : Clustered Domains - Create clustered domains using Oracle WebLogic Server 12c (12.1.2).

External 12c Links

Documentation: Oracle Database 12c Release 1 (12.1)

Homepage: Oracle Enterprise Manager Cloud Control 12c

Documentation: Oracle Enterprise Manager Cloud Control 12c

Downloads: Oracle Enterprise Manager Cloud Control 12c

Documentation : Oracle Fusion Middleware (FMW) 12c (12.1.2)

YouTube : OracleLearning Channel