BE SHARING

19c

Easy PDB migration with ODA and DB Systems

21.11.2023 by Jérôme Dubar

Introduction Oracle 23c is not yet available on Oracle Database Appliance (ODA), but it should be ready in 2024. As 23c is the next Long Term release, 19c databases will probably migrate to 23c in the coming years. If you(…)

Database Administration & Monitoring

Statspack with Oracle Database 19c and Multitenant

17.01.2022 by Jérôme Dubar

Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this(…)

Database Administration & Monitoring

Move a PDB from a server to another one using NFS

03.12.2021 by Jérôme Dubar

Introduction Multitenant brings new possibilities regarding Oracle databases, and one of them is to move a database from a container to another quite easily. When containers are on the same server, it’s very easy, but when the containers are on(…)

Database management

5 things that aren’t true about RMAN

22.11.2021 by Jérôme Dubar

Introduction RMAN backups are not a hot topic today. This is because it didn’t evolve that much in 12c/18c/19c, and most of the databases are now protected by a good backup strategy since years, and no changes are needed. Furthermore,(…)

Cloud

Get prepared to move your Oracle databases to OCI

14.11.2021 by Jérôme Dubar

Introduction Cloud often raises in the top 3 solutions when thinking about Oracle infrastructure renewal. For obvious reasons: you do not need to buy any server, platform is already available, you pay as a subscription, you drastically reduce time to(…)

Cloud

First contact with OCI’s Autonomous Database

15.10.2021 by Jérôme Dubar

Introduction Benefits of going into the Oracle Cloud (OCI) are clear for most of us: no more datacenter and hardware to manage. But what else? On OCI, you can also decide to get rid of part of the DBA tasks(…)

Database Administration & Monitoring

Is it possible to switch a service between 2 pluggable databases?

02.05.2021 by Jérôme Dubar

Introduction In an Oracle database, services have multiple purposes: identifying group of users prior authenticating them enabling/disabling access to a database for particular groups managing preferred nodes on a RAC configuration redirecting users to the primary after a switchover/failover when(…)

Database Administration & Monitoring

A typical ODA project (and why I love Oracle Database Appliance)

08.12.2020 by Jérôme Dubar

Introduction You can say everything about Oracle infrastructure possibilities but nothing compares to experience based on the realization of real projects. I did quite a lot of ODA projects during the past years (on other platforms too), and I would(…)

Oracle

Troubleshooting performance on Autonomous Database

29.08.2020 by Oracle Team

By Franck Pachot . On my Oracle Cloud Free Tier Autonomous Transaction Processing service, a database that can be used for free with no time limit, I have seen this strange activity. As I’m running nothing(…)

Cloud

Oracle 18c – select from a flat file

04.06.2020 by Oracle Team

By Franck Pachot . This post is the first one from a series of small examples on recent Oracle features. My goal is to present them to people outside of Oracle and relational databases usage, maybe some NoSQL players.