Contenting Logo

News

Entertainment

Science & Technology

Sport

Business & Money

Life

Culture & Art

Hobbies

Sites
Lists
#tags
  1. home
    2. ›
  2. Make DBA Life Easy Blog

Make DBA Life Easy Blog

8 | Follower

Software

See All

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,…

Make DBA Life Easy Blog

29.07.2025

ASM Instance ORA-04031: unable to allocate 232 bytes of shared memory (“shared pool”,”select ks.inst_id,ksuxsins,k…”,”KKSSP^2431″,”kglpn”) – Make DBA Life Easy

One of the +ASM instance alert log has ORA-04031 errors: 2025-07-17T23:00:48.475567+10:00Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ppa7_64031.trc (incident=160513):ORA-04031: unable to allocate 2072 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","parameter table block")Incident details in: /u01/app/grid/diag/asm/+asm/+ASM1/incident/incdir_160513/+ASM1_ppa7_64031_i160513.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.2025-07-17T23:00:48.550908+10:00ORA-04031 heap dump being written…

Make DBA Life Easy Blog

08.08.2025

RMAN-06004: Oracle error from recovery catalog database: RMAN-20020: database incarnation not set – Make DBA Life Easy

The following errors occur when RMAN backup took place: RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of backup command at 08/06/2025 12:38:27RMAN-03014: implicit resync of recovery catalog failedRMAN-06004: Oracle error from recovery catalog database: RMAN-20020: database incarnation not set RESOLUTION RMAN> reset database;reset database;database incarnation already registered

Contenting Logo
About UsPrivacy PolicyTerms Of UseContact