8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 12c » Here


Oracle 12c Articles

Upgrade to Oracle Database 12c (1Z0-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.

Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c - An overview of the ASH Analytics feature in Oracle Enterprise Manager Cloud Control 12c.

Adaptive Plans in Oracle Database 12c Release 1 (12.1) - See how the 12c optimizer uses adaptive plans to adjust execution plans on the fly.

Adaptive Query Optimization in Oracle Database 12c (12.1 and 12.2) - This article provides links to articles on the individual features of Adaptive Query Optimization.

Adaptive SQL Plan Management (SPM) in Oracle Database 12c Release 1 (12.1) - Check out the changes to SQL Plan Management (SPM) in Oracle Database 12c Release 1 (12.1).

Administrative Privileges and Job Role Separation in Oracle Database 12c Release 1 (12.1) - Oracle 12c includes additional administrative privileges to allow a greater level of job role separation if that is necessary in your organisation.

Asynchronous (Delayed) Global Index Maintenance for DROP and TRUNCATE Partition in Oracle Database 12c Release 1 - Oracle 12c can optimize the performance of some DROP PARTITION and TRUNCATE PARTITION commands by deferring the associated index maintenance, while leaving the global indexes in a valid state.

Auditing Enhancements (Unified Audit Trail) in Oracle Database 12c Release 1 (12.1) - The introduction of audit policies and the unified audit trail simplifies the configuration of database auditing in Oracle 12c.

Automatic Column Group Detection in Oracle Database 12c Release 1 (12.1) - This article describes how necessary extended statistics for column groups are identified automatically in Oracle Database 12c Release 1.

Automatic Database Diagnostic Monitor (ADDM) Compare Period in Oracle Database 12c Release 1 (12.1) - Oracle database 12c now allows you to compare periods of activity at database or instance level using the DBMS_ADDM package.

Automatic Diagnostics Repository (ADR) Enhancements in Oracle Database 12c (ADRCI) - This article describes the enhancements to ADR in Oracle Database 12c.

Automatic Reoptimization in Oracle Database 12c Release 1 (12.1) - See how statistics feedback and performance feedback are used by automatic reoptimization in Oracle Database 12c Release 1.

Capture Privilege Usage (DBMS_PRIVILEGE_CAPTURE) in Oracle Database 12c Release 1 (12.1) - Use the DBMS_PRIVILEGE_CAPTURE package to capture privilege usage, helping you to identify unused privileges.

Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION in Oracle Database 12c Release 1 - The TRUNCATE [SUB]PARTITION and EXCHANGE [SUB]PARTITION commands can now include a CASCADE clause, allowing the actions to cascade down the hierarchy of reference partitioned tables.

Concurrent Statistics Collection in Oracle Database 12c Release 1 (12.1) - Improve the speed of statistics collection from Oracle database 12c Release 1 onward.

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

Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1) - The Database Migration Assistant for Unicode (DMU) allows you to convert databases to use a unicode character set.

Database Smart Flash Cache in Oracle Database 12c Release 1 - Learn how to configure and use the Database Smart Flash Cache in Oracle Database 12c Release 1.

Data Redaction (DBMS_REDACT) in Oracle Database 12c Release 1 (12.1) - Use data redaction to protect sensitive data in Oracle Database 12c Release 1 (12.1).

Dynamic Statistics in Oracle Database 12c Release 1 (12.1) - This article describes the changes made to dynamic sampling in Oracle Database 12c Release 1 (12.1).

Emergency Monitoring in Oracle Enterprise Manager Cloud Control 12c - Get diagnostics information from hung databases using the Emergency Monitoring feature of Oracle Enterprise Manager Cloud Control 12c.

Enterprise Manager Database Express in Database 12c Release 1 - An overview of Database Express in Oracle Database 12c Release 1.

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.

External Table Enhancements in Oracle Database 12c Release 1 (12.1) - An overview of the enhancements to external tables in Oracle Database 12c Release 1 (12.1).

Flashback Data Archive (FDA) Enhancements in Oracle Database 12c Release 1 (12.1) - Check out the latest enhancements to flashback data archive (FDA) in Oracle Database 12c Release 1 (12.1).

Heat Map, Information Lifecycle Management (ILM) and Automatic Data Optimization (ADO) in Oracle Database 12c Release 2 (12.2) - This article gives an overview of Heat Map, Information Lifecycle Management (ILM) and Automatic Data Optimization (ADO) in Oracle Database 12c Release 2 (12.2).

Histogram Enhancements in Oracle Database 12c Release 1 (12.1) - Two new types of histogram have been added and one of the existing types has been de-emphasised in Oracle Database 12c Release 1.

In-Database Archiving in Oracle Database 12c Release 1 (12.1) - Use the in-database archiving functionality to implement "mark for delete" functionality out-of-the-box.

Index Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to index enhancements in Oracle Database 12c Release 1

Interval-Reference Partitioning in Oracle Database 12c Release 1 - Oracle 12c allows you to use an interval partitioned table as the parent for a reference partitioned table.

