A few days ago, I was working at a customer and made a few changes to the running listener's configuration. After having verified that my changes were working as expected, I asked the listener to save the configuration, but the result was quite unexpected. The listener crashed with TNS-1153. I had hit bug #8612344, which is affecting all 10.2 … [Read more...]
Case: Oracle Dataguard switchover test
Recently, we migrated a large customers database environments to new databases on new hardware. The new setup consists of a cold failover Linux Cluster, which is located in the preferred production site, and two Dataguard(standby) databases in a remote DR site. Oracle 11gR2 Grid Infrastructure is used as basis for ASM diskgroups and for … [Read more...]
Oracle RAT – an easy way of proving how performance will be after an upgrade/change
An often overlooked feature of Oracle is Real Application Testing, called RAT. RAT is by far the best way of testing the impact of changes to the database (not applications). This can be anything from upgrading to new hardware, upgrading the database release, adjusting database parameters, creating new optimizer statistics, adding indexes, … [Read more...]