Use of Splunk with Oracle listener log files

(Photo by Alfons Morales, on Unsplash) There are several ways to dig for precious information in listener logs, for example this method described by Arup Nanda or this one by Liron Amitzi. I currently work in an environment with 40+ servers and 550+ databases managed by Grid Infrastructure. I recently wanted to help a colleague […]

Read More

Database Service Firewall : Access Control to a PDB in RAC

(Photo by Johannes Plenio, on Unsplash) Conferences are great. Not only for the technical content, also for the people. Recently during DOAG, I had very interesting conversations (yes, several conversations 🙂 ) with Martin Berger about how to control who is connecting to which database in a complex environment. Among other topics, we mentioned that […]

Read More

Create READ ONLY + AWR access on database targets in Oracle Enterprise Manager 12.1.0.5

A critical application is recently having a creepy behaviour in production, so its developers are willing to understand what is going on in the database and troubleshoot in an effective way. Let’s give them access to all the databases related to this application throught Oracle Enterprise Manager 12.1.0.5. The following procedure is mainly relevant with […]

Read More

DMU reports “Need conversion” on table WRI$_SQLSET_DEFINITIONS in Data dictionary

By chance, right after my “ODC Appreciation Day” post, I’ve been asked to convert a database from character set WE8ISO8859P1 to AL32UTF8 with DMU. Apart from a few well-known issues described in MOS note 2018250.1, I got a “Need conversion” row on table WRI$_SQLSET_DEFINITIONS in data dictionary. Section D.11 of MOS note 2018250.1 states that you […]

Read More

ODC Appreciation Day : DMU – Oracle Database Migration Assistant for Unicode

(Picture from Oracle.com) It was very difficult for me to choose a topic for #ThanksODC this year 🙂 I finally decided to talk about something very useful, but maybe not so widespread. For once, I am going to praise a GUI 🙂 : The Oracle Database Migration Assistant for Unicode (DMU). Migrating a database’s character […]

Read More

Problem with datapatch, sqlpatch_bootstrap.sql and obj$

(Picture by Hermes Rivera, via Unsplash) EDIT : This bug has finally been fixed by patch 28809007 and should be included with release 20.1 🙂 ! This blog post describes a very specific problem I encountered while using datapatch. I recently patched 400+ 12.1.0.2 databases on RHEL 7.5 with Database Proactive Bundle Patch + OJVM […]

Read More

Deinstalling previous Grid Infrastructure Home after an upgrade to 18c

(Picture by The Creative Exchange, via Unsplash) Yesterday, I upgraded my lab Grid Infrastructure version 12.1 to version 18c on Oracle Linux Server release 7. Everything went (approximately) OK, but this is not the subject of interest today. Afterwards, I wanted to get rid of the old 12.1 Grid Infrastructure home with the deinstall utility.

Read More

Services are useful, especially for tracing

(Picture by Shane Hauser, via Unsplash) A fellow developer recently asked me if I could help him check if a bug had been fixed in production or not, because he could not trace (pun intented) recent changes. The problem consisted in 2 specific queries launched a gazillion times on an Oracle 12.1 database. Among other […]

Read More