I was managing an ORACLE RAC database configured with Oracle Data Guard when I discovered the archive log was not being deleted after the retention policy of 2 days in our backup configuration. Therefore, I started the investigation by collecting some information from the alert log. And the first initiative I took was to verify if the database had been deleting old archives when there was a space pressure in the recovery area as below: It is a cheerful and ordinary Oracle database approach to automatically deleting unneeded files. The…
Category: Oracle RAC, +ASM and Clusterware
Managing the availability of a portable collection of schemas, schema objects, and non-schema objects in an Oracle multitenant database
This post serves as a reference to close and open PDB databases. I have been mentoring some colleagues on the way to a data and database management career. As we have been managing Oracle multitenant environments quite often, I decided to create an example where they can easily visualize and have a reference on it. I made another blog post where one can imagine the existence of PDBs (https://www.techdatabasket.com/2018/11/08/how-to-check-if-my-database-is-a-cdb-database-or-not/). Thus, follow below is the representation of the closing and opening of a database instance named TECHDB in an Oracle RAC…
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,…
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translate
I was configuring an Oracle Data Guard 19c database, and when I tried to start the database, I received the following error: After some analysis, I concluded that the error was the “*.db_recovery_file_dest” parameter configured in the database. When you use a location on ASM, it is only necessary to specify the name of the disk group and not the directories inside the disk group. Knowing that I configured the parameter from : To: After the modification the pfile had the output below: Consequently, the startup worked after that: brunorsHi!…
DB_UNKNOWN directory created after an attempt of copying a pwfile to ASM
I was trying to copy a password file from a file system to the ASM. Every time I tried to copy this file, I noticed that the directory named “DB_UNKNOWN” was created. This error usually happens when the database unique_name (resource) is not configured into the CRS and the output can be seen as below: To fix this issue, you must use the “–dbuniquename” clause while copying a file from disk to the ASM: I hope that this post helps you! brunorsHi! I am Bruno, a Brazilian born and bred.…
1Z0-432: Oracle Real Application Clusters 12c Essentials: Tips
I have taken exam 1Z0-432: Oracle Real Application Clusters 12c Essentials on Thursday, June 24, 2021. This exam has the following format: Format: Multiple Choice Duration: 120 minutes Exam Price: kr 2.108 (Price in Swedish kronor) Number of Questions: 85 Passing Score: 74% Validation: This exam is validated against 12c. To do this certification, Oracle Corporation recommends taking official training before the exam. I did not take training specific to Oracle RAC. Instead, I took the Oracle official exam to the Oracle Certified Master exam in June 2019. That means that I have been studying this…
[Oracle 12c]How to remove and add databases from Oracle cluster
Owner:oracle (Oracle software owner) Database: techdb Instances: techdb1, techdb2 Servers/Node: basket-techdb01, basket-techdb02 To remove and later add the cluster Oracle database, follow these steps: It is important to know the previous configuration for a possible backup: Stop the database: Remove the database from cluster configuration: Add the database in the cluster configuration: (For all nodes) Start the database: Check the configuration again : Check the status of the database : brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten…