Question on database fleet maintenance patching

From: Tharmarajah, Sam <sambavan.tharmarajah_at_usask.ca>
Date: Mon, 23 Dec 2019 22:23:40 +0000
Message-ID: <E2B1D891-2532-4763-A789-EC4DADEB8E07_at_usask.ca>




Hi All,

We have been asked to reduce the number of personals involved during our quarterly database patching. I was looking into using the fleet maintenance. Upon doing a POC, I notice the process of deploying the software job, awaits for manual step run and confirmation at three different points (new oracle home dir creation, pre -root run section and post root.sh run section), in spite of providing the normal and privileged credentials . We are wondering if there is a way to have these steps be run as part of the process automatically, instead of running manually.

Example:
./emcli db_software_maintenance -performOperation -name="deploy195" -purpose=DEPLOY_DB_SOFTWARE -target_type=oracle_database -target_list=xyz.com -normal_credential=FLEETMGR_STANDARD:SYSMAN -privilege_credential=FLEETMGR_PRIVILEGED:SYSMAN -input_file="data:/oracle/local/config/xyz.inp"

The .inp file
NEW_ORACLE_HOME_LIST=/oracle/product/195 workingDir=/backup/tmp

The databases we are trying patch is 19.x We have EM 13.3c

Our advance thanks for all your thoughts and suggestions.

Thanx,
Sam

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 23 2019 - 23:23:40 CET

Original text of this message