Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Daniel Westermann

The size of Oracle Home: from 9GB to 600MB – What about PostgreSQL?

By | Database Administration & Monitoring | No Comments

A recent blog post from Franck and a tweet around that topic is the inspiration for this blog post, thanks Jan for requesting :). In short it is about how small you can get the binaries. Is that important? At least when it comes to Docker images it might get important as you usually try make the image as small as possible. Well, comparing PostgreSQL and Oracle in that field is unfair as Oracle comes…

 
Read More
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
Mouhamadou Diaw

Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE

By | Database Administration & Monitoring | 2 Comments

With Oracle Database 18c, we can now refresh a standby database over the network using one RMAN command, RECOVER STANDBY DATABASE. The RECOVER STANDBY DATABASE command restarts the standby instance, refreshes the control file from the primary database, and automatically renames data files, temp files, and online logs. It restores new data files that were added to the primary database and recovers the standby database up to the current time. When you use the RECOVER…

 
Read More
Marc Wagner

ODA database been stuck in deleting status

By | Database Administration & Monitoring | No Comments

Facing an internal inconsistency in the ODA derby database is very painful (see https://blog.dbi-services.com/oda-lite-what-is-this-odacli-repository/ for more info about the derby database). I have recently faced a case where the database deletion was failing and the database remained then in “Deleting” status.  Connecting directly to the internal derby database and doing some self cleaning is very risky and should be performed at your own and known risk. So, in most of the case, a database inconsistency issue…

 
Read More
Pierre Sicot

Upgrade EM 13.2 to EM 13.3

By | Database Administration & Monitoring | 2 Comments

As the last Enterprise Manager Cloud Control 13.3 is out since a few days, I decided to test the upgrade procedure from the Enterprise Manager Cloud Control 13.2 You have to follow some pre-requisites: First you copy the emkey : oracle@localhost:/home/oracle/ [oms13c] emctl config emkey -copy_to_repos_from_file -repos_conndesc ‘”(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=em13c)(PORT=1521)))(CONNECT_DATA= (SERVICE_NAME=EMREP13C)))”‘ -repos_user sysman -repos_pwd manager1 -emkey_file /home/oracle/oms13c/sysman/config/emkey.ora Oracle Enterprise Manager Cloud Control 13c Release 2 Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved. Enter Admin…

 
Read More
Pierre Sicot

Licensable targets and Management Packs with EM13c

By | Database Administration & Monitoring | No Comments

When you add a new target in Enterprise Manager 13c , the management packs are enabled by default. This could be a problem in case of a LMS control, and to avoid any problem, you have to  manually disable those management packs. If like me you recently have moved your database infrastructure to a new one and have to add one hundred targets, you will have to click some hundredth of times on the management…

 
Read More
Franck Pachot

ORACLE_HOME with symbolic link and postupgrade_fixups

By | Database Administration & Monitoring | No Comments

By Franck Pachot . Here is a quick post you may google into if you got the following error when running postupgrade_fixups.sql after an upgrade: ERROR – Cannot open the preupgrade_messages.properties file from the directory object preupgrade_dir DECLARE * ERROR at line 1: ORA-29283: invalid file operation ORA-06512: at “SYS.DBMS_PREUP”, line 3300 ORA-06512: at “SYS.UTL_FILE”, line 536 ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, line 41 ORA-06512: at “SYS.UTL_FILE”, line 478 ORA-06512: at “SYS.DBMS_PREUP”, line…

 
Read More
Daniel Westermann

Bringing up your customized PostgreSQL instance on Azure

By | Database Administration & Monitoring | No Comments

The Azure cloud becomes more and more popular so I gave it try and started simple. The goal was to provision a VM, compiling and installing PostgreSQL and then connecting to the instance. There is also a fully managed PostgreSQL service but I wanted to do it on my own just to get a feeling about the command line tools. Here is how I’ve done it.  

 
Read More