When configuring Oracle Data Guard Broker to be used in your Oracle Data Guard configuration, you must disable the parameter log_archive_dest_n to Null at Primary and Standby before starting your setup. Otherwise, you are going to receive the following error on your Data Guard configuration: “Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added”. It’s effortless to modify this parameter, and an example on an Oracle RAC database it is as it is below on the Primary and Standby databases: #Primary: #Standby: The idea is the Broker control LOG_ARCHIVE_*…
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)
Oracle Enterprise Manager 13c release 4- How to add a target host and agent manually
Enterprise Manager tool in its release 13.4 has been up since January 2020 (ORACLE1) and its current release 13.5 since April 2021 (ORACLE2). Currently, I have been involved in a project where I had to install both Oracle Management Repository (Management Repository) (ORACLE3) following by the installations of the agents in several servers. Therefore, in this post, I will show how you can deploy an agent release 13.4 in a server that runs Oracle Database after configuring an Oracle Management Repository in another server. Thus, one of the primary steps…
PLS-00201: identifier ‘DBMS_JAVA.GRANT_PERMISSION’ must be declared
I was doing the deployment of data in one database when I got the following error message: After some researches, I found that the Oracle Database Java Packages component was invalid in the database as below: And the documentation that helped to find out it was (Doc ID 397770.1) and (Doc ID 2314363.1). This documentation helps you identify invalid components in the registry of your database and recreate this component in case one of them is with the INVALID status. After the procedure of creating any invalid features again, the…
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,…
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…