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: brunors*The…
Author: brunors
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.
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! brunors*The views expressed here are my own and do…
Oracle Data Guard 19c: Fetch Archive Log FAL: Error 12154 connecting to DB_TECH1,DB_TECH2 for fetching gap sequence
I was managing and configuration an Active-Standby database running in an Oracle RAC that has two nodes when I found the following output from the alert.log: After some research, I found that the parameter FAL_SERVER was not configured right in both Primary and Standby databases. The parameter was fixed on both sides. The main issue to cause this to happen is because the multiple service names in the FAL_SERVER parameter on the Standby database were not configured correctly. The issue was that the parameter was configured as below: Instead of…
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…
AWR Snapshot listing empty results Oracle Database 12c Release 2 (12.2.0.1)
I was checking some performance issues in some databases and one of the issues I found was that I couldn’t get the snapshot IDs to choose the interval between “Begin” and “End” snapshot to create my report. I started to find the reason for not showing the expected output as I can list as below: Check tablespace SYSAUX usage: I had 25GB free of 75GB; So, OK. Parameter “statistics_level” was configured to TYPICAL; Thus, OK. Parameter “control_management_pack_access” was configured to “DIAGNOSTIC+TUNING”. So, OK. I checked MOS and started to do…
Services Summary…Service “86b637b62fdf7a65e053f706e80a27ca” has 1 instance(s). Don’t freak out!
Those who install and create a database running in the Oracle release 12.2.0.3 launched by Oracle Corporation in February 2019 might get surprised about the unknown hash services shown in the listener due to the PDB databases. I must say that my first thought was, “What?????”. Write in the comments how was yours. My first information is: don’t freak out! This service was introduced by the Oracle Database release 12cR2 due to the possibility of creating a PDB as a Proxy PDB. Thus, what you can see of new in…
Unexpected ‘supportedOSCheck’ while installing Oracle database 19c in silent mode on Oracle Linux 8.2 64-bit (x86-64)
As usual, I checked all the pre-requisites for the installation of Oracle Database 19c on Oracle Linux 8.2. However, I didn’t expect to be surprised with the below error at the very beginning: I thought:” Did I miss Oracle Linux 8 isn’t supported with Oracle 19c?”. I was sure that I checked this before so I started googling around again and then I found that this error has happened in previous releases as 12.1 due to the fact that it does not contain Pre-req checks specific to OL /RHEL 8…
Oracle Cloud: Sign up failed “Error processing transaction”
I have already configured many accounts to use Oracle Cloud. Especially, since December 2020 I started to face some problems on the step where you must provide a credit card to simulate a payment but in fact, it works like a personal identification. So I have used the same card that I used previously in some setups, two other new cards and even asked some friends in different countries using their own cards and some of them have experienced the same erros while others could create their account successfully. Follow…
My participation at GoldenTalks “#45- Bruno Reis”- Get know my path from Brazil until the Oracle Ace Associate in Hungary and Ace in Sweden
Last Thursday 03, December 2020, I was invited to join and share my personal history at the Youtube channel GoldengateBR (If you don’t know anything about it check it out here : https://www.youtube.com/channel/UCJmOZ4iNh4mE9gMsNq9Oz8g where you can find the presentation in Portuguese about this channel). However, even though that the majority of the interviews in this channel is made in Portuguese where Gilson (the owner and the creator of the OraSIM tool) has been interviewing many people, you can find several other interviews in English with many Oracle Product managers and…
Example of how to use Oracle Cloud Infrastructure (OCI) Gen 2 with Terraform – Macbook Pro OS – part 2
This is the second article of these series where I will be covering the use of Terraform with Oracle Cloud Infrastructure from scratch. If you haven’t seen the first article I do recommend you check it out here https://www.techdatabasket.com/2020/10/21/example-of-how-to-use-oracle-cloud-infrastructure-oci-gen-2-with-terraform-macbook-pro-os-part-1/ , before you proceed with the following steps here. On the first article, how to create your account at Oracle Cloud was shown and a glimpse on Terraform. Now we are going through some examples that show what Terraform can really do while using it with OCI. So, let’s try to build an…