How to run Datapump from a PDB as SYS when ORACLE_PDB_SID canโ€™t work

by CloudDudeUncategorizedPosted on Comments are Disabled

Intro In Oracle multitenant architecture, default database container upon connection is CDB$ROOT. But as of 18c, a new environment variable appeared to ease the direct access to a specific PDB (given a defined ORACLE_SID). The variable in question is ORACLE_PDB_SID.  As explained in Mike Dietrichโ€™s Blog, this variable is checked by a small AFTER EVENT …

Read more “How to run Datapump from a PDB as SYS when ORACLE_PDB_SID canโ€™t work”

Interview With Oracle FPP head Ludovico Caldara

by CloudDudeUncategorizedPosted on Comments are Disabled

I want to thank Ludovico Caldara [FPP & Cloud MAA Product Manager @Oracle] for accepting the publication of this interview which is based on a conversation we had some time ago. It is mainly focused on the Oracle Fleet Patching and Provisioning (FPP) โ€œFUNDAMENTALSโ€, but I hope this could help the community to glean a …

Read more “Interview With Oracle FPP head Ludovico Caldara”

My Vagrant fork of Oracle Fleet Patching and provisioning (FPP)

by CloudDudeUncategorizedPosted on Comments are Disabled

Intro I have been asked to read about Oracle database fleet management at work but the turnoff was that it relied entirely on OEM. Aggregating both functionalities makes provisioning, in my opinion, cumbersome and unattractive for shops that only want to manage the fleet. Luckily for me, I got acquainted with an even better framework …

Read more “My Vagrant fork of Oracle Fleet Patching and provisioning (FPP)”

The not so AUTO …UPGRADE ! (ORACLE Autoupgrade in Windows )

by CloudDudeUncategorizedPosted on Comments are Disabled

Intro First, before anyone starts sending me print screens about their successful Autoupgrade, or flexing about how their 100+ databases were smoothly migrated to PDBs over the weekend, I am stopping you right there. This is my honest feedback on the experience I had when trying the tool on a windows environment. It is obviously …

Read more “The not so AUTO …UPGRADE ! (ORACLE Autoupgrade in Windows )”

Convert local listeners to Oracle Grid managed listeners

by CloudDudeUncategorizedPosted on Comments are Disabled

Intro One of the advantages of Oracle grid Infrastructure is to restart all managed resources (databases, asm, listeners,โ€ฆetc)  automatically whenever you (re)start the cluster service (crs) or reboot the whole server. I recently had to patch an oda where the client still had few listeners (with non default ports) managed locally and not through grid. …

Read more “Convert local listeners to Oracle Grid managed listeners”