Mufalani – DBA (OCM) – Tips and tricks from a real life DBA

ORA-01466: unable to read data – table definition has changed

During some tests that I was executing, I was often facing this issue, ORA-01466: unable to read data – table definition has changed, on data export with… Read more “ORA-01466: unable to read data – table definition has changed”

A couple of days ago, I was playing a bit with encryption and I got a weird message when I was trying to encrypt a tablespace a… Read more “ORA-28340: A different encryption algorithm has been chosen for the table or tablespace”

Some weeks ago, I was trying to upgrade a database from 12.2 to 19.16 with the AutoUpgrade tool, and I got an annoying error at the end… Read more “Stop blaming the software… Sometimes it’s You!!!”

One of the things you need to care about is the TZ to be chosen while you are deploying an Oracle DB System, otherwise, you gonna suffer… Read more “Choose your TZ while creating a DBS on OCI”

Last week, I was scripting something and I would like to replace an entire line on a init file, using sed, which I use a lot, but… Read more “Changing an entire line with sed”

When we launch a new instance on OCI, the time zone is defined by default as GMT and you have no options to change it via cloud… Read more “Changing TZ of a instance (OCI)”

This week I was involved in an automation project that required a database to be named after a flash copy (storage level snapshot). So I need to… Read more “How to automate NID (renaming a DB)”

It is not uncommon to create new services on the database, in fact, it is a best practice for the level of HA of your application, for… Read more “How to delete a SERVICE created with a typo”

One of the main advantages of the Cloud Computing, is the ability to scale up and down some resources of your running environment without the long process… Read more “OCI – Resize a boot volume on Ubuntu – Workaround”

This error happens when your sysadmin makes the LUN on the OS side larger than 2TB, by increasing it, and then you need to “resync” to be… Read more “ORA-15099: disk ‘/dev/oracleasm/disks/ASM1’ is larger than maximum size of 2097152 MBs”