Bitten by AHF
From: DOUG KUSHNER <dougk5_at_cox.net>
Date: Wed, 15 Mar 2023 17:06:00 -0700 (MST)
Message-ID: <165644766.979260.1678925160426_at_myemail.cox.net>
Have finally found the cause of the intermittent failures of our rman backup script and thought I should share it.
Date: Wed, 15 Mar 2023 17:06:00 -0700 (MST)
Message-ID: <165644766.979260.1678925160426_at_myemail.cox.net>
Have finally found the cause of the intermittent failures of our rman backup script and thought I should share it.
This backup script and many other scripts run ps -ef | grep pmon | grep $ORACLE_SID and expect to get a single line back. Just discovered today that AHF launches a background process that meets this criteria. When it is running, 2 rows are returned. It was an easy fix, but finding the cause when the AHF process runs so infrequently was a challenge.
oracle 57984 270005 0 16:20 ? 00:00:00 ksh /u01/app/grid/oracle.ahf/data/repository/suptools/prw/oracle/prw.sh shortstack start 161780 oracle MYORASID1 /u01/app/oracle/product/19.0.0.0/dbhome_1 /u01/app/grid/oracle.ahf/data/repository/suptools/prw/oracle/PRW_DB_MYORASID1/prw_ora_pmon_MYORASID1_161780_03-15-23
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 16 2023 - 01:06:00 CET