Got an ODG patched recently and after that, Dataguard was out of sync. DGMGRL> show database verbose "PROD2" Database Status: DGM-17016: failed to retrieve status for database "PROD2" ORA-01033: ORACLE initialization or shutdown in progress ORA-16625: cannot reach database "PROD2" PROD2 is the physicla standby. Normally in a Dataguard envrionment, it means something wrong with … Continue reading ORA-01033: ORACLE initialization or shutdown in progress with Dataguard
Month: October 2021
Return IP from a specific NIC (Network Binding Order) for Windows Server 2016 and above
For some applications it is important to see and bind to a correct IP when there are multiple NICs (hence multiple IPs assigned) on a Windows server. For example, if a server has two NICs with two different IPs from 2 subnets, one for public traffic and another for the storage network. You may want … Continue reading Return IP from a specific NIC (Network Binding Order) for Windows Server 2016 and above
The home is not clean and cannot be used due to a failed OPatch execution
A while ago I ran into this error when trying to install Oracle 19c on an Oracle Linux 8 sever and apply the patch set 32545013 on top. The error was from the following command: runInstaller -silent -applyRU /tmp/32545013 -force -executePrereqs -responseFile /tmp/db_patch.rsp ERROR: The home is not clean. This home cannot be used since … Continue reading The home is not clean and cannot be used due to a failed OPatch execution
ssh break out while loop?
From time to time, you might run into tasks like execute commands remotely on different Linux servers regularly, for example collecting logs. A bash script will be handy to do so and likely you will use SSH within the script. Then don't be surprised to see your loop doesn't work any more with SSH in … Continue reading ssh break out while loop?