Multiple Indexes on the Same Set of Columns in Oracle Database 12c Release 1 - Oracle 12c allows multiple indexes on the same set of columns, provided only one index is visible and all indexes are different in some way.

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 : Querying Container Data Objects (CONTAINER_DATA) - The visibility of the data for container data objects is controlled using the CONTAINER_DATA attribute of a common user.

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.

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).

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).

Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1 - In Oracle 12c it is now possible to move table partitions and sub-partitions as online operations.

Online Operation Enhancements in Oracle Database 12c Release 1 (12.1) - Oracle database 12c includes a number of new online operations.

Online Statistics Gathering for Bulk Loads in Oracle Database 12c Release 1 (12.1) - See how Oracle 12c can automatically gather statistics for some bulk operations.

Partial Indexes for Partitioned Tables in Oracle Database 12c Release 1 - Oracle 12c allows the creation of global and local indexes on a subset of the partitions of a partitioned table.

Partition Maintenance Operations on Multiple Partitions in Oracle Database 12c Release 1 - In Oracle 12c some maintenance operations can now be performed on multiple partitions in a single ALTER TABLE statement.

Partitioning Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 1.

Real-Time Automatic Database Diagnostics Monitor (ADDM) in Oracle Database 12c Release 1 (12.1) - Get up-to-the-minute analysis from ADDM, rather than waiting for the next AWR snapshot.

Real-Time Database Operation Monitoring in Oracle Database 12c Release 1 and 2 (12.1 and 12.2) - Oracle 12c extends real-time SQL monitoring to allow monitoring of multiple SQL and PL/SQL calls as a single operation.

Recovery Manager (RMAN) Enhancements in Oracle Database 12c Release 1 (12.1) - This article described the new features and enhancements made to Recovery Manager (RMAN) in Oracle Database 12c Release 1 (12.1).

Recovery Manager (RMAN) Database Duplication Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the enhancements made to Recovery Manager (RMAN) for database duplication in Oracle Database 12c Release 1 (12.1).

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

Resource Manager Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the enhancements to automatic consumer group switching in Oracle 12c Release 1 (12.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.

Session-Private Statistics for Global Temporary Tables in Oracle Database 12c Release 1 (12.1) - This article explains the role of SQL Plan Directives in Adaptive Query Optimization in Oracle Database 12c (12.1 and 12.2).

SQL Plan Directives in Oracle Database 12c Release 1 (12.1) - This article explains the role of SQL Plan Directives in Adaptive Query Optimization in Oracle Database 12c (12.1 and 12.2).

SQL*Loader Enhancements in Oracle Database 12c Release 1 (12.1) - An overview of the enhancements to SQL*Loader in Oracle Database 12c Release 1 (12.1).

Statistics Collection Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together links to all the statistics collection enhancements in Oracle Database 12c Release 1.

Table Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to table enhancements in Oracle Database 12c Release 1

Temporal Validity in Oracle Database 12c Release 1 (12.1) - Make querying of effective date ranges simpler using temporal validity in Oracle database 12c.

Feature List:

Oracle Database 12c Release 1: Miscellaneous Articles

APPROX_COUNT_DISTINCT : Quick Distinct Count in Oracle Database 12cR1 (12.1.0.2) - Use the APPROX_COUNT_DISTINCT to get quick counts of distinct values in 12.1.0.2 onward.

Attribute Clustering in Oracle Database 12c Release 1 - Attribute clustering groups specific attributes together so they are in close physical proximity, making the processing of related attributes more efficient.

Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1) - Discover how Oracle Database 12c allows you to grant roles directly to PL/SQL program units.

Control Invoker Rights Privileges for PL/SQL Code in Oracle Database 12c Release 1 (12.1) (INHERIT [ANY] PRIVILEGES) - Learn how to plug security holes related to invoker rights PL/SQL code in Oracle Database 12c Release 1.

Control Invoker Rights Privileges in Views in Oracle Database 12c Release 1 (12.1) (BEQUEATH CURRENT_USER) - This article describes support for invoker rights function calls in views in Oracle Database 12c Release 1.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 12c Release 1 - This article contains an example of setting up a physical standby database for Oracle 12c Release 1 using the Data Guard Broker.

DBMS_COMPRESSION Enhancements in Oracle Database 12c Release 1 (12.1.0.2) - Check out the enhancements to the DBMS_COMPRESSION package in Oracle Database 12c Release 1 (12.1.0.2).

DBMS_CREDENTIAL : Persist Database and OS Credentials in Oracle Database 12c Release 1 (12.1) - In Oracle 12c the credential related sub-programs of the DBMS_SCHEDULER package have been deprecated and replaced by the new DBMS_CREDENTIAL package. From a usage perspective it feels similar.

DBMS_UTILITY.EXPAND_SQL_TEXT : Expand SQL References to Views in Oracle Database 12c Release 1 (12.1) - Easily display the true complexity of SQL statements that reference views.

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.

Edition-Based Redefinition Enhancements in Oracle Database 12c Release 1 (12.1) - Learn how to create non-editionable objects in edition-enabled schema.

Fine-Grained Access to Network Services Enhancements in Oracle Database 12c Release 1 - Take control of the external services accessed by the UTL_TCP, UTL_INADDR, UTL_HTTP, UTL_SMTP, and UTL_MAIL packages.

