Oracle case studies, make it simple

  • Engineered Systems
  • Oracle 11g
    • 11g: Grid & RAC
    • 11g: Backup & recovery
    • 11g: Dataguard
    • 11g: Installation
    • 11g: Performance & Tuning
    • 11g: Security configuration
  • Oracle 12c
    • 12c: Installation
    • 12c: Multitenant
    • 12c: Performance & Tuning
    • 12c: Security configuration
    • 12c: Grid & RAC
    • 12c: Dataguard
    • 12c: Backup & recovery
  • Coming next…
  • My OCM experience
    • OCM 11g Preparation
      • Server Configuration
      • Enterprise Manager Grid Control
      • Managing Database Availability
      • Data Management
      • Data Warehouse Management
      • Performance Management
      • Grid Infrastructure and ASM
    • OCM 11g Exam Taken
    • OCM 12c Preparation
    • OCM 12c exam taken
    • My OCM Profile
  • About me
  • Company I work in
Oracle case studies, make it simple
Skip to content
  • Engineered Systems
  • Oracle 11g
    • 11g: Grid & RAC
    • 11g: Backup & recovery
    • 11g: Dataguard
    • 11g: Installation
    • 11g: Performance & Tuning
    • 11g: Security configuration
  • Oracle 12c
    • 12c: Installation
    • 12c: Multitenant
    • 12c: Performance & Tuning
    • 12c: Security configuration
    • 12c: Grid & RAC
    • 12c: Dataguard
    • 12c: Backup & recovery
  • Coming next…
  • My OCM experience
    • OCM 11g Preparation
      • Server Configuration
      • Enterprise Manager Grid Control
      • Managing Database Availability
      • Data Management
      • Data Warehouse Management
      • Performance Management
      • Grid Infrastructure and ASM
    • OCM 11g Exam Taken
    • OCM 12c Preparation
    • OCM 12c exam taken
    • My OCM Profile
  • About me
  • Company I work in

Cannot create database on ODA X6-2m after changing default port from 1521 to 13200

Jacques    January 8, 2018 January 8, 2018    No Comments on 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 »

Uncategorized   

RAC Database upgrade from 12.1.0.2 to 12.2.0.1

Jacques    July 5, 2017 July 5, 2017    No Comments on RAC Database upgrade from 12.1.0.2 to 12.2.0.1

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 »

12.2, 12c, 12c: Grid & RAC, TIPs   

8 Nodes Cluster Upgrade from 12.1.0.2 to 12.2.0.1

Jacques    July 4, 2017 March 5, 2017    4 Comments on 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 »

12.2, 12c, 12c: Grid & RAC   

Setting up TAF with Data Guard: news from error ORA-16456

Jacques    December 13, 2016 December 13, 2016    No Comments on 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 »

12c: Dataguard, TIPs, Uncategorized   

Setting up TAF with Data Guard: A new ORA-16456 is coming!

Jacques    December 12, 2016 December 12, 2016    No Comments on 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 »

11g, 11g: Dataguard, 12c, 12c: Dataguard, TIPs   

Managing standby redologs in policy managed RAC configuration

Jacques    November 21, 2016 November 24, 2016    No Comments on 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 »

11g: Dataguard, 12c: Dataguard, TIPs, Uncategorized   

Consequences of System Board replacement for ODA

Jacques    November 10, 2016 November 10, 2016    No Comments on 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 »

Engineered Systems, TIPs   

Commit_logging and Commit_wait in SYNC DataGuard configuration

Jacques    October 7, 2016 October 12, 2016    1 Comment on 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 »

12c, 12c: Dataguard, TIPs   

Logon trigger on active dataguard

Jacques    August 17, 2016 August 17, 2016    No Comments on 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 »

11g: Grid & RAC, 12c: Grid & RAC, TIPs   

DataGuard 12c: Is broker mature with serverPools? part 2

Jacques    July 8, 2016 July 11, 2016    No Comments on 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 »

12c, 12c: Dataguard, 12c: Grid & RAC, TIPs   

DataGuard 12c: Is broker mature with serverPools?

Jacques    July 6, 2016 July 11, 2016    No Comments on 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, 12c: Dataguard, 12c: Grid & RAC, TIPs   

12c wrong result while playing with optimizer_adaptive_features in Singletenant

Jacques    May 4, 2016 May 4, 2016    No Comments on 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 »

12c, TIPs   

12.2 is coming soon…

Jacques    May 2, 2016 May 2, 2016    No Comments on 12.2 is coming soon…
12.2, Uncategorized   

Check access/filter predicate efficiency

Jacques    May 2, 2016 October 17, 2016    1 Comment on 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 »

11g, 11g: Performance & Tuning, 12c, 12c: Performance & Tuning, Uncategorized   

Identify good candidate sql statements for Result Cache

Jacques    May 2, 2016 May 2, 2016    No Comments on Identify good candidate sql statements for Result Cache

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 »

11g, 11g: Performance & Tuning, 12c, 12c: Performance & Tuning, Uncategorized   

Posts navigation

1 2 3 Next »

Recent Posts

  • Cannot create database on ODA X6-2m after changing default port from 1521 to 13200
  • RAC Database upgrade from 12.1.0.2 to 12.2.0.1
  • 8 Nodes Cluster Upgrade from 12.1.0.2 to 12.2.0.1
  • Setting up TAF with Data Guard: news from error ORA-16456
  • Setting up TAF with Data Guard: A new ORA-16456 is coming!

Tweets

Recent Comments

  • Gustavo on Implement fine-grained access control
  • Camille Diesendorf on Multiple awr report parser in perl
  • Cory Costa on 12c db_block_checking and db_block_checksum measured overhead
  • zavi on Check access/filter predicate efficiency
  • NEW PUBG MOBILE 0.7.0 UPDATED HACKCHEATMOD .APKWITH DOWNLOADWORKING PUBG MOBILE HACK 2018 on Implement ASM failure groups

Archives

  • January 2018
  • July 2017
  • December 2016
  • November 2016
  • October 2016
  • August 2016
  • July 2016
  • May 2016
  • January 2016
  • December 2015
  • March 2015
  • January 2015
  • December 2014
  • July 2014
  • June 2014
  • May 2014
  • March 2014
  • January 2014
  • October 2013
  • August 2013
  • June 2013
  • May 2013
  • November 2012

Categories

  • 11g
  • 11g: Dataguard
  • 11g: Grid & RAC
  • 11g: Installation
  • 11g: Performance & Tuning
  • 12.2
  • 12c
  • 12c: Backup & recovery
  • 12c: Dataguard
  • 12c: Grid & RAC
  • 12c: Performance & Tuning
  • Engineered Systems
  • TIPs
  • Uncategorized

Google Analytics Stats

generated by GADWP 
@jkofr
Ribosome by GalussoThemes.com
Powered by WordPress