Infrastructure at your Service

Category Archives: Database management

Jérôme Dubar

Easily manage dual backup destination with RMAN

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

Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these multiple channels. As far as you’re using Enterprise Edition because Standard Edition is stuck to a single channel. Disk space is very often limited and you’ll probably have to find another solution to keep backups…

 
Read More
Petre Radut

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

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

The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver). Assumptions : You have installed Oracle GI 12.1 as grid user You have installed Oracle Database 12.1 as oracle user You have configured the groups asmadmin,asmoper,asmdba You installed oracle-rdbms-server-12cr2-preinstall rpm You patched your Oracle GI to…

 
Read More
Jérôme Dubar

Patching ODA lite to 12.2.1.4.0

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

Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed. 1) Download the patch The patch number is 28216794. This patch will update the following components:  dcs (odacli), operating system, bios/firmwares, ilom, GI, dbhomes and databases. Download and copy the patch to a temporary folder on the server,…

 
Read More
Michael Hein

Logical standby: No view for data guard status on session level

By | Database management, Oracle | No Comments

On logical standby you have to switch off data guard at least on session level to make modifications on objects which are maintained by data guard. This is done by command alter session disable guard; Dataguard can be reenabled for this session by issuing alter session enable guard; For executing these commands “alter database” privilege is at least needed, which is often not liked by IT security staff. Command “alter session disable guard” is also…

 
Read More
David Barbarin

SQL Server on Linux – I/O internal thoughts

By | Database management, Development & Performance, SQL Server | 2 Comments

Let’s start the story from the beginning with some funny testing I tried to perform with SQL Server on Linux a couple of months ago. At that time, I wanted to get some pictures of syscalls from SQL Server as I already did in a past on Windows side with sysinternal tools as procmon and stack traces. On Linux strace is probably one of the best counterparts. Firstly, please note this blog is just from…

 
Read More
Mouhamadou Diaw

DataGuard and Transparent Data Encryption

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

Setting up a DatagGard environment for a database with Transparent Data Encryption requires some tasks concerning the encryption keys. Otherwise the steps are the same than for an environment without TDE. In this blog we will present the tasks we have to do on both primary and standby servers for the keys. We will not describe the procedure to build the standby database. We will just talk about tasks for the wallet and we will…

 
Read More
Nicolas Penot

How to fix your own SQL plan in Oracle ?

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

There is time when you have build an SQL plan and then you want to fix it for all next executions of the query by your application. In this post I show how fix a plan you have created by yourself. First we need to identified the query SQL> select /* INDEX_ACCESS */ line_item_id, product_id, unit_price, quantity from ORDER_ITEMS where order_id = 234098 ; LINE_ITEM_ID PRODUCT_ID UNIT_PRICE QUANTITY ———— ———- ———- ———- 1 414 851…

 
Read More
Clemens Bleile

sqlplus and its column output

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

During tuning or normal DBA activities one of the most annoying things is sqlplus with its default column output when running queries. I.e. even after setting a linesize of 1000 and a pagesize of 1000 the output may look as follows in your preferred terminal emulation (putty here): Most people address this by using other tools like sqldeveloper (or sqlcl with sqlformat ansiconsole). However, a lot of people still use sqlplus. How can you address…

 
Read More
Joël Cattin

PostgreSQL – logical replication with pglogical

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

Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called pglogical. It’s a Postgres extension developed by 2ndQuadrant, major contributor to PostgreSQL development. The goal of this blog post is to discover how to install pglogical and configure it in order to generate simple logical replication cases. Installation To get the extension…

 
Read More
Clemens Bleile

Connect-times to the DB suddenly become very slow using sqlcl

By | Database Administration & Monitoring, Database management, Development & Performance, Oracle | 2 Comments

I recently wrote a couple of sql-scripts which had to run on all of my customer’s DBs. The sql-scripts had to be started from a Linux-client, which does not have any Oracle client software installed. So I thought of using sqlcl (see http://www.oracle.com/technetwork/developer-tools/sqlcl/downloads/index.html), because there is no need to “install” something then. All I needed was an installed JRE on the Linux-machine. Fortunately that was available. So I downloaded the newest version of sqlcl and…

 
Read More