RMAN-06531 | Oracle 12c: Changing INC 0 backup sets to keep forever failed

Because of a customer requirements I had to change different backup pieces to KEEP FOREVER in a huge amount of database environments with very different database versions (10.2.0.5 – 12.1.0.2). During the tasks different complications came in. One of those is a change in the behavior between different RDBMS versions I also wrote a blog post … More RMAN-06531 | Oracle 12c: Changing INC 0 backup sets to keep forever failed

DOAG Conference 2015 – My impression / My presentation

Some weeks ago the DOAG Conference and Exhibition took place at the Nuernberg Convention Center. There were around 400 sessions in 20 parallel tracks and very different topics from application development over business intelligent till oracle database core themes. I was pleased to also take part of this very interesting and intensive days. Especially from … More DOAG Conference 2015 – My impression / My presentation

ORA-4031: Oralce miscalculating size of reserved pool

Our monitoring alarmed us about a short outage of one of our database environments. The alert.log of the database shows the following error. Wed Feb 04 19:41:48 2015 ORA-04031 heap dump being written to trace file /u00/app/oracle/diag/rdbms/p235/P2352/trace/P2352_lck0_24372.trc Errors in file /u00/app/oracle/diag/rdbms/p235/P2352/trace/P2352_lck0_24372.trc (incident=47049): ORA-04031: unable to allocate 8424 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,0)”,”KSXR … More ORA-4031: Oralce miscalculating size of reserved pool

Oracle database 11.2.0.4 randomly producing huge trace files with memory dumps

A few weeks ago I was alarmed by a spasmodic rise of the usage of the diagnostic directory in one of our database environments. At first some information’s about this system. * IBM AIX on POWER Systems (64-bit) 6.1 * Oracle Database 11.2.0.4.4 After a small research I realized that there were really huge trace files … More Oracle database 11.2.0.4 randomly producing huge trace files with memory dumps

Prechecking Oracle Grid Infrastructur and RDBMS 12c before installing CPU patch

After the release of the newest Critical Patch Update (CPU) for Oracle Grid Infrastructur (GI) and RDBMS of version 12.1.0.1 we decided to roll out this patch on one of your central database system. At first some information of this system: * OS: Oracle Enterprise Linux 6.4 * GI: Oracle Restart 12.1.0.1 * RDBMS: Oracle … More Prechecking Oracle Grid Infrastructur and RDBMS 12c before installing CPU patch

Change Oracle user account status from EXPIRE(GRACE) to OPEN

Last week i had the issue that the password of an oracle user was expired. Usually we set the password life time of the default profile to unlimited, because this database user is exclusively used by one application and it is inconvident to frequently change the password in the application. But accentally on this database it was not … More Change Oracle user account status from EXPIRE(GRACE) to OPEN