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. Former Oracle ACE, Computer…
Category: Oracle Database General
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…
I am now an Oracle ACE Alum
On October 2017, I received an e-mail from the Oracle Corporation with the approval of my application to become an Oracle ACE Associate, being then the first member of the Oracle ACE program in Hungary. The years passed, and I moved from Hungary to Sweden. Thus, on Jun 16, 2020, Oracle corporation upgraded my level from Oracle ACE Associate to Oracle ACE, the 2nd Oracle ACE in Sweden at that moment. For more information about it check it out: https://www.techdatabasket.com/2020/06/17/finally-an-oracle-ace/ The Oracle ACE Program, managed by Jennifer Nicholson and her…
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied when Primary and Standby have the same password for the password file
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” I was creating a standby database and had the intention of using an active duplicate to copy the data from the primary database to the standby when I had the following error: I did all the ordinary checklist by checking if the password file on the standby file had the same password as the primary database and also by checking if the “Password file:” option configured on the srvctl “srvctl config database -d…
19c datapatch hangs on “Installing patches…”
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” I upgraded a database from 12.1 to 12.2, from 12.2 to 19.3, and then from 19.3 to 19.15 on an environment with Oracle Restart (HAS). However, after successfully applying the patch and the environment running 19.15, the datapath hanged on the “Installing patches…” part of the script followed by the error ” Died at $ORACLE_HOME/rdbms/admin/catcon.pm line 18217″ after a while. Follow below an example of the description above: The solution to it was…
ORA-15031: disk specification ‘XXXX:XXX40’ matches no disks while starting Oracle Clusterware
I was working in an environment after a reboot of the server that when I tried to startup the Oracle Clusterware on all belonged nodes, I received the following error: After some investigation of the logs, I checked the support package ASMLib to verify the status of the disks as below: Then I confirmed that it has not been possible to gather the status of one of the disks. Therefore, I continue to get more additional information to solve the issue as the current ASMlib is installed, and its logs…
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x2425E8B, qkaProjRwo()+139] [flags: 0x0, count: 1]
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” After applying the rollback from the Critical Patch Updates PATCH 33583921 – GI Jan 2022 Release Update 12.2.0.1.220118 at both Oracle RAC Databases 12.2.0.1 and GRID 12.2.0.1, I found the following messages on the alert log of the database: After some investigation, I found that the error “ORA-7445 [kcbm_sim_one()+1288] [SIGSEGV]” is very generic and often the argument [kcbm_sim_one()] is related to many known bugs on the Oracle database from versions 10.1 to 10.4.…
ORA-00609: could not attach to incoming connection ORA-12637: Packet receive failed
I upgraded an Oracle RAC database from 12c to 19c. After a while, I identified that some jobs were having problems running. Therefore, I investigated and found out about the new default feature on the 19c client database that requires tests if Out of Bound breaks are allowed. Thus. Follow below the steps to handle this: The first step was to check the alert.log, and the errors messages were as below: I have also checked traces to understand more about the error, and this is what looked like: From now,…