OGB Appreciation Day : SQLcl

I am really glad to participate in #ThanksOGB this year. The 2017 edition (called #ThanksODC at that time) was actually the starting point of my blogging journey. This year, I will not surprisingly talk about a Command Line Interface again : Oracle SQL Developer Command Line, as known as SQLcl. What is it ? Simply […]

Read More

Exadata Cloud at Customer : Drill down into Cloud Tooling RPM content

On one of my Exadata Cloud at Customer system, I recently had an issue which required to check exactly which files were updated when upgrading the cloud-specific tooling included on Exadata Cloud at Customer, also know as dbaastools_exa. I needed to know if a configuration file had been overwritten or not, when upgrading dbaastools_exa. My […]

Read More

Oracle Data Guard Broker 18 : new VALIDATE NETWORK CONFIGURATION command

There is a very handy new command available in Oracle Data Guard Broker 18c. Too bad I discovered it AFTER I solved my problem 😉This quick blog post demonstrates what can be easily spotted with this new VALIDATE NETWORK CONFIGURATION command. In this example, I have 2 sites, each with a 2-node Oracle 18.6 Grid […]

Read More

Exadata Cloud at Customer : Reinstall Cloud Tooling

(Photo by Joël Assuied, on Unsplash) I just started working on Exadata Cloud at Customer. And with this, come my first mistakes 😉 One of my compute node had all cloud tooling scripts located in the adequate directories : # ls -l /var/opt/oracle/exapatch/ […] -r-xr-xr-x 1 oracle oinstall 0 Feb 4 21:23 exadbcpatchsm -r-xr-xr-x 1 […]

Read More

Fun with attribute STOP_TIMEOUT for a custom clusterware resource

(Photo by Alex Guillaume, on Unsplash) I recently encountered a problem, for which I do not have any clue yet. But at least, I have a workaround. The goal of this blog post is to remember the exploration towards this workaround. And then to switch back to a normal sitution when possible. For some reason, […]

Read More

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