LATEST TOPICS

12c Archive

Oracle 12c: Customize your seed (pdb$seed) template PDB

Oracle has introduced multi tenant architecture with the release of Oracle database 12c (12.1.0.1). In a multi tenant Oracle database, we have a ROOT container database (CDB$ROOT), a SEED database (PDB$SEED) and the potential to have a

Oracle 12c: A quick look in to the new SESSION sequence

We are aware of the Oracle’s sequences. Sequences help us generate incremented sequence of numbers to be used as key for a record in the table. Until Oracle 11g, we used to create sequences which are persisted

Oracle 12c (12.1.0.2) : Enhancement made to the alternate archive dest[ination] handling

In one of my earlier post, I had discussed about the option of setting up a alternate archive destination in Oracle database. We have seen that, how we can leverage the alternate archive destination in the event

Oracle 12c: Implemented TDE? Cloning a PDB? you need to perform few additional steps

With Oracle 12c multitenant architecture, we need to maintain TDE encryption keys in both root (CDB$ROOT) and pluggable database (PDB) level. If we clone a PDB (which is encrypted with TDE) to another PDB within the same

Oracle 12c: TRUNCATE can be cascaded down to the lowest level of hierarchy

Do you recall the following error? ---// ---// ORA-02266 when truncating table //--- ---// SQL> truncate table parent; truncate table parent * ERROR at line 1: ORA-02266: unique/primary keys in table referenced by enabled foreign keys Well,

Oracle 12c: DDL Logging.. will it serve the purpose?

Oracle had introduced a cool feature in version 11g, where we were able to log or track DDL statements executed in the database by means of a parameter called ENABLE_DDL_LOGGING without setting up database auditing. Setting ENABLE_DDL_LOGGING

Oracle 12c: Global Index maintenance is now asynchronous

Introduction Maintaining global indexes were always a expensive task in Oracle, particularly in the context of partitioned tables, where dropping or truncating a table partition could cause a global index to become UNUSABLE/INVALID unless specified to update

Oracle 12c: Lost your PDB’s XML manifest file? Here’s how you can recover it

In this post, I will demonstrate how we can recover a pluggable database’s XML manifest file in the event of the the XML manifest file being lost or corrupted. When we UNPLUG a pluggable database from a

Oracle 12c : Know and understand your PDB’s history

As we know, with Oracle 12c multi tenant architecture we can have multiple pluggable databases within a single container database. A pluggable database can be created in a container and if required can be unplugged from a

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 RAC: Move management repository database (MGMTDB) to different location

Introduction This article outlines the steps required to relocate the Grid Infrastructure Management Repository (GIMR) database MGMTDB to a different file system storage. By default OUI (Oracle Universal Installer) creates the MGMTDB on the same file system

Oracle 12c RAC: Solving ‘Grid Infrastructure Management Repository connection error’

While trying to query the management repository path using OCLUMON utility, I was receiving the following error. ---// ---// error while accessing management repository //--- ---// myracserver1 {/home/oracle}: $GRID_HOME/bin/oclumon manage -get reppath Connection Error. Could not get

Oracle 12c: OS authentication and the multitenant architecture

Are you upgrading/migrating your databases to Oracle 12c? Are you using OS (external) authentication for schemas running batch jobs? If yes, then this post covers the areas that you need to look into, to be able to

Oracle 12c (12.1.0.2): 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 12c RAC: Clusterware logs are now centralized

When dealing with a Oracle Real Application Cluster (RAC) issue, a DBA generally needs to jump around multiple directories to find the relevant logs. Those days are now history as Oracle has centralized all the Clusterware (RAC)
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed