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…
Search Results for: ORACLE
Comparing files to be used by an Oracle External tables using Python3
Since I started to work using Python to automate some tasks on my Since I started working with Python to automate some tasks in my environment. I also started to think about what I can get from it. Python is powerful and there are a lot to be explorered from it and I am a DBA person and I am slowly getting to know this programming language. I started to create some scripts for fun and that is the topic of this post . Remember that on this blog you…
Connecting to Oracle Database using cx_Oracle module 7 for Python
In this post I will simply show how to connect to an Oracle database using Python 3 in an Oracle Linux 7.6 OS. One of the things that you have to do is to install Python in your OS. By default, Oracle Linux 7.6 comes with Python 7.6 but from 7.7 ownwards it comes with the version Python 3. If you wish to install the Python 3 in your system I do recommend you to take a look at one of my blog posts about this topic: “Installing Python 3…
Installing Python 3 on Oracle Linux 7.6
There are several ways to install python 3 on Oracle Linux 7 systems. You can either perform an installation using an EPEL (Extra Packages for Enterprise Linux) repository or the Software Collection Library (SCL) which requires that you perform other types of commands. However, on this post I am going to install from the the Oracle Linux 7 latest repository which is also another method besides the two previously mentioned. Also the OS will be an Oracle Linux 7.6 that comes installed by default, the version 2.7 of Python is…
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…
#8 DIÁRIO DE UM DBA – GUORS: I Encontro de Usuários Oracle do RS 2020
Faz exatamente 1 ano e 6 dias desde que eu escrevi o meu últigo post sobre essa série que eu criei no meu blog para escrever em português e escrever sobre eventos e notícías do universo Oracle no Brasil. Pois é meus amigos… 1 ano e 6 dias mas isso não quer dizer que o blog ficou parado não. Desde então, teve vários outros posts mas na língua inglesa e não sobre esta série. Por isso, me desculpem ! 🙂 Voltamos com tudo e agora para falar do evento GUORS:…
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…
CDC Oracle is not CDC Amazon
I have done some migrations from Oracle On-premise to Oracle AWS RDS using the AWS DMS (Data Migration Services) . However, while I was giving a lecture in Sweden I found out that the CDC is not supported in Oracle 12 and onward. Mathias Magnusson, one of the Oracle Aces (Oracle Ace Program) in Sweden asked me if the Amazon CDC mentioned in my presentation was the same CDC in the Oracle Database. At that moment I didn’t have the information but after the presentation and some research I found…
Oracle Enterprise Manager Cloud Control 12c Release 1 Installation
In this post I will display some screenshots and basics setups to be able to create an Oracle Enterprise Manager Cloud (OEM) Control 12c Release 1. I won’t go into the details in the installation because the purpose of this post is simply to show the installation by screenshots. If you want more details I recommend you go through both Oracle Database and Oracle Enterprise Cloud documentation. The first step in getting an OEM 12c1 is to have a database that it will work as the repository of this application.…