Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation

Posted on by Ahmed Abdel Fattah

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

Advertisement

Oracle Database 32-bit Funny Migration to 64-bit

Posted on by Ahmed Abdel Fattah

Objective: Migrating one 11.1.0.7 32-bit database that resides on an old Windows 2008 (32-bit) (4GB memory) to Windows 2008 64-bit (no upgrade) on a brand new server with 64GB memory. {At 2017 and still there is 11.1.0.7 database ==> yes there is!} Introduction and Background I have a client with the following very old environment: … Continue reading Oracle Database 32-bit Funny Migration to 64-bit

Oracle Database Upgrade to 12c (In a Fail Safe Environment)

Posted on by Ahmed Abdel Fattah

This a step-by-step detailed procedure for upgrading one Oracle Database 11gR2 (11.2.0.4) on Windows Server 2012 to the latest version 12c (12.1.0.2) with the latest available Windows Bundle Patch. The database is configure with Fail Safe (Active/Passive) cluster to provide some sort of high availability. This is an actual live upgrade for one of my … Continue reading Oracle Database Upgrade to 12c (In a Fail Safe Environment)