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…
PostgreSQL Archive Log Directory
According to PosgreSQL’s documentation : “Write-Ahead Logging (WAL) is a standard method for ensuring data integrity.”. These files are created in a directory at a local or remote server and if you desire to copy them you have to tape library. However, PostgreSQL database isn’t created with the WAL option enabled and to be able to use it you have to configure some essential parameters in the postgresql.conf file. Therefore , these parameters are: archive_command: Here is the directory that you want your WAL files be stored in. You can…
OEM 12c: Installing an agent on a remote server
Hello guys, I hope everyone is doing ok in these times of the Covid-19. Nevertheless, I am writing to you a post about how to install an OEM agent in a server other than the OMS server. If you haven’t performed the discovery of the agent in your OMS server, take a look at this post: The first thing you have to do in order to install an agent in other servers, is to add the name, IP and alias of the host that you want to install the agent…
OEM 12c : Discovering an agent on the OMS server
Hello guys, I hope everyone is doing ok in these times with the COVID-19. Nevertheless, I am writing to you a post about how to discover an OEM 12C agent on the same server that you have your OEM. In the other words, discovering the OEM agent in your OMS server as soon you have completed the installation of the OEM 12c. So let’s start. The first thing you have to do is to connect to your OEM 12 console: This is the Enterprise Manager Home Page. Here you can…
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.…
Changing default PGDATA for PostgreSQL 9.5 in RedHat 7
By default Red Hat and Centos OS stores the database in the file system /var/lib/pgsql/data/. The area where the database is located can be changed depending on individual environment requirements or preferences. So to speak, in this post I will show how to change this location. First, let’s check the current location of the PostgreSQL using the command “SHOW data_directory;” inside one of the databases. You can see in the example above that the location of the database files are the default location for RedHat which is “/var/lib/pgsql/9.5/data “. So…
PostgreSQL 9.5 installation on RedHat el7.x86_64
When it comes to perform the installation of the database engine Postgres SQL the link to download the software is: https://yum.postgresql.org/. Also take a look at the documentation to check the prerequisite: https://www.postgresql.org/docs/manuals/ The installation is performed using the repository and in this post I will install the version 9.5 on the operating system Red Hat el7.x86_64. So, let’s install the repository with the root user: Search for the installed repository using the command “yum search postgresql9”: After we have confirmed the installation of the repository, we can proceed with…
#sweoug #oracle #meetup – Feb 18 – 2020
Hello, I invite you all to attend my presentation in Stockholm, Sweden about “ORACLE DATABASE ON ORACLE AWS RDS” this Tuesday, 18th of February. Come to have the opportunity to check out Oracle engine in other vendors and compare with Oracle OCI ED2. We will also have Göran Paues speaking about “London OOW highlights”. Don’t miss this opportunity. Sign up here: https://www.meetup.com/Stockholm-Oracle/events/ctmzlrybcdbxb/