From 12.2.0.1 onwards, local undo tablespace is introduced in PDB level. In many cases, the automatically created undo tablespace in PDB is not complying with naming standard. For example: SQL> select inst_id,name, con_id, value from gv$system_parameter where name='undo_tablespace' and con_id=3 order by 1; INST_ID NAME CON_ID VALUE---------- -------------------- ---------- -------------------- 1 undo_tablespace 3 UNDOTBS1 2…

Make DBA Life Easy Blog

21.05.2025

“runcluvfy.sh Stage -pre crsinst -n node1,node2” Hangs – Make DBA Life Easy

The following command hangs : $cd /u01/app/19.0.0/grid/$./runcluvfy.sh Stage -pre crsinst -n node1,node2 -verbose SOLUTION $ cat /etc/redhat-releaseRed Hat Enterprise Linux release 8.6 (Ootpa) As workaround: $export CV_ASSUME_DISTID=OEL7.8$./runcluvfy.sh stage -pre crsinst -n node1,node2 -verboseOrUse the latest Cluster Verification Utility (CVU) (Doc ID 2731675.1) Patch 30839369

Make DBA Life Easy Blog

24.05.2025

Clean Grid Infrastructure Environment – Make DBA Life Easy

The purpose of this document is to describe steps to clean clusterware (GI) environment where deinstall fails to work or cannot complete. Cleaning Steps 1. Remove the current GI home from central inventoryAs grid home owner: $ORACLE_HOME/oui/bin/runInstaller -detachHome -silent -local ORACLE_HOME=$ORACLE_HOME 2. Disable oracle ohasd service on Linux as root user # /usr/bin/systemctl stop oracle-ohasd.service#…

Make DBA Life Easy Blog

28.05.2025

How to add a port to a service in firewalld – Make DBA Life Easy

This post shows how to add port 5000 into filrewalld for Oracle Autonomous Health Framework (AHF) running on GI/RAC. List existing services:# firewall-cmd --get-services Add the port: If the service you want to modify already exists, use the following command to add the port: # firewall-cmd --permanent --add-port=<port>/<protocol> --service=<service-name>eg. #firewall-cmd --permanent --add-port=5000/tcp --service=oracle_rac Reload firewalld: After making changes,…

home›Make DBA Life Easy Blog

Make DBA Life Easy Blog

Software

How to Switch or Recreate Undo Tablespace at PDB Level – Make DBA Life Easy

“runcluvfy.sh Stage -pre crsinst -n node1,node2” Hangs – Make DBA Life Easy

Clean Grid Infrastructure Environment – Make DBA Life Easy

How to add a port to a service in firewalld – Make DBA Life Easy

home
›
Make DBA Life Easy Blog