PDB_OS_CREDENTIAL and external jobs
After introduction of Multitenant option, Oracle provided additional ways to ensure proper isolation between pluggable databases. PDB_OS_CREDENTIAL initialization parameter is part of them. It allows to use specified operating system user while interacting with operating system from a PDB. According to documentation, it is taken…
Kerberos Troubleshooting – A few approaches
It is way too long ago since my last blog post. These were or are busy weeks for me. Any way, I finally found some time to start writing a blog post about a special setup for kerberos authentication of Oracle databases. It is about…
Useful Oracle tools – DBCOMP
Getting lost writes (e.g. ORA-00752: recovery detected a lost write of a data block) is one of the worst DBA’s nightmares. There are a lot of very important questions popping up. Apart from the obvious ones on how to solve the problems reported (hopefully without…
Be careful with ‘save state’ in Data Guard configuration
Users are complaining that from time to time they are connecting to standby database which is opened read-only, instead to primary opened also for writing. What can be the root cause? Previous usage of below command: It keeps not only information about the state of…
Side effect of ExaWatcher workaround for LSOF check
While analysing the problem with ExaWatcher not being able to start, I found quite nasty side effect of a workaround implemented in recent versions of this useful tool. In fact, you will hit it only on Exadata X7 where you had previously implemented another workaround…
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…
ExaCC: what to do if dbaas_diag_tool.pl 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/dbaas_diag_tool.pl. If it works… In my case it failed, with…
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…
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…
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,…
Social Media @trivadis