Blog – Keyword: Oracle

  • Can ChatGPT steal our (Oracle DBA) job?

    I would not say it will steal our job, but it can facilitate in some cases to write small pieces of code without having much to think. Well, help first to be lazy, before getting our job. Last example today: The power is amazing. After looking at the result, you think about a small detail, […]

  • Root mailbox huge on Exadata after upgrade to OL7

    Finally I got to work a bit more with an Exadata. And finding its unknown “features”. Our monitoring just detected that “/ diskspace 6% free (1.9/23.5 GB) (DiskWarning)”. Looking for the guilty folder or file, I end up here: The huge file was /var/spool/mail/root – the mailbox of the root user. Trying to open it, […]

  • The OPatch, .patch_storage and its space issues: the solutions!

    I love database patching and apart of the tiring coordination work or the applications that keep to not automatically reconnect to the database, all is usually perfect and issue free. Well, almost. The most common error are space issues. You can try to follow the Oracle guidelines and have a 100 GB partition for the […]

  • Solution for ODA 19.13 list-availablepatches error

    After patching an ODA to 19.13, often we have the error The workaround provided by Oracle on the 19.13 “Known Issues” is incomplete and might not solve the problem in many cases. The complete solution is to change all patchmetadata.xml files where this “targetVersion” is missing. Here is the sed command that creates a backup […]

  • Useful aliases for ODA Patching

    Patching an Oracle Database Appliance can be tiring. The ODA patching commands are quite long and there is always a jobid to check… So I just created a set of alias that make these tasks a bit easier: Maybe you have other suggestions?

  • gDBClone – Good and easy Oracle cloning tool with potential

    Instead of writing and adapting cloning scripts for each client, I was looked today at gDBClone script, provided by Oracle note gDBClone Powerful Database Clone/Snapshot Management Tool (Doc ID 2099214.1). Ruggero Citton did an excellent work and I believe that for most of situations and mainly in a development environment with the need of fast […]