Oracle Home Installation with Ansible Role
This post shows an ansible role for installing and patching an Oracle Home in a fully automated way.
18.3 silent installation including patching
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 …
Oracle Database 12.1 Information about PDB Snapshots
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 …
Error in DBMS_RESOURCE_MANAGER calibrate_io in Databases >= 12.2
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 …
ODA X6-2S upgrade Databases to 12.2
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 …
ODA X6-2 upgrade to 12.2
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 …
Database Connection to an oracle Database authenticated with a Certificate
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 …
