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…
Month: March 2020
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…