Infrastructure at your Service

Category Archives: Database Administration & Monitoring

William Sescu

Oracle 12cR2 – ORA-44777 – Pluggable database service cannot be started

By | Database Administration & Monitoring | No Comments

Have you ever experienced the following error? SQL> alter pluggable database pdb2 open; alter pluggable database pdb2 open * ERROR at line 1: ORA-44304: service does not exist ORA-44777: Pluggable database service cannot be started. The error says, that Oracle is not able to open the pluggable database because a service is missing. At least the default service, which is the name of the pluggable database itself should be there. But in my case, it…

 
Read More
Mouhamadou Diaw

PostgreSQL 10 Beta 1: Logical replication

By | Database Administration & Monitoring | No Comments

In a previous blog we talked about partition in postgreSQL 10 Beta 1. In this article we will talk about another new feature logical replication. Yes in postgreSQL 10, logical replication is now impelemented. We can replicate one table or many tables. In our example we are replicating between two clusters in the same server. The primary cluster is running on port 5432 and the second on port 5433. But of course we an use…

 
Read More
Mouhamadou Diaw

History of Upgrading 9 Tb PostgreSQL database

By | Database Administration & Monitoring | No Comments

In this blog I am going share a history of PostgreSQL migration and upgrade from 9.2 to 9.6. Let me first explain the context We have a PostgreSQL environment with following characteristics. Note that real database name, server name are changed for security reason Host: CentOS release 6.4 PostgreSQL version: 9.2 Database size : 9Tb postgres=# select version(); version ————————————————————————————————— ———— PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2- 52),…

 
Read More
Daniel Westermann

You do use the Oracle Trace File Analyzer, don’t you?

By | Database Administration & Monitoring | One Comment

When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don’t know what it is for then you probably should read this, especially when you are working in clustered Oracle environments. You know, Oracle loves to create plenty of trace files in various places (yes, this got much better with the Automatic Diagnostics Repository(ADR)). Now imagine you have a cluster and something goes wrong,…

 
Read More
David Barbarin

SQL Server 2017 on Linux and some log shipping scenarios

By | Database Administration & Monitoring | No Comments

In this blog let’s talk a little bit about the log-shipping feature from the SQL Server CTP 2.0. First of all, let’s say that as a Windows version, it is possible to create our own solution based on Linux (and cron jobs for example). You may find out different pointers on the internet that deal with this topic. But getting the built-in log-shipping feature from SQL Server presents some advantages. Indeed, this is basically the…

 
Read More
Clemens Bleile

Workaround for bug 19566227/20563128 doing Cross Platform Migration (MOS Note 1389592.1)

By | Database Administration & Monitoring, Database management | No Comments

In a project I have to move an Oracle 11.2.0.4-DB (around 7TB in size) from Sparc Solaris (called Source in the remainder of this Blog) to Linux x86-64 (called Target in the remainder of the Blog). I.e. a platform migration from Big Endian to Little Endian. A good method to do that is described in My Oracle Support Note 1389592.1: 11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup Basically I copy the…

 
Read More
Daniel Westermann

Replicating from Oracle to PostgreSQL with EDB Replication Server – 1 – A simple replication setup

By | Database Administration & Monitoring | No Comments

When you want to offload reporting stuff from Oracle to PostgreSQL there are several solutions you can go for. There most widely known probably are Oracle GoldenGate and SharePlex. EnterpriseDB has its own solution for this which is called EDB Replication Server. As soon as you have one subscription from EnterpriseDB this tool is included and can be used to offload from Oracle to PostgreSQL. Lets do a simple replication setup and see how it…

 
Read More
William Sescu

Oracle Linux 7 – How to audit changes to a trusted file such as /etc/passwd or /etc/shadow

By | Database Administration & Monitoring, Operation systems | No Comments

Linux auditing is quite powerful and a lot of different use cases might be handled via the auditing framework. However, in this blog I would like to show you, how to audit changes on trusted files, like /etc/passwd or /etc/shadow. Of course, you are not limited to these files. You can audit whatever you want. Maybe the sqlnet.ora, the /etc/oratab or Oracle wallets are of more interest in your environment. Before we start, we got…

 
Read More
Mouhamadou Diaw

PostgreSQL 10 Beta 1: Native Table Partitioning

By | Database Administration & Monitoring | No Comments

The Beta 1 version PostgreSQL 10 is now released with lot of new features. One of the most popular is the native support of table partitioning. In this blog we are going to see how we can implement partitioned table in PostgreSQL 10. Note that RANGE and LIST partition are the supported methods. In following example RANGE partition is used. The first step is to create the table to be partitioned, let’s say for example…

 
Read More