PDB Archive

Oracle 12c: Restrict OS authentication to a single pluggable database

In my last article, I have discussed about the process of implementing OS authentication in a multitenant Oracle 12c database without setting the deprecated parameter REMOTE_OS_AUTHENT. We have seen that we can create a common user for

Oracle 12c ( Now we can preserve the PDB state between instance startup

As we know, Oracle has introduced the multitanent architecture with Oracle version 12c, where we can have multiple pluggable databases (PDB) within a single container database (CDB). However, when we start up a container database (CDB), all

Oracle Database 12c (12.1): Datapump Export and Pluggable databases

As a DBA, we all are familiar with the Datapump (EXPDP/IMPDP) utility for exporting and importing database objects in and across databases. However, with the introduction of Oracle Database 12c and particularly with the introduction of Multi-tenant

Oracle Multitenant: Impact of a Pluggable Database (PDB) Failure

Introduction Today I would be discussing the impact of a pluggable database failure (particularly media failure) on the other pluggable databases and the parent container database. In this article series, I am trying to make an attempt

Oracle Database 12c Multitenant: Create a Pluggable Database

Oracle Database 12c multitenant architecture allows multiple pluggable databases (PDB) to be hosted in a single container database (CDB) or root database. In today’s article, I would be discussing the different methods that we can utilize to

Migrate a Non CDB database to PDB and plug in to a CDB using DBMS_PDB package

Following databases were used for demonstration Existing CDB : LABCP Existing PDB: LABP Existing NON CDB: LABPA   Step by Step Migration Tasks 1. Generate XML file from NON CDB to prepare for the PDB creation Make
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed