Infrastructure at your Service

All posts by Franck Pachot

Franck Pachot
Technology Leader
Principal Consultant

OCM 12cFranck Pachot has 20 years of experience in Oracle databases. Through his expertise as a DBA, Oracle expert, data architect, and performance specialist, he is able to cover all database areas: architecture, data modeling, database design, tuning, operation, and training. Franck knows how to enable an efficient collaboration between the developers and the operational team when it comes to troubleshooting issues or performance tuning.

RSSOracle ACEOracle ACE Franck is Oracle Certified Master (OCM 12c), Oracle ACE Director and proud member of Oraworld-team and Oak Table.

DOAGDB17
Düsseldorf (D), May 31st

From Transportable Tablespaces to Pluggable Databases
ITOUG
Milano (IT), June 8th

Single-Tenant in 12.2: the multitenant features without option
POUG
Cracow (PL), Sept. 1st

12cR2 Statistics Advisor: Do you gather statistics in the way the optimizer expects them?
12cR2MT
12cR2 Multitenant (Oracle Press)

Authors: Anton Els, Vit Spinka, Franck Pachot


Franck Pachot

12cR2 needs to connect with password for Cross-PDB DML

By | Database management | No Comments

In a previous post, I explained that Cross-PDB DML, executing an update/delete/insert with the CONTAINERS() clause, seems to be implemented with implicit database links. Connecting through a database link requires a password and this blog post is about an error you may encounter: ORA-01017: invalid username/password; logon denied This blog post also explains a consequence of this implementation, the big inconsistency of CONTAINERS() function because the implementation is completely different for queries (select) and for…

 
Read More
Franck Pachot

random “ORA-01017: invalid username/password” in 12cR2

By | Database management | 2 Comments

Since 12cR2 is out, we give our 12c new feature workshop with hands-on exercises on 12.1 and 12.2 releases. When I gave it last month, I had a small problem when doing demos: sometimes the connections as sysdba failed with “ORA-01017: invalid username/password”. It was at random, about one every 5 login attempts and I was sure that the password did not change. As I give another of this training next week, I tried to…

 
Read More
Franck Pachot

12cR2 Cross-container DML – insert into container()

By | Database management | No Comments

Multitenant has been introduced in 12.1.0.1 with the goal to share resources but isolate data. However, having all PDBs in the same root may be convenient to manipulate data in multiple PDBs. In the first patchset, 12.1.0.2, a way to query cross-container has been introduced for the CDB administrator to see data in other containers. In the second release, 12.2.0.1, this goes further with the introduction of Application Containers and cross-PDB DML. Currently, not all…

 
Read More
Franck Pachot

What is in a transportable tablespace dumpfile?

By | Database Administration & Monitoring | 2 Comments

On 31st of May in Düsseldorf, at DOAG Datenbank, I’ll talk about transportable tablespaces and pluggable databases. Both methods are transporting data physically, the difference is in the transport of the metadata, which can be more flexible when transported logically, as with TTS, but faster when transported physically with PDB. I have a lot of demos to show transportable tablespaces with RMAN, and the different cloning features available in 12cR2. If I have time I’ll…

 
Read More
Franck Pachot

12c nologging and Data Guard

By | Database management | 3 Comments

The title sounds weird because Data Guard synchronisation is based on the redo stream, so it makes no sense to do nologging operations on the primary. And this is the reason why we set FORCE LOGGING on a Data Guard configuration. However, to lower the downtime of a migration done with Data Pump, you may want to import with minimal logging and then re-synchronize the standby. This post is about the re-synchronisation in 12.1  

 
Read More
Franck Pachot

Listener and Virtual IP

By | Database management | No Comments

When you configure a standby database, you want the application to transparently connect to the primary database, wherever it is. That’s the role of Transparent Application Failover, but this requires configuration on the client side. If you can’t configure TAF, you can use a virtual IP address. But then the question is how to configure the listener.ora to handle connections to this VIP.  

 
Read More
Franck Pachot

12cR2 RMAN> REPAIR

By | Database management | One Comment

Do you know the RMAN Recovery advisor? It detects the problems, and then you: RMAN> list failure; RMAN> advise failure; RMAN> repair failure; You need to have a failure detected. You can run Health Check if it was not detected automatically (see https://blog.dbi-services.com/oracle-12c-rman-list-failure-does-not-show-any-failure-even-if-there-is-one/). In 12.2 you can run the repair directly, by specifying what you want to repair.  

 
Read More