While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the installation completion, the session fully stucked.I restarted the database (the CDB), then I tried to open the PDB, but I got the above errors. While searching for this … Continue reading Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation
Installing Oracle Sample Schemas (19.3)
In this post, I'm going to explain how to install Oracle sample schemas, if they are not already installed. If you created a database sing DBCA , you can select to install the sample schemas: Please note that using this method (dbca) will install only the HR sample schema. Or you can install sample schemas … Continue reading Installing Oracle Sample Schemas (19.3)
How to Create Autonomous Datawarehouse Database (Always Free Services)?
https://www.youtube.com/watch?v=nOJowoCyw7Y ThanksAhmed
How to Create Autonomous Transaction Processing Database (Always Free Services)?
https://www.youtube.com/watch?v=eF9LwCHCrRo ThanksAhmed
Oracle Apex Deployment Models in a Multitenant Database
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
Ahmed AbdelFattah Blog ! 