To be part of the OGB Appreciation Day I have written a Blog Post to show you how easy it is to create an always free Autonomous Database with the OCI CLI. Probably not everyone noticed it but the oci-cli does support always free databases in the Oracle Cloud. According to my google search the …
This post shows an ansible role for installing and patching an Oracle Home in a fully automated way.
Oracle changed some installation Steps for the Database Version 18c. One thing is that there should be a rpm installation (according to “Release Schedule of Current Database Releases (Doc ID 742060.1)” still in development (10.09.2018)). Then there is the possibility of a read only installation ( another Blog post will describe this). Then there is …
Since Oracle 12c we do have the feature of creating snapshots of existing PDBs. This feature is excellent for development purposes. On a Oracle Database Appliance it took <3seconds for the creation of a snapshot of an existing PDB (~200GB size) which is far less than the time it would take to create a rman …
Update: Still present in 18.4 During the upgrade of some databases on the ODA X6 I recogniced a strange behavior in DBMS_RESOURCE_MANAGER.calibrate_io. I use DBMS_RESOURCE_MANAGER.calibrate_io some times as a baseline test of my system to check what is possible. For workload tests there are many better tests than calibrate_io but as a baseline to check …
In the Blog Post ODA X6-2 upgrade to 12.2 I described the way for upgrading an ODA to 12.2. In this post I will describe the two ways with ODA tools for upgrading a database to 12.2 and I will show on what you have to take care about. Prerequisites for upgrading databases Before you …
During February Oracle release the Oracle Appliance Kit 12.2.1.2.0 for ODA. There are two different patches available: Patch 27141226 for versions X6-2S, X6-2M, X6-2L, X7-2S, X7-2M, X7-2HA Patch 27119652 for versions V1, X3-2, X4-2, X5-2, X6-2 HA In this blog post I will go through the patch of an ODA version X6-2S. Updated software in …
Instead of connecting to the database with username and password it is also possible to connect to the database via username and certificate. In this example we will use self signed certificates. A similar configuration is possible with trusted certificates. To be able to login to the database with a certificate we need a wallet …
I am working since more than 10 years as an Oracle Database consultant in many different companies all around Switzerland.