Full Database Caching Mode in Oracle Database 12cR1 (12.1.0.2) - Learn how changes in Oracle Database 12cR1 (12.1.0.2) affect the way Oracle handles the buffer cache.

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.

Index Key Compression : Advanced Index Compression in 12c - Reduce the size of indexes by using index key compression, including advanced index compression in Oracle 12c.

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.

In-Memory Column Store in Oracle Database 12c Release 1 (12.1.0.2) - This article provides an overview of the In-Memory Column Store feature in Oracle 12c Release 1 (12.1.0.2).

Invisible Columns in Oracle Database 12c Release 1 (12.1) - Oracle database 12c allows columns to be created or modified to make them invisible.

JSON Support in Oracle Database 12c Release 1 (12.1.0.2) - This article describes the server side support for JSON in the database.

Indexing JSON Data in Oracle Database 12c Release 1 (12.1.0.2) - This article provides an overview of how to index JSON data in Oracle Database 12c Release 1 (12.1.0.2).

LATERAL Inline Views, CROSS APPLY and OUTER APPLY Joins in Oracle Database 12c Release 1 (12.1) - Learn the new variations on inline views and joins available in Oracle 12c.

Multitenant : Clone a Remote PDB or Non-CDB in Oracle Database 12c (12.1.0.2) - Clone PDBs from remote PDBs and Non-CDBs over database links in Oracle Database 12c (12.1.0.2).

Multitenant : Controlling PDB Replication in Data Guard Environments : STANDBYS Clause (12.1.0.2) - This article describes two methods for controlling the replication of PDBs in standby databases when using Data Guard.

Multitenant : Database Triggers on Pluggable Databases (PDBs) in Oracle 12c Release 1 (12.1) - With the introduction of the multitenant option, database event triggers can be created in the scope of the CDB or PDB.

Multitenant : PDB Logging Clause in Oracle Database 12c Release 1 (12.1.0.2) - The PDB logging clause is used to set the default tablespace logging clause for a PDB in Oracle Database 12c Release 1 (12.1.0.2).

Multitenant : PDBs With Different Time Zones to the CDB in Oracle Database 12c Release 1 (12.1) - The multitenant architecture allows you to specify a different database time zone for each pluggable database.

Multitenant : Prevent Accidental Creation of a Pluggable Database (PDB) - Lone-PDB- This article gives an example of a way to save yourself from a costly mistake of creating more than one PDB in a Lone-PDB instance.

Multitenant : Metadata Only PDB Clones in Oracle Database 12c Release 1 (12.1.0.2) - Make structure-only copies of PDBs using the NO DATA clause added in Oracle Database 12c Release 1 (12.1.0.2).

Multitenant : PDB CONTAINERS Clause in Oracle Database 12c (12.1.0.2 and 12.2) - The PDB CONTAINERS clause allows data to be queried and amended across multiple PDBs in Oracle Database 12c (12.1.0.2 and 12.2).

Multitenant : PDB Subset Cloning in Oracle Database 12c Release 1 (12.1.0.2) - Use subset cloning to limit the amount of tablespaces you bring across to your new PDB.

Multitenant : Pluggable Database (PDB) Names - A brief article to highlight the importance of unique PDB names.

Multitenant : Pluggable Databases - What they will break and why you should use them anyway! - This article identifies the type of problems you will encounter when moving to the multitenant architecture.

Multitenant : Remove APEX Installations from the CDB in Oracle Database 12c Release 1 (12.1) - This article describes how to remove APEX from the CDB so you can install it directly in a PDB.

Multitenant : Rename a Pluggable Database (PDB) - From Oracle database 12.1.0.2 onward we can rename a pluggable database (PDB).

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.

Multitenant : Transparent Data Encryption (TDE) in Pluggable Databases (PDBs) in Oracle Database 12c Release 1 (12.1) - This article describes some of the basic key management operations as they relate to Transparent Data Encryption (TDE) in Oracle Database 12c Release 1.

Multitenant : Upgrade a PDB using Unplug/Plugin - This article describes the method for upgrading a PDB using the unplug/plugin method.

Multitenant : USER_TABLESPACES Clause in Oracle Database 12c (12.1.0.2) - The USER_TABLESPACES clause of the CREATE PLUGGABLE DATABASE command gives control over which tablespaces are included in a PDB created from a clone or a plugin operation.

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.

Pattern Matching (MATCH_RECOGNIZE) in Oracle Database 12c Release 1 (12.1) - Learn about the new pattern matching analytic function clause available in Oracle 12c onward.

PGA_AGGREGATE_LIMIT : A Hard Limit for PGA Usage in Oracle Database 12c Release 1 (12.1) - Set a maximum limit on the amount of PGA used by the instance using the PGA_AGGREGATE_LIMIT parameter introduced in Oracle 12c.

PL/SQL New Features and Enhancements in Oracle Database 12c Release 1 - Learn about the new features and enhancements to PL/SQL in Oracle 12c Release 1.

PL/SQL-to-SQL Interface Enhancements for PL/SQL-Only Data Types in Oracle Database 12c Release 1 (12.1) - Oracle 12c now supports the binding of additional PL/SQL-only data types to SQL.

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.

