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,…
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.
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…
Finding the alert log file anywhere
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” Some database administrators have a hard time finding the alert log file in systems that they are not familiar with. Therefore, I decided to share two simple techniques to find the alert log file regardless of whether you know the system. Thus, the first technique is to check the alert log being connected to the SQL prompt using the x$dbgalertext view that brings the current information of the alert log. Therefore, this SQL…
ORAPWD : Password complexity failed for SYS user
I was creating an Oracle Data Guard environment when I got the following error while I was creating the password file: And the reason behind this error is that Oracle Corporation has been working hard to ensure more security in their database releases. Therefore, from the Oracle database release version 12.2, Oracle has changed some policies within passwords, and due to it, no longer weak passwords are allowed unless you want to. The new requirements about passwords that are allowed can be found in the chapter “3 Configuring Authentication” of…
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…
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…