Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Nathan Courtine

Manipulate Stretch database feature by script

By | Database Administration & Monitoring | No Comments

On November 30th, I presented the Stretch Database feature in “Les Journées SQL Server 2015” in Paris. I explained how to manage by script this new feature in SQL Server 2016 CTP 3.0 I decided to share you my demonstration into a blog.   I – Enabling the feature at the instance level First, you need to enable the “Remote Data Archive” option at the instance level. To check if the options is enabled: sp_configure…

Read More
Nicolas Jardot

How to read XML database alert log?

By | Database Administration & Monitoring | No Comments

Since Oracle 11g, Oracle maintains two copies of the database’s alertlog in ADR: a flat text file in the sub-directory trace and an XML like in the folder alert. I had a case recently at a customer where the log.xml was moved to another place and compressed for archiving reason. As the regular text file was not containing old data, the goal was to exploit the archived XML -like file. When the file is still located…

Read More
Daniel Westermann

Upgrading PostgreSQL to a new major release

By | Database Administration & Monitoring | No Comments

The last post looked into how to upgrade PostgreSQL to a new minor version. In this post I’ll look into how to upgrade PostgreSQL to a new major version. This is not as simple as just installing the binaries and start the instance from there. For major upgrades there are two possibilities: dump the old version and restore into the new version by using pg_dump and pg_restore use pg_upgrade I’ll only look into pg_upgrade for…

Read More
Daniel Westermann

Patching PostgreSQL to a new minor release

By | Database Administration & Monitoring | 3 Comments

If you are used to patch Oracle databases you probably know how to use opatch to apply PSUs. How does PostgreSQL handle this? Do we need to patch the existing binaries to apply security fixes? The answer is: No. Lets say you want to patch PostgreSQL from version 9.4.1 to version 9.4.5. What do you need to do? For this little demo I’ll create a new database and a sample table in my 9.4.1 instance:…

Read More
Oracle Team

OCM 12c preparation: Manage PDB

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Let’s see the different ways to create a PDB, with different tools. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what you will have at the exam, but they cover important points that matches the exam topics. Documentation Information about the exam says: Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax. Documentation…

Read More
Oracle Team

OCM 12c preparation: Create CDB in command line

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . This post starts a series about things I wrote while preparing the OCM 12c upgrade exam. Everything in those posts are written before taking the exam – so don’t expect any clue about the exam here. It’s based only on the exam topics, and only those points I wanted to brush up, so don’t expect it to be a comprehensive list of points to know for the exam. Let’s start by…

Read More
Daniel Westermann

Migrating the Oracle 12cR1 sample schemas to PostgreSQL Plus Advanced Server 9.4

By | Database Administration & Monitoring | No Comments

This post takes a look on how to migrate the Oracle 12cR1 sample schemas to PPAS 9.4 (PostgreSQL Plus Advanced Server 9.4). I’ll not dig into how to install PPAS as this was described in detail some time ago. Just follow this post if you need a setup guide. If you wonder why I am doing this there are two reasons: to see if it works, to have fun and to learn PostgreSQL and PPAS…

Read More
Hervé Schweitzer

With Oracle Goldengate take care of additional column creation on the replicated database

By | Database Administration & Monitoring | 3 Comments

This week I worked on a GoldenGate 12.1.2.1.10 POC setup and was facing an issue which for me is a serious drawback of the Oracle GoldenGate product.If you want to create additional columns on the target database online in a GoldenGate configuration you have to be aware of the below situation which can happen in your setup:The below demo was created on a Oracle GoldenGate Downstream server For the test, I have created the schema…

Read More
Pierre Sicot

How to rename listener target in EM Cloud 12c ?

By | Database Administration & Monitoring | No Comments

Sometimes it is necessary to rename targets in Enterprise Manager Cloud Control 12c. In my case I have listener targets discovered by EM12c with the hostname at the end of the target name: TESTDBA_LSN_dbserver1 As I work in a Veritas clustered environment, when the target switches to the other node (dbserver2) the listener target is relocated, but its name is always TESTDBA_LSN_dbserver1. How to rename a listener target in EM Cloud Control 12c? We use…

Read More
Daniel Westermann

Upgrading the Grid Infrastructure from 12.1.0.1 to 12.1.0.2 on the command line

By | Database Administration & Monitoring | 2 Comments

A lot of people use the graphical way to upgrade Oracle software from one version to another. While there is nothing to say against that the same can be done without any graphical tools. This post outlines the steps to do so. Currently my cluster is running Grid Infrastructure 12.1.0.1 without any PSU applied. The node names are racp1vm1 and racp2vm2: [grid@racp1vm2 ~]$ /u01/app/12.1.0/grid_1_0/bin/crsctl query crs softwareversion Oracle Clusterware version on node [racp1vm2] is [12.1.0.1.0]…

Read More