READ Object Privilege in Oracle Database 12c Release 1 (12.1.0.2) - Use the READ object privilege to create read-only users that no longer have the ability to lock rows in the tables they query.

SecureFiles Enhancements in Oracle Database 12c (12.1 and 12.2) - This article provides and overview of the enhancements to the SecureFiles functionality in Oracle Database 12c (12.1 and 12.2).

Session Sequences in Oracle Database 12c Release 1 (12.1) - Use sequences whose current value is not persisted between sessions in Oracle database 12c Release 1 (12.1).

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

SQL*Plus Enhancements in Oracle Database 12c (12.1 and 12.2) - This article provides a brief description of the enhancements to SQL*Plus in Oracle Database 12.1 and 12.2.

Temporary Undo in Oracle Database 12c Release 1 (12.1) - Place undo segments for global temporary tables in the temporary tablespace in Oracle Database 12c Release 1 (12.1).

TRUNCATE TABLE ... CASCADE in Oracle Database 12c Release 1 (12.1) - This article discusses the TRUNCATE TABLE ... CASCADE functionality in Oracle Database 12c Release 1. (12.1).

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

Using the TABLE Operator with Locally Defined Types in PL/SQL - In Oracle 12c, the TABLE operator can now be used in PL/SQL with locally defined types.

UTL_CALL_STACK : Get Detailed Information About the Currently Running Subprogram in Oracle Database 12c Release 1 (12.1) - Display information about call stack and error stack for PL/SQL subroutines using the UTL_CALL_STACK package.

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 following blog posts talk about other features available in Oracle Database 12c.

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.

Feature List:

Upgrade Oracle DBA 11g/12c to 12cR2 (1Z1-074) : OCP DBA Upgrade Exam

This exam covers both 12.1 and 12.2 topics, so some of the previous articles will be repeated here where they are relevant to this exam.

Auditing Enhancements (Unified Audit Trail) in Oracle Database 12c Release 1 (12.1) - The introduction of audit policies and the unified audit trail simplifies the configuration of database auditing in Oracle 12c.

Conversion Function Enhancements in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) includes a number of enhancements to datatype conversion functions, making it easier to handle conversion errors.

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

Data Redaction (DBMS_REDACT) Enhancements in Oracle Database 12c Release 2 (12.2) - This article demonstrates a number of the enhancements to Data Redaction in Oracle Database 12c Release 2 (12.2).

Heat Map, Information Lifecycle Management (ILM) and Automatic Data Optimization (ADO) in Oracle Database 12c Release 2 (12.2) - This article gives an overview of Heat Map, Information Lifecycle Management (ILM) and Automatic Data Optimization (ADO) in Oracle Database 12c Release 2 (12.2).

In-Memory Column Store in Oracle Database 12c Release 1 (12.1.0.2) - This article provides an overview of the In-Memory Column Store feature in Oracle 12c Release 1 (12.1.0.2).

Index Key Compression : Advanced Index Compression in 12c - Reduce the size of indexes by using index key compression, including advanced index compression in Oracle 12c.

Long Identifiers in Oracle Database 12c Release 2 (12.2) - Oracle 12.2 increases the maximum size of most identifiers from 30 to 128 bytes, which makes migration from other database engines easier.

Multitenant : Application Containers in Oracle Database 12c Release 2 (12.2) - An application root can house one or more applications, each made up of shared configuration, metadata and objects that are used by the pluggable databases associated with the application root.

Multitenant : Disk I/O (IOPS, MBPS) Resource Management for PDBs in Oracle Database 12c Release 2 (12.2) - Control the amount of disk I/O used by a PDB, making consolidation more reliable in Oracle Database 12c Release 2 (12.2).

Multitenant : Flashback Pluggable Database (PDB) in Oracle Database 12c Release 2 (12.2) - Oracle Database 12.2 now supports flashback of a pluggable database, making flashback database relevant in the multitenant architecture again.

Multitenant : Hot Clone a Remote PDB or Non-CDB in Oracle Database 12c Release 2 (12.2) - Hot clone PDBs from remote PDBs and Non-CDBs over database links in Oracle Database 12c Release 2 (12.2).

Multitenant : Local Undo Mode in Oracle Database 12c Release 2 (12.2) - In Oracle Database 12c Release 2 each pluggable database can use its own local undo tablespace.

Multitenant : Memory Resource Management for PDBs in Oracle Database 12c Release 2 (12.2) - Control the amount of memory used by a PDB, making consolidation more reliable in Oracle Database 12c Release 2 (12.2).

Multitenant : PDB Lockdown Profiles in Oracle Database 12c Release 2 (12.2) - Restrict the operations possible inside a PDB using a lockdown profile in Oracle Database 12c Release 2 (12.2).

Partitioning Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 1.

Partitioning Enhancements in Oracle Database 12c Release 2 (12.2) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 2.

Multitenant : Proxy PDB in Oracle Database 12c Release 2 (12.2) - A proxy PDB can provide a local connection point that references a remote PDB.

Multitenant : Relocate a PDB in Oracle Database 12c Release 2 (12.2) - From Oracle 12.2 onward you can relocate a PDB by moving it between two root containers with near zero-downtime.

