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…
Author: brunors
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)
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/ brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with…
When use Temporary Tablespace Groups
I was managing a database that had a temporary tablespace which was having problems to hold the results of a sort. Then I solved this problem by creating a temporary tablespace group. And according to Oracle Corporation, “… enables parallel execution servers in a single parallel operation to use multiple temporary tablespaces.”. So how can I do that? If you are managing a multitenant database you must have in mind what problem is occurring in one of your PDB or the CDB. Let’s see if we are going to create…
Presentation LUXOUG: Oracle Database on Oracle AWS RDS
“Oracle Database on AWS RDS “ to the LUXOUG (Luxembourg Oracle User Group) 🇱🇺 on February . Here are the details: – Oracle Database on AWS RDS. – How to migrate the On-prem Oracle to AWS RDS (Oracle LogMiner) – Pros x Cons of using DMS tool (According to my experience) Link: https://lnkd.in/dyEjvrd Speaker: Bruno Reis – 02/13/2020 19:00 (CEST) Please subscribe to the portal for free. Youtube link : https://www.youtube.com/watch?v=Ud3CGT4B1Io Pdf of the presentation below: brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a…