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 »
Hi There He is the first attempt to migrate 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… Read more »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
Hi There, This the query I am using to identify good candidate sql statements for result_cache sqlpatch. You can adjust to some specific schema and when you are fine with… Read more »