Multitenant : Resource Manager PDB Performance Profiles in Oracle Database 12c Release 2 (12.2) - PDB performance profiles define the resource management for groups of PDBs in Oracle Database 12c Release 2 (12.2)

Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1 - In Oracle 12c it is now possible to move table partitions and sub-partitions as online operations.

Online Conversion of a Non-Partitioned Table to a Partitioned Table in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 makes it easier than ever to convert a non-partitioned table to a partitioned table, requiring only a single command and no downtime.

Online Move of a Table in Oracle Database 12c Release 2 (12.2) - In Oracle Database 12c Release 2 (12.2) you can now perform an online move of a table, as well as partitions and sub-partitions.

Optimizer Statistics Advisor in Oracle Database 12c Release 2 (12.2) - The Optimizer Statistics Advisor was introduced in Oracle Database 12c Release 2 (12.2) to help validate the quality of your optimizer statistics and provide corrective actions, should they be necessary.

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

Real-Time Materialized Views in Oracle Database 12c Release 2 (12.2) - Oracle 12.2 introduced the concept of real-time materialized views, which allow a statement-level wind-forward of a stale materialised view, making the data appear fresh to the statement.

Real-Time Database Operation Monitoring in Oracle Database 12c Release 1 and 2 (12.1 and 12.2) - Oracle 12c extends real-time SQL monitoring to allow monitoring of multiple SQL and PL/SQL calls as a single operation.

Resource Manager : Per-Process PGA Limits in Oracle Database 12c Release 2 (12.2) - Resource Manager can limit the amount of PGA used by a session in Oracle Database 12c Release 2 (12.2).

SQL*Plus Enhancements in Oracle Database 12c (12.1 and 12.2) - This article provides a brief description of the enhancements to SQL*Plus in Oracle Database 12.1 and 12.2.

Oracle Cloud : Database as a Service (DBaaS) - Create Service - This article provides a run through of creating a new DBaaS service on the Oracle Cloud.

Oracle Cloud : Database as a Service (DBaaS) - Patch Service - This article provides a run through of patching a DBaaS service on the Oracle Cloud.

Feature List:

Oracle Database 12c Release 2 : Miscellaneous Articles

Approximate Query Processing in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) extends the concept of approximate query processing by the addition of new functions and transparent conversion to approximate query processing.

Automatic List Partitioning in Oracle Database 12c Release 2 (12.2) - Automatic list partitioning was introduced in Oracle Database 12c Release 2 (12.2) to solve the problem of how to handle new distinct values of the list partitioning key.

Code Coverage Using DBMS_PLSQL_CODE_COVERAGE in Oracle Database 12c Release 2 (12.2) - The DBMS_PLSQL_CODE_COVERAGE package was introduced in Oracle Database 12c Release 2 (12.2) to provide an API to capture code coverage information during testing.

Column-Level Collation and Case-Insensitive Database in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) lets you specify the collation used for columns that hold string data, allowing you to easily perform case insensitive queries, as well as control the order of queried data.

Create Table for Exchange With a Partitioned Table in Oracle Database 12c Release 2 (12.2) - Make sure a table is compatible for an EXCHANGE PARTITION operation by using CREATE TABLE ... FOR EXCHANGE WITH TABLE in Oracle Database 12c Release 2 (12.2).

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 12c Release 2 - This article contains an example of setting up a physical standby database for Oracle 12c Release 2 using the Data Guard Broker.

DEPRECATE Pragma for PL/SQL in Oracle Database 12c Release 2 (12.2) - Oracle database 12.2 introduced the DEPRECATE pragma to mark code as deprecated and display compiler warnings if deprecated code is referenced by any newly compiled code.

DBMS_SQLDIAG Enhancements in Oracle Database 12c Release 2 (12.2) - Manual creation of SQL Patches to add hints to SQL has been documented in 12.2 and is now available from the DBMS_SQLDIAG package.

External Tables and XMLTAG to Load XML Documents in Oracle Database 12c Release 2 (12.2) - This article describes how to use the XMLTAG clause of an external table to load XML fragments from XML documents in Oracle Database 12c Release 2 (12.2).

Filtered Partition Maintenance Operations - Oracle Database 12c Release 2 (12.2) allows you to add a filter condition when you move, split or merge a partition, move a table or convert a non-partitioned table to a partitioned table.

Index Usage Tracking (DBA_INDEX_USAGE, V$INDEX_USAGE_INFO) in Oracle Database 12c Release 2 (12.2) - Index usage tracking in Oracle 12.2 replaces the index monitoring functionality of previous versions. Use it to help identify unused indexes.

JSON Data Guide in Oracle Database 12c Release 2 (12.2) - Simplify the interaction with JSON data stored in the database using the JSON Data Guide functionality introduced in Oracle Database 12c Release 2 (12.2).

JSON Support Enhancements in Oracle Database 12c Release 2 (12.2) - Oracle 12c Release 2 (12.2) includes several enhancements to the JSON functionality in the database. This article details some of them, as well as linking to separate articles on some of them.

LISTAGG Function Enhancements in Oracle Database 12c Release 2 (12.2) - The LISTAGG function has been enhanced in Oracle Database Release 2 (12.2), allowing it to handle overflow errors gracefully.

Multi-Column List Partitioning in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) introduced the ability to define a list partitioned table based on multiple columns.

