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…
Search Results for: ORACLE
Oracle Data Guard 12c: ORA-01110: data file 0000: ‘$ORACLE_HOME/dbs/UNNAMED0ZZZ’
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” Oracle Data Guard is a great Oracle product that ensures high availability, data protection, and disaster recovery for enterprise data. However, as with any other product, sometimes there are some issues that appear and it is needed to be solved. Therefore, the post today will be about the error “ORA-01110: data file 0000: ‘$ORACLE_HOME/dbs/UNNAMED0ZZZ’”. Many causes can lead to this error but one that I can point out is when the primary database…
Implementing Oracle Data Guard Broker 19c in an Oracle Standby RAC Database
Before I start, I would like to do a disclaimer and say that this is a procedure that might help you. However, I do not recommend you test it in a production environment before reading Oracle documentation and notes to understand the concepts that I will write here. Oracle Data Guard Broker is a utility that can help you manage your Oracle Data Guard. Among many benefits of using this utility, I highlight that while using it, it will not need manual intervention to recover the databases or eventually a…
Oracle Data Guard 19c: rfs (PID:11969): Possible network disconnect with primary database
One of the essential things in the configuration of Oracle Data Guard and Oracle Data Guard Broker is where the file tnsnames.ora is placed, which by default, from some other early releases of 19c it has been defined at $ORACLE_HOME/network/admin. However, in one of the environments that I was providing some job as a consultant, I could see the following outputs from the Oracle Data Guard broker utility : Just a brief explanation on the output above to make it easier to understand from now on: Standby database has db_unique_name…
Active Data Guard feature: since 11g keeping your Oracle Data Guard open in read-only mode, and still applying redo information
The active Data Guard feature is not something new. It has been on since Oracle Database version 11g, but it is the first time I am writing about it on my blog (I think so!), and I think it is always nice not to miss anything on our career path. So here we go! Before Oracle Database version 11g, it was already possible to open Oracle Data Guard in open mode. Still, there were some complications, e.g., when it was needed to recover the standby database. Thinking on that, Oracle…
Using Oracle Data Guard with Oracle Data Guard Broker? Disable your LOG_ARCHIVE_n parameters and reconfigure your Oracle Data Guard Broker settings
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_*…
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…
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…