Database Administration & Monitoring How to read XML database alert log? 04.12.2015 by Nicolas Jardot 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(…)
Database Administration & Monitoring Upgrading PostgreSQL to a new major release 02.12.2015 by Daniel Westermann 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(…)
Database Administration & Monitoring Patching PostgreSQL to a new minor release 01.12.2015 by Daniel Westermann 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.
Database Administration & Monitoring, Oracle OCM 12c preparation: Manage PDB 30.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring, Oracle OCM 12c preparation: Create CDB in command line 30.11.2015 by Oracle Team 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.
Database Administration & Monitoring Migrating the Oracle 12cR1 sample schemas to PostgreSQL Plus Advanced Server 9.4 29.11.2015 by Daniel Westermann 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(…)
Database Administration & Monitoring With Oracle Goldengate take care of additional column creation on the replicated database 27.11.2015 by Hervé Schweitzer 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(…)
Database Administration & Monitoring How to rename listener target in EM Cloud 12c ? 27.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring Upgrading the Grid Infrastructure from 12.1.0.1 to 12.1.0.2 on the command line 25.11.2015 by Daniel Westermann 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(…)
Database Administration & Monitoring Oracle Compliance Standard 23.11.2015 by Oracle Team In Enterprise Manager 12c, using the compliance standard results might be a good solution for DBA’s to detect security incoherences (for example a lambda user who has the sysdba role …) for their various targets. From the 12.1.0.3 version, a(…)