Multitenant : Controlling PDB Replication in Data Guard Environments : ENABLED_PDBS_ON_STANDBY Parameter (12.2) - This article describes two methods for controlling the replication of PDBs in standby databases when using Data Guard.

Multitenant : Default Tablespace Clause During PDB Creation in Oracle Database 12c Release 2 (12.2) - This article describes the change in behaviour of the DEFAULT TABLESPACE clause of the CREATE PLUGGABLE DATABASE command between Oracle database 12.1 and 12.2.

Multitenant : Parallel PDB Creation Clause in Oracle Database 12c Release 2 (12.2) - From Oracle database 12.2 onward pluggable databases (PDBs) are created in parallel. You have some level of control over the number of parallel execution servers used to copy files during creation of a pluggable database (PDB).

Multitenant : PDB Archive Files for Unplug and Plugin in Oracle Database 12c Release 2 (12.2) - Oracle 12.2 allows a PDB to be unplugged to an archive file, containing all the files necessary to move and plugin the PDB.

Multitenant : PDB CONTAINERS Clause in Oracle Database 12c (12.1.0.2 and 12.2) - The PDB CONTAINERS clause allows data to be queried and amended across multiple PDBs in Oracle Database 12c (12.1.0.2 and 12.2).

Multitenant : PDB Upgrades Using Priority Lists, Inclusion Lists and Exclusion Lists in Oracle Database 12c Release 2 (12.2) - From Oracle 12.2 onward it's possible adjust the priority in which PDBs are upgraded when running the 'catupgrd.sql' script with the parallel upgrade utility (catctl).

Multitenant : PDBs With Different Character Sets to the CDB in Oracle Database 12c Release 2 (12.2) - A PDB can use a different character set to the CDB in Oracle Database 12c Release 2 (12.2).

Multitenant : PDB Refresh in Oracle Database 12c Release 2 (12.2) - From Oracle Database 12.2 onward it is possible to refresh the contents of the remotely hot cloned PDB provided it is created as a refreshable PDB and has only ever been opened in read only mode.

Multitenant : Pluggable Database (PDB) Operating System (OS) Credentials in Oracle Database 12c Release 2 (12.2) - Oracle 12.2 allows you to assign a different default operating system (OS) credential to each pluggable database (PDB), giving a greater degree of separation between the pluggable databases and therefore better control over security.

Multitenant : Prevent Accidental Creation of a Pluggable Database (PDB) - Lone-PDB - This article gives an example of a way to save yourself from a costly mistake of creating more than one PDB in a Lone-PDB instance.

Multitenant : Rename Services During PDB Creation in Oracle Database 12c Release 2 (12.2) - In Oracle 12c Release 2 it is possible to rename PDB services during PDB creation to prevent clashes.

Multitenant : Extended USER_TABLESPACES Clause in Oracle Database 12c Release 2 (12.2) - The USER_TABLESPACES clause of the CREATE PLUGGABLE DATABASE command gives control over which tablespaces are included in a PDB created from a clone or a plugin operation.

Online SPLIT PARTITION and SPLIT SUBPARTITION in Oracle Database 12c Release 2 (12.2) - In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION and SPLIT SUBPARTITION operations on heap tables can be performed online so they don't block DML.

Oracle File System (OFS) and Database File System (DBFS) Enhancements in Oracle Database 12c Release 2 (12.2) - Oracle Database 12.2 makes the setup and interaction with FUSE much simpler when using the Oracle File System (OFS) and Oracle Database File System (DBFS).

Oracle SQL and PL/SQL Enhancements in Oracle Database 12c Release 2 (12.2) - This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 12c Release 2 (12.2).

Override External Table Parameters From a Query in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) allows a query to modify of some external table parameters using the EXTERNAL MODIFY clause of the SELECT statement.

Partitioned External Tables in Oracle Database 12c Release 2 (12.2) - Partitioned external tables were introduced in Oracle Database 12c Release 2 (12.2), allowing external tables to benefit from partition pruning and partition-wise joins.

Partitioning Enhancements in Oracle Database 12c Release 2 (12.2) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 2.

PL/Scope Enhancements in Oracle Database 12c Release 2 (12.2) - PL/Scope is a tool that gathers information about user defined identifiers in PL/SQL code at compile time. Oracle Database 12c Release 2 (12.2) enhances the information captured by PL/Scope.

PL/SQL Object Types for JSON in Oracle Database 12c Release 2 (12.2) - Oracle 12c Release 2 (12.2) includes several enhancements to the JSON functionality in the database including native support for JSON parsing and generation in PL/SQL.

Read-Only Partitions and Subpartitions in Oracle Database 12c Release 2 (12.2) - From Oracle Database 12c Release 2 (12.2) onward you can mark partitions and subpartitions as read-only to protect their data from accidental change.

Resource Manager Enhancements in Oracle Database 12c Release 2 (12.2) - This page brings together all the articles related to Resource Manager enhancements in Oracle Database 12c Release 2 (12.2).

SecureFiles Enhancements in Oracle Database 12c (12.1 and 12.2) - This article provides and overview of the enhancements to the SecureFiles functionality in Oracle Database 12c (12.1 and 12.2).

