Today again very short post, just pointing to my recent article inside new issue of UKOUG magazine called #PTK (former Oracle Scene): Exadata Cloud at Customer: Real-life experiences. Enjoy!
Today short post, just to announce that I became Oracle ACE Associate! I’m happy to be recognised by the Community and would like to thank all the people I’ve met during my career, who positively influenced me (not only with technical and Oracle knowledge!) and guided me to the point where I am now.
When you open Service Request related to problems on your Exadata Cloud at Customer (or other Oracle Cloud environments), very often you’ll be asked to upload diagnostic data, which can be easily gathered by running
/var/opt/oracle/misc/dbaas_diag_tool.pl. If it works…
As Oracle has quite recently announced that Privilege Analysis is now included with the Oracle Database Enterprise Edition licence, I played a little bit with this cool feature to solve infamous
ORA-01031: Insufficient privileges error. You can read results of my investigation in the article inside new issue of UKOUG magazine called #PTK (former Oracle Scene): ORA-01031: Insufficient privileges. Enjoy!
In my previous post I shared some findings on migrating user and application data between platforms with different endianness, focusing on problems with reducing downtime.
Today I’ll talk more about the complexity of chosen method. It’s not only about complexity per se, it’s rather about the possibility to automate as much as possible in order to allow efficient migration of a big number of databases.
One can find a lot of sources and materials regarding migrating Oracle databases between platforms having different endianness, even though the choice of possible methods is limited in this case. On paper (slides?) everything looks fine, but then you hit bugs or environment-specific problems. Moreover, in real life the situation is always more complex than moving just one tablespace with just one datafile as shown in many places as an example. Today I would like to add my 2 cents into this topic, focusing on moving user and application data.
I have been recently asked to investigate very interesting issue. In short: