Of Motorcycles, Databases and the Cloud

Of Motorcycles, Databases and the Cloud



What has Oracle to do with motorcycles? At first sight: nothing at all! Except I’m a motor rider myself and I’m doing something with databases. But, inspired by a motorcycle-vlogger I made a mental connection between those area’s, where motorcycles can be replaced by cars or any other luxury goods we are using. Just a small reflection about overlooking the hidden costs or savings.

(and by the way, the photo of Itchy Boots I used, has her permission).

Motorcycles

To explain the relation, and relevant for this short blogpost, I first need to tell you what bike I own at the moment.

My motorcycle is a Yamaha XT1200Z Super Tenere Worldcrosser with 112 BHP, 1200cc, an impressive machine with massive power, especially designed for people like me, a wannabee world-traveller with little or no experience in off-road riding. The motor has been equipped with all kind of fancy electronics avoiding me falling off, be involved in an accident or get lost. But… you don’t see a lot of dirt-road travellers choose this bike for their adventures. (more…)

Multitenancy: is a Proxy PDB part of the 3 free PDBs at 19c

Multitenancy: is a Proxy PDB part of the 3 free PDBs at 19c

As most of us know, Oracle Database 19c now supports up to 3 pluggable databases (PDBs) per container database (CDB) without requiring additional multitenant license—applicable for both Standard Edition (SE2) and Enterprise Edition (EE). This documentation clearly states: “For all offerings, if you are not licensed for Oracle Multitenant, then you may have up to 3 user-created PDBs in a given container database at any time.” Meaning it’s about user-created PDBS.

But is a Proxy PDB (in fact a kind of symbolic link in Linux terms) considered user-created, or are you allowed to have 4 PDBs in theory? Once, I attended a presentation of Carajandb (Johannes Ahrends) in Germany, who stated that a Proxy PDB is free to use, based on the 18c documentation.

(more…)

Stretched – paid – support for 11.2.0.4 Oracle db

Stretched – paid – support for 11.2.0.4 Oracle db

A brief note this time. I checked the release-planning of the Oracle databases the other day (Doc ID 742060.1), and to my big surprise I noticed that the database version 11.2.0.4 will be supported till the end of 2022 through an added Error Correction level: ‘Paid Market Driven Support’.

(more…)

Should a standby database be considered in the cloud?

Should a standby database be considered in the cloud?

To answer this question for your company, the criticalness of your application and database must be clear. In a High Availability Environment, a standby-database can be part of the technical solution to ensure minimum downtime for your database.

But when moving to a public or private cloud (IaaS, PaaS), the providers ensure a certain high availability, so why should a standby database be considered as a viable configuration when high availability is needed?

(more…)

Oracle disaster recovery without licensing the DR site

Oracle disaster recovery without licensing the DR site

Recently I got a question of a customer regarding a failover configuration. They wanted to install a second server acting as a failover server, switched off until the primary experiences an outage, and they don’t want to pay licenses for it. By bringing the failover-server to life and restore the backup,  business continues on this server. Question: are licenses needed for Oracle databases and Linux as Operating System? (more…)

No more RAC in SE2 19c

No more RAC in SE2 19c

A short post after a tweet of Johannes Ahrends (@carajandb on twitter). He brought to our attention that he was worried: SE2 doesn’t include RAC anymore in 19c. Is it a documentation bug? Unfortunately not… his worries appeared to be ligitimate.  He made a blogpost about it – in the German language. Tried to summarize some in this blogpost.

(more…)

X