Service-Level Access Control Lists (ACLs) - Database Service Firewall in Oracle Database 12c Release 2 (12.2) - Service-Level Access Control Lists (ACLs) allow you to control access to specific services, including those associated with individual pluggable databases (PDBs).

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 continues to extend the functionality of the Oracle scheduler with in-memory jobs, job incompatibility definitions and scheduler resource queues.

SQL/JSON Functions in Oracle Database 12c Release 2 (12.2) - This article gives basic examples of the SQL/JSON functions introduced in Oracle Database 12c Release 2 (12.2).

UTL_URL : Escape and unescape strings in URLs - The UTL_URL package was introduced in Oracle 12.2 to help escape and unescape strings in URLs.

V$DIAG_TRACE_FILE and V$DIAG_TRACE_FILE_CONTENTS - Easily identify and read the contents of trace files directly from the database in Oracle Database 12c Release 2 (12.2).

V$DIAG_ALERT_EXT View - Display the contents of the alert log from SQL using the V$DIAG_ALERT_EXT view.

Feature List:

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) Installation On Oracle Linux 7 - A brief guide to installing Oracle 12c Release 1 (12.1) on Oracle Linux 7.

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

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

Oracle Database 12c Release 1 (12.1.) RAC on Oracle Linux 6 Using NFS - This article describes the installation of Oracle Database 12c Release 1 (12.1) RAC on Oracle Linux 6 using NFS to provide the shared storage.

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

Oracle Database 12c Release 1 (12.1.) RAC on Oracle Linux 7 Using NFS - This article describes the installation of Oracle Database 12c Release 1 (12.1) RAC on Oracle Linux 7 using NFS to provide the shared storage.

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.

Oracle Database 12c Release 1 (12.1) Installation On Fedora 18 (F18) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 18 (F18).

Oracle Database 12c Release 1 (12.1) Installation On Fedora 19 (F19) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 19 (F19).

Oracle Database 12c Release 1 (12.1) Installation On Fedora 20 (F20) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 20 (F20).

Oracle Database 12c Release 1 (12.1) Installation On Fedora 21 (F21) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 21 (F21).

Oracle Database 12c Release 1 (12.1) Installation On Fedora 22 (F22) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 22 (F22).

Oracle Database 12c Release 1 (12.1) Installation On Fedora 23 (F23) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 23 (F23).

Oracle Database 12c Release 1 (12.1) Installation On Fedora 24 (F24) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 24 (F24).

Oracle Database 12c Release 1 (12.1) Installation On Fedora 25 (F25) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 25 (F25).

Oracle Database 12c Release 1 (12.1) Installation On Fedora 26 (F26) - A brief guide to installing Oracle 12c Release 1 (12.1) on Fedora 26 (F26).

Oracle Database 12c Release 2 Installations

Oracle Database 12c Release 2 (12.2) Installation On Oracle Linux 6 (OL6) and 7 (OL7) - A brief guide to installing Oracle 12c Release 2 (12.2) on Oracle Linux 6 (OL6) and 7 (OL7).

Oracle Database 12c Release 2 (12.2) Installation On Fedora 25 (F25) - A brief guide to installing Oracle 12c Release 2 (12.2) on Fedora 25 (F25).

Oracle Database 12c Release 2 (12.2) Installation On Fedora 26 (F26) - A brief guide to installing Oracle 12c Release 2 (12.2) on Fedora 26 (F26).

Oracle Database 12c Release 2 (12.2) Installation On Fedora 27 (F27) - A brief guide to installing Oracle 12c Release 2 (12.2) on Fedora 27 (F27).

Oracle Database 12c Release 2 (12.2) Installation On Fedora 28 (F28) - A brief guide to installing Oracle 12c Release 2 (12.2) on Fedora 28 (F28).

Oracle Database 12c Release 2 (12.2) Installation On Fedora 29 (F29) - A brief guide to installing Oracle 12c Release 2 (12.2) on Fedora 29 (F29).

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

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

Oracle Database 18c

Oracle Database 18c is actually the equivalent of the 12.2.0.2 patchset, so it is part of the 12.2 release cycle. Despite this all 18c articles are placed on a separate page. You can find them here.

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 Release 4 Installation on Oracle Linux 5.9 and 6.5 - This article describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 4 on Oracle Linux 5.9 and 6.5.

Upgrade Oracle Enterprise Manager Cloud Control 12c Release 3 (12cR3) to Release 4 (12cR4) - This article describes an upgrade of Oracle Enterprise Manager Cloud Control 12c Release 3 (12cR3) to Release 4 (12cR4).

Oracle Enterprise Manager Cloud Control 12c Release 5 Installation on Oracle Linux 5.11 and 6.6 - This article describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 5 on Oracle Linux 5.11 and 6.6.

Oracle Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5) Silent Installation on Oracle Linux 7 - This article describes the silent installation of Oracle Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5) on Oracle Linux 7 (x86_64).

Upgrade Oracle Enterprise Manager Cloud Control 12c Release 4 (12cR4) to Release 5 (12cR5) - This article describes an upgrade of Oracle Enterprise Manager Cloud Control 12c Release 4 (12cR4) to Release 5 (12cR5).

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.

Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c - An overview of the ASH Analytics feature in Oracle Enterprise Manager Cloud Control 12c.

