Once again this year, we have spared no effort to bring you an unforgettable Christmas celebration. With the FREE edition of the 2023 Christmas tree, you can immediately start decorating your home in festive style. This tree stands 10 cm tall and impresses with its striking solitaire ornament.
The SELF STRICKING CHRISTMASTREE Blogbeitrag lesen »
Oracle extends Oracle 19c Support for version 19c until December 31, 2029 (Premier Support) and until December 31, 2032 (Extended Support). See the “Oracle Lifetime Support Policy” here.
Oracle 19c Support until 2032 Blogbeitrag lesen »
This Blog describes how to set up a Database link from an Oracle Database to a MySQL Database. As an example serves an Oracle Standard Edition Two Version 19c (19.14.0) Database with the Standard Edition High Availability (SEHA) configuration on Oracle Linux 8.
Setup Oracle Database Link to MySQL Blogbeitrag lesen »
In many companies the DBAs – and not only them – are working with the user “SYSTEM“. Is that wrong? Not necessarily but you might what to check “who did what?” for auditing purposes. And the GDPR is pushing you to thing about if using build in users or security relevant build in objects is helpful.
Who is SYSTEM? Blogbeitrag lesen »
If you create a database using dbca (Database Configuration Assistant) step 3 allows you to select one of two templates (Data Warehouse or General Purpose or Transaction Processing). Both of them have the checkbox Include datafiles enabled. If you choose one of them the database creation is easy and within less that 5 minutes the new database is up and running.
Are Database Templates useful? Blogbeitrag lesen »
Since Oracle 18 (with some restrictions) it’s possible to set the Oracle software installation directory <ORACLE_HOME> into read only. And with Version 21 this will be the default. So it’s time to get used with it – not with version 18c of course but with 19c and the patch set from october 2020 (19.9).
Read-Only Oracle Home Blogbeitrag lesen »
On May 7th Oracle released “Standard Edition High Availability” (SEHA). There has been a high availability gap so far because as you probably know Oracle RAC is no longer available for Standard Edition since Version 19.(see Blog “No RAC for Standard Edition“). In March Oracle announced that there will be an alternative and … Here it is.
Standard Edition High Availability Blogbeitrag lesen »
April 15th was patch day again. New security patches, patch sets, release update and whatever they are named became available. On the same day Oracle announced that for 12.2.0.1 a “Limited Error Correction Support” will be offered. Limited Error Correction Support According to Oracle the reason for this support extension is to give customers more time to upgrade from version 12.2.0.1 to version 19. It doesn’t include version 18 or any other release. The support extension will start on December 1st 2020 and will last until March 31st 2022. And it only includes security patches and fixes for severity 1
Oracle 12.2.0.1 Support Extended Blogbeitrag lesen »
In one of my projects we had a disaster most recently: An application was connected to two databases simultaneously and propagated changes to both of them. But why was this possible? Why did we use two databases? And why is it possible for a service to connect to two databases – that shouldn’t work, should it?
Data loss with Database Services Blogbeitrag lesen »
At the Openworld conference 2019 Oracle announced that Oracle 19c will allow up to three pluggable database per database on both Enterprise and Standard Edition. If you take a look into the licensing guide it says:“For all offerings, if you are not licensed for Oracle Multitenant, then you may have up to 3 PDBs in a given container database at any time.” What does that mean? First it says that it might be time to upgrade to version 19c, also known as 12.2.0.3, because this release is the so called “Long Term Support Release” with a standard support until 2023.
Multitenant for Everybody Blogbeitrag lesen »
