Infrastructure at your Service

 
Marc Wagner

How to migrate High Availability databases on an ODA?

By | Oracle | One Comment

Through this blog, I would like to show, with a real customer case, how I have been migrating databases in High Availability environment on an ODA. High Availability using Data Guard for Oracle Enterprise Edition or dbvisit for Oracle Standard Edition 2. One of the advantage here would be to use the Standby Database as fallback in case there would be some application issue with new database version. Although, I would expect that for any…

Read More
Marc Wagner

How to synchronize the appliance registry metadata on an ODA?

By | Database Administration & Monitoring, Oracle | No Comments

Databases administration on a Bare Metal ODA will be done as root user by running odacli commands : odacli create-database to create a database odacli upgrade-database to upgrade a database between major releases odacli move-database to move databases from one Oracle home to another of the same database version odacli update-dbhome to update a specific RDBMS home to the latest patch bundle version etc… The odacli commands will do the needful and at the end…

Read More
Karsten Lenz

Azure Database for PostgreSQL

By | Database Administration & Monitoring | No Comments

This Blog is about some findings on Microsoft’s Azure service for PostgreSQL which I think needed to be noted. Findings about the infrastructure The Microsoft Azure Service for PostgreSQL is using Windows as OS Infrastructure, there are several points where it is possible to find out the used OS on PostgreSQL Level. select version(); => PostgreSQL 11.6, compiled by Visual C++ build 1800, 64-bi show dynamic_shared_memory_type; => windows show archive_command; => c:\postgres\bin\xlogcopy\xlogcopy.exe archive blob “%f”…

Read More
Clemens Bleile

Oracle DML (DELETE) and the Index Clustering Factor

By | Oracle | No Comments

As a consultant working for customers, I’m often in the situation that I have an answer to a problem, but the recommended solution cannot be implemented due to some restrictions. E.g. the recommendation would be to adjust the code, but that is not feasible. In such cases you are forced to try to help without code changes. Recently I was confronted with the following issue: A process takes too long. Digging deeper I could see…

Read More
Daniel Westermann

PostgreSQL 13: Trusted extensions

By | Database Administration & Monitoring | No Comments

PostgreSQL 13 is just around the corner and one little, but important feature that was added are trusted extensions. When you want to add an extension to a database you need to be superuser for most of the extension or you need to implement something like this (please also note the comment from Hans at the bottom of the blog). This is where this new feature helps: If extensions are marked as “trusted” you do…

Read More
Daniel Westermann

Using PostgreSQL’s adminpack extension to write files

By | Database Administration & Monitoring | No Comments

In PostgreSQL you have several ways of working with files and you can find quite some examples here on our blog, e.g. Modifying pg_hba.conf from inside PostgreSQL, Can I do it with PostgreSQL? – 4 – External tables or Working with files on the filesystem in PostgreSQL. There is also copy which allows you to load or unload tables and there is the adminpack extension which is the topic of this post.

Read More
Nabil Saoual

VirtualBox issue E_FAIL (0x80004005)

By | Database Administration & Monitoring | No Comments

Hi everybody, I get an issue on my VM today , so that I can’t open it anymore. When trying a  system restore I get the same state. I was really embarrassed to fail to restore my VM (as a huge work was done on it) Below we will see how to fix this issue Issue description Investigations I have checked the VM folders , still got the snapshots but can’t even load them :/…

Read More
Franck Pachot

Amazon Aurora Serverless (PostgreSQL compatibility)

By | AWS, Cloud | No Comments

By Franck Pachot . I’ve written a blog post about serverless databases and here is an example of Amazon RDS Aurora PostgreSQL in serverless mode: When I’ve created the instance (15:55 – CloudWatch is GMT+2 but event log is UTC), it started with 0 capacity unit (18:03), which means that it was paused (you pay for storage only). Then I connected and the instance was resumed (18:19) to its maximum capacity unit (4 here). And…

Read More
Franck Pachot

Amazon or AWS services?

By | AWS, Cloud | No Comments

By Franck Pachot . When I’m writing about a product I like to be precise about the name, the upper and lower case, and even more: do you know that was taking special care of writing Oracle 12cR2 before then non-italic came with 18c? And that’s also the reason I’m not writing a lot about VMware as it takes me 5 minutes to put the uppercase right 😀 You may have seen that many Amazon…

Read More
Mouhamadou Diaw

Duplicate Database on ODA X4

By | Database Administration & Monitoring, Database management, Operation systems, Oracle | No Comments

The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After these backups are backep up by Netback on tape. The goal was just to validate that the backups done by Netback can be used to restore if needed. So the backup teams restored the backups…

Read More