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…
Learn and certify for free: Oracle Cloud Infrastructure and Oracle Autonomous Database
If you ever hesitated to jump into learning about Oracle Cloud Infrastructure or Oracle Autonomous Database the time is now! Oracle Cloud Free Tier together with Always Free Services is already available since last year. This is very useful, as it allows to familiarize with…
Useful Oracle tools – purgeLogs
Recently I’ve came across a nice tool provided by Oracle named purgeLogs, so I would like to shortly blog about it for reference (also for me). As the name suggests it is meant to be used for cleaning up log and trace files. Unfortunately, it…
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…
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! Advertisements
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…
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…
Social Media @trivadis