Upgrading Oracle database 12.2 to 19.10 came with some surprises, and one of them was the invalid status of the index WRH$_SYSMETRIC_HISTORY_INDEX owned by the user SYS. Rebuilding the index helped only temporarily, so I decided to recreate the index by following the procedure below: — Confirmation of the invalid index: — Action plan: For more information, please check the following MOS notes below: Index WRH$_SYSMETRIC_HISTORY_INDEX Status Unusable (Doc ID 2426391.1)WRH$_SYSMETRIC_HISTORY_INDEX Index Does Not Get Partitioned After Database Upgrade From 12c To 19c (Doc ID 2777641.1)Index WRH$_SYSMETRIC_HISTORY_INDEX Status Unusable (Doc…
Author: brunors
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)
Enabling SPOOL output using RMAN
I had a performance problem in one of the routine backups, so I opened a Service Request (SR) at MOS (My Oracle Support). After a few hours from the moment I opened the SR, I got a request to upload the output of a few commands. Therefore, I used a SPOOL output to create it. For those unfamiliar with how to create a SPOOL output in the RMAN utility, follow below how you can accomplish this task: brunorsHi! I am Bruno, a Brazilian born and bred, and I am also…
Bug ORA-38881 during “drop tablespace” even though there is NO Guaranteed Restore Point (GRP) – Fixed in version 19.17
I just upgraded one Oracle Database system from 12.2 to 19.10. I was happy with the result until one database procedure started to fail with the message “ORA-38881: Kan inte radera tabellutrymmet TECH_29102_9292 i den primära databasen pga. garanterade återställningspunkter.” . For those unfamiliar with the Swedish language, this is the same error message as “Oracle Error ORA-38881: Cannot drop tablespace string on primary database due to guaranteed restore points.”. I started doing some investigation until I found that there is a BUG:14163359 fixed on version 19.17 of the Oracle databases. And…
Rebuilding Oracle Partitioned Index- Solving “ORA-14086: a partitioned index may not be rebuilt as a whole”
It is known that Oracle has two types of partitioned Indexes: Local and Global Partitioned Index. I will only cover some of the specifications that explain their differences. However, according to the VLDB and Partitioning Guide release 21c, “Partitioning is possible on both regular (heap organized) tables and index-organized tables, except for those containing LONG or LONG RAW columns. You can create nonpartitioned global indexes, range or hash partitioned global indexes, and local indexes on partitioned tables.”. Furthermore, while creating a local index, the database constructs the index, which is…
Oracle Certified Master Exam Updates – March 2023
It has been a while since I aimed to be an Oracle Certified Master (OCM). For those unfamiliar with this exam, it is (or was) an Oracle practical exam that consisted of two days somewhere in the world. It would test your Oracle skills to achieve the master’s and top certification from Oracle. It is a certification that gives prestige and recognization because a minority number of database administrators have this credential, and all because of all the value invested in the courses as prerequisites and other expenses. From the…
Exam preparation – Exam AZ-305: Designing Microsoft Azure Infrastructure Solutions
It has been a while since I got nervous about taking a certification exam, and this was the big surprise about the “Exam AZ-305: Designing Microsoft Azure Infrastructure Solutions” for me. This year is all about Infrastructure and cloud, and for those who read something on my blog is a new approach after nearly a decade of writing mainly about databases, especially my favorite RDBMS, Oracle. I wish I had much to say about this exam. Still, everything about my preparation was everything that I covered in the book “Book…
Book Review: Exam Ref AZ-305 Designing Microsoft Azure Infrastructure Solutions
This post is about my thoughts about the book “Exam Ref AZ-305 Designing Microsoft Azure Infrastructure Solutions” written by Ashish Agrawal, Gurvinder Singh, Mohammad Sabir Sopariwala, and Avinash Bhavsar. Some specifications of this book are below: Language English Publisher Pearson Education Author Ashish Agrawal, Gurvinder Singh, Mohammad Sabir Sopariwala, Avinash Bhavsar Title Exam Ref Az-305 Designing Microsoft Azure Infrastructure Solutions ISBN-13 9780137878789 Publication Date November 2022 ISBN-10 0137878788 I decided to read this book to increase my skills in designing…
If you ever need clarification about the functionality of the content delivery network (CDN) service Amazon CloudFront …
It has been some years since I graduated in Computer Science. Then, out of curiosity, I checked the college website to see the new courses and everything else that was new. However, after many attempts, I could still be blocked by the configuration in the Amazon CloudFront established as below: I understand that Amazon Cloud Front has many advantages, such as communication encryption while handling certificates and default protection against DDoS attacks by covering the majority of attacks on the 3 and 4 layers of the OSI model provided by…
Exam Preparation – Google Cloud Certified – Associate Cloud Engineer
First of all, check out my GitHub to keep up-to-date about my programming https://github.com/brunorsreis and find some projects, scripts, or use cases about my studies. This exam is one of those that I most enjoy taking. The approach here was setting up some weeks with my twin brother where we were located on two different continents, making it work to have a meeting and study together with each other, real teamwork. I am grateful to have a brother like my twin. On top of that, I have been working on…
Exam Preparation – Google Cloud Certified – Professional Data Engineer
Google Professional Data Engineer is one of the most exciting and interesting exams I was aiming to pass. Over my career, I have worked mainly with database management until I realized something had happened – The RDBMS databases were no longer the inevitable choice for data management. As a Data Engineer, one is expected to work still with databases and streaming technologies, microservices, third-party APIs, data pipelines, big data technologies, etc. And back then, I had no idea what was happening. Therefore, what does one do when do not know…