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 »
In this blog I will show you how to use an RMAN backup to create a database clone. In my last blog “Recovery with RMAN is easy!” I explained how RMAN can assist to recover from a data file corruption. Fortunately failures like corrupted data files or loss of the entire database are very rarely. More often you might have the challenge to create a copy of the database on a different server for testing or Q&A purposes. RMAN can assist directly with the duplicate command. But it might be a good idea to validate the backup while creating a
Cloning with RMAN is easy! Blogbeitrag lesen »
In this blog I will show you how easy it is to restore a corrupted tablespace or datafile using RMAN. In my last blog “Backup and Recovery with RMAN is easy!” I wrote how easy it is to backup a database using RMAN if “Oracle” can take care of the file structure. The third blog will than give some details about database cloning / database restore. Let’s start with a curruped database first. Linux is very handy so to destroy or corrupt a data file you can simply use the following command: dd if=/dev/zero of=/u02/oradata/PAUL/88ECC48AE4632772E0530D63A8C04AEF/datafile/o1_mf_users_gfqznp2m_.dbf’ bs=8192 count=1000 Please don’t test
Recovery with RMAN is easy! Blogbeitrag lesen »
