Small fix for SQLcl Java problem with Oracle 12.1

Let’s say you want to quickly use some cool features of SQLcl inside the script running on the database server, but only Oracle below version 12.2 is available there (which is the first one being shipped with SQLcl). This means that you have to download it manually – not a big deal. Now, assume that you really need to connect AS SYSDBA without a password, so using OS authentication. Should not be a problem neither – you just set ORACLE_SID and ORACLE_HOME properly and you are good to go – unless you hit some Java errors…

Continue reading “Small fix for SQLcl Java problem with Oracle 12.1”

Exadata Cloud at Customer: Real-life experiences

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!

Oracle ACE Associate

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.


Continue reading “Oracle ACE Associate”

ExaCC: what to do if fails

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/ If it works…

Continue reading “ExaCC: what to do if fails”

Oracle Privilege Analysis in action

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!

Cross-endian Oracle migration – moving user data – part II

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.

Continue reading “Cross-endian Oracle migration – moving user data – part II”

Cross-endian Oracle migration – moving user data – part I

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.

Continue reading “Cross-endian Oracle migration – moving user data – part I”