As usual, I checked all the pre-requisites for the installation of Oracle Database 19c on Oracle Linux 8.2. However, I didn’t expect to be surprised with the below error at the very beginning: I thought:” Did I miss Oracle Linux 8 isn’t supported with Oracle 19c?”. I was sure that I checked this before so I started googling around again and then I found that this error has happened in previous releases as 12.1 due to the fact that it does not contain Pre-req checks specific to OL /RHEL 8…
Category: Oracle Database General
Oracle Cloud: Sign up failed “Error processing transaction”
I have already configured many accounts to use Oracle Cloud. Especially, since December 2020 I started to face some problems on the step where you must provide a credit card to simulate a payment but in fact, it works like a personal identification. So I have used the same card that I used previously in some setups, two other new cards and even asked some friends in different countries using their own cards and some of them have experienced the same erros while others could create their account successfully. Follow…
Example of how to use Oracle Cloud Infrastructure (OCI) Gen 2 with Terraform – Macbook Pro OS – part 2
This is the second article of these series where I will be covering the use of Terraform with Oracle Cloud Infrastructure from scratch. If you haven’t seen the first article I do recommend you check it out here https://www.techdatabasket.com/2020/10/21/example-of-how-to-use-oracle-cloud-infrastructure-oci-gen-2-with-terraform-macbook-pro-os-part-1/ , before you proceed with the following steps here. On the first article, how to create your account at Oracle Cloud was shown and a glimpse on Terraform. Now we are going through some examples that show what Terraform can really do while using it with OCI. So, let’s try to build an…
Oracle Database 19c doesn’t support OL6 – /lib64/libc.so.6: version `GLIBC_2.14′ not
One of the pre-requisite before installing any database software is to check if the platform that you are going to install your database in is supported by that platform. For instance, if you are going to install Oracle database on Linux, it is recommended to check the “Database Installation Guide for Linux” and check the operating system checklist. On April 25th 2019, Oracle database 19c became available to downloaded from Oracle.com. Regardless of the new features, software libraries and so on one difference from the previous release made me think…
Get to know Epico Tech. A gold partner Scandinavian company of Oracle
Everything changes and we as human beings are always looking to evolve. Following this mindset, I have joined a gold partner Scandinavian company of Oracle. For this post I would like to talk a little about this company and show what line of business they are into. What is the story? Epico Tech was started as Miracle Sweden in 2011 to build on the success Miracle A/S in Denmark. Since 2013 we have an office in the center of Stockholm. Miracle have since the start recruited some of the best within the…
Finally an Oracle ACE!
On October 2017, I received an e-mail from the Oracle Corporation saying that my “self-apply” to become an Oracle ACE Associate was successful and I have was accepted and became the first Oracle ACE Associate in Hungary (I lived there at that time). I have even written a post about this: Yesterday, Jun 16, 2020, it was the birthday of a very close friend of mine living in Australia and after a few hours of having a call with him, to wish him all the best during his day, I…
Oracle 12cR1: Moving tablespace by using the transportable tablespace feature from a Solaris Operating System (x86-64) to a Linux x86 64-bit system
This post will be about Cross-platform transportable tablespace. Cross-platform transportable tablespace is a technique where you can copy a tablespace from a database running in one platform to another platform. Also Cross-platform transportable tablespace isn’t the same as Cross-platform transportable database. In this instance the whole database is copied including the SYSTEM tablespace. In this post we are going to copy a tablespace from one database to another database. Then the first thing you have to know is the internal names for each platform that supports cross-platform data transport and…
Join the OraWORLD magazine! It’s free!
I have added to my blog a banner about the OraWorld magazine. This magazine is free and technical about Oracle contents. To get this magazine you only have to go through this link http://www.oraworld.org/home/, click on the “Subscribe to Newsletter” tab and fill in your information like e-mail, name, last name, user group (if you a part of one), accept all terms and then submit your subscription. Once this is done, you will receive an e-mail in your e-mail box. If you don’t find the e-mail from the magazine, take…
Digging the STAR_TRANSFORMATION_ENABLED parameter on Oracle database 12cR1 inside a PDB
When you think of a parameter that can help you out with star queries, this parameter is the STAR_TRANSFORMATION_ENABLED. According to the Oracle official documentation, it is described as the difference between a typical query and a star query, “A typical query in the access layer is a bond between the fact table and some number of dimension tables and is often referred to as a star query. In a star query, each dimension table is joined to the fact table using a primary key to foreign key join. Normally…
Taking an Oracle exam in unusual times – Nothing like a day (or months) like the other – Oracle Autonomous Database Cloud 2019 Specialist 1Z0- 931
My interest in the Oracle Autonomous Database Cloud 2019 certification started in September 2019 when I took this exam while attending the OOW19 (Oracle Open World 2019) at San Francisco, California, USA. Back then I failed the exam for many reasons, lack of studying (what matters a lot), pressure and so on but I am not here to make excuses because it would not change the results. So since then, I was involved in more projects where I could not only work with Oracle but also with Amazon Cloud and…