8 Nodes Cluster Upgrade from 12.1.0.2 to 12.2.0.1
Here there, This a from scratch first test case I am trying to upgrade my 12.1.0.2 cluster lab to 12.2.0.1 just downloaded! Here are some specification: Main Host is Red… Read more »
RAC Database upgrade from 12.1.0.2 to 12.2.0.1
Hi There He is a migration of a RAC 12.1.0.2 database to 12.2.0.1 using dbua! Upgrade of the grid infra to 12.2.0.1 can be seen here I am choosing ECOM… Read more »
Managing Standby RedoLogs
Hi There, In a policy managed RAC configuration with dataguard also in RAC mode, sometimes it is getting hard to manage standby redo logs. From time to time, after a… Read more »
Cannot create database on ODA X6-2m after changing default port from 1521 to 13200
Hi There, Here is a nice one, We managed to setup two nice ODA X6-2M for one customer and because of security reasons, the customer request us to setup the… Read more »
Setting up TAF with Data Guard: news from error ORA-16456
Hi there, An update following my initial post here Within Trivadis, we have made some tests on 12.1.0.2 • JUL 2016 – affected • APR 2016 – affected • JAN 2016… Read more »
Setting up TAF with Data Guard: A new ORA-16456 is coming!
Hi there Normally, all of us have already setup TAF for client connection in a dataguard configuration. We always do a simple check with a switch-over to show that a… Read more »
Managing standby redologs in policy managed RAC configuration
Hi There, In a policy managed RAC configuration with dataguard also in RAC mode, sometimes it is getting hard to manage standby redo logs. From time to time, after a… Read more »
Consequences of System Board replacement for ODA
Hi there, If one day, you have the experience like me to manage the replacement of a motherboard into an ODA, think about the following: No more private interconnect between… Read more »
Commit_logging and Commit_wait in SYNC DataGuard configuration
Hi there, In this post, I would like to show the effect of commit_logging and commit_wait parameters with physical standby in SYNC mode. To clearly understand how those two parameters… Read more »
Logon trigger on active dataguard
Hi There, Normally this works fine! But today I just discovered that it could not work anymore when it has worked few weeks before. What the… I was able to… Read more »
DataGuard 12c: Is broker mature with serverPools? part 2
Hi there, This is the part II for DataGuard 12c in RAC with serverpools. This is a test case in production, you will probably never ever have the standby on… Read more »
DataGuard 12c: Is broker mature with serverPools?
Hi there, Having a DataGuard configuration in RAC with the introduction of ServerPools was chalenging in 11g. This is a test case in production, you will probably never ever have… Read more »
12c wrong result while playing with optimizer_adaptive_features in Singletenant
Hi there, Db version: 12.1.0.2 in RAC on ODA X5-2 and Singletenant and VPD. Test case query: Connected to cusarprd pdb using default service cusarprd.customer.com with user “myuser” gives me… Read more »
Check access/filter predicate efficiency
Hi there, This some queries I am using to check access predicate efficiency. First two small functions. Access predicate: And filter predicate Usage as follow: Check index access predicates efficiency… Read more »