I was working on an activity that required me to set some datafile offline when I received the following error: After some analysis, I realized that the database was in no archive mode, and to be able to make a datafile offline, the database must be in archive mode. Therefore, I enabled the archive mode in the database by restarting the database in the MOUNT state, allowing the archive to mode option, and after it was possible to change the status of the database as below:
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied when Primary and Standby have the same password for the password file
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” I was creating a standby database and had the intention of using an active duplicate to copy the data from the primary database to the standby when I had the following error: I did all the ordinary checklist by checking if the password file on the standby file had the same password as the primary database and also by checking if the “Password file:” option configured on the srvctl “srvctl config database -d…
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,…
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…