12c

Install grid infrastructure 12c on standalone server

Grid installation on the standalone database server is also known as oracle Restart. This is required if you wish you use ASM file system with oracle restart feature. Oracle Restart Means, During any ...

Change dbsnmp password for target db in oem 12c

  Update_db_password command can be used to updates DBNSMP password of the target in the Enterprise Manager Credential sub-system and change the password on the target database as well. The command ...

Upgrade database from 12.1.0.2 to 12.2.0.1

Oracle database version 12.2.0.1 is recently released.  I searched the database software for Solaris platform, Found it in oracle edelivery.     I downloaded the software from edelivery and...

Oracle 12c multitenant architecture

                         The most prominent feature of oracle 12c is its multitenant feature. We can use oracle 12c as normal database as that of previous version. But if you want to use ...

How to unplug and plug in pluggable database in oracle 12c

We can unplug the pluggable database from existing CDB and Plug it in a different CDB or in the same CDB, depending upon the required. While plugging you can keep the pdb name same as before or can gi...

Rman backup in multitenant database oracle 12c

With multitenant feature introduced in oracle 12c, New commands are there for taking rman backup of pluggable database and root container database. Backup of complete container( ROOT + ALL PDBS ) SQL&...

ENABLE_DDL_LOGGING in oracle 12c

This  ENABLE_DDL_LOGGING parameter has been introduced in oracle 12c. If this ENABLE_DDL_LOGGING is enabled,then DDL records are written to the ADR. All DDL operations like alter/create/drop/truncat...

How to install oracle 12c on Linux

Download the 12c software from edelivery :  EDELIVERY LINK   You can refer below oracle doc for installing required rpm packages and setting kernel parameters depending upon os platform ( RHEL 5...

How to create a multi tenant database in oracle 12c

If you haven’t installed 12C ORACLE_HOME, then below the below link. Install oracle database 12c software Once installation is done, Let’s create one container database(CDB) with 2 pluggab...

truncate table with cascade feature1 in oracle 12c

In oracle 12c TRUNCATE TABLE CASCADE will truncate its child tables, if ON DELETE CASCADE relationship is present on child table. Create one parent and child table with some data SQL> CREATE TABLE ...