Database Administration & Monitoring

#DOAG2016

By Franck Pachot . That's a very late 'wrap-up' post about the DOAG Conference. Well, not so late because it was last week but time flies and blog posts are already listed.

Can I do it with PostgreSQL? – 3 – Tablespaces

In the last posts of this series we talked about restore points and how you could do things that would require the dual table in Oracle. In this post we'll look at tablespaces. This(…)

Can I do it with PostgreSQL? – 2 – Dual

In the first post of this series we talked about restore points. Another question that pops up from time to time is how you can do things in PostgreSQL that would require the dual(…)

Observing DML restarts caused by invalidations

By Franck Pachot . Usually, cursor invalidations do not interrupt the current execution of the cursor. You can even drop a table while a query on it is running and the query may end successfully. However some invalidations will throw(…)

Can I do it with PostgreSQL? – 1 – Restore points

When discussing with customers about PostgreSQL we often hear that they can do things in one database that they can not do in PostgreSQL. Most of the times this is not true and you actually can do it in PostgreSQL.

MongoDB Installation on Windows

In this blog post, we will show how to install MongoDB on Windows. Download installer First go to the MongoDB download center https://www.mongodb.com/download-center#community. According to your Windows server version, click on the green buton and download the installer (.msi).

12cR2: Upgrade by remote clone with TDE in DBaaS

By Franck Pachot . Upgrading from 12.1 to 12.2 is easy in Oracle Public Cloud DBaaS because you are in multitenant. Here is how to clone a 12.1 PDB to 12.2 service.

12cR2: Upgrade by remote clone – workaround ORA-17630 in DBaaS

By Franck Pachot . Easier than unplug/plug, you can move pluggable databases with remote cloning. It's the same idea but you don't have to manage the files yourself: the are shipped through database link. However, this uses the 'remote file(…)

12cR2: How long to upgrade a PDB?

By Franck Pachot . In the previous post I described how simple it is to unplug a PDB and plug it into a newer version CDB. One goal of dictionary separation in the multitenant architecture is(…)

12cR2: Upgrade by unplug/plug in the Oracle Cloud Service

By Franck Pachot . 12.2 is available in the Oracle Public Cloud DBaaS. If you have a 12.1 DBaaS service, there's no button to upgrade it. I'll describe all the possible upgrade procedures and the first one, and the most(…)