Following are screen shots from one of my latest presentations about this topic: References: https://docs.oracle.com/database/121/HTMIG/db_pluggable.htm https://oracle-base.com/articles/12c/multitenant-uninstall-apex-from-the-cdb-12cr1 ThanksAhmed
Oracle 12.2 Database Creation
This post is just a screen cast for the process of creating a new container database with two PDBs in Oracle version 12.2. Login to the database server, set the ORACLE_HOME , PATH and DISPLAY , then run the Database Configuration Assistant "dbca" as oracle user: Check the listener status and ensure that the newly … Continue reading Oracle 12.2 Database Creation
Oracle Database Guard 12c Implementation with RAC (Step-by-Step)
Introduction: This is a real data guard implementation case for one of my clients. Data Guard is implemented between two clusters that reside on two different supercluster machines. The below procedure applies between any two clusters, it doesn't matter if it is a supercluster or Exadata or normal servers. I tried to put as much … Continue reading Oracle Database Guard 12c Implementation with RAC (Step-by-Step)
Oracle Database 12c Password File
Introduction: I (and we) used to see the oracle database password file under $ORACLE_HOME/dbs for both single instance and RAC databases. Example for RAC database: On node1 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD1 On node2 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD2 If one password file was changed in one node, then you have to copy it to all other nodes in the cluster. What is … Continue reading Oracle Database 12c Password File
Installing Oracle Apex 5.1.4 on Oracle Database 12c R2
This is a quick post on how to install Oracle Apex version 5.1.4 on Oracle Database 12.2 on Windows platform. 12cR2 Update: From Oracle Database 12c Release 2 (12.2) onward APEX is not installed by default, so you no longer need to worry about uninstalling APEX before creating PDBs. The software is still shipped with … Continue reading Installing Oracle Apex 5.1.4 on Oracle Database 12c R2
Oracle Database 12c R2 Partitioning New Features – Automatic List Partitioning
Oracle Database 12.2 introduces new nice and powerful partitioning features. This post will introduce one of them “Automatic List Partitioning”. We may talk about other features in future posts. Before 12.2, if you have a list partitioned table in specific discrete values, and there is a need to add a new list value, then you … Continue reading Oracle Database 12c R2 Partitioning New Features – Automatic List Partitioning
Ahmed AbdelFattah Blog ! 