Database Administration & Monitoring Upgrade to Enterprise Manager 13.2 13.12.2016 by Oracle Team I will describe how to upgrade Enterprise Manager 13.1.0.0 to the new 13.2.0.0 version. At the beginning we have to ensure that we applied the latest PSU on the repository database. It is mandatory to apply the following patch before(…)
Database Administration & Monitoring Getting started with Docker – 2 – building your own base image 12.12.2016 by Daniel Westermann In the last post we quickly looked at how you can install everything you need to run docker containers on a CentOS 7 host and did bring up the official PostgreSQL image. However there are good reasons(…)
Database Administration & Monitoring Getting started with Docker – 1 – overview and installation 11.12.2016 by Daniel Westermann Everybody is talking about Docker nowadays. What it is about? Do you remember Solaris Zones or Containers? It is more or less the same although development of Docker during the last years made Linux(…)
Database Administration & Monitoring Oracle 12c – RMAN and Unified Auditing – Does it really work? 09.12.2016 by Oracle Team By William Sescu The new Oracle Unified Auditing feature, audits RMAN operation per default as soon as you relink your Oracle binary and start your instance. A quite cool new feature, because it allows me to audit RMAN(…)
Database Administration & Monitoring EnterpriseDB Backup and Recovery Tool (BART) 08.12.2016 by Oracle Team By Mouhamadou Diaw Many tools are proposed for backup and recovery operation of a PostgreSQL database. EnterpriseDB has developed a product named BART (Backup and Recovery Tool). Use of this product needs a subscription but you can download a trial(…)
Database Administration & Monitoring Installing PostgreSQL 9.6.1 with EnterpriseDB Installer 08.12.2016 by Oracle Team By Mouhamadou Diaw As you may know PostgreSQL 9.6 was released a few months ago. And EnterpriseDB (EDB) offers a package installer for installing the community version. This EDB package can be downloaded here. In this(…)
Database Administration & Monitoring Can I do it with PostgreSQL? – 7 – Partitioning 08.12.2016 by Daniel Westermann PostgreSQL supports tables up to 32TB. Do you want to be the one responsible for managing such a table? I guess not. Usually you start to partition your tables when they grow very fast and consume more(…)
Operating systems OEL 7 – Project Quotas on Oracle Homes with XFS on Oracle Linux 7 08.12.2016 by Oracle Team By William Sescu User and group quotas do exist for quite a while for all kind of file systems, like ext4 or vxfs and maybe many others. However, for my use case, I do need quotas for different directories on(…)
Database Administration & Monitoring Oracle 12cR2: Statistics Advisor 07.12.2016 by Oracle Team By Franck Pachot . Today at #ukoug_tech16 12:30 in hall 11A I'll talk about Statistics Gathering Best Practice & 12cR2 Statistics Advisor Rather than taking the Optimizer Statistics Advisor rules one by one I'll show the(…)
Operating systems OEL 7 – How to disable IPv6 on Oracle Linux 7 07.12.2016 by Oracle Team By William Sescu In case you are not interested in IPv6, you can use the following HowTo to disable it on Oracle Linux 7. Unless you have something very very special on your System, these 10 Steps should do it.