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

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

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

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

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

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

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

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

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

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