Julian@Database
  • Home
  • Blog
  • Contact
  • Events
Julian@Database Julian Frey about Databases
October 10, 2019
OGB Appreciation Day: Always free autonomous database with OCI CLI

OGB Appreciation Day: Always free autonomous database with OCI CLI

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 …

Oracle Home Installation with Ansible Role

Oracle Home Installation with Ansible Role

December 12, 2018

This post shows an ansible role for installing and patching an Oracle Home in a fully automated way.

18.3 silent installation including patching

18.3 silent installation including patching

September 10, 2018

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

Oracle Database 12.1 Information about PDB Snapshots

July 13, 2018

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

Error in DBMS_RESOURCE_MANAGER calibrate_io in Databases >= 12.2

March 2, 2018

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

ODA X6-2S upgrade Databases to 12.2

March 2, 2018

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

ODA X6-2 upgrade to 12.2

February 22, 2018

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

Database Connection to an oracle Database authenticated with a Certificate

September 3, 2017

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 …

Julian Frey

Adresse
Edorex AG
Unterdorfstrasse 5
3072 Ostermundigen

Follow @JulianFreyCH

Julian Frey

Julian Frey

I am working since more than 10 years as an Oracle Database consultant in many different companies all around Switzerland.

Search

Contact me

© 2019 Julian@Database | Powered by Outstandingthemes