Browsed by
Category: Howto

To CDB or not to CDB, that’s the question

To CDB or not to CDB, that’s the question

A product manager has several parts on the job. You can do outbound PM, that is what you, the readers or public, see. But we have also an inbound task. One of the things we do is answer internal questions and advise on how to use the product. This question is coming from a colleague who is doing an upgrade at a customer and facing some strange things with the move from non-cdb towards a cdb. On My Oracle Support…

Read More Read More

A walkthrough the Transient Logical Standby

A walkthrough the Transient Logical Standby

This blog post is created because I got some questions in the last weeks about upgrading using Data Guard. For migration to the cloud we now have Oracle Move and ZDM ( https://www.oracle.com/database/technologies/cloud-migration.html and https://www.oracle.com/database/technologies/rac/zdm.html) Check them out as well! Data Guard is meant as a Disaster Recovery (DR) solution, but to leverage the usage, one of the things it is often used for is also migrations. My colleague Mike Dietrich ( https://mikedietrichde.com ) can tell you all the differences between upgrade and migration,…

Read More Read More

Is your PDB state saved?

Is your PDB state saved?

This might save you a couple of minutes if you wonder how multitenant works in combination with Oracle Data Guard. The question I got was, is your PDB state saved after a switchover? The short answer is: Yes it is. No statements without proving them of course, so here we go. The primary database: I have the state of my pub always saved in my post creation script, but you can easily retrieve in what state the PDB will be…

Read More Read More

Data Guard made easy

Data Guard made easy

Sometimes I hear stories about struggles to setup Data Guard correctly. It should not be hard. There are lots of ways which lead to a correct setup. Die hards prefer the manual or own scripted way. Other people prefer the point and click method in Enterprise Manager. But one way, which is very easy, and I don’t hear people speaking a lot about it, is using the Database Creation Assistant (dbca).

OCI-Tenant admin locked, how to reset your own password

OCI-Tenant admin locked, how to reset your own password

There are some of those days that you rely too heavily on password tools. Yes, you always should use different passwords and strong ones. But I won’t preach to you, but due to this, I locked myself out of my tenant admin user in the Oracle Cloud Infrastructure (OCI). For those who have seen my OCI – talk already, you know I’m a big fan of the OCI – utility. Also a comprehensive list of things you can do with it,…

Read More Read More

lab-time: upgrading grid infrastructure (gi) from 12.1 to 18c – the final version

lab-time: upgrading grid infrastructure (gi) from 12.1 to 18c – the final version

In an earlier blogpost, I was playing around in an unsupported way to upgrade my lab Grid Infrastructure from 12.1 to 18c. The problem there was, that the 18c software was not officially available for on-premises installations. Now it is! During my holidays I had a little time to play around with it and this is how I upgraded my cluster. Reading the documentation it seems very easy (and it really is). Unzip the software and run gridsetup.sh. I wouldn’t…

Read More Read More

Exadata Security: the joy of PXE and UEFI: Secure boot violation

Exadata Security: the joy of PXE and UEFI: Secure boot violation

Today I had the honour to join my colleague Freek D’Hooge (find him here: @dhoogfr )in the datacenter. Task for today, reimage an 1/8th X7 Exadata using PXE. Andy (Colvin) warned me already that, when trying to reimage them, they are now using UEFI – boot. Knowing this in advance, this would be an #exatastic day. As usual, Andy was right. Trying to boot one of the cells on the pxe “the old method” resulted in: “Secure boot violation: Invalid signature…

Read More Read More

Tunnelblick ovpn client for Mac os High Sierra

Tunnelblick ovpn client for Mac os High Sierra

This weekend I was playing around with Openvpn to a new site. I use Tunnelblick for this, but this time was the first time after I had upgraded my Mac to High Sierra (10.13.5). Suddenly my vpn connections didn’t want to load anymore. Tunnelblick threw these errors to me:

I was running a beta, so first thing was to install the stable release, but the message remained. This link: https://tunnelblick.net/cKextLoadError.html helped me. In high sierra to use or add modules…

Read More Read More

Building bridges: “Bridge must not have discovery mode for LACP interface; Interface file: bondeth0;”

Building bridges: “Bridge must not have discovery mode for LACP interface; Interface file: bondeth0;”

Some days start as an exatastic day and end up grasping your hair. This post is about such a day. A brand new shiny X7 Quarter Rack exadata was being installed for a customer. This setup was a fairly straightforward one. Quarter rack, full ovm and 2 virtual clusters. Not too fancy. LACP is being used for the public network on the fibers and vlan tagging is done on the switch. Given that, my customer created a OEDA configuration using…

Read More Read More

OCI-C orchestration error with load balancers

OCI-C orchestration error with load balancers

There are some of those days that you just don’t get it anymore. Last few days were like that for me. One of my current projects is to provide a fully redundant infrastructure in the Oracle Cloud for some critical applications. So I created the Database as a service with dataguard to another region, provisioned a vm (IAAS) for the webserver and tomcat and made some firewall rules. Check also my colleague Freek (you can find him here @dhoogfr ) his journey…

Read More Read More

%d bloggers like this: