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…
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).
Ok I cannot name the customer (Approval pending) but a very exciting project just came to an end. You might be aware that I currently have a focus on exadata and high availability and sometimes nice projects come across your way. The title is an invented one, as it was a combination of looooots of exadata stuff and dataguard. And admit, it just sounds cool, isn’t it? 😉 The beginning The initial question was: “Can we expand our X3-2 non-prod…
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…
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…
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…
Gotcha! This post is not about memory settings at all, but a quick heads up. If you are dealing with several generations of exadata’s and you like ironhugging them as much as I do, sometimes things can get confusing. The X7 exadata has changed a bit so when you use them, it’s nice to do things right. Only way to do it right is check it, double check it and verify. One of the things which is always in my…
Some customers ask for help to fill in the Exadata Deployment assistant (OEDA for short). This is the case in my current project. They bought a shiny brand new X7 and requested assistance for the OEDA as they faced an issue with the admin network. It reproduces very easily so I will show this using a demo example. A small introduction is maybe needed for this. Most of us know the 10.x.x.x/8 or the 172.16.x.x and 192.168.1.x/24 ranges that are…
EDIT: This post is meant for playing around and this way is unsupported. The good way of upgrading is described here First of all I like to start with telling you that this blog-post is intended only for testing, playing, learning,… things. It is not intended for production use and currently 18c is only available for Cloud and engineered systems environments. For on-premises availability check Mike Dietrich’s ( @MikeDietrichDEÂ ) blog here:Â https://mikedietrichde.com/2018/03/20/when-will-oracle-database-18c-be-available-on-prem/ . There I like his sentence that I…
Today I was at one of my Exadata customers for a (PL/)SQL performance tuning assignment. In the meantime there is a parallel project running for a new Exadata. So as you might know, the configuration for an Exadata starts with running the OEDA-tool. The latest version can always be found on My Oracle Support note 888828.1. At the moment of writing this blog, the latest one was January 2018 with patch number 27370068. One of the things which caught our attention,…