Emergency Monitoring in Oracle Enterprise Manager Cloud Control 12c - Get diagnostics information from hung databases using the Emergency Monitoring feature of Oracle Enterprise Manager Cloud Control 12c.

Enterprise Manager Cloud Control Agent Notes - This article includes a variety of notes related to the Enterprise Manager Cloud Control Agent, relevant to both 13c and 12c.

EMCLI : Enterprise Manager Command Line Interface

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

EMCLI : Manage Credentials using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage credentials in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Agents using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage agents in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Listeners using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage listeners in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Databases using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage databases in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage WebLogic Domains using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage WebLogic domains in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Jobs using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage jobs in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Tablespace Thresholds using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage tablespace thresholds in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

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 Server 11g and 12c : Changing Heap Size and other Managed Server Start Arguments - A brief note to explain how to modify managed server start arguments on WebLogic Server 11g and 12c.

WebLogic : Database Access Descriptor (DAD) Configuration - Learn how to create a Database Access Descriptor (DAD) with the WebLogic Web Tier.

WebLogic 12c Silent Installation - This article demonstrates how to perform a silent installation of WebLogic Server 12c on Oracle Linux.

WebLogic : Upgrade the Java Version Used by WebLogic Components - This article explains how to upgrade the Java version used by WebLogic components.

Oracle HTTP Server (OHS) 11g and 12c : Configure SSL - This article describes how to configure SSL for Oracle HTTP Server (OHS) 11g and 12c.

WebLogic 12cR1 (12.1.1)

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 (12.1.1): Create, Extend and Remove Domains - A quick overview of managing domains in WebLogic Server 11g and 12cR1.

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

WebLogic 12cR1 (12.1.2)

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

WebLogic Server 12cR1 (12.1.2 and 12.1.3) : 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 and 12.1.3).

WebLogic Server 12cR1 (12.1.2 and 12.1.3) : 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 12cR1 (12.1.2 and 12.1.3) : Create, Extend and Remove Domains - A quick overview of managing domains in WebLogic Server 12c (12.1.2 and 12.1.3).

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

WebLogic 12cR1 (12.1.3)

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

WebLogic Server 12cR1 (12.1.2 and 12.1.3) : 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 and 12.1.3).

WebLogic Server 12cR1 (12.1.2 and 12.1.3) : 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 12cR1 (12.1.2 and 12.1.3) : Create, Extend and Remove Domains - A quick overview of managing domains in WebLogic Server 12c (12.1.2 and 12.1.3).

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

WebLogic 12cR2 (12.2.1)

Oracle WebLogic Server (WLS) 12cR2 (12.2.1) Installation on Oracle Linux 6 and 7 - This article describes the installation of Oracle WebLogic Server (WLS) 12cR2 (12.2.1) on Oracle Linux 6 and 7.

WebLogic 12c Silent Installation - This article demonstrates how to perform a silent installation of WebLogic Server 12c on Oracle Linux.

Oracle Forms and Reports 12c (12.2.1) Installation on Oracle Linux 6 and 7 - An overview of the installation of Oracle Forms and Reports 12c on Oracle Linux 6 and 7.

Oracle Forms and Reports 12c (12.2.1) Silent Installation on Oracle Linux 6 and 7- An overview of the silent installation of Oracle Forms and Reports 12c on Oracle Linux 6 and 7.

WebLogic Server 12cR2 (12.2.1) : 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 (12.2.1) : ADF Application Development Runtime - Repository Configuration Utility (RCU) in Silent Mode - This article provides a brief example of using the Repository Configuration Utility (RCU) from the ADF Application Development Runtime in silent mode.

Forms and Reports Services 12c (12.2.1) : Create a New Domain - This article describes the creation of a Forms and Reports Services domain in 12c.

Standalone Forms Builder 12c (12.2.1) Installation on Windows - Easily deploy a Forms Builder development environment without needing a WebLogic Infrastructure installation.

Oracle Forms and Reports Services 12c Configuration Notes - This article is a collection of useful notes on a variety of topics related to configuration of Oracle Forms and Reports Services 12c.

Oracle HTTP Server (OHS) 12cR2 (12.2.1) Installation on Oracle Linux 6 and 7 - This article demonstrates how to perform an installation of Oracle HTTP Server (OHS) on Oracle Linux.

Miscellaneous

Oracle Business Intelligence 12c (12.2.1.2.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Business Intelligence 12c (12.2.1.2.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Oracle Business Intelligence 12c (12.2.1.3.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Business Intelligence 12c (12.2.1.3.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Oracle Data Integrator (ODI) 12c (12.2.1.2.6) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 12c (12.2.1.2.6) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR2 (12.2) for the repository created by the Repository Creation Utility (RCU).

Oracle Data Integrator (ODI) 12c (12.2.1.3.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 12c (12.2.1.3.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR2 (12.2) for the repository created by the Repository Creation Utility (RCU).

External 12c Links

Documentation: Oracle Database 12c Release 1 (12.1)

Documentation: Oracle Database 12c Release 2 (12.2)

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 : Oracle Learning Channel