After database migration from Oracle 10gR2 on UNIX to Windows (Windows Server 2008 R2 64-bit), two productive databases were located on dedicated servers; one server running the 11.2.0.4 database and another server running the 12.1.0.1 database (both Enterprise Edition single-instance using non-ASM based storage). Another Windows server was … [Read more...]
Oracle12c R1 RDBMS New Features: Upgrading to 12cR1 (pluggable) database
When upgrading to 12cR1 (pluggable and non-CDB) database we can choose between the following methods: 1) Upgrade the pre-12cR1 database to 12cR1 using DBUA or command-line/upgrade script (catctl.pl); for some releases a Direct Upgrade to 12cR1 is possible (10.2.0.5, 11.1.0.7 and >=11.2.0.2). Notice that in 12cR1 the upgrade can now run in … [Read more...]
Challenges with object invalidation and ORA-04045 in Active Data Guard STANDBY-database
At one of our customers Oracle Active Data Guard is being utilized for resource intensive BI queries during normal business hours. The setup is based on 11.2.0.3 EE on OEL 6.4 and everything is running just smooth. One issue has been identified - namely implicit invalidation of database objects, e.g. VIEWS and PL/SQL procedures. The invalidation … [Read more...]
Oracle12c R1 RDBMS New Features: Creating pluggable database within an existing container database
One of the important new features in Oracle12c RDBMS is the concept of container databases (CDB) containing several pluggable databases (PDB). This enables customers to easily consolidate databases and will be an important feature for a Cloud database (12c, c = Cloud). The overhead in system resource usage will be reduced as the PDBs will share … [Read more...]
Unpleasent ORA-600 [kfdJoin3] caused by FCO/HDD replacement on ODA V1 with OAK 2.5.0
After several HDDs were replaced in a FCO (Field Change Operation) by Oracle Support on two ODAs, we ran into an unpleasent ORA-600 [kfdJoin3], which resulted in ASM disk groups not mounting, thereby causing the CRS stack to not startup properly. … [Read more...]