Archiv der Kategorie: Oracle 12.1

Flashback in a Data Guard Environment but what are the steps

The Setup of an Data Guard environment with Physical Standby via Data Guard Broker was done including an Switchover. Everything fine and works as expected. (Oracle Release is 12.1.0.2 and PSU Jan 2017). The Dev Team asked for a Flashback … Weiterlesen

Veröffentlicht unter General, Oracle 12.1 | Verschlagwortet mit | Kommentar hinterlassen

Problems with Adaptive Features in 12.1.0.2 What’s to do?

The Adaptive Features is divided in two parts Adaptive Plans the possibility to change plans during execution Adaptive Statistics the statistics allow plans to be built from the results of previous executions Version 12.1  In 12.1 both components  will be … Weiterlesen

Veröffentlicht unter General, Oracle 12.1, Oracle 12.2, Oracle Database | Verschlagwortet mit , | Kommentar hinterlassen

Oracle RAC 12.1 Summary Deployment and Admin

If you need a good overview and introduction in Oracle 12.1 RAC take a look to the following document. RAC-12.1-Deployment-Admin          

Veröffentlicht unter Oracle 12.1 | Verschlagwortet mit , | Kommentar hinterlassen

How to fix ‚PLAN_TABLE‘ is old version

During a lot of SQL Performance activities I saw all the time the following message but why? Yes, I did a few days before an Upgrade from 11.2.0.4 -> 12.1.0.2. Now I start to check out some important SQL Queries … Weiterlesen

Veröffentlicht unter General, Oracle 12.1 | Verschlagwortet mit , | Kommentar hinterlassen

Exadata GI Upgrade 11.2.0.4 to 12.1.0.2 + PSU Jul2016

Recently I did a upgrade to Grid Infrastructure 12.1.0.2 on a few Exadata Clusters Here my summary of the installation Before you start please read the following MOS note 1681467.1. This note is very helpful and describes the whole procedure in … Weiterlesen

Veröffentlicht unter Exadata, General, Grid Infrastructure, Oracle 12.1 | Verschlagwortet mit , , | Kommentar hinterlassen

reinstall tfactl after GI Upgrade 12.1.0.2

Recently I finished a Grid Upgrade from 11.2.0.4 to 12.1.0.2 + PSU JUL 2016. So far so good during a check I saw that the old tfactl tool under Software Release 11.2.0.4 where up and running. That could not be … Weiterlesen

Veröffentlicht unter Grid Infrastructure, Oracle 12.1 | Verschlagwortet mit , , | Kommentar hinterlassen

Exadata ASM Disk overview via kfod

That’s the question: How can I  easily create an overview from the OS command line of all ASM Disks which are configured? Exadata ASM Disks ASM disks in an Exadata Machine are part of the Storage cells and presented to … Weiterlesen

Veröffentlicht unter ASM, Engineered Systems, Exadata, Grid Infrastructure, Oracle 12.1 | Verschlagwortet mit , , , | Kommentar hinterlassen

X5-2 Jan2016 GI – Bug 22135419 – 12C GRID HOME PERMISSIONS NOT RESET

    The last days I did a Upgrade on a Exadata X5-2 Machine including the GRID Software. During the GI Patching  (Patch 22243551) there was no error message. But after a short while we get a lot of errors … Weiterlesen

Veröffentlicht unter Exadata, Grid Infrastructure, Oracle 12.1, Oracle Database | Verschlagwortet mit | Kommentar hinterlassen